Anyone else still using the ORacle Designer tool. We keep all of our models here and metadata. I know Oracle is not moving forward with anymore Designer Development. The repository really works well for us. Also, once you understand how to use the CI views, you can really pull out some nice reports by just writing your own SQL.
Are there other repositories like Designer. I have looked at SQL Modeler, but it does not seem to be as robust. Also, I would not be able to use the SQL we developed to run the reports that we use.
> Anyone else still using the ORacle Designer tool.
You can use Designer 10g as long as it fits your needs. When you want to start using new column types or properties (like redaction in 12c), it's time to switch to another tool. SQL Data Modeler is an obvious choice, but you can consider a tool like TOAD too, of course.
We are still using it but are about to convert over to SQL Developer Data Modeler (SDDM). Yes, the repository is nice and you won't get a repository you can query with SQL or a generator for Forms or Reports with SDDM. I haven't used it yet, but there is a reporting tool and you can use Subversion for version control.
ER Studio and Data Modeler are other options, but they do not come with the repository that Designer has. If I need a report of any fields that have the word EMPLOYEE in it, I can do that by writing SQL to look at the CI views within Designer. I don't have that "impact analysis" option with the other tools. We are just confused as to whether Oracle will continue to support Designer. We keep not only Oracle metadata in the repository, but also DB2/Sybase and SQLServer. It is the maintaining of metadata that I feel is one of the more usefulness of a tool.
A bit late response, but better late than never
Our company use Oracle Designer as main project development tool. We keep all project information there - entities, functions, tables, modules, etc. We have tools which generates DDL from designer (we have our own API so we had to write our own DDL generator). Also we have 100% Oracle forms and APEX forms generated from designer. It is a pity Oracle burried such a great tool.