Recently active topics
Trying to Insert a ManualJournal into Xero with ODBC
I am trying to insert a manual journal entry into Xero using below SQL insert statement. And I get the following error. “A validation exception occurred: The total Debits (1.50) must equal total credits (0.00)" It suggests that cdata is not processing it as one API post but as 2 posts and Xero spits back an error because it expects both lines in the POST api. INSERT into ManualJournals ( JournalLine_AccountCode, JournalLine_LineAmount, Narration) VALUES (620, 1.50, 'Test1'), (611, -1.50, 'Test1');Any ideas would be appreciated.
EXCEEDED_ID_LIMIT: there are '600000' or more records deleted in the specified time period. Please retry getDeleted() call using a shorter time period.
I am using cdata sync and getting the error “EXCEEDED_ID_LIMIT: there are '600000' or more records deleted in the specified time period. Please retry getDeleted() call using a shorter time period.”I have seen other posts say to use a Full vs partial copy but I am not sure that is something that Cdata sync does. Is there a way go get beyond this error in cdata or salesforce?
Trying to use a cData ODBC DSN in Excel to connect to an OLAP cube in Azure Analysis Services on macOS.
ObjectiveTrying to use a cData DSN in Excel to connect to an OLAP cube in Azure Analysis Services on macOS. I can successful setup the DSN in iODBC Data Manager and it tests successfully, but when I try to use the DSN in Excel I get a “Could not bind server socket: Operation not permitted”. I have screen-grabbed all my steps below in the attached PDF.
DBAMP Patches and Hotfix Plans
Is there a patch / hotfix official release schedule for DBAMP? There must be some fixes since the official V2022 release. I did get some Hotfix patches but was wondering if I am to expect an official 2023 or 2022.1 release. I currently have to restart the windows service each night to prevent crashes.
How to update columns for SSIS oData source
We are a new CData user, connecting Acumatica oData as the source to SQL Server OLE DB destination. It works great for the initial configuration of the data flow, but we often change the underlying Acumatica query (i.e. add columns). I can’t seem to find a way to refresh the available columns in the CDdata Acumatica Source Editor screen. If I click the preview button, the new columns appear there correctly with data, but how are the columns added to the Columns node of the Editor screen? Along those lines, is there a way to refresh the list of available Generic Inquiries for new oData sources? The first time you log into Visual Studio the list of available inquiries refreshes, but after that I have to just use the Advanced Editor and hand-write the name of the query. Thanks for any feedback!
Using the QuickBooks driver with the QuickBooks Gateway
The QuickBooks Gateway (formerly Remote Connector) is useful if you want to access QuickBooks in a situation where direct COM access to QuickBooks is not available, such as in ASP.NET, Java, or QuickBooks on a remote machine.To authenticate to the QuickBooks company file, you will first need to create a user in the QuickBooks Gateway. Upon pressing Test Connection on that user, a prompt will open and ask you to authenticate it to QuickBooks. Note that QuickBooks must be open as an administrator in single-user mode for this to succeed.Then, you will need to open the QuickBooks DSN/Connection Manager/Connection String Builder and, in the Remote section, enter the information on the QuickBooks Gateway user you just created. The User and Password will be the username and password of your QuickBooks Gateway user, and the URL will be the URL of the QuickBooks Gateway. Note that the Company File property can be left blank, as the QuickBooks Gateway has already specified which company file to
Driver In Focus June 2023Newsletter
Driver In Focus: NoSQL featuring MongoDBWelcome to the latest Driver in Focus quarterly newsletter. In this edition, we’ll provide an overview of CData NoSQL solutions, featuring MongoDB.CData enables out-of-the-box connectivity to NoSQL data sources from your application, whether it be ETL or BI analytics and reporting tools. Check out this NoSQL customer use case blog post.Learn more Real-time analytics from MongoDB in Power BIWatch this 15-minute pre-recorded Coffee Break webinar to see how easy it is to perform analytics on data stored in MongoDB using Power BI.Watch now Simplified access to your MongoDB dataCData Connectors provide the fastest and most flexible support for NoSQL data integration, allowing you to interact with NoSQL databases as if they were a relational database leveraging the familiarity and utility of SQL-92 queries.Check out this blog post for a technical dive into how to get real-time analytics on MongoDB data in Power BI. Introducing the CData Community! Have
Introducing CData’s User Group Program - An Exciting New Venture
Hello CData Community!We're incredibly excited to announce the official formation of the CData User Group Program, a platform designed to bring our diverse, dynamic community even closer together.Our aim for the User Group Program is to create specialized groups that revolve around shared interests, expertise, or goals within the realm of data and technology. These groups provide an opportunity for members to connect more deeply, learn from each other, collaborate, and drive discussions that will enrich our community and shape the future of our field.Benefits of the User Group Program: Focused Discussions: Each user group will offer focused discussions on its particular area, allowing members to dive deep into topics they're passionate about. Collaboration Opportunities: User groups are an excellent way to meet other users with similar interests, fostering collaborations that could lead to innovation, partnerships, or new projects. Knowledge Sharing: User groups create a dynamic sp
Arc HTTPGet Operation - How to pass Authentication: Bearer header
I’m just trying to authenticate with an API Endpoint which expects a fixed token to be passed as the Authorization HTTP header.Does this look like it should work? I need to pull the token/API key from the Vault.<arc:set attr="http.URL" value="https://api.XXXX.com/carrier/api/shipment-listing/[data.shipmentNumber]" /> <arc:set attr="http.header:Authorization" value="Bearer [Vault(My.API.Token)]"/> <arc:set attr="http.contenttype" value="application/json"/> <arc:call op="httpGet" in="http"> <arc:set attr="output.data" value="[http:content]" /></arc:call>I’m getting a 401 thanks
I am unable to bind my server on port XXXX (which was previously used for the embedded web server) on Windows
One issue that comes up infrequently but can be inscrutable to troubleshoot is a situation where you are unable to start the web server hosting CData Arc on a port that you have previously used for the embedded web server provided with the application. For the purposes of this thread, we will refer to port 8001 here, since this is the default port assigned to the embedded web server distributed with CData Arc. Most commonly, issues with binding to a specific port are due to an existing process that is already listening on that port, but you may find that even after you run a check for ports in the listening statenetstat -a You do not see anything listening on that port. One possibility is that the URL for the port you are selecting has already been reserved on the system and cannot be assigned to another server. To check for this, run: netsh http show urlacl This will list all of the reserved entries on the machine. If the URL that you are trying to bind shows up like this: Reserved U
Excel add-in for Zoho Books: How to select all “BillLineItems”
Hi!I’m using the Excel add-in to connect to Zoho Books. I would like to get all “BillLineItems” from Zoho. The BillLineItems is a standard view or table.It is not possible to use the SELECT * command in order to retrieve all lineitems. It is required to a specify a BillID (key) number in order to get the data for that specific bill from this table (as I understand).Maybe it is my lack of knowledge of SQL. Do you have any suggestions how to get all BillLineitems? Thanks in advanve for your response.Regards,Marc
CData Connect Cloud Newsletter - Q2 2023Newsletter
CData Connect Cloud NewsletterThank you for your interest in CData Connect Cloud! We are excited to share what’s new and upcoming, product tips, as well as resources and events you may have missed for your real-time data connectivity needs.In case you missed it…We’re partnering with Workday, one of the most popular cloud-based HCM platforms, to support new connectivity and integration initiatives for our mutual customers.Check out this video on analyzing Workday data in Tableau Cloud. Although this video demos Tableau Cloud, you can analyze Workday data using any of your favorite BI, analytics, or reporting tools.Watch the video Introducing the CData Community!Have you heard the news? Our brand new CData Community site is here! We’re thrilled to offer our customers and partners a platform to connect with fellow CData users, start conversations, ask questions, and interact with our experts.Sign me up Product improvements and new functionalityGoogle Analytics 4Learn how to make Google An
Error when trying to open editor in Visual Studio SSIS
When double clicking on the CData source, I am getting the following error. “Could not load file or assembly 'Microsoft.DataWarehouse, Version=126.96.36.199, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.”
CData Arc Quick Tip of the Quarter: Using the Arc Vault
This quarter’s quick tip centers around the Arc Vault, a feature that enables storing and referencing values for simpler and more secure configuration.Why Use ItHere are a few cases in which the Vault is helpful:Save time when using the same configuration values in multiple connectors Protect sensitive values from limited-permissions users Simplify the process of updating passwords or identifiers across all workflowsHow It WorksThe Arc Vault allows you to give certain configuration values a “name” so that you can refer to these values by name instead of by the value itself.For example, if my SFTP server password is “test123,” I can use the Arc Vault to give this value a name like “mySFTPPassword.” Then, when configuring SFTP connectors, I can use “mySFTPPassword” instead of the password value itself in the connector’s configuration.The vault stores the relationship between the name (“mySFTPPassword”) and the value (“test123”) so that either can be used within Arc. Sensitive values can
Custom Signature Authentication in the Webhook Connector
OverviewSometimes, a requirement arises where you may need to receive data from a trading partner via the Webhook connector but that partner might require a bit more security other than just the basic auth username/password that is used to authenticate inbound webhook requests - or maybe you just want to add an additional layer of security on inbound webhook messages.Using the custom response feature of the webhook connector, you can actually create your own HTTP signature authentication logic to perform some additional authentication on inbound webhook requests, via the use of an HMAC signature value assigned to a header on the request.GitHub has a good writeup about this, and this is what has been used to make the below example within CData Arc - https://docs.github.com/en/webhooks-and-events/webhooks/securing-your-webhooksThe ScriptThis script is one that I wrote within the Response event of the Webhook Connector attached to this post:<!-- setting the secret key value to be avail
CData Sync Newsletter - Q2 2023Newsletter
CData Sync NewsletterThe latest version of CData Sync is here! This new release delivers a next-generation user interface designed to make building and deploying your data pipelines even easier. Read on to learn more and explore recent news and resources. Next-generation UI designThe CData team has spent several months enhancing the Sync GUI to deliver a modern, intuitive design with complete visibility into your replication and ETL/ELT jobs. New features include:Reflecting schema changes in a Kafka destination Use of Google Analytics 4 reports with pre-built schemas Support for Oracle Change Data Capture in Oracle multitenant instances Support for AlloyDB as a destination Load From Bucket in Amazon S3Learn more Introducing the CData Community!Have you heard the news? Our brand new CData Community site is here! We’re thrilled to offer our customers and partners a platform to connect with fellow CData users, start conversations, ask questions, and interact with our experts.Sign me up
FireDac batch insertion in Excel or...
Does CDataFireDACComponentsforExcel2022 support batch insert to a sheet?If so, how to use it?I am using Delphi + FireDac + CDataExcel + SQLServer.From a stored procedure that returns two DataSets I need to create an excel file with those two DataSets (worksheets).Previously I have managed to use a batch insert from CSV files to SQL Server; but I have not been able to do the same from a dataset to an excel sheet. I tried this but it throws this exception:[FireDAC][Phys][CDataExcel]-303. Capability is not supported FDQuery1.Connection.StartTransaction; FDQuery1.Params.ArraySize := 3; FDQuery1.Params.AsStrings := '66666666-269a-491f-ae3a-86ff85149e03'; FDQuery1.Params.AsStrings := 'A666666666'; FDQuery1.Params.AsStrings := '2023-05-02'; FDQuery1.Params.AsFloats := 666666.7895; FDQuery1.Params.AsStrings := '77777777-269a-491f-ae3a-86ff85149e03'; FDQuery1.Params.AsStrings := 'A777777777'; FDQuery1.Params.AsStrings := '2023
Class java.lang.Boolean cannot be cast to class java.lang.Number
Issue encountered while extracting data using CDATA JDBC driver in Snaplogic. Specifically, we are receiving the following error message: "Class java.lang.Boolean cannot be cast to class java.lang.Number (java.lang.Boolean and java.lang.Number are in module java.base of loader 'bootstrap')" Thanks
CData Drivers Newsletter - Q2 2023Newsletter
CData Drive NewsletterThank you for your interest in CData connectivity solutions! We are excited to share what’s new and upcoming, driver tips, as well as resources and events you may have missed. Great news for Workday usersWe're partnering with Workday, one of the most popular cloud-based HCM platforms, to support new connectivity and integration initiatives for our mutual customers. Check out our newest video on analyzing workday data in PowerBI.Watch the video Introducing the CData Community!Have you heard the news? Our brand new CData Community site is here! We’re thrilled to offer our customers and partners a platform to connect with fellow CData users, start conversations, ask questions, and interact with our experts.Sign me up Driver update: CData Predefined Reports for GA4We have updated the data model in our Google Analytics 4 driver to give you a head start on your analytics queries. These new predefined reports make it easy to retrieve commonly used reports without havin
Connector Backoff Behavior in CData Arc
In CData Arc 2022, a new feature was added to the application which has been coined “backoff”. You may or may not have seen this mentioned in the application log of your instance, but if you haven’t, an entry in the application log would look something like this:~/AutomationService Warning The [ConnectorID] connector has failed more than 3 times and has entered a backoff state. The automation service will skip this connector until [date/time]. The connector will remain in the backoff state until a message is successfully sent manually, the connector settings change, or all messages are sent successfully during an automated send attempt.This is a feature where the automation for the connector will be temporarily paused if the connector fails to send a file successfully with automation three times in a row. If this happens, a 60 minute delay will be added to the automation of that connector before the connector will try to send any files via automation again. If the connector fails
New Sync release - modern UI and even better hybrid cloud connectivity
Our newest Sync release is now generally available! In this release, as part of our ongoing work to improve the Sync user experience, we employed a Voice of the Customer methodology, soliciting and listening to customer feedback about navigation flows, tasks that would benefit from a more streamlined approach, and the need for improved schema support for common use cases. Read the blog to learn more.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.