Solved

I am wondering if your SAP ERP JDBC driver will help me with my requirement where my Java application running on an external server needs to be communicated with SAP Server via SAP's interfaces like RFC, BAPI, and IDoc.I am new to SAP and found your SAP ERP JDBC driver and SAP Java Connector (SAP JCo) and tried to find the suitable driver that would solve the purpose.Please correct me if I am wrong. SAP Java Connector (SAP JCo) works at the application layer of the SAP R/3 architecture; however, your SAP ERP JDBC driver works at the database layer. Am I understanding it right?

Hello, Snowflake seems to be case-sensitive with table names, sort of.  If the incoming table name from Sync gets created with lower or mixed case, it gets created that way in Snowflake, and you have to reference them with quotes later on when querying.  Like    select * from “my_table".  Whereas if it were created as MY_TABLE, you wouldn’t need to bother adding quotes.Some data sources (a SQL server database we have, Active Directory, etc.) have lower or mixed case tables as exposed in CData.Is there a way to uppercase these either on the source as the metadata is read, or, when created in the destination?thank you!

Hi,Following the instructions on the help I have set the property “SSLServerCert” to “*” to allow all certificates. If not specified, any certificate trusted by the machine is accepted.Use '*' to signify to accept all certificates. Note that this is not recommended due to security concerns.    I do get authorized on the Zoho CRM server. However on connector side of the CData component I get the error message as shown on the last image below.   Error Message    

Hi,I'm using the CData ODBC Driver for NetSuite (version: 21.0.7867.0 release) to access a customer's NetSuite data. Within the ODBC driver's connection properties, there are no options available to explicitly specify whether to connect to Netsuite.com or Netsuite2.com. Instead, I can provide the Account Id and Version (default 2021_1) for the connection. What data source the CData ODBC Driver for NetSuite is utilizing—Netsuite.com or Netsuite2.com when connecting to the customer's NetSuite? Where can I get this information, thanks. 

Hello Team,Can you are aware for  connectors authentication  in restricted environment would require URL Whitelisting and for  Facebook , I have to “facebook.com” done.Still  doesn't work. Am I missing anything,Any quick response would be appreciated.BTW we are working on Facebook, Instagram, LinkedIn and  YouTube CDATA Conectors. RegardsNS   

I have an angular project that is being built with the command: `npm run start`which runs the script:    "start": "set NODE_OPTIONS=--openssl-legacy-provider && ng serve --proxy-config proxy.conf.json --prod",When the app is opened in "http://localhost:4200" it seems to load ok, but as soon as I change the user using the command:    _setUser(window._user.sally_superAdmin);The user info is returned but I get an error message in the console:    main.js:1 ERROR Malformed UTF-8 data    rc @ main.js:1    handleError @ main.js:1    next @ main.js:1    __tryOrUnsub @ main.js:1    next @ main.js:1    _next @ main.js:1    next @ main.js:1    next @ main.js:1    emit @ main.js:1    main.js:1 ERROR TypeError: Cannot read properties of undefined (reading 'filter')        at a.project (main.js:1:4756133)        at a._next (main.js:1:3551188)        at a.next (main.js:1:3529941)        at a._next (main.js:1:3551286)        at a.next (main.js:1:3529941)        at h._next (main.js:1:3557774) 

Hi, I have a case where receiving  XML files with base64 (e.g. PDF)files inside the file which ones do I want to send as attachments in an email with Email Send connector (Template mode)maybe someone knows what script could be used?XML example<?xml version="1.0" encoding="utf-8"?><ForwardingInstructions xmlns="urn:oasis:names:specification:ubl:schema:xsd:ForwardingInstructions-2" xmlns:dtd="http://dtd.riege.com/scope/shippingorder" xmlns:cbc="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2" xmlns:cac="urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2">  <cac:DocumentReference>    <cbc:ID>523651</cbc:ID>    <cbc:DocumentType>comment</cbc:DocumentType>    <cbc:DocumentDescription> Transporter: Agile Logistics AS - BIL - Bil (Vei transport)</cbc:DocumentDescription>  </cac:DocumentReference>  <cac:DocumentReference>    <cbc:ID>126242</cbc:ID>    <cbc:Status>Docum

Current servers are running with SQL 2016 version and in these servers we have CData.SSIS.Excel  (18.0.6705) with 2018 version. This Cdata version is running fine in current server.In the new server which is running on SQL 2019 version, we cannot install this version, so we installed a updated version(22.0.8509) . Below steps are getting performed for package migration from 2016 to 2019: We are converting the solution configuration from 2016 to 2019 and build the solution and deploy the solution to 2019 server. Error That we are getting in package : which was earlier using CData.SSIS.Excel  (18.0.6705) on sql 2016  and now using updated version(22.0.8509) on 2019 SQL server. When we opened the package on new 2019 server, we could not able see the cdata excel connection manager there. So we have to manually create a connection manager, select connection manager on source and deploying the package. What we are looking for is there a way , all these package can run on 2019 sql server with

