Solved: Re: Connecting to enterprise databases - Qlik Community

Report Inappropriate Content · ‎2015-06-15

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?

sinanozdemir · ‎2015-06-15

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

datanibbler · ‎2015-06-15

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

Report Inappropriate Content · ‎2015-06-15

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 · ‎2015-06-15

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.