A direct connections to the Unifier database using SQL Developer is not possible. The creation of SQL queries must be done in Unifier Data Views, or by pulling rows down from Unifier into a local database.
If you need to pull the data into a local database for the purpose of SQL development, Oracle offers Oracle Database 11g Express Edition (XE) free of charge. You can install this lightweight DB on your computer and use it for development purposes.
Download Oracle Database Express Edition (XE). Refer to the XE documentation for instructions on how to install the software and create a local database.
In Unifier, once you know the table names, you can export 200 lines so it can be inserted into your local Database (DB). To pull down the data:
SELECT * FROM <tablename>
At this point, you can create the table and insert the exported rows into your local XE database using tools like SQL Developer.
Repeat the steps above for any tables that you like to access offline.
Note: You can reuse the same Data View multiple times; however, you need to do find and replace in the downloaded SQL to ensure that the table names match the names that are in Unifier.
Since you have a subset of the database locally, you can use SQL Developer to write complex queries, offline, before bringing them into Unifier.
Legal Notices
Copyright © 2016, 2018,
Oracle and/or its affiliates. All rights reserved.
Last Published Wednesday, March 28, 2018