...
You can configure a new Oracle account in Fast Data Loader (FDL) by using the user credentials from your existing account in Oracle.
Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
Prerequisites
Login credentials and access to Oracle account. Contact your administrator, if you do not have access or settings details.
For more information on Oracle JDBC database connectivity, see Oracle JDBC documentation.For more information on Oracle JDBC Thin Client, see Overview of JDBC Thin Client in Oracle documentation.
For more information on Account Settings, see Features and Properties of Data Sources in Oracle documentation.
Access to Oracle Snap Pack in SnapLogic’s Intelligence Integration Platform.
...
Oracle 11i JDBC driver. This driver supports versions 11i, 12c, and 19c, but may be compatible with later versions. However, that will be down to the compatibility of the Oracle JDBC driver. The Fast Data Loader is tested against Oracle 11.2.0.4.0.
Account Settings
Parameter Name | Data Type | Description | Example |
---|---|---|---|
Create new connection tag | String | Required. Enter a name that will help identify your Oracle account in FDL. | FDL_oracle Account |
Hostname | String | Required. The server address to which the application must connect. | oratestdb2.cwztyhkwzzvnq.us-east-1.rds.azaws.com |
Port Number | String | Required. The database server's port number to which the application must connect. | 1521 |
Database name | String | Required. The database name to which the application must connect. | MYDB |
Database specifier type | String | Specify the database specifier type to use. The selected option decides the format of URL for JDBC that is to be used internally. The valid options are:
| Service name |
Username | String | The user name that is allowed to connect to the database. It is used as the default username when retrieving connections. The user name must be valid in order to set up the data source. | FDL_Data_User |
Password | String | The password used to connect to the data source. It is used as the default password when retrieving connections. The password must be valid in order to set up the data source. | N/A |
Troubleshooting
You might encounter the following errors when you validate and save your integration:
Error | Reason | Resolution | ||
---|---|---|---|---|
Asset conflict error. | You cannot have another account in FDL with the same name. If you enter the existing account name, the Asset conflict error message is displayed. | Ensure that account name is unique. You can click Overwrite to overwrite the existing configuration with the new one, or click Cancel and enter a unique name for your account. | ||
Failed to validate account. | You might have entered an invalid username or password.
| Ensure that you enter valid account credentials. |
...
Contact FDL customer support at fdl-support@snaplogic.com for further assistance.
...
Configuring your Redshift Account as a Data Destination
Configuring your SAP DWC account Account as a data destinationData Destination
Configuring your Snowflake account Account as a data destinationData Destination
...
See Also
...