process-mining
2023.4
false
- Release notes
- Before you begin
- Getting started
- Integrations
- Managing access
- Working with process apps
- Creating apps
- Loading data
- Uploading data
- Retrieving the SQL Server database parameters
- Setting up a SQL Server account for data upload using an extractor
- Installing CData Sync
- Create a source connection
- Create a destination connection
- Create a job
- Run the job
- Incremental extraction
- Troubleshooting CData Sync
- Loading data using Theobald Xtract Universal
- Customizing process apps
- Data transformations
- TemplateOne app template
- Purchase to Pay app template
- Order to Cash app template
- Basic troubleshooting guide
Create a destination connection
Process Mining
Last updated Oct 17, 2024
Create a destination connection
To set up a SQL Server destination connection you need the following setup parameters for the SQL Server database.
Server
Database
Schema
Role
Follow these steps to create the SQL Server destination connection.
- Define a new connection of type SQL Server.
- Enter a descriptive name for the destination connection. For example SQLServer_IM.
- Configure the Settings to connect to your SQL Server database using the SQL Server database setup credentials retrieved
Note: Server must be specified as <Server>,<Port>.Note: User / Password must be the SQL credentials of the user that has permissions to write into the database. See also Setting up a SQL Server account for data upload using an extractor. Password may not contain a semicolon
;
. - Create and test the connection.