PostgreSQL

​

Add the PostgreSQL Connector

​

Authenticate to PostgreSQL

• Password (default)
• Azure Active Directory
• Azure Service Principal
• Azure Service Principal Certificate
• Azure Password
• Azure Managed Service Identity
• Aws IAM Roles
• Aws EC2 Roles
• GCP Service Account

​

Password

• Auth Scheme: Select Password.
• User: Enter the username that you use to authenticate to your account.
• Password: Enter the password that you use to authenticate to your account.

​

Azure Active Directory

• Auth Scheme: Select AzureAD.
• User: Enter the username that you use to authenticate to your account.
• Azure Tenant: Enter the Microsoft Online tenant to which you want to connect. If you do not specify a tenant, uses the default tenant.
• OAuth Client Id: Enter the client Id that you were assigned when you registered your application with an OAuth authorization server.
• OAuth Client Secret: Enter the client secret that you were assigned when you registered your application with an OAuth authorization server.

​

Azure Service Principal

• Auth Scheme: Select AzureServicePrincipal.
• Azure Tenant: Enter the Microsoft Online tenant to which you want to connect.
• User: Enter the username that you use to authenticate to your account.
• OAuth Client Id: Enter the client Id that you were assigned when you registered your application with an OAuth authorization server.
• OAuth Client Secret: Enter the client secret that you were assigned when you registered your application with an OAuth authorization server.
• (Optional) Scope: Specify the scope of your access to the application.

1. Log in to the Azure portal.
2. In the left navigation pane, select All services. Then, search for and select App registrations.
3. Click New registrations.
4. Enter an application name and select Any Azure AD Directory - Multi Tenant.
5. After you create the application, copy the application (client) Id value that is displayed in the Overview section. Use this value as the OAuth client Id.
6. Navigate to the Certificates & Secrets section and select New Client Secret for the application.
7. Specify the duration and save the client secret. After you save it, the key value is displayed.
8. Copy this value because it is displayed only once. You will use this value as the OAuth client secret.
9. On the Authentication tab, make sure to select Access tokens (used for implicit flows).

​

Azure Service Principal Certificate

• Auth Scheme: Select AzureServicePrincipalCert.
• User: Enter the username that you use to authenticate to your account.
• Azure Tenant: Enter the Microsoft Online tenant to which you want to connect.
• OAuth JWT Cert: Enter your Java web tokens (JWT) certificate store.
• OAuth JWT Cert Type: Enter the type of key store that contains your JWT Certificate. The default type is PEMKEY_BLOB.
• (Optional) Scope: Specify the scope of your access to the application.
• (Optional) OAuth JWT Cert Password: Enter the password for your OAuth JWT certificate.
• (Optional) OAuth JWT Cert Subject: Enter the subject of your OAuth JWT certificate.

1. Log in to the Azure portal.
2. In the left navigation pane, select All services. Then, search for and select App registrations.
3. Click New registrations.
4. Enter an application name and select Any Azure AD Directory - Multi Tenant.
5. After you create the application, copy the application (client) Id value that is displayed in the Overview section. Use this value as the OAuth client Id.
6. Navigate to the Certificates & Secrets section and select Upload certificate. Then, select the certificate to upload from your local machine.
7. Specify the duration and save the client secret. After you save it, the key value is displayed.
8. Copy this value because it is displayed only once. You will use this value as the OAuth client secret.
9. On the Authentication tab, make sure to select Access tokens (used for implicit flows).

​

Azure Password

• Auth Scheme: Select AzurePassword.
• User: Enter the username that you use to authenticate to your account.
• Password: Enter the password that you use to connect to your account.
• Azure Tenant: Enter the Microsoft Online tenant to which you want to connect. If you do not specify a tenant, uses the default tenant.

​

Azure Managed Service Identity

• Auth Scheme: Select AzureMSI.
• User: Enter the username that you use to authenticate to your account.

​

AWS IAM Roles

​

AWS EC2 Roles

​

GCP Service Account

• Auth Scheme: Select GCPServiceAccount.
• OAuth JWT Cert: Enter your Java web tokens (JWT) certificate store.
• OAuth JWT Cert Type: Enter the type of key store that contains your JWT Certificate. The default type is PEMKEY_BLOB.
• OAuth JWT Cert Password (optional) - Enter the password for your OAuth JWT certificate.
• OAuth JWT Cert Subject (optional) - Enter the user subject for which the application is requesting delegated access.

​

Complete Your Connection

1. Specify these settings:
   • Database: Enter the name of the database that to which you want to connect when you connect to the server.
   • Port: Enter the port number of the server that hosts the database. The default port value is 5432.
2. Define advanced connection settings on the Advanced tab. (In most cases, though, you should not need these settings.)
3. Connect to to connect to your account.
4. Click Create & Test to create your connection.

​

Configure Logical Replication

​

Enable Logical Replication for

1. Ensure that the wal_level=logical parameter is set in your database. You can set this parameter in the postgresql.conf file.
2. Create a logical replication slot for by submitting the following SELECT statement:
   SELECT pg_create_logical_replication_slot('cdatasync_replication_slot', 'test_decoding');
   
   The slot name cdatasync_replication_slot is an example slot name. You can substitute any name in its place. You need this slot name when you create your job in . It is important that this slot is used by only because changes are consumed when it reads from the slot.
3. Ensure that the user that connects from has permission to read the replication slot by submitting the following statement.
   ALTER ROLE <em>PostreSQL-User</em> WITH REPLICATION;
   
4. Create a job in with a source. After you select the Change Data Capture option, enter the replication slot name.

​

Deletion Behavior

​

Support for Incremental Replication

​

More Information