5 Replies Latest reply: Jan 17, 2014 3:47 AM by Giedrius S. RSS

    Looking for people who are still using Oracle Designer

    joecbc


      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.

       

      thanks,

       

      Joe

        • 1. Re: Looking for people who are still using Oracle Designer
          InoL

          > Anyone else still using the ORacle Designer tool.

          Yes.

           

          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.

          • 2. Re: Looking for people who are still using Oracle Designer
            Marcus2014

            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.

            • 3. Re: Looking for people who are still using Oracle Designer
              Mark_Kramm

              I love Oracle Designer.

              In fact a co-authored a book about it.

               

              There is no other tool that has the same type of robust repository as Oracle Designer.

               

              However you may want to look at ER Studio.

               

              Good Luck

               

              Mark Kramm

              • 4. Re: Looking for people who are still using Oracle Designer
                joecbc

                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.

                • 5. Re: Looking for people who are still using Oracle Designer
                  Giedrius S.

                  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.

                   

                  Giedrius