...
| Code Block | ||||
|---|---|---|---|---|
| ||||
<jdbcDriverClass>net.sourceforge.jtds.jdbc.Driver</jdbcDriverClass> <jdbcConnectionString>jdbc:jtds:sqlserver://hostname;DatabaseName=TestDB;integratedSecurity=true;</jdbcConnectionString> |
SQL Server with linked server
It is also possible to use the database import from a Microsoft SQLServer database with a linked server. In the example below the linked server is "168.168.0.0\TESTLINK" with a database name "dbName", schema name "dbo" and table name "TableName". To import data from this table, the connectionstring need to be connected to the original database, the table configuration requires the linked database information. If the linked server contains points '. ', line in an IP address, make sure to use [] around the linked server name.
...