process-mining
2023.4
false
Process Mining
- 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
- 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
To set up a SQL Server destination connection you need the following setup parameters for the SQL Server database.
ServerDatabaseSchemaRole
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. Check out Setting up a SQL Server account for data upload using an extractor. Password may not contain a semicolon
;. - Create and test the connection.