# Step 1: Set up a publisher

## Procedure

1. Set up a database connection dedicated to CDC.
2. Set up a connection to the database where data is located.

## Results

For more information about how to set up a database connection, see [Centralizing database metadata](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/centralizing-database-metadata).

Information noteNote: If you work with an MS SQL Server, you must set the two connections to the same database but using two different schemas.

![Example of two connections to the same database on an MS SQL Server.](https://help.qlik.com/talend/en-US/studio-user-guide/Resources/images/cdc_trigger_publisher.png)