CData Software - Knowledge Base
Recent Articles
-
How to import Pinterest Data into Apache Solr
Use the CData Software JDBC Driver for Pinterest in Data Import Handler and create an automated import of Pinterest data to Apache Solr Enterprise Search platform.
-
Integrating GitHub Copilot with Basecamp 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 MVC Applications with Connectivity to HDFS Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access HDFS from an ASP.NET MVC application.
-
Connect to Sage Intacct Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Sage Intacct and the Script function in FileMaker Pro to connect to Sage Intacct and work with Sage Intacct data in your FileMaker application.
-
Build Apps with Live Sage Intacct Data Using the Low-Code Development Platform of Mendix
Connect Sage Intacct data with Mendix to build apps using the CData JDBC Driver for Sage Intacct.
-
Replicate Stripe Data to Multiple Databases
Replicate Stripe data to disparate databases with a point-and-click configuration.
-
How to connect to Accelo Data from Spring Boot
Connect to Accelo in a Spring Boot Application using the CData API Driver for JDBC
-
Automated Continuous ConstantContact Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ConstantContact replication to AlloyDB.
-
Integrating Codex with SAP BusinessObjects BI 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 Slack Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Slack replication to PostgreSQL.
-
Integrate Real-Time Access to GraphQL in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to GraphQL data in real time.
-
Create Couchbase-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Couchbase Data from OutSystems and build custom enterprise apps using live Couchbase data.
-
Replicate Multiple Chargebee Accounts via the CData Sync CLI
Replicate multiple Chargebee accounts to one or many databases.
-
Connect Email Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Email data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Edit and Search External Salesforce Pardot Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Salesforce Pardot data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Salesforce Pardot Data objects that you can access from apps and the dashboard.
-
Getting Started with the CData Python Connector for Apollo
Learn to install and license the CData Python Connector and configure a connection to live Apollo data.
-
Getting Started with the CData ADO.NET Provider for Smartsheet
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Smartsheet.
-
How to Query Quickbase Data in MySQL Workbench
Execute MySQL queries against live Quickbase data from MySQL Workbench.
-
How to connect to ADP Data in DBVisualizer
Integrate ADP data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrating Kiro with Dynamics NAV 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.
-
How to use SQLAlchemy ORM to access Microsoft Exchange Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Exchange data.
-
Automated Continuous Box Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Box data replication to OneLake in Microsoft Fabric.
-
Visualize Live Certinia Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Certinia data into custom reports in Power BI.
-
Integrate Goose with Live FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live FHIR data from within the local AI agent.
-
Connect to Real-Time Freshsales Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Freshsales data in Power Apps.
-
Analyze Egnyte Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Egnyte data and visualize live Egnyte data in Infragistics Reveal.
-
Connect to Google Calendar Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Google Calendar and the Script function in FileMaker Pro to connect to Google Calendar and work with Google Calendar data in your FileMaker application.
-
How to Create Power BI Visual Reports with Real-Time DB2 Data
Use CData Power BI Connectors to visualize DB2 data in Power BI.
-
Automated Continuous Browserless Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Browserless replication to delimited files (CSV/TSV).
-
Connect to Egnyte Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Egnyte and work with Egnyte data in your FileMaker application.
-
Automated Continuous Sybase IQ Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Sybase IQ replication to Apache Kafka.
-
DataBind Charts to ZohoExpense Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ZohoExpense 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.
-
Create Datasets from Pipeliner CRM in Domo Workbench and Build Visualizations of Pipeliner CRM Data in Domo
Use the CData Software ODBC Driver for Pipeliner CRM to create datasets from Pipeliner CRM data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Google Sheets Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Google Sheets Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Informatica Mappings From/To an ODBC Data Source for Zuora
Create an ODBC connection to Zuora in Informatica and browse and transfer Zuora data.
-
Getting Started with the CData ADO.NET Provider for DocuSign
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for DocuSign.
-
How to connect to Adobe Target Data in DBVisualizer
Integrate Adobe Target data with visual data analysis tools and data connection wizards in DBVisualizer
-
Trigger Sybase IQ IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Sybase IQ with standard wizards in Logic Apps.
-
Connect to Oracle Service Cloud Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Oracle Service Cloud data.
-
Automated Continuous Cosmos DB Replication to MySQL
Use CData Sync for automated, continuous, customizable Cosmos DB replication to MySQL.
-
Create Power BI Reports on Real-Time Exact Online Data
Use the CData ODBC Driver for Exact Online to visualize Exact Online data in Power BI Desktop.
-
LINQ to Drip 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 Drip Data Provider.
-
Connect to GitHub Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for GitHub to connect to GitHub data and execute queries in PowerBuilder.
-
Connect to Marketo Data in Aqua Data Studio
Access Marketo data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automate PostgreSQL Data Replication to Azure Synapse
Use CData Sync to customize and automate PostgreSQL data replication to Azure Synapse.
-
Build Apps with Live Oracle SCM data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Oracle SCM data into the Adalo platform and build custom mobile and web applications with real-time Oracle SCM data.
-
Use Biml to Build SSIS Tasks to Replicate ClickUp Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ClickUp data to SQL Server.
-
Replicate Amazon S3 Data from PowerShell
Write a quick PowerShell script to query Amazon S3 data. Use connectivity to the live data to replicate Amazon S3 data to SQL Server.
-
Create Dynamic Recurly Grids Using the Infragistics XamDataGrid
Learn how you can connect Recurly to Infragistics XamDataGrid to build dynamic grids.
-
Integrating Kiro with Recurly 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.
-
Integrating GitHub Copilot with Box 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.
-
Connect to Sage 200 Data in Aqua Data Studio
Access Sage 200 data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use Databricks Agent Bricks to Talk to Your Azure Table Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Azure Table data for you.
-
Replicate Placid Data from PowerShell
Write a quick PowerShell script to query Placid data. Use connectivity to the live data to replicate Placid data to SQL Server.
-
Work with Access Data in FoxPro
Load Access data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software ODBC Driver for Gumroad in SAS for Real-Time Reporting and Analytics
Connect to real-time Gumroad data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Gumroad.
-
Automate DocuSign Data Replication to SAP HANA
Use CData Sync to customize and automate DocuSign data replication to SAP HANA.
-
Visualize Live XML Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live XML data into custom reports in Power BI.
-
Connect to Adobe Analytics Data in RazorSQL
Connect to Adobe Analytics from wizards and query Adobe Analytics data from the GUI in the RazorSQL database management tool.
-
Integrating LlamaIndex with Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Elasticsearch data in real time.
-
Work with CouchDB Data in FoxPro
Load CouchDB data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect the Power BI Service to Salesloft: Complete Guide
Connect to the CData Software Power BI Connector for Salesloft from PowerBI.com to provide real-time Salesloft data across the organization.
-
Create Data Visualizations in Cognos BI with Short.io Data
Access Short.io data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Productboard-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Productboard data and build web apps with connectivity to live Productboard data.
-
Create a Data Access Object for Authorize.Net Data using JDBI
A brief overview of creating a SQL Object API for Authorize.Net data in JDBI.
-
Getting Started with the CData Excel Add-In for Wrike
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Wrike.
-
Analyze Google Tasks Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Tasks from Power Pivot. You will use the Table Import Wizard to load Google Tasks data. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Google's Vertex AI Agent with Live Bullhorn CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Bullhorn CRM data within intelligent workflows.
-
Access Live Instantly Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Instantly data into the statistical analysis tools available in SAS JMP. This article shows how to use Instantly data in the Graph Builder and Query Builder.
-
DataBind Freshteam Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Freshteam data to a chart.
-
Operational Reporting on Azure Data Lake Storage Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Azure Data Lake Storage data.
-
Build Dynamics 365 Business Central-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Dynamics 365 Business Central data.
-
DataBind Controls to BambooHR Data in Delphi
DataBind to BambooHR data in Delphi with standard data access components and controls.
-
Automated Continuous Hacker News Replication to SQLite
Use CData Sync for automated, continuous, customizable Hacker News replication to SQLite.
-
Integrate Salesforce CRM Analytics Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Salesforce CRM Analytics data and integrate live Salesforce CRM Analytics data into your Power Automate tasks.
-
Connect SAP BusinessObjects BI to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP BusinessObjects BI data using the CData Python MCP Server.
-
Use Dash to Build to Web Apps on Instantly Data
Create Python applications that use pandas and Dash to build Instantly-connected web apps.
-
Access Live HDFS Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live HDFS data from your Google Sheets.
-
Connect to ShipStation Data from a Connection Pool in Jetty
The ShipStation JDBC Driver supports connection pooling: This article shows how to connect faster to ShipStation data from Web apps in Jetty.
-
DataBind Controls to Moosend Data in Delphi
DataBind to Moosend data in Delphi with standard data access components and controls.
-
Getting Started with the CData Tableau Connector for OpenWeatherMap
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Replicate Qualaroo Data to Multiple Databases via the CData Sync CLI
Replicate Qualaroo data to disparate databases with a single configuration.
-
Configure the CData JDBC Driver for Superchat in a Connection Pool in Tomcat
Connect to Superchat data from a connection pool in Tomcat.
-
Connect to Greenplum from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Greenplum data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to CSV Data in DBeaver
Use the CData ODBC Driver to connect to CSV data in DBeaver.
-
Create Reports with WordPress Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date WordPress data.
-
How to Work with Pushbullet Data in AWS Glue Jobs Using JDBC
Connect to Pushbullet from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Azure Blob Storage Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to delimited files (CSV/TSV).
-
Connect to Couchbase Data from PowerBuilder via ADO.NET
This article demonstrates how to access Couchbase data from Appeon PowerBuilder using the CData ADO.NET Provider for Couchbase.
-
Create SQL Analysis Services Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SQL Analysis Services data access from reports, embedded analytics, and more.
-
Publish Reports with Google Ads Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Ads data.
-
Migrating data from Certinia to Snowflake using CData SSIS Components.
Easily push Certinia data to Snowflake using the CData SSIS Tasks for Certinia and Snowflake.
-
How to connect to Pipeline CRM Data in DBVisualizer
Integrate Pipeline CRM data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Agents in Relevance AI with Access to Live Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Snowflake data within intelligent agent workflows.
-
Automated Continuous Webex Replication to SingleStore
Use CData Sync for automated, continuous, customizable Webex replication to SingleStore.
-
Connect to Shippo Data from PowerBuilder via ADO.NET
This article demonstrates how to access Shippo data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Create QuickBooks-Connected Nintex Workflows
Use CData Connect AI to connect to QuickBooks Data from Nintex Workflow Cloud and build custom workflows using live QuickBooks data.
-
How to import Sage 200 Data into Apache Solr
Use the CData Software JDBC Driver for Sage 200 in Data Import Handler and create an automated import of Sage 200 data to Apache Solr Enterprise Search platform.
-
Build HubSpot-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live HubSpot data.
-
Use Claude to Talk to Your Teradata Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Teradata data for you.