This content has been marked as final. Show 11 replies
Just to clarify, you are talking about Sybase ASA - Sybase SQl Anywhere, aren't you?
Unfortunately Sybase ASA isn't supported by SQl Developer, please have a look at the release notes (http://www.oracle.com/technetwork/developer-tools/sql-developer/sqldev31-ea-relnotes-487612.html) which state:
SQL Developer supports IBM DB2 UDB LUW , Microsoft SQL Server and Microsoft Access, MySQL, Sybase Adaptive Server and Teradata. See Supported Platforms for details on all third party database releases supported.
This seems to be an old post. I also would like to connect the Oracle Data Modeler to the SQL Anywhere 12.0.1 database. Is this possible? And if so, where to find the JDBC driver?
Thanks a lot, Robert
Oracle SQL Developer Data Modeler is a different story than Oracle SQL Developer. Go get yourself a JDBC driver (check with Sybase first) and use the JDBC connection page when you go to do a data dictionary import...you'll have to lie and say that the database type is 'SQL Server' - and even that might not work.
We don't support that platform in the modeler, so if it doesn't work, sorry.
Where do i foind this JDBC connection page you are mentioning at/before? importing the Data Dictionary?
I really would like to connect to the SQL Anywhere database. Is there a chance you are going to support it?
Can I make a request for it, where?
Thanks for your help, Robert
There are no existing plans to add support for that platform in the Modeler.
Existing priority is Oracle platform first, additional support for DB2 and SQL Server as time allows.
You can submit your request formally to MOS or informally at our exchange
The JDBC connector page - yes, that's on the Import Data Dictionary Dialog - where you go to connect to a database.
I got some help in the Sybase forum and someone (Jeff Albion) was able to connect via the JDBC tab (File > Import > Data Dictionary and then Add button on the Data Dictionary Import Wizzard) and then selecting the JDBC tab (New / Select Database Connection) and entering the corresponding data. That was on Windows.
Problem is I do not get the JDBC tab. What are the conditions to get this JDBC tab? I am pretty sure if I get this tab the connection will work.
Any help or hints are very much appreciated.
Are you still using version 3.1? That's pretty old now. I would recommend upgrading to version 3.3
Also, are you on a Mac? That's a known issue and also has a working solution.
I am using the current ODM version 3.3.0-747, not the old version 3.1.
Of course I am keenly interested in what the working solution for the Mac OS X is to get the JDBC tab in the New / Select Database Connection dialog window? Could you please help or point me to the solution?
Thanks a lot, Robert
Edited by: Robert Huber on May 1, 2013 3:49 AM
I would very much appreciate if you could tell about the work around, thanks a lot.
what the working solution for the Mac OS X is to get the JDBC tabUnfortunately working solution is called Data Modeler 4.0 standalone version. It'll be available for you when DM 4 is released.
Still remember you need to add JDBC driver in Preferences>third party JDBC drivers.
PS Robert normally you should create separate thread for your questions, and Data Modeler has a separate forum SQL Developer Data Modeler