Solved

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?

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> <Sheet1> <Country_code>AC</Country_code> <field_1 xsi:nil="true" /> <field_2 xsi:nil="true" /> <Year>2013</Year> <field_4 xsi:nil=

Hi!Two pronged question. What’s typical performance that should be expected with Cdata’s Sage Intacct / Power BI connector? [I’m getting about 250k rows loaded from a large data set in an hour] Are there any tricks / tips to enable faster load times for large data sets? If I want to say download the GL-Detail table from Sage intacct, waiting 4+ hours to get the information is sometimes a hard ask.Thanks in advance!

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 

I need to generate a CSV file with a header and trailer record, not column headers.  What is the best way to accomplish this?

hi, Dear Team, I am in the process of setting up an AS2 link between us and our partner but my partner cannot send us the message. For our part, sending messages to the partner works well but it is impossible to receive their messages.I have no logs on ArcESB and my partner thinks that the problem comes from us.We have traffic on our partner's port but we have an error like: 'RST,ACK'Looks like the partner is rejected.On the partner’log :disconnection indication         [reason="Error 0 (0x0)"] [origin="0"].My partner can do a telnet our AS2 server successful. Could you help me please Best Regards,BL

I've set up a flow that interacts with other services using the REST connector. From this flow I've created a Flow API by multi selecting the entire flow, right clicking it and selecting the API settings option. Inside the flow I extract a response header from one of the REST requests respones I receive in the flow and I want that value to show up as an output header of the entire Flow API response whenever this service gets called from the outside. Right now I only can see the default response headers. I've read and search the documentation pertinent to these elements but I haven't found out how I can create and parse custom response headers for the Flow API and if anyone knows how to do that, your help will be immensely appreciated 😬

I have Workspaces A, B and SWorkspace S (for ‘shared’) is a sort of utility or library workspace.My plan is for Workspaces A & B to set a message header e.g. _message.header:callingFlow in Event:BeforeSend and then use WorkspaceSend to call the WorkspaceReceive in S. S then needs to respond back to the correct calling Workspace.Can a WorkspaceSend in S dynamically call WorkspaceReceive in A or B based on  _message.header:callingFlow ?Or do I need use maintain a series of Branches (we could have many more calling workspaces in the future)

Trying to bring JIRA data onto snowflake using CData. All the tables loaded successfully except Worklog. The worklog table failed with below error. [0] [500] Could not execute the specified command: Failed to cache row [3652696] Invalid HTTP response! Timeout.. StackTrace: at aso230l.nT.Next() at aso230l.mH.Next() at aso230l.mb.Next() at aso230l.mY.Next() at aso230l.mQ.Next() at aso230l.Kz.q(DbCommand , DataTable , IResultSet , ColumnInfo[] , Int32[] , jsb ) Any help on this topic is greatly appreciated.

