Skip to main content

Create a Data Source for Oracle

Use this API to create a new data source.

See the Create a Data Source for Oracle section of the Create a Data Source topic to create an MS Access data source using Directory Manager.

Endpoint​

https://machinename:4443/GroupIDDataService/api/DataSource/Create

HTTP Method​

POST

Sample Request Syntax​

The following syntax is for creating an Oracle data source. You can create a data source for an Oracle server or a specific database on a server. This data source can be used in queries and as source and destination provider in Synchronize jobs. This provider supports dynamic schema detection.

note

Oracle client must be installed to use this provider. Make sure you reboot your computer after installing the Oracle client.

{
    "name": "Oracle1",
    "providerTypeName": null,
    "type": 5,
    "creationDate": "2024-05-29T06:27:55.61",
    "lastUpdate": null,
    "configurationValues": {
        "ConnectionString": "orca",
        "UserName": "HR",
        "Password": "password123",
        "Protocol": "",
        "HostName": "",
        "PortNumber": "",
        "Database": ""
    },
    "identityStoreObject": null,
    "details": [],
    "currentDirectoryServer": null,
    "errorCode": null,
    "exceptionMessagesAttributeWise": null,
    "isResyncAble": true
}

Sample Response Syntax​

{
    "name": null,
    "type": 6,
    "status": 0,
    "message": null,
    "data": 2,
    "identityStoreObject": null,
    "details": [],
    "currentDirectoryServer": null,
    "errorCode": null,
    "exceptionMessagesAttributeWise": null,
    "isResyncAble": true
}