Here are several important considerations when designing Integration Projects. This includes:
- Data Refresh or Cross-Reference Tables
- Using Cloud Monitors and Adapters
- Cloud Data Routing
- Cloud Connection to Customer Database
- Throughput Analysis
Data refresh or cross-reference tables
If your Business Process (BP) needs a cross-reference table during CIC processing, but this information resides in an on-premise ERP environment, you'll need to work with the CIC Cloud support team to create the cross-reference tables in CIC and set up the automated process for data refresh.
Using Cloud Monitors and Cloud Adapters
Cloud Monitors and Cloud Adapters must point to relevant Endpoints. In cases where you have a single Filesystem Endpoint sending multiple documents to a Cloud Monitor, you'll need to include a launcher BP to segregate the various transaction types (outbound 856, 810, 846, etc.)
If there is only a single environment (Production), you should still create separate Cloud Monitors and Adapters for Stage and Production environments. For example, Stage Monitors and Adapters connect to Stage Endpoints, etc.
Note: Customers having single Clarify environments must have different EDI IDs between Stage and Production.
Cloud Data Routing
For inbound data, data transformation must use Business Processes to handle different data formats (like EDI, XML, CSV) received from the trading partner Endpoint. The Integration Engine must differentiate between the data formats based on either content-based routing (in the Integration Engine) or file name.
For outbound, it would be preferred to have {data_format} and {doc_type} subdirectories to route different documents within the Integration Engine. However in the situation when the customer cannot create the subdirectories, the transformation needs to handle different data formats (XML, CSV, Flat file) and doc types (810, 855, 856) either based on file name or content-based routing within Business Processes.
Cloud Connection to Customer Database
Use the proxy to connect to your database. See Database Integration. Do not use the JDBC SSL connection in this case. If working with a Managed Services customer, use a proxy to connect to a database, as noted above. However, if the database proxy method does not work, try a JDBC SSL connection.
Throughput analysis
Throughput analysis of the interfaces within CIC needs to be performed to plan for large size file processing or large volume of file processing. Please work with Cloud Support or your Solution Architect to resolve any issues.