Skip to main content

Oracle

Prerequisite steps to perform in the Anansi tool.

Import CSV Templates​

To create a High-Level Demo Catalog, import templates from the provided link. Make the necessary changes to the catalog names in the CSV template.

Import data from Oracle Database​

After setting up the tables as per the templates given above, navigate to the Anansi Tool, hover over 'Import' icon and select 'Import DB'.

import_database

Enter parameters into the tool​

  • DB Type: Select "Oracle" as the database type.
  • Connection String: Enter the Oracle connection string of your database.
  • Schema Name: Specify the schema name to be imported from Oracle Database.

PostGre Import

note

Sample Connection String

DRIVER={Oracle Driver};DBQ=your_host_name/your_service_name;UID=your_username;PWD=your_password;

Replace your_host_name/your_service_name, your_username, your_password with your Oracle database connection.

  • Click 'Next'.

In the Data Import Wizard Enter the following parameters

  • DB Name: Provide the unique name/identifier for your database. (For Ex: Smith__Database, Suraj_Sample_Database etc.)
  • Catalog Name: Select the catalog name where the data needs to be imported from the dropdown.

PostGre Import

  • Click 'Submit'. After a successful import, it will display 'Metadata Fetched Successfully'.