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:
Install the Microsoft Command Line Utilities for SQL Server on the host where the Virtual DataPort server runs:
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
On Windows: enter
c:\Program Files\Microsoft SQL Server\bcp.exe.
On Linux: enter
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.