Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data Source

I am connecting to an Oracle database instance and when I go to create the connection in the wizard by:

1. Selecting edit script

2. Selecting ODLE DB then Connect

3. Selecting Oracle Provider for OLE DB

4. On the connection Tab I do not know the value to put in for the prompt requesting me to

"Enter the data source and/or location of the data

Data Source: ??? I don't know what to put here and the video doesn't explain it

5. The part that says "Enter information to log on to the server:

I select "Use a specific user name and password" then I enter the correct information.

The test connection tab comes back as pass but it is not connecting me to a specific database. What do I do?

11 Replies
agomes1971
Specialist II
Specialist II

Hi,

please see this

how to connect in oracle database?

HTH

André Gomes

johnca
Specialist
Specialist

Hi Ledon,

The data source is the database name, and usually looks something like ERPDATA02 (but could be anything). It is part of the TNS info used to access the database that must be in the TNSNAMES.ORA file you're computer is pointed to. It could be local or on the server someplace. Did you set up an environment variable in system properties for this?

--john

Not applicable
Author

Sorry,

This has been more of a journey than I expected. My database name in oracle 12c is SSSales. That is not working as a data source so I guess that they are looking for a specific path. I do not know what that path name is. Other relevant data might be that the system is on localhost on port 1521. The system is not taking SYTSTEM@//localhost:1521/ORCL as a potential string. I don't know if this helps much

Not applicable
Author

Hi Andre,

Thank you for your response. The link that you gave did not help. Are you able to review the below listed thread?

johnca
Specialist
Specialist

Are you using QlikView Personal Edition? Do you have an Enterprise-wide QlikView setup, or local Desktop only?

The name SSSales is only part of the connection. I'm no expert, and no IT background, but I think you need to update your tnsnames.ora file with the tns information for this database. And, make sure your QlikView points towards this file with an environmental variable. Can you confirm any of this exists? If not, go to advanced system settings > environment variables and look for a variable called TNS_ADMIN. It's value will be the path where your tnsnames.ora file resides. It could be local...it could be on the QlikView server...it could be almost anywhere. If that doesn't exist you will have to add it, knowing where the tnsnames.ora file really is. Let me know if you can get his far.

Not applicable
Author

Hi John,

I am using QlikView Desktop personal edition. It is not set up on a network. My Oracle database is 12c and it is on my desktop as a local host as well. The document you are speaking of is in the following path C:\app\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN\SAMPLE

I don't know much of anything about how the listener program goes about searching this document. I searched the web and there was some info on this but I am afraid to mess with I tmuch because I don't want to shut down my Oracle Dbase. The file is attached below.

johnca
Specialist
Specialist

Hi Ledon, did you look in System >> Advanced System Settings >> Environment Variables for the TNS_ADMIN listing? It's value should be the path you show.

Not applicable
Author

IIs this a user variable or a system variable? I used the following instructions to set it up Create a Variable for the TNSNames.ora File - Toad for Oracle 12.1 Guide to Using Toad for Oracle

johnca
Specialist
Specialist

I would surmise its a system variable, but did it help?