Search

Connections for INFACore

Connections for INFACore

Back Next

JD Edwards EnterpriseOne

JD Edwards EnterpriseOne

You can use a JD Edwards EnterpriseOne connection to connect to the JD Edwards EnterpriseOne Enterprise server.

Feature snapshot

Operation	Support
Read	Yes
Write	Yes

Connection properties

The following table describes the JD Edwards EnterpriseOne connection properties:

Property	Description
Connection Name	Name of the connection. Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -, Maximum length is 255 characters.
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 driver class name that you can enter for the applicable database type. Required to write data in bulk with the interface table write option. Use the following JDBC driver class name: 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. Required to write data in bulk with the interface table write option. 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>
JDE Product Code	The product code for the tables and views in JD Edwards EnterpriseOne. You must specify only the product code without the description. If you specify a schema that is not valid, a java exception appears.

Connections to source and target endpoints

Watch

Comments

0 COMMENTS

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