Oledb connection in Qlikscence

[hari8088]

Hi All,

I am trying to connect Oracle database using oledb connection in qlikscence but i am not able to connect It was asking Server name but i am not able to find server name in my oracle db.

I have metadata file also same issue i am getting by using this file also.

kindly help on this.

Thanks in advance.

Regards,

Hari

[rupamjyotidas]

You will have TNS names for Oracle. Check tnsnames.ora.

You can find all the details there

[hari8088]

I am using oracle SQL*Plus.

Can you please help me where i can get this name

[hari8088]

Hi,

Any help......

[MK9885]

Select your Provider correctly and then manually give the USER NAME and PASSWORD.

Once you give that, test the connection

Get to your DB and select the view you would like to extract data....

If you do not have a provider then maybe you should Install it.

[hari8088]

It's not highlighting test connection option if i gave user name and password

[rupamjyotidas]

You would require your DB details. Contact the DB team if you don't have it.

Only after you give all the details , will the 'Test Connection' be highlighted

[MK9885]

Provide the DATA Source (Data base)

Ex: ABCD.world

This will be the source where you've your schema and view.

After you give that, you'll get 'Test Connection'

[julian_rodriguez]

I recommend you  use the Qlik ODBC Connector,

It's the simplest way to make database's connections that I know.

ODBC Connector

Regards

[jaimeaguilar]

Hi,

you need these 3 parameters in order to succesfully conect to your DB:

Datasource: It can be either the IP of the server or the name of the server

User

Password

After following these 3 steps, you can test your connection.

Also it is important to check if your connection will be made through OLE DB or ODBC,

regards