Microsoft SQL Server¶

To be able to use the Microsoft SQL Server API to perform bulk data loads, first you need to follow these steps:

1. Install the Microsoft Command Line Utilities for SQL Server on the host where the Virtual DataPort server runs:

1. If the Denodo server runs on Windows, download the package and install it.

2. If the Denodo server runs on Linux, follow the steps for your platform.

2. Edit the JDBC data source and click the tab Read & Write. Then, select Use bulk data load APIs and in the Bcp executable location box, enter the path to the file bcp.

   • Windows: it usually is in c:\Program Files\Microsoft SQL Server. For example, c:\Program Files\Microsoft SQL Server\bcp.exe.

   • Linux: it usually is in /opt/mssql-tools/bin. For example, /opt/mssql-tools/bin/bcp.

The process is the same regardless of if you selected a jTDS adapter or a Microsoft adapter.