Hi,I have been trying to migrate data from cassandra to mysql..The size of the source data table is approx. 4.5 GB.The migration job ran for 11 hours and then failed with below error:2024-01-24T22:13:40.908+0530    1    [2|Q-Id]    [SQL |Cache ] The operation timed out.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [SQL |Cache ] Cache failed: The operation timed out.2024-01-24T22:13:40.955+0530    0    [2|Q-Id]    [SQL |Cache ] Replication Failed. Error:The operation timed out.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [RealDB:cdata.jdbc.cassandra.CassandraDriver]The connection is disconnected.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [RealDB:MySQL]The connection is disconnected.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [RealDB:Derby]The connection is disconnected.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [SQL |Messag] Query Failed: [REPLICATE [orderdashboard] WITH _id = 'dVliqUz79KW/pJr8i8+vNg==', ReplicateID = 'ym5RUxyrxDweS3YeOqwAow==' SELECT * FROM [hen

Hi!I am working with a client who uses NetSuite ERP. We are trying to get Sales reports for them, which we are doing by using the transaction table from SuiteQL schema.We also need the transactions’ status, for which we need the transactionStatus table to load through Sync. On doing so, I am getting the following error :“[0] [INVALID_PARAMETER] Invalid search query. Detailed unprocessed description follows. Search error occurred: Record 'transactionStatus' was not found. Bad Request.” Please help me load this table.​​​​​​​

I'm using an xmlmap connector to create an insert into a slq table. everything works correctly, I recently had to add a field for each record I insert that must contain the name of the file I'm importing (which is the same name as the output mapping xml file for the slq connector)There is no way I can create the mapping via the script. I searched for examples and other topics, I use this simple command <arc:set attr="result.text">[Filename]</arc:set>The error in the log i have is:The value of the attribute could not be accessed: The attribute does not exist.I have no indication of the reason and I have already made many attempts, any suggestion or idea is welcome, thanks in advance for any help you wish to give me.Best Regards.

Hello,I need to get a specific filename part value while mapping XML to the desired structure in the XMLMap connector. F. ex. I need to extract ‘1234’ part from a file name 1234_abcd.xml.I have tried to write an expression in the Expression Editor: [getfilename(substring(0, indexof(filename(), "_")))]It does not work and I am not sure that is wrong.Any ideas? Maybe there are even better solutions?

I upgraded the Salesforce JDBC  driver from version 21 to 23.There is a difference in behavior between the 2 versions : I execute this query and get different results: SELECT User.Name FROM User On version 23:{  "Name": "Carmel"} On version 21:“Carmel”Is this the expected behavior? Is there a fix for it? 

Is there a way to export the message or transaction logs from /logs.rst#messages or logs.rst#transactions ?I want to analyse traffic so I can determine a maintenance window for the best time do upgrade cData Arc I’m sure with a bit of AI magic cData Arc could even suggest one 😃 

Greetings everyone.I have a problem using a flat file connector, which I use to convert a fixed length .txt file to xml. the conversion is successful, but the characters present that have accents are converted with the symbol � in the resulting xml. Are there any settings or workarounds to avoid this?address in the .txt file → 3 AVENUE DES SPÉLUGUESaddress in the xml file → 3 AVENUE DES SP�LUGUESThanks in advance to anyone who can help me

Quickbooks - ODBC call is failing when trying to update a column using a Passthrough query in MS Access. It appears to only fail when there are multiple records to update. Works fine with a single record. SQL string looks like this:UPDATE SalesReceiptsSET DepositAccount = ‘Checking’WHERE Date=’2024-01-01’;Persistent connection is ENABLED  

Im trying to design a select query to get the email items in a Inbox subfolder of a shared mailbox when using the Exchange ODBC driver (Exchange online/Office 365). I can get to the shared folder inbox but not query the subfolder. Can anyone help me figure it out please?

Dear All, I have a business logic, where i need to select value for RSN field , based on below Condition  IF  TypeCode = WriteOff  then   {       if  RsnCode = “1004” then          Rsn = “925”      elseif RsnCode = “1006” then         Rsn = “200”      elseif RsnCode = “1003” then         Rsn = “935”    }ElseIf TypeCode = WriteOn then  {       if  RsnCode = “1004” then          Rsn = “950”      elseif RsnCode = “1006” then         Rsn = “250”      elseif RsnCode = “1003” then         Rsn = “935”    } to achieve i tried to add the arc:case within the If condition as below,  <arc:if exp="'TypeCode'=='StockWriteOff'">  <arc:select attr="RSNCode">  <arc:case value="1006">    <arc:set attr="Rsn" value="200"/>  </arc:case>  <arc:select attr="RSNCode">  <arc:case value="1004">    <arc:set attr="Rsn" value="925"/>  </arc:case>  <arc:select attr="RSNCode">  <arc:case value="1003">    <arc:set attr="Rsn" value="935"/>  </a

Hi Team,I’m trying to create a customer sales and purchase P& L model for one of our clients using CData Netsuite integration. For this, it is important to get the COGS AMOUNT details in our sales order or invoice item list table. I know this is available as a search columns in Netsuite, but is there a way to load it through CData? Looking forward to everyone's contribution. 

I’m wondering if there’s a way to leverage Power Automate to automatically update data tables within Snowflake every time a sharepoint list is updated?

HelloWhere can I find the connector release notes (fix, improvements...) depending on their version?Thanks