Replies 2

Amazon Redshift is based on PostgreSQL and as its documentation states you can use PostgreSQL JDBC drivers to connect to database. This way you can use our reverse engineering tool that can connect to your database and extract schema information to Vertabelo XML file. Then you should create empty database model in Vertabelo (choose PostgreSQL engine) and import XML file. Here you find detailed instruction how to use our reverse engineering tool:https://www.vertabelo.com/blog/documentation/reverse-engineering

The second option you can try is dumping your database schema to sql file and import it directly into Vertabelo (we have import from SQL DDL feature). But I'm not sure if pg_dump works well with Amazon Redshift.

Warning: SQL definition for view 'datarepo.cntct_addr' not found.Probably the user you're running the application as (shradha_samantray) has no permission to read the view definition.

Try running the application as a different user.

Warning: SQL definition for view 'staging.seq_1_to_1000' not found.Probably the user you're running the application as (shradha_samantray) has no permission to read the view definition.Try running the application as a different user..Extracting reference information

Extracting sequence informationException in thread "main" java.lang.AbstractMethodError: Method org/postgresql/jdbc2/Jdbc2DatabaseMetaData.getDatabaseMajorVersion()I is abstract at org.postgresql.jdbc2.Jdbc2DatabaseMetaData.getDatabaseMajorVersion(Jdbc2DatabaseMetaData.java) at com.vertabelo.reverse.oa.a(:290) at com.vertabelo.reverse.nt.b(:193) at com.vertabelo.reverse.Main.main(:491)