5.1.6.2. Type 2 ODBC connection: Create&Use an ODBC connection based on a Connection-String

<< Click to Display Table of Contents >>

Navigation:  5. Detailed description of the Actions > 5.1. General Parameters used in many actions > 5.1.6. ODBC Connections >

5.1.6.2. Type 2 ODBC connection: Create&Use an ODBC connection based on a Connection-String

 

Let’s give a small example of usage. In the below example, we’ll create a new “Type 2” ODBC connection to access the content of a “Microsoft SQLServer database”. The technique is similar for all the databases (Oracle, Teradata, SQL Server, DB2, etc.). You’ll find additional information for the proper setup of an ODBC connection to an Oracle, Teradata, MySQL & Sybase database in the sections 5.1.6.3. to 5.1.6.6.

 

Inside Anatella, inside the “Manage OBC Connections” window, click the button named “Add an ODBC connection based on a Connection-String”:

 

clip0015

 

 

A window that lists all the installed ODBC drivers opens. Since we want to access the content of a “Microsoft SQLServer database”, we’ll select the “SQL Server” ODBC driver on the first line (Thereafter, we click the “Next” button and we wait: i.e. The next Window usually appears after a long time):
 

ANATEL~2_img81

 

 

For your convenience, you can go here to directly download the most common ODBC drivers (for MS-SQLServer, Oracle, Teradata, MySQL, SQLite, Access, Sybase, DB2):
 

http://download.timi.eu/ODBC/

 
 
The above drivers have been thoroughly tested and are known to work well with Anatella.

 

 

ANATEL~2_img8

If you cannot see an ODBC driver that you just installed, it means that you are using the 64-bit “Microsoft ODBC Administrator” software (for Anatella 64-bit) and you installed some 32-bit ODBC drivers (or vice versa).

Be sure to install 64-bit ODBC drivers to be able to use Anatella 64-bit

(or install 32-bit ODBC drivers, if you want to use Anatella 32-bit).

 
 
All the next Windows are all based on the same canvas: They are progressively collecting all the required informations to properly contruct the connection string. For example, the first requested parameters are:

 

ANATEL~2_img83

 

 
The second set of requested parameters are:

 

clip0016
 

 

Since, inside this second set, all the parameters are optional, you can skip all later steps and directly click the “Finish Immediately” button here:    

 
ANATEL~2_img84

 
 
We should now have one additional row/connection inside the “Manage OBC Connections” window:

 

ANATEL~2_img85

 

 
Let’s give a proper name to this new connection: In the example above, the name is “sqlserver”:

 

clip0017

 
 

The setup of our new ODBC connection is now complete. This means that we can now use our new ODBC connection inside a ANATEL~2_img46 readODBC action (see section 5.2.3) or inside a ANATEL~2_img47 upsertODBC action (see section 5.24.4).

 

For example: Let’s use a ANATEL~2_img46 readODBC action to extract the table “censusincome” from our SQLServer database:

 

ANATEL~2_img89