Adding an Existing Oracle Business Intelligence Cloud Service Instance as a Target

Publish a repaired or enriched data file to an existing Oracle Business Intelligence Cloud Service instance.

To add an existing Oracle Business Intelligence Cloud Service instance as a target:
  1. On the Home or Catalog page, click Create Source.
    The Create Source page appears.
  2. In the Name field, enter a name to identify the source.
    The name must not contain spaces. If you enter a space, then the application changes it to an underscore.
  3. From the Type drop-down list, select Oracle BICS .
  4. Provide your credentials to access your Oracle Business Intelligence Cloud Service instance.
    This information appears in the email that you receive when you activate your Oracle Business Intelligence Cloud Service account.
    1. In the Service URL field, enter the URL .
      This URL is the Service REST Endpoint for the DataSync API of your Oracle Business Intelligence Cloud Service instance. Most often, this REST Endpoint is the URL for your Oracle Business Intelligence Cloud Service instance without any values after the .com extension.
      For example, if your Oracle Business Intelligence Cloud Service instance is at http://service-domain.analytics.us2.oraclecloud.com:443, then the corresponding DataSync API REST Endpoint for your service is http://service-domain.analytics.us2.oraclecloud.com.
    2. In the Username field, enter the user name.
      This is the user name specified in the email that you receive when you create your account.
    3. In the Password field, enter the password.
      This is the password specified in the email that you receive when you create your account.
    4. In the Domain field, enter the domain name.
      This is the domain name specified in the email that you receive when you create your account.
  5. Optionally, click Test to verify that you entered the correct data, and that the connection to the service works.
    A confirmation message appears.
  6. Click Save.
    The Catalog page appears.
The Catalog now shows the target that you created. Use this target to publish your enhanced or repaired data sets and analyze them using the tools available in Oracle Business Intelligence Cloud Service.

When you publish your data, Oracle Big Data Preparation Cloud Service creates a table in the repository of your Oracle Business Intelligence Cloud Service instance. From this table, you must create fact tables and dimension tables containing columns that store the data of your data model. You can then use Visual Analyzer to create and analyze your data.

To learn more about publishing to Oracle Business Intelligence Cloud Service, see Publishing Results to Oracle Business Intelligence Cloud Service.