Setting up a Flat File Definition Repository

  1. Right-click in the Definition in repository pane, select Add Repository.
  2. In the Add Repository window, specify this information:
    Driver

    Specify the JDBC class to use. By default, here are the configurations:

    For Microsoft, by default, use this value:

    com.microsoft.sqlserver.jdbc.SQLServerDriver

    URL

    Specify the URL for the JDBC connection string.

    If the database is configured with the default port number and not installed as a named instance, use this URL format:

    For Microsoft, by default, use this value:

    jdbc:sqlserver://[host]:[port number]

    User

    Specify a case-sensitive user name to access the database.

    Password

    Specify a case-sensitive user password for the user.

    Catalog

    Specify a case-sensitive database name.

    Schema

    Specify a schema to use. Default value is dbo.

  3. Click Test to verify the database connection.

    If an error occurs, click show stack trace to show the database connection log. Check your database connectivity to correct the error.

    Click OK to proceed.

  4. Click OK to save the new setting.

    The new setting is shown in Flat File Definitions Repository pane.