Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

stonecold111
Contributor

Oracle database connection

Hi Qlikss,

In one of my dashboards connection to oracle database got added by using Insert --->Include  from a text file. Can someone guide me to create a connection like below to Oracle database.

OLEDB CONNECT32 TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=FCKQLIKV;Data Source=BIFCKPROD;Extended Properties=""] (XPassword is DFcUJFFPPLINJUUjstQSTQdMWD);

14 Replies
arvind_patil
Valued Contributor II

Re: Oracle database connection

Hi Suresh,

Please do below steps.

1. Copy above connection code into notepad

OLEDB CONNECT32 TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=FCKQLIKV;Data  Source=BIFCKPROD;Extended Properties=""] (XPassword is DFcUJFFPPLINJUUjstQSTQdMWD);

2.Give appropriate name to file

  LiveConnection.txt

3. Go to Sript editor there is option in file include.

include LiveConnection.txt

4.Load the database table.

Thanks,

Arvind Patil


venkatasreekant
Valued Contributor

Re: Oracle database connection

Hi Kumar,


Save the connection string in a .txt file. Using the include function call that connection string notepad in Qlikview script. With this connection string notepad, your no need to connect every time to same Database.


Thanks & regards,

Venkata Sreekanth

stonecold111
Contributor

Re: Oracle database connection

Hi Aravind,

You didn't understand my point.

I want to create that connection. I know how to load into qlikview

stonecold111
Contributor

Re: Oracle database connection

Hi Srikanth,

I want to know how to create that connection.connection is already there in qlikview and it got developed by some other guy. I just want know how he created that line of code

OLEDB CONNECT32 TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=FCKQLIKV;Data Source=BIFCKPROD;Extended Properties=""] (XPassword is DFcUJFFPPLINJUUjstQSTQdMWD)

stonecold111
Contributor

Re: Oracle database connection

How can I create this connection OLEDB CONNECT32 TO.....

Can someone explain me step by step

shiveshsingh
Honored Contributor

Re: Oracle database connection

You have Password?

you can do it through connect button in script editor by selecting OLEDB

stonecold111
Contributor

Re: Oracle database connection

Yes, I have password. Can you please guide me step by step

shiveshsingh
Honored Contributor

Re: Oracle database connection

Sure, select OLE DB database in script editor and click on connect, a new data link properties  window will open.

Select Microsoft  OLE DB  Provider  For SQL Server,click next.

Select your server name, and put user name and password to connect to server.

On that server, select the DB that contains the tables. Test connection and it's done!

Hope you are having necessary drivers installed.

arvind_patil
Valued Contributor II

Re: Oracle database connection

Hi Suresh,

https://help.qlik.com/en-US/sense/2.1/Subsystems/Hub/Content/LoadData/ODBC-data-connection.htm

ODBC data connections

You can create a data connection to select data from an ODBC data source that has already been created and configured in the ODBC Data Source Administrator dialog in Windows Control Panel.

See: ODBC

Creating a new ODBC data connection

Do the following:

  1. Click Create new connection and select ODBC.The Create new connection (ODBC) dialog opens.
  2. Select which data source to use from the list of available data sources, either User DSN or System DSN.System DSN connections can be filtered according to 32-bit or 64-bit.For User DSN sources you need to specify if a 32-bit driver is used with Use 32-bit connection.
  3. Add Username and Password if required by the data source.
  4. If you want to use a name different from the default DSN name, edit Name.
  5. Click Create.

The connection is now added to the Data connections, and you can connect to, and select data from the connected data source.

Editing an ODBC data connection

Do the following:

  1. Click @ on the ODBC data connection you want to edit.The Edit connection (ODBC) dialog opens.
  2. You can edit the following propertiesSmiley Frustratedelect which data source to use from the list of available data sources, either User DSN or System DSN.UsernamePasswordName
  3. Click Save.

Thanks,

Arvind patil

Community Browser