Skip to main content

Basic Properties

Database information basic properties:
  • Database Name - The name of the database as you wish to refer to it. This will be the name of the object that is visible in the Repository navigator.

  • Database Type - Specify the type of database using the list.

  • Database Name or Instance Id - Specify the name of the database or the instance Id of the server. The label on this will change depending on the type of database selected.

  • Schema/User Name - For Oracle this is the Schema name, for all other databases this will appear as the user name.

  • Password - The password of the above user.

  • Host - The host name to connect to. Leave blank for the current host.

  • Port - The port number to connect to. Leave as zero for the default port number for the database.

  • Schema - Some databases (SQL Server and Sybase) have the notion of a schema within the database. You can specify a schema value here (like dbo) which will be used to filter the tables extracted from the database.

  • Test Connection - Use this to immediately connect to the database and report any errors.

  • Show More - Press this and you will see the advanced properties (below).

  • Structure Folder (not shown on screenshot) - The folder that contains the structure definitions for the database that were generated on the import. This appears only when viewing the properties of the database object. It does not appear in the import wizard.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!