topic Re: Data Source in QlikView

Data Source

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Data Source

agomes1971 — Thu, 25 Aug 2016 16:16:45 GMT

Hi,

please see this

how to connect in oracle database?

HTH

André Gomes

Re: Data Source

johnca — Thu, 25 Aug 2016 17:30:58 GMT

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

Re: Data Source

Thu, 25 Aug 2016 18:46:40 GMT

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

Re: Data Source

Thu, 25 Aug 2016 18:49:19 GMT

Hi Andre,

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

Re: Data Source

johnca — Thu, 25 Aug 2016 20:34:06 GMT

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.

Re: Data Source

Thu, 25 Aug 2016 22:01:10 GMT

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.

Re: Data Source

johnca — Fri, 26 Aug 2016 00:10:39 GMT

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.

Re: Data Source

Fri, 26 Aug 2016 00:22:51 GMT

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

Re: Data Source

johnca — Fri, 26 Aug 2016 12:26:50 GMT

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

Re: Data Source

Sat, 27 Aug 2016 18:37:11 GMT

Sorry John. Was super busy yesterday. Let me take a look at it a little later today and I will respond back tomorrow. Thank you for your time and your quick response.

Re: Data Source

Sun, 28 Aug 2016 19:34:05 GMT

Nope. Same error. It's official. Networking sucks lol... I have no idea how to get around this. This should be such an easy step.