Data Integration

Hello,I am having issues trying to generate logs in CData Sync. Could someone help me with it?

After I installed this new DBAmp v22, I tried to remake the linked server I had before, but the DBAmp.DBAmp provider wasn’t in the list. How do I get the provider?

Whenever I try to do anything with the linked server, I either get an error about the OLE DB provider returning a message that the “Login timeout expired” or “TCP Provider: The wait operation timed out.” Sometimes it also says "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible.” I can’t do anything with DBAmp, how do I fix this?

A common challenge that can be encountered in mapping projects occurs when a data source contains element that can be grouped into multiple transactions, but the format of the data is in a flatten data model. A simple example of this can be seen in many CSV files: OrderNumber Customer Date Item Qty 12345 James Blasingame 3/17/23 Corned Beef 1 12345 James Blasingame 3/17/23 Colcannon 1 12346 Teddy Blasingame 3/17/23 Peanut Butter 1 12346 Teddy Blasingame 3/17/23 Apples 2   With the human eye, it is easy to tell that this table represents two separate transactions, each of which contains 2 line items (Or

There’s a question that arises in configuring Arc that comes up often:I have a transport connector (like AS2 or SFTP) that receives multiple EDI files that are addressed to different interchange relationships. How can I support this in my flow if each X12 connector expects one EDI relationship (Interchange Sender ID and Interchange Receiver ID)?By default, the X12 connector is meant to be used in a 1:1 relationship with the interchange relationship in the EDI document, so if you had a sender that was using different interchange IDs for different document types - 123A and 123P for instance, you would set up X12 connectors where the Sender Identifier is configured in each one, and EDI files would need to be routed to the correct connector accordingly. Support multiple EDI relationships in a single connector (only supported in unlimited EDI licenses)If you are using a license that supports unlimited u

There’s a question that arises in configuring Arc that comes up often:I have a transport connector (like AS2 or SFTP) that receives multiple EDI files that are addressed to different interchange relationships. How can I support this in my flow if each EDIFACT connector expects one EDI relationship (Interchange Sender ID and Interchange Receiver ID)?By default, the EDIFACT connector is meant to be used in a 1:1 relationship with the interchange relationship in the EDI document, so if you had a sender that was using different interchange IDs for different document types - 123A and 123P for instance, you would set up EDIFACT connectors where the Sender Identifier is configured in each one, and EDI files would need to be routed to the correct connector accordingly. Support multiple EDI relationships in a single connector (only supported in unlimited EDI licenses)If you are using a license that supports

There’s a question that arises in configuring Arc that comes up often:I have a transport connector (like AS2 or SFTP) that receives multiple EDI files that are addressed to different interchange relationships. How can I support this in my flow if each X12 connector expects one EDI relationship (Interchange Sender ID and Interchange Receiver ID)? By default, the X12 connector is meant to be used in a 1:1 relationship with the interchange relationship in the EDI document, so if you had a sender that was using different interchange IDs for different document types - 123A and 123P for instance, you would set up X12 connectors where the Sender Identifier is configured in each one, and EDI files would need to be routed to the correct connector accordingly.  Support multiple EDI relationships in a single connector (only supported in unlimited EDI licenses)If you are using a license that supports unlimited use of th