Before you connect to the JD Edwards EnterpriseOne Enterprise Server, you must configure the JD Edwards EnterpriseOne Enterprise Server to support interoperability using XML and the JDBj APIs.
You can import JD Edwards EnterpriseOne tables and views as source or target data objects. When you import a source or target data object, Data Integration connects to a JD Edwards EnterpriseOne Enterprise Server to import the metadata.
When Data Integration connects to JD Edwards EnterpriseOne, it connects to an environment. The Secure Agent sends a request for metadata in XML format to JD Edwards EnterpriseOne. The Secure Agent then converts the XML response from JD Edwards EnterpriseOne to a source or target data object.
When you run a mapping, the Secure Agent connects to JD Edwards EnterpriseOne to read data from sources and write data to targets. When the Secure Agent reads or writes JD Edwards EnterpriseOne data or executes a business function, it connects to the JD Edwards EnterpriseOne Enterprise Server through the JDBj APIs and makes API calls to the JD Edwards EnterpriseOne system.
The Secure Agent reads and writes data based on the mapping and application connection configuration in Data Integration. To connect to any environment in the JD Edwards EnterpriseOne system, specify the name of the environment in the JD Edwards EnterpriseOne application connection. The Secure Agent uses the JDBj APIs to read data from or write data to JD Edwards EnterpriseOne after establishing a connection with the specified environment.
When you want to write bulk data, you configure the JDBC connection string in the JD Edwards EnterpriseOne connection properties and specify the interface table write properties in the JD Edwards EnterprsieOne target properties. The Secure Agent uses the JDBC connection string to write data in bulk to the JD Edwards EnterpriseOne interface table.
The following image shows how Data Integration integrates with JD Edwards EnterpriseOne:
