Forum Discussion

kabra_ashish's avatar
kabra_ashish
Icon for Helper III rankHelper III
4 years ago

Multiple Schemas in a single report

I am looking to import tables from multiple schemas (same databsase) into a single report.

Example: Table_1 from Schema_1, Table_2 from Schema_2

 

My datasource is PostGRESQL database.

 

Challenge is it only allows to connect to 1 schema and import that table. When I try to import from the other schema (again the same database) I have to edit permissions and then able to import the 2nd but then the table imported from schema 1 throws an error because permissions were edited.

 

Any turnaround here?

Need Help

3 Replies

    • kabra_ashish's avatar
      kabra_ashish
      Icon for Helper III rankHelper III
      4 years ago

      amitchandak I tried using Blank query option and it still doesn't work. I missed saying that every schema has credentials.

       

      So when I try using PosrGRESQL or blank query it prompts for username and password. Ther server name and Database is the same but username and password is seperate for each and every schema created in the database.

       

      So when I import from 1 schema and then try to import using the other it prompts for the credentials and the imports the same. But then the 1st schema imported thors and error.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi kabra_ashish ,

        Do you want to import multiple tables from same PostGRESQL Database? If your tables are from same database I they should need the same credentials. Can you see different tables in Navigator when you connect to database?

        I think you can multiple select the tables you need.

        Here is an offical blog about how to connect to PostgreSQL. I hope it could help you solve your problem.

         

        Best Regards,
        Rico Zhou

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.