Atlan natively supports Oracle, which allows you to seamlessly integrate your Oracle with your Atlan workspace.
You can set up an Oracle integration in four easy steps:
Select the source, aka Oracle 😉
Provide your credentials ✍️
Set up your configuration 🗄️
Schedule automatic updates 🕑
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
<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 accessGRANT SELECT ON "<schema>"."<table_name>" TO atlan_user;
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
Once you have the information listed above, follow the steps below 👇 to establish a connection and integrate Atlan with your Oracle database.
Log into your Atlan workspace.
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.
Select "Oracle" from the list of options, and click on "Next".
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.
You will need to fill in your Oracle credentials. Below is an example of the credentials required:
Oracle SID: ORCL
Once you have filled in the details, click on "Next".
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.
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.
Click on "Create". Your connection is now created.
Congratulations! You have now integrated Atlan with Oracle 🎉
Once the integration setup is completed, you will be redirected to the "Monitor" tab for your Oracle asset, where you can monitor its progress.