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:
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
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.