Okera supports connecting to these JDBC data sources out of the box:
- Object Storage (e.g. HDMS, Amazon S3, ADLS, GS)
- Amazon Redshift
- AWS Athena
- Google BigQuery
- Microsoft SQL Server
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:
- Create a connection to the data source.
- Create and run a crawler to search for datasets in the connection.
- 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:
- Who Can Manage Connections
- Create a Connection
- List Connections
- Filter and Search for a Connection
- Edit a Connection
- Test a Connection
- Delete a Connection
- Connection Pushdown Processing
For details and examples for connecting to a specific data source type, select it below:
- Object Storage (e.g. HDMS, Amazon S3, ADLS, GS) data sources
- Snowflake data sources
- Amazon Redshift data sources
- AWS Athena data sources
- Dremio data sources
- Google BigQuery data sources
- Microsoft SQL Server data sources
- MySQL data sources
- Oracle data sources
- PostgreSQL data sources
- Custom JDBC data sources