Solved

Hi, I am getting below error when connecting to mongoDB instance using kerberos.Failed to authenticate database 'instrument', Cannot invoke "XcoreXmongodbX220X8326.qff.c(String)" because the return value of "XcoreXmongodbX220X8326.igf.a()" is null. connection string used: jdbc:mongodb:AuthScheme=GSSAPI;Server=wh-171d272d46.svr.us.jpmchase.net;Port=27040;UseSSL=True;KerberosRealm=exchad.jpmchase.net;KerberosTicketCache=C:\Users\R654476\krb5cc_R654476;SSLServerCert=*;ReplicaSet=wh-1761a58f43.svr.us.jpmchase.net:27040,wh-113139d5b5.svr.us.jpmchase.net:27040;logFile=I:\OMNI-DB2-CERTIFICATES\mongodb-driver.log;Verbosity=5;AuthDatabase=%24external;readPreference=primary;Database=instrument;kerberosServiceRealm=exchad.jpmchase.net driver class name: cdata.jdbc.mongodb.MongoDBDriver

Hi, I am getting below error when connecting to mongoDB instance using kerberos.Failed to authenticate database 'instrument', Cannot invoke "XcoreXmongodbX220X8326.qff.c(String)" because the return value of "XcoreXmongodbX220X8326.igf.a()" is null. connection string used: jdbc:mongodb:AuthScheme=GSSAPI;Server=wh-171d272d46.svr.us.jpmchase.net;Port=27040;UseSSL=True;KerberosRealm=exchad.jpmchase.net;KerberosTicketCache=C:\Users\R654476\krb5cc_R654476;SSLServerCert=*;ReplicaSet=wh-1761a58f43.svr.us.jpmchase.net:27040,wh-113139d5b5.svr.us.jpmchase.net:27040;logFile=I:\OMNI-DB2-CERTIFICATES\mongodb-driver.log;Verbosity=5;AuthDatabase=%24external;readPreference=primary;Database=instrument;kerberosServiceRealm=exchad.jpmchase.net driver class name: cdata.jdbc.mongodb.MongoDBDriver

Hello, to use FireDAC Excel to read xlsx files, is it necessary to have Microsoft Excel installed on the client's computer?Thanks.

[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)

Hello everyone ,I am trying to retrieve a Bearer Token with the GET Bearer Token script on ARC script connector : Below is my script :<arc:set attr="http.URL"      value="https://prodautok.authentication.eu10.hana.ondemand.com/oauth/token?grant_type=client_credentials&token_format=jwt" /><arc:set attr="http.postdata" value='{"password":"XXXXXXX=","username":"sb-21f210cb-9a40-44f8-a78f-c23d13ceec27!b185659|it-rt-prodautok!b117912"}' /><arc:call op="httpPost" in="http" out="response">  <!-- Pass in the json response that contains the token to jsonOpen. -->  <arc:set attr="token.text" value="[http:content]" />  <arc:call op="jsonOpen" in="token" out="handle">    <!-- Call jsonDOMGet with the handle that was obtained from jsonOpen. -->    <arc:set attr="json.handle"    value="[handle.handle]" />    <arc:set attr="json.map:token" value="/json/access_token" />    <arc:call op="jsonDOMGet" in="json" out="result" >      <!-- Se

Hi Folks, When we config the AS2 connection with new partner, receiving the “Invalid signature schemes” error , below is the log info , How to resolve this Signature issue. Is it something done at CData end or the Partner end.  

Hi everyone! I would like to know if is it possible to retrieve data from the SAP ECC 6.0 Function READ_TEXT, using the CData SSIS Components for SAP ERP 2023. Thanks.

Hi Tech Support,I am currently testing your ODBC Connector to Business Central. I managed to connect to Business Central. What I noticed was that the connection was returning all the different divisions that we have on the server. We use the connector to link an SQL Server (as a linked server) but it created a problem. We have multiple tables with the same name which I think it is normal all the different divisions have exactly the same structure tables and field names.So I decided to create multiple ODBC connections, each of them pointing at a different division (on the company field of the connector). This filtered out perfectly the different divisions.The problem is that on the “CData SQL Gateway” I can only start the connection with one of them (that happens to have the default name of “CData D365BusinessCentral Sys”) They are configured exactly the same, using different ports but pointing at different divisions (Company).On the users tab I use also exactly the same user.When I hit

Hi Ethem,thanks for your replay, i have updated the latest drivers in my system. after that i can see the WQL extension objects. all objects i can see but however i am seeing some more problem in this query i am attaching error image for your reference. and also one more is, please suggest how to get all the objects listed in workday, same like in sql server usually SELECT * FROM information_schema.Tables sintax used to get all objectssimilar kind of thing any sintax is it available in Workday? kidnly advise.   

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.

Hi Folks, Please help to advice what will be the max number of files / max Workers a connector will be utilized in a time, since many time i could see files getting stagged up for few hours not getting processed. Then manually sending the files also take time to process, but the server CPU utilization is in optimal level. This causes the business team unable to receive files in time and causing issues,  above is the example from today 9.27 AM MYT files got queued up and not processed for nearly 1.5 hrs. Now i am manually processing them. This is simple Copy Connector. 

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

Hi Team, while connecting Workday Cdata SSIS connector below error is coming kidnly advise.“Invalid FROM clause starting with character: 6405. Invalid WQL syntax.”i am using below query from workday.select * from creditcardtransactionswhere "company_Prompt" = 'LE020 Redwood Software, Inc.' 

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</endDateTime> <Results> <TrackingEvent> <e_updated_at>2024-03-11T00:03:25.0000+00:00</e_updated_at> <e_shipment_id>20167856</e_shipment_id> <s_uuid>

HiIs support for the new objects in Salesforce’s Non Profit Cloud (NPC) built into the latest version of dbamp; this would be for objects like GiftTransaction, etc?If not, is there a timeline to provide support?Many thanks

I’m evaluating the QuickBooks Destination SSIS connector and have a specific use case of inserting checks into QuickBooks from an OLEDB source query.  When mapping the fields from the query, I noticed that the QuickBooks Destination depicts the Check Amount field as read only.  Is there a workaround that would allow me to insert new check information into QuickBooks Desktop Premier 2020 to include the check amount?

I recently copied over a company file from our production server to test server. The company file from the production server is of a different QuickBooks version than QuickBooks on the test server. When testing the connection within the Remote Connector, I keep running into different error messages stating the connection cannot be made. Why can’t I connect?

 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.

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

HI,Is there a direct path available to migrate data from Cassandra to MySQL RDS on AWS??

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 :)

Have a user that gets the following error when trying to refresh the data & import more data using PowerBI.  How can I remedy this for her?