Skip to content

Connection Overview

Okera supports connecting to these JDBC data sources out of the box:

  • Object Storage (e.g. HDMS, Amazon S3, ADLS, GS)
  • Snowflake
  • Amazon Redshift
  • AWS Athena
  • Dremio
  • Google BigQuery
  • Microsoft SQL Server
  • MySQL
  • Oracle
  • PostgreSQL

You can also connect to a custom JDBC data source by providing your own JDBC driver.

There are three main steps to connect Okera to your data source:

  1. Create a connection to the data source.
  2. Create and run a crawler to search for datasets in the connection.
  3. Register the datasets that were found by the crawler in an Okera database.

This section describes creating a connection to a data source. To see the programmatic SQL commands for a connection, see Programmatic Registration.

See the following subsections:

For details and examples for connecting to a specific data source type, select it below: