Creating or modifying a Smart Notification data source

Use to create or modify reusable data sources for DME, JDBC, OLAP, or JNDI. After you create and save your data source, you can select it when you create an InfoSet.

You must be an administrator to perform this procedure.

  1. Click Admin to list the Admin Utilities.
  2. Click Work With Data Sources to open the Work With Data Sources screen.
  3. Click Add to create a data source or click Edit to edit an existing data source. The data source wizard is displayed. Specifications depend on your connection type.
  4. Specify this information for a DME Connection:
    Name
    Specify the data source name to display on the Work With Data Sources screen.
    Description
    Specify a description of the data source to display on the Work With Data Sources screen.
    Connection type
    Select the connection type:
    • Http
    • Socket
      Note: 
      • If you are connecting to an ADFS 3.0 authenticated server, select Socket for the connection type.
      • If you select a socket connection, select the IOS server ID.

    The socket services are configured in Framework Services. For more information, see the Framework Services Administrator and User Guide.

    DME URL
    Specify the name of the Lawson DME path.

    For example, http://myserver/dme.exe.

    DME PROD
    Specify the name of the Lawson product specified in the DME call. The product is specified in the DME query as PROD=myprod.
    User Name
    Specify a user name. The user you specify must have permission to execute DME queries on the server and product line to be used as a data source.
    Note: If the data source is connecting to an ADFS authenticated server, the user name depends on the type of connection:
    • For http: The identity should be used as the user name (with domain), for example, testuser@infor.com.
    • For socket: The resource manager ID should be used as the user name (without domain), for example, testuser.
    Password
    Specify the password for the user name you specified.
  5. Specify this information for a JDBC Connection:
    Name
    Specify the data source name to display on the Work With Data Sources screen.
    Description
    Specify a description of the data source to display on the Work With Data Sources screen.
    JDBC Driver
    Specify the path and class name of the JDBC driver to be used to connect to the database.

    The driver's class must be accessible from the server and reside in the server's classpath. The information that you provide for the remaining JDBC specification fields depends upon the path you enter in this field.

    User Name
    Specify a user name. The user you specify must have permission to connect to the database and execute the query or stored procedure. Also, the user name must be configured on RDBMS before you can specify it in this field.
    Password
    Specify the password for the user name you specified.
    Database
    Optionally, specify the name of the database from which you want to extract data.

    The database name is not necessarily the name of the application database, for example, Oracle. Also, this field is not required by all JDBC drivers.

    Database Location/URL
    Specify the database's location. The location format differs between driver vendors. For example, IBM's DB2 driver has the format of jdbc:db2:sample.
    Server
    Optionally, specify the name of the server or service name for the database. If you specify a server, you must also specify a port.

    The server name is often part of the database location or URL.

    Port
    Optionally, specify the port ID for the database on which the service is listed. If you specified a server, you must specify a port.

    The port ID is often part of the database location or URL.

  6. Specify this information for an OLAP Connection:
    Name
    Specify the data source name to display on the Work With Data Sources screen.
    Description
    Specify a description of the data source to display on the Work With Data Sources screen.
    User Name
    Specify a user name.
    Note: The user you specify must have permission to connect to the OLAP database and execute the query or stored procedure.
    Password
    Specify the password for the user name you specified.
    Database Location/URL
    Specify the location for the OLAP database. The location format differs between driver vendors. For example, Mircosoft has the format of:

    jdbc:xmla:Server=[OLAP Server URL]/msmdpump.dll;Catalog=[OLAP Database];

  7. JNDI Connection
    Name
    Specify the data source name to display on the Work With Data Sources screen.
    Description
    Specify a description of the data source to display on the Work With Data Sources screen.
    JNDI Name
    Specify the name of the JNDI data source to be used to connect to the database. The name must match the JNDI name located in the Smart Notification server.
  8. Specify this information for File Locations:
    Name
    Specify the data source name to display on the Work With Data Sources screen.
    Description
    Specify a description of the data source to display on the Work With Data Sources screen.
    Location
    Specify the location of the file to be used as a data source.
    Authentication Connection
    Select this check box to authenticate the connection to the file. If selected, you must provide a user name and password.
  9. Click Test Settings. If you have specified any parameters for the data source, a form listing the parameters along with text boxes is displayed. Use this form to specify a value for each parameter.
  10. Select the security level. If necessary, select users or user groups.
  11. Click Save. The Work With Data Sources screen is displayed with any new or modified data sources.