Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Connecting to enterprise databases

Hi, everyone!

Can anybody explain me, how to connect to enterprise databases? I mean I've read all that "OLE DB, ODBC" thing, saw some simple examples, but however I can't get it.

I need to connect my Qlikview file to HR system to  load the information. I see the front-end part of it in the browser, however I have no idea of what type of database it is: Oracle or other.

Has anybody had such an experience loading the info from various databases? How did you do that?

1 Solution

Accepted Solutions
sinanozdemir
Specialist III
Specialist III

Hi Diana,

The main difference is that:

ODBC is for relational databases such as SQL Server or PL/SQL

OLE DB for both relational and non-relational databases such as Access, Excel, SQL Server, or PL/SQL.

I use ODBC connections to load data from various servers. In order to do that, you first need to create an ODBC connection to your HR database and you can retrieve the server and database names from your DBA(s). In the Windows' search box, just type ODBC and i will bring you the ODBC driver. I also 64 bit. I also pick "SQL Server Native Client 10.0" from the driver choices.

Some of the settings that your DBA needs to provide is what kind of authentication you need to use such as Windows NT authentication or additional configuration options. Once you are in the server, you need to pick a database and finally test the connection.

Hope this helps.

View solution in original post

3 Replies
datanibbler
Champion
Champion

Hi Diana,

well, you do need to know what type of database it is and how you can connect to it 😉

Your HR department should know that given it is their database ...

Then you need to be set up in the database (if you do the reloads; If the server does that on a regular basis, then that server_user needs to be set up).

You can go from there.

HTH

Not applicable
Author

Hello!

Thanks for the reply! Ok, I get it. Can you please tell me which type of questions do I need to ask? I mean: what type of database they have and the path to it? Or do they need to give me special rights?

I'm sorry for stupid questions, this task is pretty new to me.

sinanozdemir
Specialist III
Specialist III

Hi Diana,

The main difference is that:

ODBC is for relational databases such as SQL Server or PL/SQL

OLE DB for both relational and non-relational databases such as Access, Excel, SQL Server, or PL/SQL.

I use ODBC connections to load data from various servers. In order to do that, you first need to create an ODBC connection to your HR database and you can retrieve the server and database names from your DBA(s). In the Windows' search box, just type ODBC and i will bring you the ODBC driver. I also 64 bit. I also pick "SQL Server Native Client 10.0" from the driver choices.

Some of the settings that your DBA needs to provide is what kind of authentication you need to use such as Windows NT authentication or additional configuration options. Once you are in the server, you need to pick a database and finally test the connection.

Hope this helps.