Here is a simple example of a query that works in FDConnection but not FDQuery.  This was tested on the 30 row Excel table using the CDataExcel driver id.  The first component returns a 30 row result set.  The second component fails on “field 2023-01 not found in subquery ….”select "Budgeted Items", "2023-01", "2023-02", "2023-03", "2023-04", "2023-05", "2023-06", "2023-07", "2023-08", "2023-09", "2023-10", "2023-11", "2023-12"  from(  select "Budgeted Items", "MonthNo", "Amount"   from "BUDGETED") as SourceTablePIVOT(  sum("Amount")  for  "MonthNo" in ("2023-01", "2023-02", "2023-03", "2023-04", "2023-05", "2023-06", "2023-07", "2023-08", "2023-09", "2023-10", "2023-11", "2023-12"))

Is it possible to import PDF data into QuickBooks Online (QBO) with CData Arc? If so, can someone please provide a step-by-step guide?

Hi, I hope someone here can help me.I have been trying to establish a connection to ZohoCRM using FireDac CDataZohoCRM component and I have failed 100% of my attempts.I do have a general idea on how the OAuth protocol works. To help myself understanding I have used Postman to test the parameters I use (client_id, client_secret, tokens etc) From Postman I did not encounter any difficulty.I believe that the main issue I am finding with the FireDac CDataZohoCRM is the amount of granularity that your component offers it is a bit overwhelming. I am sure that the granularity offered it is probably a great asset for someone that has an expertise on this. However as a beginner, I got into a point where I would have to brute force the component testing every single permutation and combination to isolate my mistakes on the misuse of the connector.A I understand from the documentation the SSLServerCert attribute it is not mandatory here and it can be replaced by a “*”. Not secured but not mandato

Hi Team, Tried to fetch results from Exact online where it does not work properly for some divisions Exact online - QUERY_ABORTED -Error Fetching Results  

INFO: Get app data directory form /Users/mac/Downloads/CDataSync /sync.properties file. nullAug 18, 2023 3:51:40 PM cdata.sync.SyncServer aINFO: The server log directory is /Users/mac/Downloads/CDataSync /logs/httpserverAug 18, 2023 3:51:40 PM b.d qINFO: Init Jetty log with default settings.Aug 18, 2023 3:51:40 PM b.d bINFO: Starting server from /Users/mac/Downloads/CDataSync /sync.properties configuration.Aug 18, 2023 3:51:40 PM d.a aINFO: The properties deserializes success.Aug 18, 2023 3:51:41 PM b.d cINFO: Enabling embedded Jsp support...Aug 18, 2023 3:51:41 PM b.d cINFO: Successfully enabled embedded Jsp support.2023-08-18 15:51:41.719:INFO :oejs.Server:main: jetty-10.0.14; built: 2023-02-22T23:12:32.272Z; git: 976721d0f3e903a243584d47870ad2f2c1bf9e55; jvm 17.0.8+9-LTS-2112023-08-18 15:51:49.684:WARN :oejw.WebAppContext:main: Failed startup of context o.e.j.w.WebAppContext@7d3a22a9{/,null,STOPPED}{/Users/mac/Downloads/CDataSync /webapp/sync.war}java.util.zip.ZipException: invalid

 What should I put in the “”Perform this query to select the UPSERT key” box?

Hi Community, new to CData Sync here.When am trying to extract a certain table from Workday through the inbuilt Workday source connection, an getting the error - [0] Cannot invoke "java.util.List.iterator()" because "" is null Could anyone help with the error please. Thanks in advance.  

How to define a cross reference table or codelist in XML to X12  mapping? Collect = CCPrepaid = PPPer Contract = DE

Dear all, apologizes in advance for the probably silly question, but I am new at this and I could not find any examplea customer of mine is sending me a file always with the same filename, and I need to be able to save it and be sure that it will not be overwrittenfor example adding a timestamp would be perfect (but preserving the extension)EUC2313.xml → EUC2312_20230828101211.xmlEUC2313.xml → EUC2312_20230828101313.xmlhow could I do this ? I can not use filepath or filename

