Connecting Data Sync to Your Data Target and Your Data Sources

In Data Sync, use the Sources/Targets dialog in the Connections view to specify connections details for your target database and your source databases. Data Sync loads data from these sources to the target location. If you’re loading data only from data files, for example XLSX or CSV format, then you don’t need a connection in Data Sync

  • For your target database, edit the connection named TARGET and specify the details of your target Cloud database. See Specifying Connection Details for Your Cloud Service.
  • If you’re loading data from a database, then specify the connection details for your database. See Specifying Connection Details for a Data Source.
    If you’re loading data only from data files, then you don’t need a connection in Data Sync. Go straight to the Project view, click the File Data tab, and specify your data file details. For example, you might load from a spreadsheet or CSV file.

Specifying Connection Details for Your Cloud Service

To set up a Data Sync environment, you specify connection details for your target Cloud service.

  1. In Data Sync, click Connections, then click the Sources/Targets tab.
  2. In the list of connections, select TARGET.
  3. In the Edit dialog, specify the following details:
    Field or Element Description
    Name Do not change the default name TARGET.

    Connection Type

    Select Oracle (BICS) if you’re loading data to the default Database Schema Service.

    If you’re loading data to Database Cloud Service, then select Oracle (Thin), and specify additional values for service name, host, and port number of the local TNS connection.

    User

    Enter the name of a user with an appropriate data loading application role (BI Data Load Author and/or BI Advanced Content Author). See Giving Users Permissions to Upload Data with Data Sync.

    Password

    Specify the password for the user that you entered in the User field. See Giving Users Permissions to Upload Data with Data Sync.

    URL

    Specify the URL of your target Cloud service without the ‘/analytics’ part at the end. For example, if your cloud service URL is ‘http://bics12345.analytics.us1.cloud.oracle.com/analytics’, then specify: http://bics12345.analytics.us1.cloud.oracle.com

Specifying Connection Details for a Data Source

To set up a Data Sync environment, you specify connection details for your source database. If you’re only loading data from files, then you can skip this task.

For guidance on specifying connection details for specific data source types:
  1. In Data Sync, click Connections, then click the Sources/Targets tab.
  2. Click New to add an empty record to the list of connections.
  3. Use the Edit dialog to specify the connection details.
  4. Click Test Connection to make sure that the connection details are valid.
  5. Click Save.