CData Software - Knowledge Base
Recent Articles
-
Load Harvest to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Harvest to a database.
-
Visualize Epicor Kinetic in TIBCO Spotfire through ADO.NET
Integrate Epicor Kinetic into dashboards in TIBCO Spotfire.
-
Create Sage 200-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Sage 200 from OutSystems and build custom enterprise apps using live Sage 200.
-
Automate Certinia Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Certinia and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to Dynamics 365 from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Dynamics 365 from Appeon PowerBuilder using the CData ADO.NET Provider for Dynamics 365.
-
Automate Tasks in Power Automate Using the CData API Server
Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
-
Build Airtable Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Airtable and build visualizations in Tableau Cloud.
-
Viewing Certinia in RAD Studio Data Explorer
How to view Certinia in RAD Studio Data Explorer using the CData ODBC Driver for Certinia.
-
How to Query Live Azure Table in Perplexity MacOS Desktop
Connect to and query live Azure Table in Perplexity Desktop using CData Code Assist MCP.
-
Working with Oracle in LINQPad
Execute LINQ queries to Oracle Database in LINQPad.
-
Publish OData-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live OData.
-
Create SharePoint Excel Services Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SharePoint Excel Services data access from reports, embedded analytics, and more.
-
Getting Started with the CData JDBC Driver for SingleStore
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SingleStore.
-
Extract, Transform, and Load Amazon Marketplace in Informatica PowerCenter
Create a simple Workflow for Amazon Marketplace in Informatica PowerCenter.
-
Connect to Azure Synapse in RapidMiner
Integrate Azure Synapse with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to TaxJar in the Denodo Platform
Use CData driver technologies to create a virtual data source for TaxJar in the Denodo Virtual DataPort Administrator.
-
Automate ADP Replication to SAP HANA
Use CData Sync to customize and automate ADP replication to SAP HANA.
-
DataBind Charts to Cloudant
Use the standard ADO.NET procedures for databinding to provide bidirectional access to IBM Cloudant from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Build AI Agents with Vault CRM Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Access Live Reckon Accounts Hosted in Coginiti Pro
Connect to and query live Reckon Accounts Hosted from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Migrating data from Couchbase to Google BigQuery using CData SSIS Components.
Easily push Couchbase to Google BigQuery using the CData SSIS Tasks for Couchbase and Google BigQuery.
-
Connect to Reckon Accounts Hosted from PowerBuilder via JDBC
This article demonstrates how to access Reckon Accounts Hosted from PowerBuilder using the Reckon Accounts Hosted JDBC Driver.
-
Visualize Oracle in TIBCO Spotfire through ADO.NET
Integrate Oracle Database into dashboards in TIBCO Spotfire.
-
Connect Tally to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Tally ERP using the CData Python MCP Server.
-
Integrate Live SurveyMonkey into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SurveyMonkey from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SurveyMonkey.
-
Use Azure AI Foundry to Talk to Your Shopify via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Shopify for you.
-
Build Dashboards with Active Directory in Dundas BI
Create dynamic dashboards and perform analytics based on Active Directory in Dundas BI.
-
Edit and Search SAP ByDesign External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SAP Business ByDesign to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SAP ByDesign objects that you can access from apps and the dashboard.
-
Analyze MailChimp in Infragistics Reveal
Use CData Connect AI to create on OData API on top of MailChimp and visualize live MailChimp in Infragistics Reveal.
-
Integrating Boomi Agentstudio with LinkedIn via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to LinkedIn, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to SAP Ariba Procurement in DBeaver
Use the CData ODBC Driver to connect to SAP Ariba Procurement in DBeaver.
-
CSV Reporting in OBIEE with the CSV JDBC Driver
Deploy the CSV JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Analyze Azure DevOps in R via JDBC
Use standard R functions and the development environment of your choice to analyze Azure DevOps with the CData JDBC Driver for Azure DevOps.
-
Analyze AlloyDB in Infragistics Reveal
Use the CData API Server to create an OData API on top of Google AlloyDB and visualize live Google AlloyDB in Infragistics Reveal.
-
Connecting Moonlit Workflow with Oracle HCM Cloud via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Oracle HCM Cloud in real time.
-
How to Create Power BI Visual Reports with Real-Time SAP SuccessFactors
Use CData Power BI Connectors to visualize SAP SuccessFactors in Power BI.
-
Back Up Bing Ads to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Bing Ads. In this article, we will employ an SSIS workflow to populate a database with Bing Ads data.
-
Visualize Live Zuora of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Zuora using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Gumloop with Zoho Inventory via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Zoho Inventory within automated workflows.
-
Import and Visualize Workday in Power View
Create data visualizations based on Workday in Excel.
-
Integrate with Access using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft Access to a JSON file on disk.
-
Validate Zoho Creator with QuerySurge
Access and validate Zoho Creator in QuerySurge using the CData JDBC Driver.
-
Visualize XML in Tableau
The CData ODBC driver for XML enables you integrate XML Files into Tableau dashboards.
-
DataBind Controls to LinkedIn in Delphi
DataBind to LinkedIn in Delphi with standard data access components and controls.
-
How to use SQLAlchemy ORM to access OneNote in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft OneNote.
-
Connect to Sage Intacct from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Sage Intacct to connect to Sage Intacct and execute queries in PowerBuilder.
-
Create Power BI Reports on Real-Time Calendly
Use the CData ODBC Driver for Calendly to visualize Calendly in Power BI Desktop.
-
Connect TigerGraph to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your TigerGraph using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Vault CRM from Crystal Reports
Use CData Connect AI to connect to and report on live Veeva Vault & Vault CRM from Crystal Reports.
-
Connect to Tableau CRM Analytics from PowerBuilder via JDBC
This article demonstrates how to access Tableau CRM Analytics from PowerBuilder using the Tableau CRM Analytics JDBC Driver.
-
Use Microsoft Copilot Studio to talk to your AlloyDB via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Google AlloyDB for you.
-
Automated Continuous QuickBooks Online Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Google Cloud SQL.
-
Configure the CData JDBC Driver for FTP in a Connection Pool in Tomcat
Connect to FTP Servers from a connection pool in Tomcat.
-
Edit and Search External OneNote Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft OneNote to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create OneNote objects that you can access from apps and the dashboard.
-
Connect to Microsoft Planner as an External Source in Dremio
Use the CData JDBC Driver to connect to Microsoft Planner as an External Source in Dremio.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP ByDesign
Create SAP ByDesign data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to integrate OneNote with Apache Airflow
Access and process Microsoft OneNote in Apache Airflow using the CData JDBC Driver.
-
Deploy the ADO.NET Provider for Acumatica on an SSRS Report Server
Connect to Acumatica ERP from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Integrating Gumloop with Zoho Creator via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Zoho Creator within automated workflows.
-
Import Splunk Using Azure Data Factory
Use CData Connect AI to connect to Splunk from Azure Data Factory and import live Splunk.
-
Connect to Oracle Eloqua in CloverDX (formerly CloverETL)
Transfer Oracle Eloqua using the visual workflow in the CloverDX data integration tool.
-
Getting Started with the CData Tableau Connector for Google Sheets
-