Data Integration

HiI would like to compare two XML files for differences.Here’s my use case.I create an order via an API and can get the entire order back in the response.I will store that order in a database table.Later, I will poll the API again and fetch the latest details of that order.I can do a quick check for overall changes using a hash, but I will need to know what changes if they latest and stored order differ. thanks in advance

In my main application, I started using Arc to send automated emails by writing a simple XML file to a folder that Arc monitors.  I have a case where I am mapping the XML to an Email Send connector (using template mode) and I need to attach a PDF to the message (which was already uploaded to the server).I have the path to the file saved in SQL and I can add the path to my XML file.  My question is, how can I configure the Email Send connector to “attached” the file (assuming the path is a node in my XML)?  Right now, all I can do is reformat the path into an http link and add it to the body. Thanks

Is is possible to pass values retrieved using xpath() into the div([value]) or divide([value]) Math formatters? I want to do something like this in an XML Map connector [xpath(ConsignmentNode/DefinitionOfGoods/TotalKilos)  | div(xpath(ConsignmentNode/DefinitionOfGoods/TotalFull)| add(xpath(ConsignmentNode/DefinitionOfGoods/TotalHalf)) | add(xpath(ConsignmentNode/DefinitionOfGoods/TotalOversize))))]!--endfragment>!--startfragment>  which in pseudo code is    Weight = Total Kilos / (Full + Half + Oversize) Things like “….| div(2)” work, but I can’t seem to get it to work with values from other parts of the message. Even simplifying to [xpath(ConsignmentNode/DefinitionOfGoods/TotalKilos) | divide(xpath(ConsignmentNode/DefinitionOfGoods/TotalHalf))]gets the same error:Formatter divide failed in the evaluation of <weight>[xpath(ConsignmentNode/Definit

I’ve updated our test environment to latest version 23.4.8843.0 and I noticed that when I try to configure data source settings, I can’t and I get information “Settings are not editable”. Same issue with new tasks and previously created tasks. I can however make settings directly to query-tab and it will work ok. Our production environment is version 23.3.8700.0 and that issue is not there. Data source which I’m using is ElasticSearch

We are currently using cdata version .NET Edition - 23.3.8700.0 in our organization and we create jobs through API call. Through API call we are able to create the JOB fine, but we are unable to set StoresUppercaseIdentifiers=true Additional Options property.Any help on this topic is greatly appreciated.  

[META|Schema] Skip the drop column operation for column [_cdatasync_deleted]. Can anyone help me understand this issue please. As in the destination table there is a column  _cdatasync_deleted which is being set to null for this new row inserted(Which was supposed to be a UPDATE instead of INSERT in first place)

📢 New Year, New Features! CData Sync Q1 2024 Release Highlights   Kickstarting 2024 with a bang, we're excited to announce the latest features in the Q1 2024 CData Sync release! Check out what's new:  API Connector Query Slicer - Elevate your API interactions! This innovative feature allows more flexible and efficient API call executions. Ideal for all users, making API integrations smoother than ever.  Reverse ETL - Big news for Salesforce users! Now push data directly into your Salesforce instance, integrating your database insights seamlessly. A major leap forward in CRM data management.  Enhanced Usability Features - Based on your valuable feedback, we've improved usability aspects across our platform, ensuring an even more intuitive and user-friendly experience.  📖 Discover More in Our Q1-2024 Sync Release Blog - Dive into the details of these exciting updates in our latest

Dears,I’d like to ask for your help how to get the current system time using Script connector?So far, I tried to use:<arc:set attr="timestamp" value="[utcnow()]" /> <arc:set attr="timestamp" value="[now()]" />But I got the error saying this:Execute 'RSSBus.RsbOps.RSBFunctions.now' function failed: The function 'now' could not be found. What is the correct format? I m using ArcESB 2020 EDI.

I find it useful to document my flows using a Script connector as follows: 

Is there a way to conduct a WebSocket connection and exchange in Arc?  Maybe something that can be done in ArcScript?

Exception happened:Failed to start database 'C:\ProgramData\CData\sync\db\cdata_sync' with class loader WebAppClassLoader{CData Sync}@20ce78ec, see the next exception for details.ServletPath: /login.rst ContextPath:  

I am creating an XML message using a Script connector:<arc:set attr="output.filename" value="xmltriggerfile_[guid()].xml" /><arc:set attr="output.filepath" value="[filepath]" /><arc:set attr="output.data"><?xml version="1.0" encoding="UTF-8"?> <Schedule> <startDateTime>[_|now()|dateadd('day',-1, 'yyyy-MM-dd 00:00:00')]</startDateTime> <endDateTime>[_|now()|dateadd('day',-1, 'yyyy-MM-dd 23:59:59')]</endDateTime> <Results></Results></Schedule> </arc:set><arc:push item="output" /> This is then fed into a MySQL Lookup Connector which results in the following message <Schedule> <startDateTime>2024-03-11 00:00:00</startDateTime> <endDateTime>2024-03-11 23:59:59</

 Hey! I have written a query in CData Sync to load rows from TransactionAccountingLine only for a date range, Feb 2024.REPLICATE [TransactionAccountingLine]SELECT tranacc.* FROM [TransactionAccountingLine] tranaccLEFT JOIN [transaction] tranON tranacc.transaction = tran.idWHERE tran.trandate between '2024-02-01' and '2024-02-29'Upon running this query, I am getting the error, [0] Column 'lastmodifieddate' is ambiguous. But I should not be getting this error since  I am selecting all the columns only from the TransactionAccountingLine table, where there is only one lastmodifieddate.Please help me with this issue.

In earlier releases of CData Arc the Lookup connector / Lookup action of Database connectors had a fairly simple interface to it. You can configure a single query to select a single column from a table in a database, and output the result of the lookup in a specified XPath in the XML, like so:  Simply put, if the Input file is: <Items> <Record> <Name>James</Name> </Record></Items> The output file creates the result in a neighboring element:<Items> <Record> <Name>James</Name> <ID>0</ID> </Record></Items> In the 2023 release of CData Arc, a

Hi Team, Script manager is not registered for schema 'Aha' check whether the scheme is valid  I’m getting this error while trying to save and test the Aha connector Regards,Charitha

I have a flow which pulls rows from MySQL, formats them into JSON messages and pushes them to Azure Service Bus.There’s a step in the flow which creates the necessary signature for the REST POST to Azure Service Bus: But the SAS Token/Signature header is not dependant on the message.I only really need to do it once and make sure it is valid for long enough - at the moment I make it valid for a week.But my flow is calculating it for every row/every message. Is there a way to calculate it once (say for each time I run SELECT in the MySQL connector) and have it used repeatedly by PublishDirectToServiceBus? 

Hey tribe,I am running into a major problem while using Cdata sync to load tables through suiteql. For transactions table as an example, Many line items are not loading for a particular date range even though I made the relevant configuration and added the filters in my query.Sometimes I have to specifically type the tranid and load the same to get those lineitems. Doing this over and over again has become tiresome and is taking away the automated nature of the Fact tables we’ve built surrounding this. Is there something we can do to resolve this? Like adjusting the batch size or something? Looking out for your help :)

I am trying to download the Oracle db connector. in CDataSync application. I am getting the following error message An error occurred during downloading connector [Oracle]: Download provider error: Cannot conclude ssl handshake. Cause: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target. Any one tried downloading and configuring Source Oracle DB?

I want to do something like this <arc:set attr="scope">[encodedurl]\n[expiry]</arc:set>  I have tried using a multiline arc:set but without any luck<arc:set attr="scope">  [encodedurl]  [expiry]</arc:set> Any ideas?

Use this script before your REST connector <!-- %3A etc must be uppercase! --><arc:set attr="encodedurl">https%3A%2F%2Fyour-sb-resource-name.servicebus.windows.net%2Fyour-topic</arc:set><arc:set attr="expiry">[now(unix)|add(604800)]</arc:set> <!-- add a week --><arc:set attr="scope">[encodedurl]\n[expiry]</arc:set><!-- Encode using HMAC --><arc:set attr="encIn.data" value="[scope]" /><!--<arc:throw code="x" desc="[encIn.data]" /> --><arc:set attr="encIn.format" value="HMAC" /><arc:set attr="encIn.hmackey" value="[azureprimary.key]" /> <arc:set attr="encIn.hmacalgorithm" value="SHA" /><arc:set attr="encIn.hmacbits" value="256" /><arc:set attr="encIn.outformat" value="BASE64" /><arc:call op="encEncode" in="encIn" out="result"> <!-- setting the

In PHP I can use ‘U’ format. How do I do this in Arc Script?So far I’ve got <arc:set attr="expiry">[utcnow() | dateadd('day', 7) | todate('U')]</arc:set> But ‘U’ is not recognised, and I getError:Formatter todate failed in the evaluation of [utcnow()|dateadd('day', 7)|todate('U')]. The error was:Input string was not in a correct format.Value: 2024-02-20T11:07:09+00:00Parameters: U

HiI’m trying to convert this file to JSON.<Items xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Sheet1> <Country_code>AC</Country_code> <field_1 xsi:nil="true" /> <field_2 xsi:nil="true" /> <Year>2013</Year> <field_4 xsi:nil="true" /> <Month>1</Month> <field_6 xsi:nil="true" /> <Days>1</Days> <Description>New Year's Day</Description> </Sheet1> <Sheet1> <Country_code>AC</Country_code> <field_1 xsi:nil="true" /> <field_2 xsi:nil="true" /> <Year>2013</Year> <field_4 xsi:nil="true" /> <Month>3</Month> <field_6 xsi:nil="true" /> <Days>29</Days> <Description>Good Friday</Description> </Sheet1>

I have 3 different CSV files to load each week, and they always have the same filename.I set up a “Sync All” job to read these files and load them into my destination.However, I would like to pass the files’ creation dates or modify dates, as columns into the destination target table.  Is this possible to do? 

Dear all, I have a ftp connector that is reading from multiple folders/subfolders and transferring data to a local server using an sftp connectorI would need to either be able to set the destination folder in my local server depending on the remote source folder or to put everything in the same folder but renaming the file in such a way I can understand from where they were coming from Currently the only way I found was to use several correctors (one for each folder), but I am doing to many connections to the server and using too many  connectors for my license Thanks