2 issues : Invisible user and Invisible table from BI reporting

4286062

Hello,

I have created 2 users : "USER1" and "C##USER2".

1- USER1 : I connected Power BI and Qlik sense to the database but the "USER1" is not visible from Power BI and Qlik sense (with SQL plus and SQL developper the user is visible)

2- C##USER2 : I created a new table in this user, the C##USER2 is visible from "Power BI "and "Qlik sense" but not the table

I tryed 2 tools to know if the problem coms from the BI tools or from the database, maybe parameters to add in the database ?

Thanks a lot for your help.

best regards.

cormaco

Your connection in SQL Developer is to xepdb1.

This is the default PDB in an Oracle 18XE installation, you are supposed to work with that.

The connection in your other screenshots is to XE, this is the CDB$ROOT and as I said you should not create users there.

Unfortunately Oracle does not create an entry for xepdb1 in TNSNAMES.ORA during installation.

Use xepdb1 as in SQL Developer.

cormaco

Please change your display name into something readable:

How can I change my Display Name?

Also post your exact database version, use "select * from v$version" to find out.

The username C##USER2 is typical for a common user in the CDB$ROOT database, you shouldn't create you own users there except for special purposes.

The user USER1 has probably been created in a PDB.

https://oracle-base.com/articles/12c/multitenant-manage-users-and-privileges-for-cdb-and-pdb-12cr1#create-common-users

You can find more information on Oracle's Multitenant Architecture here:

https://oracle-base.com/articles/12c/multitenant-overview-container-database-cdb-12cr1#overview

Can you show us the exact connect strings you use to connect in BI-Publisher, Qlik and SQLPlus, SQL Developer repectively?

4286062

Thanks for your answer. I wanted just to know what is the right way to create users, fill them with tables and data, user the right connexions to be able to see the users, tables and data from the reportings BI tools ? Thanks a lot.

1- The databse version :

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

BANNER_FULL

--------------------------------------------------------------------------------

BANNER_LEGACY

--------------------------------------------------------------------------------

    CON_ID

----------

Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production

Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production

Version 18.4.0.0.0

Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production

         0

BANNER

--------------------------------------------------------------------------------

BANNER_FULL

--------------------------------------------------------------------------------

BANNER_LEGACY

--------------------------------------------------------------------------------

    CON_ID

----------

2- you fin the connexions setting in the Screenshots (I used the tnsname automatikly created by oracle)

4286062

I Forget other screenshots, sorry :

cormaco

Your connection in SQL Developer is to xepdb1.

This is the default PDB in an Oracle 18XE installation, you are supposed to work with that.

The connection in your other screenshots is to XE, this is the CDB$ROOT and as I said you should not create users there.

Unfortunately Oracle does not create an entry for xepdb1 in TNSNAMES.ORA during installation.

Use xepdb1 as in SQL Developer.

4286062

Hi cormaco,

Thanks a lot for your helpful answer, it working fine now for Power Bi and Qlik sens.

1- Qlik Sens : I you saifd before, I just replaced the service name from XE to XEPDB1

2- Power BI : I changed the tnsname from XE to XEPDB1 :

In the connexion server i fill : XEPDB1 :

All is working fine, really thanks a lot for your help, have a nice day.

Best regards

cormaco

2- Power BI : I changed the tnsname from XE to XEPDB1 :

That is not enough, you have to change the servicename to XEPDB1 as well. As it is now you have only gives the connection to XE a new name

4286062

Yes you are right, I changed also the servicename from XE to XEPDB1, Thanks a lot