Ask questions, get answers and engage with your peers
Start discussions, ask questions, get answers
The latest CData product news and updates
Explore and RSVP for upcoming events
Guides, documentation and support articles
Share product questions and get support
Join a group and share common interests
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.
CData Embedded Connectivity Newsletter The average enterprise uses 150+ tools, and 82% of software buyers require any new SaaS tools to connect with their existing stack. So how do you go about adding these integrations to your product?In this newsletter, we dive into the key considerations of integrations and how to scale them:Building integrations in-house vs. partnering with a provider The difference between data connectors and APIs An overview of standards-based SQL drivers OAuth considerations for SaaS integrations Product integration strategy: Build vs. buy SaaS integrationsMost product teams build their first few integrations in-house but quickly hit a brick wall when they have to scale integrations. In this guide, we cover the API challenges, maintenance requirements and staffing strategy to consider in your build vs. buy evaluation.Read more How data connectors standardize APIsCData Drivers place non-standard APIs inside a standard SQL wrapper so you can use the same queri
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.
CData Arc Newsletter Exciting things are afoot for CData Arc in Q2 2024:The latest update for CData Arc, packed with enterprise-driven features Great conversations about EDI in supply chain at Manifest 2024 The Arc team's first healthcare expo at the HIMSS conference Intensifying momentum towards our next major releaseRead on for more details! Discover new features in just a few minutesWe’ve significantly enhanced user roles and access policies, the ability to enforce service-level agreements with your trading partners, and much more in the latest version of Arc.This 2-minute video shows how these new features empower enterprise Arc users.Watch the video What happened in Vegas...CData Arc sponsored Manifest 2024 in Vegas last month, and we found out just how many supply chain professionals struggle with EDI. Read our retrospective to learn why supply chain & logistics orgs are opting to switch from outdated EDI providers or costly VANs to Arc.Read the takeaways Arc team talks
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
I am reaching out to propose an enhancement to our data sync product, specifically regarding the introduction of validation and reconciliation functionalities. As our data source requirements caters to various data synchronization needs, it's imperative to offer users tools necessary for ensuring data integrity and peace of mind during synchronization processes. Run Validation: Introduce a validation feature that allows users to compare the data between the source and destination systems. Provide a simple comparison of the number of records in both the source and destination, enabling users to quickly identify any discrepancies. This basic validation functionality serves as a valuable troubleshooting tool and provides users with immediate insights into the synchronization status. Advanced Validation Mode: Offer an advanced validation mode that provides detailed insights into differences between the source and destination data. Highlight discrepancies in terms of Inserts, Deletes,
My CData Sync servers are running on Azure. I’d like to use Azure Monitor Agent to monitor if CData Sync service is in stopped state. Usually Windows Service monitoring can be queried from Windows System logs finding Event ID 7036. CData Sync seem not to write anything to System Log (or I just not find it). Where should I try to find information if service is stopped?
📢 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 blog post. 🎥 Visual Learner? Watch our tutorials on the new API Connector Query Slicer and Salesforc
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.
Hello!I know that I can define an out environment variable in pre-job event and use that in the task replication query (documented here and here excellently).I’m probably stretching here but can I define that out-variable to read from a file or any other source and then run the sync task for ALL values of that variable? Kind of a loop? Thanks in advance for you answers!
I am having an issue with my sync installation. I am able to successfully start logminer on the oracle instance and query the results of that logminer session.However, when I run a CDC job from Sync, it will complete the initial data load successfully but then fail on the incremental loads after the initial one with the below error:logminer failed to start If I have it delete the table ot truncate the data then it reloads just fine. It just won’t start logminer to run the CDC loads.Has anyone run into this issue or found a way to resolve this so I can get CDC loads from oracle to sql server working correctly?
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?
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.
Explore e-Books, whitepapers, webinars and more!
Contact our support team and we'll be happy to help you get up and running!
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.