1 Reply Latest reply: Apr 14, 2013 3:17 PM by JustinCave RSS

    How to connect sql developer to workspace on apex.oracle.com

    1002801
      I just successfully got a remote workspace on apex.oracle.com and I can work on it using a webbrowser.
      I have created some tables and now I want to continue working on it with sql developer, installed under Windows 7.
      What do I use as the connection name and connection type?
        • 1. Re: How to connect sql developer to workspace on apex.oracle.com
          JustinCave
          Welcome to the forum.

          Unfortunately, this doesn't appear to be the correct forum for this question. You would probably want to post this either in the APEX forum or the SQL Developer forum. SQL Developer doesn't use ODBC.

          That said, I don't believe you'll be able to connect to the database behind apex.oracle.com directly. First off, APEX users and workspaces are (in general) completely separate from database users. You would need a database user account, not just an APEX account, in order to connect to a database using SQL Developer. Second, it would be a huge security issue to expose any database to the public internet-- you'd realistically need to be on the internal Oracle network in order to connect to that database.

          You could download and install Oracle XE on your local machine. That would let you develop an APEX application as well as allow you to connect to the XE database via SQL Developer (or any other tool you'd like)

          Justin