Step 3: Defining a data source

To define a data source

  1. Click the Data Sources tab and locate the data source for which you want to define connection information.
  2. Right-click on the target data source and choose Connections.

    The Connection Properties window opens.

  3. Type a Connection Name in the field provided.
  4. Configure parameter names and values, as required. For connecting to the MS SQL Server database, you must specify the following key/value pairs (using the exact key text shown):

    databaseName

    the name assigned to the database during installation. This must match the Database name specified during database installation.

    Infor recommends that you do not change the database name once the application is deployed, as the IAI-generated datasource name would no longer match the Infor e-Commerce Development Studio-generated JNDI name.

    If you do change the database name, you need to delete the WebSphere datasource: <Application name>_<database name>_DataSource_1 and the WebSphere J2C Authentication Alias: alias_<application name>_<database name>_1 and then redeploy the application using Deploy Application.

    host

    the name or IP address of the host computer where the database is currently installed or is to be installed. This must point to the Database server specified during database installation.

    password

    the password (for the specified user) required to access the database. This must match the Database owner password specified during database installation.

    user

    the database owner username. This must match the Database owner username specified during database installation

    port

    the host port number for the database server used for the connection.

    If this parameter is unavailable, click Add, then type the parameter name port and the port number as value.

  5. Click OK to save your settings and close the Connection Properties window.