Business Integration Solutions documentation
How to: Set up the SQL Reader endpoint
Use the SQL Reader endpoint to read data from SQL Server in XML format and process the data into Microsoft Dynamics NAV.
The SQL Reader endpoint expects data from a SQL Server database connected using the specified connection string. This variant of the reader uses automatic mode, so no further programming is required in SQL Server. The connection string must be in the appropriate format and must at minimum contain the server name, database name, and authentication information.
To set up the SQL Reader endpoint:
- Define a SQL Server database with tables, fields, and relations.
- Obtain a connection string to the SQL Server database that allows the NAV service tier user to connect and read data.
- Define an external document definition for the SQL Server tables and fields to read.
- Include the SQL Reader endpoint in the pipeline.
- Configure the SQL Reader endpoint with the connection string and the external document definition.
- Add additional filter clauses for specific tables in the document definition.
- Select Check Configuration to validate the external document definition and test the SQL connection.
For testing, enable the Trace Level setting to get insights into SQL database logging. Disable the Trace Level before publishing the connection, for performance reasons.
