CData Software - Knowledge Base
Recent Articles
-
Operational Reporting on Greenhouse Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Greenhouse data.
-
Use Grok to Talk to Your AgileCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your AgileCRM data for you.
-
Build AI Agents with SendPulse Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live SendPulse data through CData Connect AI.
-
How to create MongoDB federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for MongoDB data in MySQL .
-
Create Dynamic Exact Online Grids Using the Infragistics XamDataGrid
Learn how you can connect Exact Online to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Pipeline CRM Data from PowerBuilder via ADO.NET
This article demonstrates how to access Pipeline CRM data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
EnterpriseDB Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to EnterpriseDB data through CData Connect AI using different applications and tools.
-
Publish Crystal Reports on Xero Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Xero data.
-
Create ZohoMarketingHub-Connected Nintex Workflows
Use CData Connect AI to connect to ZohoMarketingHub Data from Nintex Workflow Cloud and build custom workflows using live ZohoMarketingHub data.
-
Automated Continuous Pinterest Replication to Vertica
Use CData Sync for automated, continuous, customizable Pinterest replication to Vertica.
-
How to create Visio diagrams from Bitbucket Data
Automatically update Bitbucket data with the changes you make to Visio master shapes.
-
How to create SharePoint Excel Services federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SharePoint Excel Services data in MySQL .
-
Connect to Paymo from Asprova with CData Software ODBC Driver for Paymo
This article shows how to connect faster to Paymo data from Asprova.
-
Use the CData ODBC Driver for CircleCI in Microsoft Power Query
You can use the CData CircleCI ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import CircleCI data into Microsoft Power Query.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Tavily
Provide connectivity to Tavily data through an SAP BusinessObjects universe.
-
How to Work with Klaviyo Data in ETL Validator JDBC
Connect to Klaviyo from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating Kiro with Stack Exchange 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.
-
Create Dynamic Facebook Grids Using the Infragistics XamDataGrid
Learn how you can connect Facebook to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Google Ads Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Ads and the SQL Gateway to access Google Ads data from Google Apps Script.
-
How to load Parquet data into Elasticsearch via Logstash
Introducing a simple method to load Parquet data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect Sage Cloud Accounting Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Sage Cloud Accounting data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to SAP SuccessFactors LMS Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP SuccessFactors LMS data from Crystal Reports.
-
SurveyMonkey Reporting in OBIEE with the SurveyMonkey JDBC Driver
Deploy the SurveyMonkey JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build a PostgreSQL Interface for CircleCI Data using the CData JDBC Driver
Use the Remoting features of the CircleCI JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Zoho Books Data Replication to SAP HANA
Use CData Sync to customize and automate Zoho Books data replication to SAP HANA.
-
Connect to PDFMonkey Data in Aqua Data Studio
Access PDFMonkey data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Trae with Live SAP SuccessFactors Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live SAP SuccessFactors data from within the AI-powered IDE.
-
How to connect and process BigCommerce data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live BigCommerce data.
-
Build Instagram-Connected Apps in Choreo
Use CData Connect AI to connect to Instagram Data from Choreo and build custom apps using live Instagram data.
-
Extract, Transform, and Load DB2 Data in Informatica PowerCenter
Create a simple Workflow for DB2 data in Informatica PowerCenter.
-
Use Databricks Agent Bricks to Talk to Your API Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your API data for you.
-
Access Azure Analysis Services Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Azure Analysis Services data from your Oracle system.
-
Use JayDeBeApi to access Oracle Service Cloud Data in Python
Use standard Python scripting and the development environment of your choice to access live Oracle Service Cloud data.
-
Visualize Live Onfleet Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Onfleet data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Data Flows from iContact to SQL Server using SSIS
Easily back up iContact data to SQL Server using the SSIS components for iContact.
-
Automated Continuous Google Spanner Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Spanner replication to Vertica.
-
How to create an RPA flow for ZohoPeople Data in UiPath Studio
Use the ZohoPeople ODBC Driver to create workflows that access real-time ZohoPeople data without any coding.
-
Manage Salesforce Marketing Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Salesforce Marketing.
-
How to connect PolyBase to FHIR
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live FHIR data.
-
Replicate Multiple Yelp Accounts via the CData Sync CLI
Replicate multiple Yelp accounts to one or many databases.
-
Build Pipelines with Live Microsoft Exchange Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Microsoft Exchange from Google Cloud Data Fusion, enabling the integration of live Microsoft Exchange data into the building and management of effective data pipelines.
-
Validate HCL Domino Data with QuerySurge
Access and validate HCL Domino data in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Guru Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Guru replication to Apache Cassandra.
-
Create Cassandra-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Cassandra Data from Klipfolio and build custom visualizations using live Cassandra data.
-
How to Access SAP SuccessFactors Data Using Entity Framework
This article shows how to access SAP SuccessFactors data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate Open WebUI with Live Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Azure Synapse data from within the chat interface.
-
Choosing the Best Method to Connect Bannerbear to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Bannerbear data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
DataBind Sage Cloud Accounting Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Sage Cloud Accounting with the DevExpress Windows Forms and Web controls to provide Sage Cloud Accounting data to a chart.
-
How to connect to SAP Concur Data in DBVisualizer
Integrate SAP Concur data with visual data analysis tools and data connection wizards in DBVisualizer
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Sage 200
Provide connectivity to Sage 200 data through an SAP BusinessObjects universe.
-
Build MVC Applications with Connectivity to Float Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Float from an ASP.NET MVC application.
-
Automated Continuous Grafana Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Grafana replication to Amazon S3.
-
Build Klaviyo-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Klaviyo data.
-
Integrate Theia IDE with Live QuickBooks Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live QuickBooks Online data from within the development environment.
-
Use Biml to Build SSIS Tasks to Replicate ServiceNow Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ServiceNow data to SQL Server.
-
Build Visualizations of Phoenix Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Phoenix data in Birst.
-
DataBind Amplitude Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Amplitude data to a chart.
-
Create Box-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Box Data from Klipfolio and build custom visualizations using live Box data.
-
Optimizely Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Optimizely data through CData Connect AI using different applications and tools.
-
Analyze Dynamics CRM Data in Looker
Use CData Connect AI to connect to Dynamics CRM Data from Looker and build custom apps using live Dynamics CRM data.
-
Build a Simple VCL Application for Onfleet Data
How to build a simple VCL Application to view Onfleet data in RAD Studio using the CData ODBC Driver for Onfleet.
-
Connect to Codat in SpagoBI
Create reports featuring live Codat data in SpagoBI Studio. Host Codat reports on SpagoBI Server.
-
Use Dash to Build Web Apps on Jumpseller Data via CData Connect AI
Build interactive Dash web apps on live Jumpseller data using pandas and the CData Connect AI Python SDK.
-
Integrating Antigravity CLI with Zoho Creator data via CData CLI
Connect Zoho Creator data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to connect PolyBase to Quickbase
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Quickbase data.
-
DataBind Charts to PagerDuty Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to PagerDuty 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 Visualize Azure Data Catalog Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Azure Data Catalog data in Python.
-
Create Reports with Harvest Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Harvest data.
-
Automated Continuous Outlook Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Outlook replication to Google BigQuery.
-
Use the CData Software JDBC Driver for Excel in MicroStrategy Web
Connect to Excel data in MicroStrategy Web using the CData Software JDBC Driver for Excel.
-
How to work with GitHub Data in Apache Spark using SQL
Access and process GitHub Data in Apache Spark using the CData Software JDBC Driver.
-
Query Excel Online Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Excel Online entities in PHP by modeling them as objects.
-
Automated Continuous Impala Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Impala replication to Google Cloud SQL.
-
Extract, Transform, and Load Dynamics 365 Business Central Data in Informatica PowerCenter
Create a simple Workflow for Dynamics 365 Business Central data in Informatica PowerCenter.
-
Integrate MYOB AccountRight Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MYOB AccountRight data from Informatica Cloud.
-
Build AI/ML Models with Live Mistral AI Data using Dataiku
Connect Mistral AI Data with Dataiku using the CData API Driver for JDBC.
-
Integrate Google's Vertex AI Agent with Live Act 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 Act CRM data within intelligent workflows.
-
How to create an RPA flow for MySQL Data in UiPath Studio
Use the MySQL ODBC Driver to create workflows that access real-time MySQL data without any coding.
-
Process & Analyze Elorus Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Elorus Data.
-
Migrating data from Act-On to Databricks using CData SSIS Components.
Easily push Act-On data to Databricks using the CData SSIS Tasks for Act-On and Databricks.
-
Natively Connect to Bugsnag Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Bugsnag data. Leverage the native support for ODBC in PHP.
-
Replicate Foursquare Data from PowerShell
Write a quick PowerShell script to query Foursquare data. Use connectivity to the live data to replicate Foursquare data to SQL Server.
-
Import Real-Time Calendly Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Calendly data in ColdFusion.
-
Load CloudConvert Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load CloudConvert data to a database.
-
Integrating Kiro with FreshBooks 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 work with Azure Analysis Services Data in Apache Spark using SQL
Access and process Azure Analysis Services Data in Apache Spark using the CData Software JDBC Driver.
-
Publish Crystal Reports on Procore Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Procore data.
-
Configure the CData JDBC Driver for Perplexity in a Connection Pool in Tomcat
Connect to Perplexity data from a connection pool in Tomcat.
-
Work with Confluence Data in FoxPro
Load Confluence data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Avalara AvaTax Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Avalara AvaTax data.
-
Replicate Mocean Data in Heroku for Use in Salesforce Connect
Replicate Mocean data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Choosing the Best Method to Connect SAP Business One to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP Business One data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to connect to Intercom Data from IntelliJ
Integrate connectivity to Intercom data with wizards in IntelliJ.
-
ETL Paddle in Oracle Data Integrator
This article shows how to transfer Paddle data into a data warehouse using Oracle Data Integrator.
-
Load ZohoPeople Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ZohoPeople data to a database.
-
Connect to Dynamics NAV Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Dynamics NAV and the SQL Gateway to access Dynamics NAV data from Google Apps Script.
-
Build Visualizations of Microsoft Planner Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft Planner data in Birst.
-
Analyze Live Zoho CRM Data in SAS Viya
Use CData Connect AI to connect to Zoho CRM data from SAS Viya and deploy self-service analytics using live Zoho CRM data.
-
View Reports on Real-Time Coinbase Data in Power BI Report Server
Use the CData ODBC Driver for Coinbase to visualize Coinbase data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Adobe Commerce Data in NetBeans
Connect to Adobe Commerce data in NetBeans with the data source configuration wizard.