Search

Developer Tool Guide

Developer Tool Guide

10.5.6
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

JD Edwards EnterpriseOne Connection Properties

JD Edwards EnterpriseOne Connection Properties

Use a JD Edwards EnterpriseOne connection to connect to a JD Edwards EnterpriseOne object.

The following table describes the JD Edwards EnterpriseOne connection properties:

Property	Description
Name	The name of the connection. The name is not case sensitive and must be unique within the domain. It cannot exceed 128 characters, contain spaces, or contain the following special characters: ~ ` ! $ % ^ & * ( ) - + = { [ } ] \| \ : ; " ' < , > . ? /
ID	The string that the Data Integration Service uses to identify the connection. The ID is not case sensitive. It must be 255 characters or less and must be unique in the domain. You cannot change this property after you create the connection. Default value is the connection name.
Description	The description of the connection. The description cannot exceed 765 characters.
Location	The Informatica domain where you want to create the connection.
Type	The connection type. Select JD Edwards EnterpriseOne.
Host Name	JD Edwards EnterpriseOne server host name.
Enterprise Port	JD Edwards EnterpriseOne server port number. Default is 6016.
User Name	The JD Edwards EnterpriseOne database user name.
Password	The password for the JD Edwards EnterpriseOne database user.
Environment	Name of the JD Edwards EnterpriseOne environment you want to connect to.
Role	Role of the JD Edwards EnterpriseOne user. Default is *ALL.
User Name	The JD Edwards EnterpriseOne database user name.
Password	Password for the database user.
Driver Class Name	The following list provides the driver class name that you can enter for the applicable database type: DataDirect JDBC driver class name for Oracle: com.informatica.jdbc.oracle.OracleDriver DataDirect JDBC driver class name for IBM DB2: com.informatica.jdbc.db2.DB2Driver DataDirect JDBC driver class name for Microsoft SQL Server: com.informatica.jdbc.sqlserver.SQLServerDriver For more information about which driver class to use with specific databases, see the vendor documentation.
Connection String	The connection string to connect to the database. Use the following connection string: The JDBC connection string uses the following syntax: For Oracle: jdbc:informatica:oracle://<host name>:<port>,ServiceName=<db service name> For DB2: jdbc:informatica:db2://<host name>:<port>;databaseName=<db name> For Microsoft SQL: jdbc:informatica:sqlserver://<host name>:<port>;databaseName=<db name>

Appendix C: Connection Properties

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.