Create the database meta-schema file

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

  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.