Create the database meta-schema file

Follow this procedure to create a database meta-schema file for your database.

Before you begin, you must have configured the database driver for your database vendor.
  1. Select Database > Extract Schema.
    The New Meta-schema dialog opens.
  2. On the Meta-schema file page, enter a name for your meta-schema file and add it to the Databases node of your project. Click Next > to continue.
    The file name must be in lower case, and must have a .4db extension.
  3. On the JDBC Connection information page, complete the Database Connection Information and Database User Information sections.

    Use this table to help complete the database connection information fields.

    Table 1. JDBC database connection information, by vendor
    Vendor Java Driver Class (Database driver) JDBC connection string format Sample connection string
    Oracle 
    oracle.jdbc.driver.OracleDriver
    		 
    jdbc:oracle:driver_type:
[username/password]@database_specifier
    		 
    jdbc:oracle:thin:@//localhost:1521/XE
    IBM Informix 
    com.informix.jdbc.IfxDriver
    		 
    jdbc:informix-sqli://[{ip-address|host-name}:
{port-number|server-name}][/database-name]:
INFORMIXSERVER=server-name[{;user=user;
password=password]|
CSM=(SSO=database_server@realm,ENC=true)}
[;name=value[;name=value]...]
    		 
    jdbc:informix-sqli://localhost:9088/native_types:INFORMIXSERVER=ol_informix1170
    IBM DB2 
    com.ibm.db2.jcc.DB2Driver
    		 
    jdbc:db2://server:port/database
    		 
    jdbc:db2://localhost:50000/NAT_TYPE
    Microsoft SQL Server 
    com.microsoft.sqlserver.jdbc.SQLServerDriver
    		 
    jdbc:sqlserver://[serverName[\instanceName]
[:portNumber]][;property=value
[;property=value]]
    		 
    jdbc:sqlserver://AUCKLAND\SQLEXPRESS2012;databaseName=native_types
    Oracle MySQL 
    com.mysql.jdbc.Driver
    		 
    jdbc:mysql://[host][,failoverhost...]
[:port]/[database] [?propertyName1]
[=propertyValue1][&propertyName2]
[=propertyValue2]...
    		 
    jdbc:mysql://localhost:3306/native_types
    PostgreSQL 
    org.postgresql.Driver
    		 
    jdbc:postgresql://host:port/database
    		 
    jdbc:postgresql://localhost:5433/native_types
    SQLite 
    org.sqlite.JDBC
    		 
    jdbc:sqlite:filepath
    		 
    jdbc:sqlite:F:/tmp/DB/jdbc/tests/sqt_types.db

    If you have previously extracted a data schema, you can select the connection stream from Previous connections combobox, and it will complete the Database type, Database driver and Connection string fields for you.

    Depending on the database, you may have to provide database user information.
  4. Click Test Connection to verify your configuration. If your test fails, determine the issue before continuing. Click Next > to continue.
  5. On the Extraction options page, you can modify the extraction options. Typically, you accept the values provided.
  6. Click Finish.
    The db_filename.4db database diagram displays in the work area, and is saved to the Databases node. You can drag and drop the tables to arrange how they display.
  7. Save your changes.