CData Software - Knowledge Base
Recent Articles
-
Build Automated Workflows with Live Shopify Data in Workato
Use CData Connect AI to connect to live Shopify data and build automated workflows in Workato.
-
Connect to Live Printify Data in MicroStrategy through CData Connect AI
Create a live connection to Printify Data in CData Connect AI and connect to your Printify data from MicroStrategy.
-
Integrating LlamaIndex with Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Oracle Financials Cloud data in real time.
-
Automated Continuous Oracle Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Oracle replication to Google BigQuery.
-
Write a Simple Go Application to work with CockroachDB Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to CockroachDB data.
-
Access Live Strava Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Strava data into the statistical analysis tools available in SAS JMP. This article shows how to use Strava data in the Graph Builder and Query Builder.
-
Connect to Samanage Data from AWS Glue
Use CData Connect AI to gain access to live Samanage data from your AWS Glue jobs.
-
Access Live Adobe Experience Manager Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Adobe Experience Manager data from your Excel spreadsheets.
-
New SharePoint Views: Sites, AllLists, AllFiles
This article reviews the newly added views to the CData SharePoint Drivers, Sites, AllLists, and AllFiles, and explores example queries using the new views.
-
How to integrate Insightly with Apache Airflow
Access and process Insightly data in Apache Airflow using the CData JDBC Driver.
-
Publish Crystal Reports on ZohoInvoice Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ZohoInvoice data.
-
How to integrate Jira with Apache Airflow
Access and process Jira data in Apache Airflow using the CData JDBC Driver.
-
Automate Google Sheets Data Replication to SAP HANA
Use CData Sync to customize and automate Google Sheets data replication to SAP HANA.
-
ETL LDAP in Oracle Data Integrator
This article shows how to transfer LDAP objects into a data warehouse using Oracle Data Integrator.
-
Integrate Cline with Live ConstantContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live ConstantContact data from within your IDE.
-
Automated Continuous ZendeskSell Replication to SingleStore
Use CData Sync for automated, continuous, customizable ZendeskSell replication to SingleStore.
-
Integrate LibreChat with Live Cloudant Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Cloudant data from within the chat interface.
-
How to Connect to & Open Clari Data in Microsoft Excel
This article uses the CData ODBC driver for Clari to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to work with PhantomBuster Data in Apache Spark using SQL
Access and process PhantomBuster Data in Apache Spark using the CData Software JDBC Driver.
-
Use Microsoft Copilot Studio to talk to your Oracle Financials Cloud Data 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 Oracle Financials Cloud data for you.
-
Back Up Oracle Sales data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Oracle Sales. In this article, we will employ an SSIS workflow to populate a database with Oracle Sales data data.
-
LINQ to Azure Data Catalog Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Azure Data Catalog Data Provider.
-
Replicate Multiple Highrise Accounts
Replicate multiple Highrise accounts to one or many databases.
-
Automated Continuous ZohoInvoice Replication to MongoDB
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to MongoDB.
-
Connect to LightSpeedRetail Data in CloverDX (formerly CloverETL)
Transfer LightSpeedRetail data using the visual workflow in the CloverDX data integration tool.
-
How to Create Power BI Visual Reports with Real-Time Stack Exchange Data
Use CData Power BI Connectors to visualize Stack Exchange data in Power BI.
-
Build Apps with Live Office 365 Data Using the Low-Code Development Platform of Mendix
Connect Office 365 data with Mendix to build apps using the CData JDBC Driver for Office 365.
-
How to create Notion federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Notion data in MySQL .
-
Query MailChimp Data as a MySQL Database in Node.js
Execute MySQL queries against MailChimp data from Node.js.
-
Automated Continuous Sage Cloud Accounting Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Amazon S3.
-
Use ChatGPT to Talk to Your LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your LinkedIn data for you.
-
Access Live Couchbase Data in Excel 365 Online (Excel for the web)
Connect to Couchbase data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Connect to Live iContact Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your iContact data for you.
-
Connect to VWO Data in Jaspersoft Studio
Execute SQL to remote VWO data in Jaspersoft Studio.
-
How to Access Live Eventbrite Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Eventbrite enables you to integrate Eventbrite data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Asana Data from PowerBuilder via JDBC
This article demonstrates how to access Asana data from PowerBuilder using the Asana JDBC Driver.
-
Connect to Invoiced Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Invoiced.
-
Integrate with live Testmonitor Data in Jitterbit
Use CData Connect AI to connect to and integrate live Testmonitor data in Jitterbit.
-
Connect to Shortcut Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Shortcut as an External Source in Dremio.
-
DataBind Charts to Workable Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Workable data 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.
-
Connect to Stripe Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Stripe data in Airbyte.
-
Build Charts with SageHR Data in Clear Analytics
Create dynamic charts and perform analytics based on SageHR data in Clear Analytics.
-
Build an OLAP Cube in SSAS from Dropbox Data
Establish a connection to Dropbox data data from SQL Server Analysis Services, and use the Dropbox Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Raisers Edge NXT Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Raisers Edge NXT data from Filemaker Pro on Mac.
-
Automate Dynamics 365 Data Replication to Couchbase
Use CData Sync to Customize and automate Dynamics 365 data replication to Couchbase.
-
Build AI/ML Models with Live AgileCRM Data using Dataiku
Connect AgileCRM Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous Bannerbear Replication to Databricks
Use CData Sync for automated, continuous, customizable Bannerbear replication to Databricks.
-
Add Helpscout Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Helpscout with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating Kiro with Typeform Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Automated Continuous Acumatica Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Acumatica replication to Apache Kafka.
-
Automated Continuous Jira Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Jira data replication to OneLake in Microsoft Fabric.
-
Access Live Redshift Data in Coginiti Pro
Connect to and query live Redshift data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect to & Open Placid Data in Microsoft Excel
This article uses the CData ODBC driver for Placid to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to connect to iContact Data from Spring Boot
Connect to iContact in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate Real-Time Access to Google Calendar in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Calendar data in real time.
-
Interact with Live Paylocity Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Paylocity data.
-
Consume Reckon Accounts Hosted OData Feeds in PowerBuilder
This article demonstrates how to consume Reckon Accounts Hosted data as OData feeds from PowerBuilder using the API Server.
-
Getting Started with the CData SSIS Components for Bannerbear
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Bannerbear.
-
Connect to FHIR Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for FHIR data in the Denodo Virtual DataPort Administrator.
-
Build Semantic Layer Views for FHIR Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for FHIR data.
-
Access Access Data from MySQL in PHP
Connect to Access through the standard MySQL libraries in PHP.
-
How to connect to Outlook Data from IntelliJ
Integrate connectivity to Outlook data with wizards in IntelliJ.
-
Integrating GitHub Copilot with Short.io data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Build a Singer.io Tap for Twilio With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Twilio data using the CData Python Connector.
-
Connect to LaunchDarkly Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to LaunchDarkly and work with LaunchDarkly data in your FileMaker applications.
-
ETL Zoho Inventory in Oracle Data Integrator
This article shows how to transfer Zoho Inventory data into a data warehouse using Oracle Data Integrator.
-
Easily Integrate BambooHR Data in Lazarus Pascal IDE
Learn how to easily integrate live BambooHR data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Real-Time Adobe Commerce Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Adobe Commerce and Dataflow to import and use Adobe Commerce data in Power Apps.
-
Connect to SharePoint Data in ACL Analytics
Connect to SharePoint data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SharePoint data.
-
How to connect and process ChargeOver data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ChargeOver data.
-
Automated Continuous Wistia Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Wistia replication to delimited files (CSV/TSV).
-
Analyze Live Paymo Data in SAS Viya
Use CData Connect AI to connect to Paymo data from SAS Viya and deploy self-service analytics using live Paymo data.
-
Bind Live Zoho Books Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Zoho Books data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Query Live Oracle Sales Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Oracle Sales data directly from the development environment.
-
Process & Analyze MYOB AccountRight Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live MYOB AccountRight Data.
-
Connect to Shopify Data from a Connection Pool in Jetty
The Shopify JDBC Driver supports connection pooling: This article shows how to connect faster to Shopify data from Web apps in Jetty.
-
Build Apps with Live Procore data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Procore data into the Adalo platform and build custom mobile and web applications with real-time Procore data.
-
DataBind Charts to Box Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Box data 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.
-
How to Connect to Live WordPress Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your WordPress data for you.
-
Connect to and Query Paddle Data in QlikView over ODBC
Create data visualizations with Paddle data in QlikView.
-
Use the CData Software ODBC Driver for QuickBooks Time in MicroStrategy Desktop
Connect to QuickBooks Time data in MicroStrategy Desktop using the CData Software ODBC Driver for QuickBooks Time.
-
How to Connect DBeaver to Onfleet via a JDBC Driver
Manage Onfleet data with visual tools in DBeaver like the query browser.
-
Connect to Zoho CRM Data in JRuby
Create a simple JRuby app with access to live Zoho CRM data.
-
Create Oracle-Connected Business Apps in AppSheet
Connect to Oracle Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Oracle data.
-
Integrate Aircall Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Aircall data from Informatica Cloud.
-
Integrate Live Outreach.io Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Outreach.io data and integrate live Outreach.io data into apps built in Microsoft Power Apps.
-
Query DocuSign Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume DocuSign entities in PHP by modeling them as objects.
-
Use the CData ODBC Driver for Box from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Box to connect to Box data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Box data in Excel.
-
How to connect and process Greenplum data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Greenplum data.
-
Getting Started with the CData SSIS Components for Dynamics 365
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Dynamics 365.
-
Access Elorus Data from MySQL in Amazon QuickSight
Connect to Elorus and build visualizations of Elorus data using a MySQL Connection in Amazon QuickSight.
-
Use CData Connect AI to Access QuickBooks Online Data in Microsoft Power Pivot
Use CData Connect AI to connect to live QuickBooks Online data in the Power Pivot business intelligence tool.
-
Build Charts with Oracle HCM Cloud Data in Clear Analytics
Create dynamic charts and perform analytics based on Oracle HCM Cloud data in Clear Analytics.
-
Use the CData Software ODBC Driver for Stripe in SAS for Real-Time Reporting and Analytics
Connect to real-time Stripe data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Stripe.
-
Replicate Neo4J Data to Multiple Databases
Replicate Neo4J data to disparate databases with a point-and-click configuration.
-
Prepare, Blend, and Analyze Adobe Target Data in Alteryx Designer (ODBC)
Build workflows to access live Adobe Target data for self-service data analytics.
-
How to Connect to Live Freshservice Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Freshservice data for you.
-
Extract, Transform, and Load Samanage Data in Informatica PowerCenter
Create a simple Workflow for Samanage data in Informatica PowerCenter.
-
How to create an RPA flow for Phoenix Data in UiPath Studio
Use the Phoenix ODBC Driver to create workflows that access real-time Phoenix data without any coding.
-
Use the CData SSIS Components to Insert New or Update Existing Amazon DynamoDB Records from SQL Server
Easily push SQL Server data to Amazon DynamoDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Amazon DynamoDB or update existing records with data from a SQL Server database.