Configuring your Oracle Account as a Data Source

In this article

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

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 

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:

  • SID: Uses the jdbc:oracle:thin@HOST:PORT:DBNAME format.

  • Service name: Uses the jdbc:oracle:thin@//HOST:PORT/DBNAME format. 

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

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.

Multiple attempts with invalid credentials may lock your account.

Ensure that you enter valid account credentials.


Contact FDL customer support at fdl-support@snaplogic.com for further assistance.

What to do next: Select destination endpoint from the following:

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2037121200

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2037121213

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2036367733


See Also

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1942159838

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2006486040

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2004029460

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2006486058