Connections > JD Edwards EnterpriseOne connection properties
  

JD Edwards EnterpriseOne connection properties

When you set up a JD Edwards EnterpriseOne connection, you must configure the 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.
Description
Description of the connection. Maximum length is 4000 characters.
Use Secret Vault
Stores sensitive credentials for this connection in the secrets manager that is configured for your organization.
This property appears only if secrets manager is set up for your organization.
This property is not supported by Data Ingestion and Replication and the Data Access Management services.
When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured.
Note: If you’re using this connection to apply data access policies through pushdown or proxy services, you cannot use the Secret Vault configuration option.
For information about how to configure and use a secrets manager, see Secrets manager configuration.
Runtime Environment
The name of the run-time environment where you want to run the tasks.
Select a Secure Agent, Hosted Agent, or serverless runtime environment.
For more information about how to configure and use the runtime environments, see Runtime environments.
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.
Note: You must specify only the product code without the description. If you specify a schema that is not valid, a java exception appears.