# Database connections

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

Supported database providers:

- **PostgreSQL**
- **Amazon Redshift**
- **Snowflake**
- **Microsoft SQL Server**, including **Azure SQL**

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. In **Data Sources**, click **\+ New Data Source**.
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**
   - **Connection 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 [map your data](<https://help.apteco.com/en/orbit/connect/data-mappings/index.md>) to a User Defined Table or, if you use the Apteco CDP, to a Customer Data Table.

## Example database connection strings

#### PostgreSQL

SQL

```sql
Server=<server>;Port=5432;Database=<database>;Uid=<username>;Pwd=<password>;
```

#### Amazon Redshift

Text Only

```text
User ID=<username>;Password=<password>;Host=<workgroup>.<account_number>.<region>.redshift-serverless.amazonaws.com;Port=<port>;Database=<database>;
```

#### Snowflake

Text Only

```text
scheme=https;ACCOUNT=<account>;HOST=<account_identifier>.snowflakecomputing.com;port=443;USER=<username>;PASSWORD=<password>;DB=<database>;
```

> [!NOTE]
>
> You can find your **Account Identifier** in Snowflake under **Account Details**.

#### SQL server

SQL

```sql
Server=<server>;Initial Catalog=<database>;User ID=<username>;Password=<password>
```

#### Azure SQL

SQL

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