Qlikview configuration ODBC Connection SQL Server/oracle

One, Qlikview configures ODBC connection to SQL SERVER

1. Open ODBC Data Source Administrator: Run--〉ODBC

2, add User DSN

3, select SQL Server Native Client 11.0, then click [Finish]

4. Enter the user name and password for the connection database

5, select the default connected database (you can not set this step)

6, Configuration complete

7. Test Connection Database

You can see from the picture above that the connection was successful, and that SQL SERVER 2012 ODBC was configured successfully.

8, Qlikview creates an ODBC data source to connect to the database with the above established

From the above can be seen I set up the sql_server2012 data source, select him and then enter the user name and password as follows:

To test the connection:

In Qlikview, the following statements are automatically generated for the day connection data:

Click on the select in Qlikview to see the objects in the database:

To this qlikview connection, the SQL SERVER 2012 configuration is complete.

Second, Qlikview configures ODBC connection Oracle (this demo is Oracle 11g)

1, create a new data source



Qlikview configuration ODBC Connection SQL Server/oracle