topic Re: how to connect in oracle database , Teradata database,Sql Server and DB2? in QlikView

how to connect in oracle database , Teradata database,Sql Server and DB2?

sbkumar — Wed, 25 Nov 2020 16:16:04 GMT

Hi I need an assistance on using different databases,up to now i am using only ODBC,OLEDB.Now i want to try for DB2,Oracle,Teradata and SQL Server databases.what are the prerequisites to use them?please help me to get the solution.

Re: how to connect in oracle database , Teradata database,Sql Server and DB2?

Anil_Babu_Samineni — Fri, 13 Oct 2017 07:20:25 GMT

Does ODBC, OLEDB are DB's?

Here, What you have done earlier is the approach can form in these. So, You need to start from Google to know connection about external data sources. Will you?

For ref - How to pull data from PostgreSQL to Qlik

Re: how to connect in oracle database , Teradata database,Sql Server and DB2?

sbkumar — Fri, 13 Oct 2017 10:50:11 GMT

no no odbc and oledb are not db's, their are just providers to access data i mean to say that I used odbc and oledb providers to access data.now i want to know about teradata,db2 and oracle ? can you please tell me the procedure?

Re: how to connect in oracle database , Teradata database,Sql Server and DB2?

Anil_Babu_Samineni — Fri, 13 Oct 2017 10:57:12 GMT

If you open the like where i provide last reply. You will get idea the same. Try to get DB's information like

Server Name, Username, Password, DB on the server details to get into work. And use OLEDB to connect and fill all mention above then you will achieve that

Re: how to connect in oracle database , Teradata database,Sql Server and DB2?

Anil_Babu_Samineni — Fri, 13 Oct 2017 12:34:07 GMT

Please close this thread by flag correct answer so then next land up users may easy to understand

Re: how to connect in oracle database , Teradata database,Sql Server and DB2?

Peter_Cammaert — Fri, 13 Oct 2017 13:20:15 GMT

For each RDBMS (luckily they're all providing a relational interface) you first have to download an ODBC or OLE DB driver from the respective manufaturer's web site. Then install the drivers. Each DBMS product has it's own driver.

Then proceed as you did with your other DB connections by configuring the OLE DB connection, or defining an ODBC DSN and configuring an ODBC Connection in QlikView.