Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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
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
Hi Aravind,
You didn't understand my point.
I want to create that connection. I know how to load into qlikview
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)
How can I create this connection OLEDB CONNECT32 TO.....
Can someone explain me step by step
You have Password?
you can do it through connect button in script editor by selecting OLEDB
Yes, I have password. Can you please guide me step by step
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.
Hi Suresh,
https://help.qlik.com/en-US/sense/2.1/Subsystems/Hub/Content/LoadData/ODBC-data-connection.htm
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
Do the following:
The connection is now added to the Data connections, and you can connect to, and select data from the connected data source.
Do the following:
Thanks,
Arvind patil