Import connection using SQL Server integration Microsoft Dynamics NAV

Dec 30, 2014 6:00:00 AM

Import connection using SQL Server integration Microsoft Dynamics NAV

In the To-Increase Business Integration Solutions for Microsoft Dynamics NAV, you can use the SQLREADER endpoint to read XML messages from Microsoft SQL Server. Today, we explain how to create an import connection using SQL Server integration. Our focus will be mainly on the SQL Reader endpoint.

In the following example, we will import the sales orders from the SQL database if the status of the sales order (sales header) is other than “Open” (i.e. Status > 0).

To begin with, you create an internal document to import sales header information into Microsoft Dynamics NAV. We want to generate the No. field automatically based on a number series. So select the No. field and in the field properties provide the Value Type and Value.

BIS NAV SQL Import 1

Next, create an external document to import sales header information from the SQL database. Choose the Subtype as SQL Server and provide SQL server connection credentials or a SQL connection string.

BIS NAV SQL Import 2

Then select the corresponding SQL table and fields.

BIS NAV SQL Import 3

Now, you need to create a connection. There are several ways to accomplish this.

You can create a connection with the SQL Reader.

BIS NAV SQL Import 4

Or you can create a connection with the SQL Mapper.

BIS NAV SQL Import 5

You can also create a connection with the SQL Record Generator.

BIS NAV SQL Import 6

Or you can use the Pipeline to create a connection.

BIS NAV SQL Import 7

In the next step, you process the connection. If the job queue is set up properly, the records are processed through the job queue.

Once the records have been processed successfully, check History.

BIS NAV SQL Import 8

I hope this example gives you a good idea on how to work with the SQL Reader endpoint in a Dynamics NAV environment! With any feedback or questions, please contact  To-Increase.

Share this message
About Author
Martien van Dam

Martien van Dam

Having started his career with To-Increase, Martien has honed and contributed his expertise across multiple roles and domains for 15 years now. Besides Microsoft, he’s also worked closely with all kinds of stakeholders in the ecosystem—including software vendors, CFOs, Accounts Payable (AP) clerks/managers, logistics managers—and is cognizant of their challenges and needs. Therefore, as a Sales Specialist for our Business Productivity and Accounts Payable domains, Martien brings a balanced mix of different market perspectives from various global associates to the table. On the personal front, Martien enjoys meeting people and experiencing cultures, and has visited around 75 countries. He's passionately involved in voluntary work and loves spending time with his three kids in the great outdoors. Martien holds a Bachelor of Commerce in International Marketing Management and Business Process and Project Management.

Get In Touch

Related Blogs

Jan 6, 2021 10:48:51 AM
Aug 11, 2020 7:38:40 AM
Jun 11, 2020 1:42:30 PM