Databases

Each project will have their own database connections and different environments. In this page is where you add or edit your connections that will be used in your Model.

In this document you will find information about:

Taps
Sinks
Environments

Taps

Taps are input connections to databases. The available taps may vary depending on your license but there are different types.

A tap can only have one model. It is not possible to create multiple models for a unique tap.

OSS

Supported OSS (OpenSource databases):

MySQL
SQLite
PosgreSQL

Proprietary databases

SQL Server
Oracle
IBM Db2 for i (AS/400)
IBM Db2 for z/OS
Azure SQL Database
Salesforce

IBM Db2 taps require the Gigantics Debaser layer for low-level extraction. Make sure the corresponding drivers are installed on the host running Debaser before configuring the connection.

To use an Oracle database it is necessary to install the drivers manually. Check how to configure them here.

Oracle taps must prepend the host in the Database field: Database: <host>/<database_name>
IBM Db2 taps need the correct subsystem or library list defined in the Debaser configuration so entity discovery can enumerate tables properly.
Salesforce taps rely on connected app credentials (consumer key/secret) and an OAuth token; keep them handy when creating the connection.

NoSQL databases

MongoDB
Amazon DynamoDB
Apache Cassandra

Big Data databases

Snowflake
Google BigQuery
Amazon Redshift
Azure Synapse Analytics
Databricks Lakehouse

Sinks

Sinks are output connections to databases. Like Taps, they are divided by type of database according to the license type.

There are two types of sinks:

Static: Sinks always refer to the same database.
Dynamic: Each time a sink is written to, a new database is created in the db host, where we provide the connection data (database name where we provide the connection data (database name, user and password to access it), user and password to access it).

Environments

It is possible to create environments to group taps and/or sinks so you can have your connections organized.

A tap or sink can only belong to one environment.

On this page