We are facing issue in connecting to Teradata. On debugging we found the below error. Can someone help? 2023-08-25T09:34:58.217+0000 0 [4|Q-Id] [INFO|Connec] Executed connect: Error: com.teradata.jdbc.TeraDriver2023-08-25T09:34:58.218+0000 0 com.teradata.jdbc.TeraDriverjava.lang.ClassNotFoundException at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:476) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:594) at XcoreXcdata.realdb.gld.loadClass(Unknown Source) at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:527) at java.base/java.lang.Class.forName0(Native Method) at java.base/java.lang.Class.forName(Class.java:315) at XcoreXteradataX220X8462.fcf.p(Unknown Source) at XcoreXteradataX220X8462.fcf.o(Unknown Source) at XcoreXteradataX220X8462.fcf.i(Unknown Source) at XcoreXteradataX220X8462.prb.aX(Unknown Source) at XcoreXteradataX220X8462.prb.k(

Executing SF_MirrorAll results in an error as indicated below.  It occurs both with FullCopy or DeltaCopy.  I have performed various searches but haven’t found a solution.  --- Starting SF_Mirror for WorkStepStatus V8304 [SQLSTATE 01000]01:53:03: Parameters: SALESFORCE_Med_ARCH_FULL WorkStepStatus  Version: V8304 [SQLSTATE 01000]01:53:04: DBAmpAZ 22.0.8304.0 Copyright c 2021 CData Software, Inc. [SQLSTATE 01000]01:53:04: Obtaining Connection Props [SQLSTATE 01000]01:53:04: Obtaining User Information [SQLSTATE 01000]01:53:04: Using settings from Registry. [SQLSTATE 01000]01:53:05: Using FullCopy because the WorkStepStatus table does not exist. [SQLSTATE 01000]01:53:05: Server: WUIT-S-14261, Database: MedARCH_SF_FULL, Linked Server: SALESFORCE_Med_ARCH_FULL [SQLSTATE 01000]01:53:05: Using the Salesforce BulkAPI. [SQLSTATE 01000]01:53:06: Create WorkStepStatus_Previous20230828015305925 with new structure. [SQLSTATE 01000]01:53:06: Error: Entity 'WorkStepStatus' is not supported by the Bul

I started using the new Branch connector with an existing AS2 connector. The Branch connector will be used to save specific messages based on the Filename to a different folder.I've setup the Branch connector as shown in the image provided in the Help for the Branch connector.IF Filename matches glob CUS*.*But instead of the output being send to the provided File Connector to save the message in a different folder, the message is forwarded to the ELSE clause and forwarded to that attached connector.The log-file shows the following information (not really helpful at the moment):[2023-08-25T15:36:47.403] [Info] CUSDEC325-0000000000062014 is routed to File_SHPP2MEP_Test (which is the ELSE clause). [2023-08-25T15:36:47.403] [Info] Message CustomerAS2_TEST-20230825-153646575-eCIr is finalized. Name: CUSDEC325-0000000000062014, Type: Output, Status: Success, Message: , Processing Time: 16ms. [2023-08-25T15:36:47.403] [Info] Arc Version: 23.2.8606.0 [2023-08-25T15:36:47.403] [Info] System Ver

Hello Experts,Can CDATA process  unstructured and semi-structured data. Please give us some pointers.

My DBAMP version is 22.0.8354.0I have DMAMP installed on a non OS Drive.   M:\Program Files\Cdata\CData DBAmpTrying to upgrade the license using the Config Utility.  Help → Licensing ->Update LicenseGetting following error.  The keys.reg file does not exist on my installation. Work Around Create the folder + File the error was complaining about. It can be an empty text file.“c:\CData\CData DBAmp\keys.reg”Re-Run the Update License command and seems to work fine now. Question Is this fixed in a later version of dbamp?  I am aware I dont have the most recent “patch”.

Hello ALL,  I have new requirement, From Customer they use API to send data and i need to receive the data, convert to XML ( CDM Customized data format) send it SWAG system via AS2. And is same way, i will be receiving the XML file from SWAG system via AS2, need to convert to customer JASON format and POST the data to Customer using API.  Please help to advice how i should be use the API, i never used API before, all i was familiar with connections like AS2 SFTP FTP’s.  Hence i cant able to understand API in term of connection method.  Thanks for your time and consideration.  Thanks Pradeep 

Hello, I’m trying CData SSIS SharePoint Components for the first time. I’m following the tutorial instructions to from CData to insert new or update existing records in SharePoint. Use the CData SSIS Components to Insert New or Update Existing SharePoint Records from SQL Server Using SQL Server (2012) as a source, I am attempting to setup a CData SharePoint Lookup task, but cannot map an ID (int) column to the ID (number) column on SharePoint (2016). Apparently a number with 0 decimal places is a datatype DT_R8, so I cannot map these columns, as DT_R8 cannot be used to map due to not being exact. I don’t see any particular option in SharePoint to make a number not a float. It does seem a bit odd that there’s no way to map on a SharePoint number column, so maybe I’m missing something, or perhaps it’s because it’s SharePoint 2016. Since I can map on text, I can modify my own SharePoint lists to use text columns, but it may not be so easy to get business partners to modify their lists to

Hi CData Community,    I am trying to add another layer of security for a webhook. I would like to do the following:    1. Pass @authtoken query parameter for CData API auth    2. Pass Authorization via headers    Unfortunately, I am getting an error Error: Authentication is required for access to this resource.It seems like the webhook first checks the Authorization header for CData API auth before checking the query parameter @authtoken.But I need the Authorization header for my additional security. Is this implementation possible?Thanks!