SQL Server Database Settings
To create an SQL Server database data mapping configuration, the following steps are involved:
- Start by opening the Creating a New Data Mapping Configuration wizard.
- In the list, select Data mapping Configuration -> Databases -> SQL Server and click Finish.
- Confirm the Database type is set to SQL Server.
- Set the following properties in this dialog:
-
- Server: Enter the server address for the SQLServer database.
- Port: Enter the port to communicate with the SQLServer. The default port is 1433.
- Database name: Enter the exact name of the database from where the data should be extracted.
- User: Enter a username that has access to the SQLServer and specified database. The user only requires Read access to the database.
- Password: Enter the password that matches the username above.
- Optionally, click Test configuration to verify that the database can be accessed.
- Click OK to close the dialog and open the actual data Mapping configuration (See Creating the Data Mapping Workflow).