Data & Intelligence

Configure Data Sync (BICS) to Load Staging Database

In this blog, I will finish the Best Practice to ETL with Data Sync (BICS) post by showing you how to configure the Data Sync to load data in staging database.

Data Intelligence - The Future of Big Data
The Future of Big Data

With some guidance, you can craft a data platform that is right for your organization’s needs and gets the most return from your data capital.

Get the Guide

First, set up a new database connection in Data Sync for SQL Server or Oracle database.

  • For SQL Server

    > Set Connection Type to MSSQL
    > Fill in the rest fields: NameUserPasswordDatabase nameHost, and Port
  • For Oracle database

    > Set Connection Type to Oracle (Thin)
    > Fill in the rest fields: NameUserPassword
    Open up the text editor for URL (Optional)

        Entering the JDBC url using one of the following formats

        >> jdbc:oracle:thin:@<database-host-name-or-ip>:<port>:<SID>
        >> jdbc:oracle:thin:@<database-host-name-or-ip>:<port>/<Service-name>

Second, create a new Job and override the TARGET using the newly created database connection above.

  • Create a new Job
  • Set the TARGET connection to use the newly created database connection in first step above

Now, run the newly created Job and the staging database will be loaded with Data Sync mappings.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Daniel Xiao

More from this Author

Subscribe to the Weekly Blog Digest:

Sign Up
Follow Us