./configure make make install
Configuring the Data Source Name (DSN)
Once you have installed the ODBC Driver Client software on your workstation, you have to configure it to connect to a Teiid Runtime. Note that the following instructions are
./configure make make install
Configuring the Data Source Name (DSN)
Once you have installed the ODBC Driver Client software on your workstation, you have to configure it to connect to a Teiid Runtime. Note that the following instructions are specific to the Microsoft Windows Platform.
To do this, you must have logged into the workstation with administrative rights, and you need to use the Control Panel’s Data Sources (ODBC) applet to add a new data source name.
Each data source name you configure can only access one VDB within a Teiid System. To make more than one VDB available, you need to configure more than one data source name.
Follow the below steps in creating a data source name (DSN)
From the Start menu, select Settings > Control Panel.
The Control Panel displays. Double click Administrative Tools.
Then Double-click Data Sources (ODBC).
The ODBC Data Source Administrator applet displays. Click the tab associated with the type of DSN you want to add.
The Create New Data Source dialog box displays. In the Select a driver for which you want to set up a data source table, select PostgreSQL Unicode.
The PostgreSQL ODBC DSN Setup dialog box displays.
In the Data Source Name edit box, type the name you want to assign to this data source. In the Database edit box, type the name of the virtual database you want to access through this data source. In the Server edit box, type the host name or IP address of your Teiid runtime. If connecting via a firewall or NAT address, the firewall address or NAT address should be entered. In the Port edit box, type the port number to which the Teiid System listens for ODBC requests. By default, Teiid listenes for ODBC requests on port 35432 In the User Name and Password edit boxes, supply the user name and password for the Teiid runtime access. Provide any description about the data source in the Description field.
Click on the Datasource button, you will see th