Table of Contents

Search

  1. Preface
  2. Understanding Domains
  3. Managing Your Account
  4. Using Informatica Administrator
  5. Using the Domain View
  6. Domain Management
  7. Nodes
  8. High Availability
  9. Connections
  10. Connection Properties
  11. Schedules
  12. Domain Object Export and Import
  13. License Management
  14. Monitoring
  15. Log Management
  16. Domain Reports
  17. Node Diagnostics
  18. Understanding Globalization
  19. Appendix A: Code Pages
  20. Appendix B: Custom Roles
  21. Appendix C: Informatica Platform Connectivity
  22. Appendix D: Configure the Web Browser

Administrator Guide

Administrator 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!