Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Modeling and DDL Generation for Redshift?

PostmodernLudditeApr 21 2016 — edited May 3 2016

Hello All --

I am working with Redshift and hoping to use SDDM to do data modeling. One small caveat. There doesn't seem to be an option to extract DDL using Redshift like there is for Oracle, SQL Server, etc. E.g. the drop-down window under File -> Data Modeler -> Export -> DDL File doesn't give a Redshift option.

Thus far I've created the model in SDDM, exported to Oracle DDL, and then done manual edits post ipso facto before running the scripts in Redshift but this is far from ideal.

I have added Redshift as a third-party JDBC driver under the Data Modeler preferences but this hasn't changed anything as far as I can see.

I realize that supporting another platform for data modeling requires a lot more than just adding a JDBC driver but is there anyway I could make this easier? Even just somehow mapping logical types to relational for Redshift?

Thank you,

Josh

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 31 2016
Added on Apr 21 2016
5 comments
1,803 views