Each data source defined in Infor e-Commerce Development Studio requires connection
properties that enable the connector to communicate with an actual
database or ERP system.
To enter connection properties for a data source
-
Click the Data Sources tab and locate the data source for which you want to define connection
information.
-
Right-click on the target data source and choose Connections.
The Connection Properties window opens.
-
Type a Connection Name in the field provided.
-
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.
-
Click OK to save your settings and close the Connection Properties
window.
If you are using another type of connector, you may need a different
set of parameters. Refer to your database or ERP system documentation
for details about which parameters are required to connect to the
data source. Usually, a set of appropriate parameters for the connector
used by your selected data source is already listed.
To configure more SQL database instances
Typically, only a single database instance is required and you
do not need to follow this procedure. In this case, the host port
number for the database server used for the connection is taken as
the default, port 1433.
If, for example, connection to a database with a different character
set is required, you might want the Infor e-Commerce Development Studio or your application
to be able to connect to a second SQL database instance through a
port number other than port 1433, you need to do the following:
Display the Connection Properties window for the target
data source.
Specify "port" in Parameter Name and the
port number you want to use (for example, "1434") in Parameter
Value.