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

**URL:** <https://community.novulo.com/t/how-to-add-a-odbc-connection-string-in-the-import-definition/97>\
**Category:** \[Q&A\] Using the Platform\
**Tags:** implementation\
**Created:** [April 18, 2024, 6:35am UTC](https://community.novulo.com/t/how-to-add-a-odbc-connection-string-in-the-import-definition/97 "2024-04-18T06:35:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![k.molokova](https://avatars.discourse-cdn.com/v4/letter/k/34f0e0/32.png) [@k.molokova](https://community.novulo.com/u/k.molokova)\
**Post date:** [April 18, 2024, 6:35am UTC](https://community.novulo.com/t/how-to-add-a-odbc-connection-string-in-the-import-definition/97/1 "2024-04-18T06:35:13Z")

</div>

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](https://canada1.discourse-cdn.com/flex008/uploads/novulo/original/1X/d07c4f2c59d9f732ffaaa3640a19eac27658c568.png)

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

---

<div class="post-metadata">

**Author:** ![Helena](https://avatars.discourse-cdn.com/v4/letter/h/c68b51/32.png) [@Helena](https://community.novulo.com/u/Helena)\
**Post date:** [April 18, 2024, 11:54am UTC](https://community.novulo.com/t/how-to-add-a-odbc-connection-string-in-the-import-definition/97/2 "2024-04-18T11:54:15Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![k.molokova](https://avatars.discourse-cdn.com/v4/letter/k/34f0e0/32.png) [@k.molokova](https://community.novulo.com/u/k.molokova)\
**Post date:** [April 25, 2024, 9:59am UTC](https://community.novulo.com/t/how-to-add-a-odbc-connection-string-in-the-import-definition/97/3 "2024-04-25T09:59:53Z")

</div>

**Step 1**  
Download vs code redistributable \> [Latest supported Visual C++ Redistributable downloads | Microsoft Learn](https://learn.microsoft.com/en-us/cpp/windows/latest-supported-vc-redist?view=msvc-170#visual-studio-2015-2017-2019-and-2022)

**Step 2**  
Download ODBC Driver version **17 :** [Download ODBC Driver for SQL Server - ODBC Driver for SQL Server | Microsoft Learn](https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16)

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