process-mining
2023.10
false
Process Mining user guide
- Before you begin
- Getting started
- Integrations
- Working with process apps
- Working with dashboards and charts
- Working with process graphs
- Working with Discover process models and Import BPMN models
- Showing or hiding the menu
- Context information
- Export
- Filters
- Sending automation ideas to UiPath® Automation Hub
- Tags
- Due dates
- Compare
- Conformance checking
- Root cause analysis
- Simulating automation potential
- Triggering an automation from a process app
- Viewing Process data
- 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
- Viewing logs
- Optimizing an app
- Scheduling Data Runs
- Customizing process apps
- Publishing Dashboards
- App templates
- Additional resources
- Out-of-the-box Tags and Due dates
- Editing data transformations in a local environment
- Setting up a local test environment
- Designing an event log
- Extending the SAP Ariba extraction tool
- Performance characteristics
Create a destination connection
Create a SQL Server destination connection in CData Sync using the required server, database, schema, and role parameters for Process Mining on Automation Suite.
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.