Database Issues

  1. How do I create a project for Oracle?
  2. Select the Oracle Module in the New Project Dialog and configure the database to be accessed. You can also configure the schemas that should be included/excluded. Lattix Architect creates an Oracle project by reading in the Oracle catalog or PL/SQL files.

  3. What permissions are required to do an analysis of an Oracle database?
  4. You need Select access to the Oracle catalog. The exact tables/views are listed in Module Guide for Oracle. Note that you do not need access to any actual data in the database.

  5. How do I create a project for SQLServer or Sybase?
  6. Select the SQL Module in the New Project Dialog and configure the database to be accessed. Lattix Architect creates an SQL project by reading in the SQL Server catalog or SQL files. Note that Lattix will not access the actual data in the database.