In creating an ODBC connection the Business-Intelligence module wizard will offer help. In case there are previously set connections on the Windows ODBC surface, we can use them by selecting the User DSN, the system DSN and the File DSN options. In this case we have to give only the name of the given configuration.

 

In case we want to create a new ODBC connection, we have to select the ODBC drive and add DBQ option, then click on the Next button:

 

 

In the next window we have to select among the installed ODBC drivers which one we want to use:

 

 

DBQ parameters (E.g.: CSV or txt) are needed in case of text drivers; here we have to add the access path (file level) of the actual text file (if we do not need it, just put an empty apostrophe pair into the filed):

 

 

If our data resource need authentication, we can give our user name and password in this window (in case no login information is needed, just leave the fields blank):

 

 

Finally give the name of the server or database (in our example we get connected to a PowerLogic SMS1500 system):

 

 

 

Finally, by clicking on the Finish button the prepared connection string will get into the filed of ODBC variable connection string and we can connect to the given database.