Database connections

Orbit connect supports several database providers, enabling you to specify and securely store database credentials and connect your database.

Supported database providers:

  • Microsoft SQL Server, including Azure SQL

  • Snowflake

  • PostgreSQL

This feature is ideal for database users who wish to use Orbit connect or the Apteco CDP.

These sources are available in addition to the file and Amazon S3 connection methods allowing for diverse and flexible integration.

Import your data

To import your data using Orbit connect:

  1. Click the Orbit connect icon.

  2. Under Data Sources, click + New Data Source to see the available options.

  3. Next to your database type (e.g., SQL Server), click Connect.

  4. Provide a descriptive name for your data source, then click Create.

  5. Under Select a credential, click + New Credential.

  6. Fill in the following:

    • Credential Name

    • Credential String (you'll receive a confirmation if valid).

  7. Click Add.

  8. Connect to your database and select the desired tables or views.

    A data preview appears.

  9. Click Import.

You've completed your data import. You can now start mapping your data in the CDP to integrate it seamlessly into your workflows.

Example database connection strings

SQL Server

Copy
SQL Server
Server=<server>;Initial Catalog=<database>;User ID=<username>;Password=<password>

Azure SQL

Copy
Azure SQL
Server=tcp:<myserver>.database.windows.net,1433;Database=<database>;User ID=<username>;Password=<password>;Trusted_Connection=False;Encrypt=True;

PostgreSQL

Copy
PostgreSQL
Server=<server>;Port=5432;Database=<database>;Uid=<username>;Pwd=<password>;

Snowflake

Copy
Snowflake
scheme=https;ACCOUNT=<account>;HOST=<account>.snowflakecomputing.com;port=443;USER=<username>; PASSWORD=<password>;