Oracle as a source
You can create a data pipeline that loads data from an on-premises Oracle database to a cloud data warehouse. To provide the information SnapLogic® AutoSync needs to connect to Oracle, supply new credentials in the wizard or select the saved credentials that were created in the IIP or the wizard. The Create credentials page describes how to create credentials in the AutoSync wizard.
After selecting Oracle as a source, you'll be asked to select a Groundplex that has connectivity to your on-premises Oracle database. The Connect to on-premises endpoints page provides details about limitations and constraints. While configuring your endpoint, you'll also need to select a column that contains the last updated timestamp. If no such column exists, create the column in the table and then select it when configuring this endpoint.
Supported account types
The IIP provides multiple Account types for most endpoints and not all types are compatible with AutoSync. When you create or edit a data pipeline, the existing credentials list only includes compatible Accounts. AutoSync supports the following IIP Account types:
- Oracle Thin Account
Known limitations
- Data pipelines with Oracle as the source can miss new and updated records when using the Incremental load type. This is due to a difference in precision between Oracle and AutoSync timestamps.
Connection configuration
Oracle properties include the following:
- Credential label: A unique, meaningful name such as
Oracle-Sales-Admin
. If a configuration with the same name exists, AutoSync displays anAsset conflict error message
. - Hostname: The name of the machine hosting the database.
- Port Number: The port number to connect to the database. Default value:
1521
- Database name: The name of the database. For example,
MyDB
. - Username: A username for an account with the correct permissions for AutoSync to retrieve and synchronize data.
- Password: The password for the account. Multiple retries with an invalid password can cause your account to be locked.
- Database specifier type: The format of the JDBC URL. AutoSync formats the connection parameters into one of the following options. Default value:
Service name
- Service name: Uses the
jdbc:oracle:thin@//HOST:PORT/DBNAME
format. - SID: Uses the
jdbc:oracle:thin@HOST:PORT:DBNAME
format.
- Service name: Uses the
- Share: (Optional) Select a user group to share this configuration with. Org admins create user groups to share credentials. If you are a member of a user group, you can select it from the dropdown. You can also select the global shared folder, which shares the credentials with everyone in your Org.
- Validate and Save: After saving and validating, AutoSync adds the configuration to the list of saved credentials.
- Select schema: AutoSync populates this list from the account. Choose the schema that contains the tables to load as a source.
- Select tables to synchronize: After configuring a destination, choose tables to synchronize. AutoSync populates the list from your Oracle account.
- Select the column that tracks the last modified time: Select the table column which tracks the last updated timestamp. The selected column must be non-nullable and have no null values.
- Click Select another table to add another table to synchronize.