Skip to main content

Varicent ELT Help Center

Oracle

Abstract

Connect your Varicent ELT and Oracle accounts to import your data.

Connect your Varicent ELT and Oracle accounts to import your data.

Important

This is an Available connector, which might require technical support to connect to your business system using REST API. For more information, contact support@varicent.com.

Importing data

  1. In Varicent ELT, go to the Data tab.

  2. Click Import data.

  3. In the Third party sources section, click Oracle.

  4. Click New Connection.

  5. On the Connect to your Database page, enter the following information to connect:

    Table 16. Oracle

    Field

    Description

    Connector name

    The name of the connection.

    Host

    The host URL.

    Port

    The port number.

    SID

    The Oracle system identifier.

    Database

    The database name.

    Username

    The user's Oracle user name.

    Password

    The user's Oracle password.



  6. On the Choose data sets page, select the set of data to include. Click Next.

  7. On the Import data page, review your data and select the data to obfuscate (if any). Click Next.

  8. On the Filter data page, optionally click Filter data to refine your data, or click Import data to continue.

    1. Filter the rows in your data by selecting the column to filter, the filter category and the value or text.

    2. Click Import data to continue.

    Note

    For more information about how to configure data filters, see: Filter data.

  9. On the Review page, review the data sets that you are importing.

  10. Click Import data.

    The data is available on the My Data page.