Steps to prepare and connect to Oracle

Lightup account setup

You'll need an account that can query data and metadata for all tables you want to monitor. You might already have an account set up that will work, or you might need to create one. Give the account the least sufficient permissions, preferably using a security role.

For help, go to Oracle's Setting Up User Accounts page.

Connector setting

  • Host - The URL or IP address of the host that processes connection requests (the string between https:// and /). Example:
  • Database Name - The name of the database instance that contains your data.
  • Username - The username of the account used for connecting to the database and querying data.
  • Password - The username account's password.

Schema scan frequency

You can adjust how often scans run for a datasource.

  • In section 3 - Advanced, select a value for Schema scan frequency: Hourly, Daily, or Weekly.

Query governance

Oracle datasources support the Query history, Scheduling, and Enable data storage settings. For steps, see Set query governance settings for a datasource.