...
| Table of Contents | ||||
|---|---|---|---|---|
|
Overview
You can configure a new Oracle account in Fast Data Loader (FDL) by using the user credentials from your existing account in Oracle.
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.
Supported Versions
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:
...
Configuring your Redshift account Account as a data destinationData Destination
Configuring your SAP DWC account as a data destination
Configuring your Snowflake account as a data destination
...