Microsoft SQL Server and Azure Synapse SQL¶

To use the API of Microsoft SQL Server or Azure Synapse SQL 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.

   • On Windows: enter c:\Program Files\Microsoft SQL Server\bcp.exe.

   • On Linux: enter /opt/mssql-tools/bin/bcp.

   Note

   Make sure the file path you enter exists; on your system, “bcp” may be installed on a different path.

If the database is SQL Server, the process is the same regardless of if you selected a jTDS adapter or a Microsoft adapter.

SET 'com.denodo.vdb.util.tablemanagement.sql.insertion.sqlserver.SqlServerBcpInsertWorker.keepEmptyStrings' = 'true';