Table of Contents

Search

  1. Preface
  2. Informatica Developer
  3. The Model Repository
  4. Searches in Informatica Developer
  5. Connections
  6. Physical Data Objects
  7. Flat File Data Objects
  8. Logical View of Data
  9. Viewing Data
  10. Application Deployment
  11. Application Patch Deployment
  12. Application Patch Deployment Example
  13. Continuous Integration and Continuous Delivery (CI/CD)
  14. Object Import and Export
  15. Appendix A: Data Type Reference
  16. Appendix B: Keyboard Shortcuts
  17. Appendix C: Connection Properties

Developer Tool Guide

Developer Tool Guide

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>

0 COMMENTS

We’d like to hear from you!