Establishing database connection

To start using the data migration feature of the Connector Toolbox, you must configure the application to establish a connection to the Infor Fashion PLM database and to any other OLEDB or Microsoft SQL Server.

You can also import data by using .csv, .xls, or .xlsx files. If you want to import a .xlsx file, ensure that you have these applications installed:

  • Microsoft Access Database Engine 2010 Redistributable
  • 2007 Office System Driver: Data Connectivity Components
Note: By default, an Infor Fashion PLM database connection is available on the Connections section. To update the connection information, double click InforFashionPLM.
  1. In the navigation pane, select Migration > Migration Workspace.
  2. Select a migration workspace from the list or create a new migration workspace by clicking Add.
  3. Specify this information:
    Provider
    Select a provider from the list.
    Note: For .csv, .xls, and .xlsx files, select OLEDB.
    Name
    Specify a name for the connection.
  4. On the Accounts section, specify this information and press Enter on your keyboard to add the account information:
    Access Type
    Select an access type from the list.
    Account Id
    Specify the account ID.
    Password
    Specify the password.
    Note: If you are importing information from .csv, .xls, and .xlsx files, select Full on the Access Type and leave Account ID and Password blank.
  5. On the Connection Properties section, set these properties:
    Note: Connection properties may vary depending on the provider that you are using. Your connection properties may have more information depending on your server configuration.
    1. If you selected SQL Server, select Click here to add new row and specify this information:
      Property
      For each row, specify this information:
      • Initial Catalog
      • Data Source
      • Integration Security
      • User ID
      • Password
      Value
      For each row, specify the corresponding connection information for these properties:
      • Initial Catalog

        Specify the database name.

      • Data Source

        Specify the instance/server name of the database.

      • Integration Security

        Specify true or false. If value is set to true, Windows Authentication will be used instead of SQL Server Authentication.

      • User ID

        Specify the SQL Server user ID.

      • Password

        Specify the SQL Server password.

    2. If you selected OLEDB, click File Connection Properties and specify the file information. Details on the Connection Properties section are automatically updated.
  6. Click Save.
    Note: To add another connection, click New Connection from the Migration Workspace window.

    To switch to a different Infor Fashion PLM destination version, click the Utility button, specify the schema, and then click Switch.