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:

    Specify the database driver to use, for example,


    Specify the path to the database location, for example,


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


    Specify the username of the SQL database server user.


    Specify the password for the SQL database server user.


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


    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.