Oracle

Overview

Use this connector to extract metadata from Oracle databases.

Create User & Grant Permissions

Run the following SQL commands to create a dedicated user and grant the required read-only permissions:

• CREATE USER connetra IDENTIFIED BY '<password>';
• CREATE ROLE connetra_role;
• GRANT connetra_role TO connetra;
• GRANT CREATE SESSION TO connetra_role;
• GRANT SELECT_CATALOG_ROLE TO connetra_role;
• GRANT SELECT ANY TABLE TO connetra_role;

Connection Setup in Connetra

When adding a data connector in Connetra, provide the following details:

• Configuration name: A user-friendly label for this connection. It helps team members identify and select the connector within Connetra
• Host/server: The network address or domain name of the database server where your data is stored.
• Port: The communication port used to connect to the database
• User: The database account Connetra will use to connect and retrieve metadata. This user should have read-only permissions.
• Password: The password associated with the user account above, used to authenticate the connection.
• SID/Service Name: The unique identifier that specifies which Oracle database instance to connect to.

Before you can save the data connector you must first test the connection.