How to add a ODBC connection string in the import definition?

[Q&A] Using the Platform
1

While creating an import definition, if you choose the import type = ODBC, how can you add an SQL connection?

You can choose a value in the select “ODBC connection string” in the import definition form if a value is set in the web.config. You need to put it in the section of the web.config file.

connectionStrings
connectionStrings743×308 22.3 KB

The fields containing “here” + the IP address must be adjusted.

After changing the web.config file you need to update the app, and the newly added value will be visible in the select.

1 Like
2

While we are at the subject… If you plan to import a lot of lines, bigger than your batchsize, you need to order your results using the ORDER BY command in your query, to ensure every row gets imported and no row gets imported twice.

3

Step 1
Download vs code redistributable > Latest supported Visual C++ Redistributable downloads | Microsoft Learn

Step 2
Download ODBC Driver version 17 : Download ODBC Driver for SQL Server - ODBC Driver for SQL Server | Microsoft Learn

Step 3
Create ODBC 32 bit System data source. Select the ODBC 17 driver and give it a name and enter server name and default database.

Step 4
Create ISS Connection string on the website.
Add connection with the SAME name as the ODBC connection you just created with a custom connection string:

DSN=●●●;UID=●●●;PWD=●●●

DSN = the datasource name you just created

UID = SQL server login

PWD = Password of SQL server login

You can also use integarted security then the connection string looks like this:

DSN=●●●;Trusted_Connection=yes;

In Novulo the connection will be available in Import definition > ODBC connection string select.