- Release notes
- Before you begin
- Getting started
- Managing access
- Working with process apps
- Creating process 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
Setting up a SQL Server account for data upload using an extractor
In order to set up a destination connection to the SQL Server database for uploading data to Process Mining on-premises (Automation Suite), a database user is needed with the correct access permissions for a process app.
When using SQL Server as the destination connection in your extraction tool, the following authentication methods are available.
Authentication method |
Description |
---|---|
SQL Server Authentication |
A SQL Server user in the target database. |
Windows Authentication |
A windows user that has access to the SQL database. |
See the illustration below.
Refer to the official Microsoft documentation for more information on authentication methods.
Both SQL Server Authentication and Windows Authentication are supported authentication methods for loading data for Process Mining process apps using an extractor. However, using Windows Authentication will require additional actions. See Windows Authentication below..
The database user needs to have access permissions to write to the app schema of the corresponding Process Mining process app in the SQL Server database. When a new Process Mining process app is created, the app schema is provided in the Upload data using extractor step. See the illustration below.
Access can be set up in the following ways:
- One user with access to all process app schemas
- One or more users with access to specific process app schemas
A database user is set up for loading data into the Process Mining SQL Server database. This database user is granted access permissions to access all Process Mining app schemas, and must have permissions to add or delete tables in these app schemas. This way, this user can be used when loading data for all Process Mining process apps. When creating a new process app in Process Mining, no additional access permissions have to be set for this database user.
AutomationSuite_ProcessMining_Warehouse
database.
Permission |
To grant |
---|---|
|
read access on all tables in the database. |
|
write access on all tables in the database. |
|
update access on all tables in the database. |
One or more database users are set up for loading data into the Process Mining SQL Server database. Each database user is granted access to write into the specific app schema of a one or more Process Mining process apps. When a new Process Mining process app is created, automatically a database Role is generated in SQL Server for accessing the corresponding app schema. The database user who is allowed to upload data for the new process app, must get assigned the app-specific role, to write in the correct app schema for the process app.
When using Windows Authentication, CData Sync uses the Windows user with which the CData Sync instance is started as the database user. This implies that a CData Sync instance can make use of only one Windows user account. If multiple Windows users are required, each Windows user needs to have their own different CData installation, in order to run CData Sync with a different Windows user.