Problem: Empty model with PostgreSQL [SOLVED]

I'm still having the same problem with version 3.1 and PostgreSQL 9.
Any fix?. Thanks

I am facing the same issue for SQL Server 2005, can anyone tell me if the issue is fixed? If yes please tell me the solution?

For those facing the "Empty model problem" with PostgreSQL:

I tried to create a metamodel with a simple database and I don't have an empty model with this operations (the second step is very important):
1- In the select connection page, in the New Metamodel wizard, select your connection to your PostegreSQL database
2- This will populate the Catalog combo box, now you must select your catalog so click on it (even if there is only one avaiable option)
3- After this selection, the Schema combo box will be populated with the avaiable schemas (I have selected "public" because my sample db is in this schema)
4- Now click next and you must see your tables to import in the Physical Model (and later in the Business Model).

I'm using the last version of PostgreSQL 9.1 avaiable on the website with the JDBC4 drivers.
Try this steps and tell me if you have problems.

any solutions for MS SQL Server 2005/2008 ?

Thank you very much!!!

I tried everything, I can't understand why I didn't try that.

Now, it works :)

Just a note, the previous operations are valid for the same problem (Empty model) with HSQLDB.

For SQL Server 2005 we are trying to do a test in the next days.

deepak.grmani.spw wrote:any solutions for MS SQL Server 2005/2008 ?

Have you selected the correct catalog when you are creating the model? (see the previuos post for PostgreSQL with similar problem)
I've done successfully a test with SQL Server 2005 using the last sqljdbc4 drivers.

Hello,
I got the same problem with Postgresql 9.1, It seems to be due to then JDBC driver.
Because when I try With an ORACLE JDBC, it works fine.
Can you please tell me what is the right version of the JDBC to use ?

Hi, try with postgresql-9.1-901.jdbc4 and check that you have jdk 1.6 installed.

Hi, try with postgresql-9.1-901.jdbc4 and check that you have jdk 1.6 installed.

Hi,

I have the same problem using server 3.6 and postgres 9.2, which driver should I use? Thank you.

Best,
Daniel

HI, i know here said "solved", but i face this problem with Postgresql 9.5 and SpagoBI all in one 5.1, i did all that is suggested here, but my postgresql doesn't show anything, just a blank page in the spagoBI, at the spagoBI studio it have everything, the BI model with the Physical model, dimensions and the cube, but when i upload it, is just blank...

i appreciate any help with this matter and thank you.