...
Code Block |
---|
language | xml |
---|
title | Example jdbc configuration |
---|
|
<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.
Code Block |
---|
language | xml |
---|
title | Example jdbc configuration |
---|
|
<importTypeStandard>database</importTypeStandard>
<jdbcDriverClass>com.microsoft.sqlserver.jdbc.SQLServerDriver</jdbcDriverClass>
<jdbcConnectionString>jdbc:sqlserver://0.0.0.0:1433;databaseName=originaldatabase;Integrated Security=SSPI;</jdbcConnectionString>
.....
<table name="[168.168.0.0\TESTLINK].dbName.dbo.TableName">
<locationColumn name="st_code"/>
<dateTimeColumn name="site_time"/>
<valueColumn name="waterlv" parameterId="H.obs"/>
<valueColumn name="flow" parameterId="Q.obs"/>
</table>
|
Configuration for PostgreSQL
...