Forum Discussion

Helper 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. Challen...

Super User

4 years ago

kabra_ashish , Check if you add them as queries using schema name in the table. Option to give query in advanced options

kabra_ashish
Helper 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
  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.