Oracle

Steps to integrate Oracle storage with Atlan

Atlan natively supports Oracle, which allows you to seamlessly integrate your Oracle with your Atlan workspace.

๐Ÿ’ญ TL;DR

You can set up an Oracle integration in four easy steps:

  1. Select the source, aka Oracle ๐Ÿ˜‰

  2. Provide your credentials โœ๏ธ

  3. Set up your configuration ๐Ÿ—„๏ธ

  4. Schedule automatic updates ๐Ÿ•‘

๐Ÿ”‘ Oracle user permissions

Oracle schemas are synonymous with owners. So if you want to integrate all tables from a schema into Atlan, you will have to add credentials for the schema's owner.

If you only want Atlan to access certain tables in the schema, you can create a user and grant permission for those specific tables. Wildcard-based (*) table assignment is not possible here.

To integrate specific tables, replace the <schema>, <table_name> and <pass> in the code below:

CREATE USER atlan_user IDENTIFIED BY <pass>
GRANT create session, SELECT_CATALOG_ROLE TO atlan_user;
โ€‹
--- Repeat the below statement for the tables you want to grant access
GRANT SELECT ON "<schema>"."<table_name>" TO atlan_user;

๐Ÿ“œ Prerequisites for an Oracle integration

Before you get started, you'll need some information to help establish a connection between Atlan and your Oracle account.

  • Hostname: The hostname of your Oracle deployment.

  • Port: The default TCP port for Oracle is usually 1521.

  • Username & password: This is the username and password for your Oracle login credentials.

  • SID: Oracle SID (System Identifier) is the unique name that uniquely identifies your instance/database

๐ŸŒŸ Pro Tip: If you don't have this information handy, reach out to your cloud or database administrator to get these details before you get started!

๐Ÿš€ The step-by-step guide to integrate Oracle with Atlan

Once you have the information listed above, follow the steps below ๐Ÿ‘‡ to establish a connection and integrate Atlan with your Oracle database.

STEP 1: Selecting the source

  1. Log into your Atlan workspace.

  2. On the home screen, click on the "New Integration" button in the top right corner. You will see a dialogue box with the list of sources available in your workspace.

  3. Select "Oracle" from the list of options, and click on "Next".

STEP 2: Providing credentials

  1. You will see options to either select a preconfigured credential from the drop-down menu or create a credential. To set up a new connection, click on the "Create Credential" button.

  2. You will need to fill in your Oracle credentials. Below is an example of the credentials required:

    1. Hostname: myhostname.ap-south-1.rds.amazonaws.com

    2. Port: 1521

    3. Username: Oracle

    4. Password: xxxxxxx

    5. Oracle SID: ORCL

  3. Once you have filled in the details, click on "Next".

Oracle Integration

STEP 3: Setting up your configuration

  1. Specify the schemas, or tables that you want to crawl. Add the comma-separated schemas or table names that you want to filter, making sure there are no whitespaces.

  2. Choose whether to run the crawler once or schedule it for a daily, weekly, or monthly run. You will be asked to specify the time zone for the run.

  3. Click on "Create". Your connection is now created.

Congratulations! You have now integrated Atlan with Oracle ๐ŸŽ‰

๐Ÿ Monitoring your Oracle integration

Once the integration setup is completed, you will be redirected to the "Monitor" tab for your Oracle asset, where you can monitor its progress.