Setting the Flat File Definition tool database connectivity

If you are using FFD tool for the first time you must set a database connection.

Use this procedure to set the database connection. The FlatFileGuiIni.xml file is now encrypted and is not available for direct edits.

  1. Launch Flat File Repository Manager.

    The Flat File Definition Tool Security Login window is displayed.

  2. Specify your user name and password.
  3. Click OK.

    The Flat File Repository Manager window is displayed.

  4. In the Definitions in repository pane right-click and select Add Repository.

    The Add Repository window is displayed.

  5. Specify this information:
    Driver

    Specify the database driver to use, for example,

    com.microsoft.sqlserver.jdbc.SQLServerDriver

    URL

    Specify the path to the database location, for example,

    jdbc:sqlserver://<path_to_database_machine>

    Specify the host name or IP address of the EC database server to connect to.

    User

    Specify the username of the SQL database server user.

    Password

    Specify the password for the SQL database server user.

    Catalog

    Specify the name of the IEC<version> Database on the host.

    Schema

    Accept the default schema. dbo

  6. Click Test to verify the connection.

    A message is displayed if the connection fails.

  7. Click OK.
  8. Close and exit the tool.