Re: Generate PG schemas from the Oracle Data Modeler tool?

I have established a connection between the Oracle tool and my PG databases
by installing the PG JDBC driver from
https://jdbc.postgresql.org/download.html and following instructions at
http://stackoverflow.com/questions/7592519/oracle-sql-developer-and-postgresql/22299552
and https://www.youtube.com/watch?v=UGG_N9Mlgdw&feature=youtu.be .

While the connection thus established seems solid, it delivers access to
only part of the PG database objects. Most weirdly, the public schema is
invisible in the Oracle tool browser, though it displays other schemas I
create. For full details of this weirdness, see
http://stackoverflow.com/questions/35809963/cant-see-postgresql-public-schema-in-oracle-sql-developer.
Any advice from the PG world would be very welcome.

~ Thanks, Ken

On Wed, Feb 24, 2016 at 10:52 PM, Ken Winter <ken(at)sunward(dot)org> wrote:

> The best affordable (in this case, free) data modeling tool that I have
> found is the "Oracle SQL Developer Data Modeler" (
> http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html).
>
>
> The best DBMS (free or otherwise) that I have found is PostgreSQL.
>
> So of course it would be great to be able to connect the Oracle tool to a
> PG database, so one could forward- and reverse-engineer between the two.
> At present, apparently the Oracle tool only natively connects with Oracle,
> DB2, and SQL Server.
>
> So I'm wondering if anybody knows of a utility or an Oracle Data Modeler
> add-on that will take some dialect of SQL DDL that that tool generates and
> turn it into PG-readable SQL.
>
> I get it from the list at
> https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL
> that there are tools that do something more ambitious: read schemas from
> actual Oracle databases and implement them as schemas in actual PG
> databases. What I need is more modest than that: a tool that inputs a file
> of DDL from the Oracle Data Modeler tool and outputs that DDL in PG syntax.
>
> ~ Thanks for any leads you can provide
> ~ Ken
>
>
>