CData Software - Knowledge Base
Recent Articles
-
Integrate Live Airtable Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Airtable and integrate live Airtable into apps built in Microsoft Power Apps.
-
Getting Started with the CData ODBC Driver for Recurly
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Recurly.
-
Use the CData Software ODBC Driver for HubSpot in MicroStrategy
Connect to HubSpot in MicroStrategy Developer using the CData Software ODBC Driver for HubSpot.
-
Connect to Customer.io Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Customer.io and work with Customer.io in your FileMaker applications.
-
Automate SAP HANA XS Advanced Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP HANA XS Advanced replication to Azure Data Lake.
-
Create Codat Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Codat from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Airtable Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Airtable.
-
Provide OData Services of Zoho Projects Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Zoho Projects by developing a WCF Service Application.
-
How to connect SharePoint with Facebook Data through external lists
Provide Facebook to SharePoint users as an external list.
-
Automated Continuous Pinterest Replication to SQLite
Use CData Sync for automated, continuous, customizable Pinterest replication to SQLite.
-
Getting Started with the CData SSIS Components for Google Directory
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Directory.
-
Connect to Wave Financial from a Connection Pool in WebLogic
Use the CData JDBC Driver for Wave Financial to connect to Wave Financial from Web applications running on WebLogic.
-
How to Connect the Power BI Service to Autopilot: Complete Guide
Connect to the CData Software Power BI Connector for Autopilot from PowerBI.com to provide real-time Autopilot across the organization.
-
Connect to SurveyMonkey Data from a Connection Pool in JBoss
Integrate SurveyMonkey into Java servlets: Use the Management Console in JBoss to install the SurveyMonkey JDBC Driver.
-
Connect to NetSuite Data from a Connection Pool in Jetty
The NetSuite JDBC Driver supports connection pooling: This article shows how to connect faster to NetSuite CRM & ERP from Web apps in Jetty.
-
Use the CData Software ODBC Driver for Azure Table in MicroStrategy
Connect to Azure Table Storage in MicroStrategy Developer using the CData Software ODBC Driver for Azure Table.
-
Build MVC Applications with Connectivity to Workday Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Workday from an ASP.NET MVC application.
-
Connect Adobe Target to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Adobe Target using the CData Python MCP Server.
-
Build AI/ML Models with Live Microsoft OneDrive Data using Dataiku
Connect Microsoft OneDrive Data with Dataiku using the CData JDBC Driver for Microsoft OneDrive.
-
LINQ to MongoDB 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 MongoDB Data Provider.
-
Import Real-Time Blackbaud FE NXT Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Blackbaud FE NXT in ColdFusion.
-
Natively Connect to Aweber Data in PHP
The CData ODBC driver for Aweber enables you to create PHP applications with connectivity to Aweber. Leverage the native support for ODBC in PHP.
-
Automated Continuous Gorgias Replication to Oracle
Use CData Sync for automated, continuous, customizable Gorgias replication to Oracle.
-
Import Xero Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Xero Data and provide access to live Xero Accounting for custom reports in the Power BI Service.
-
Build Data Flows from SQL Server to Excel Online through SSIS
Easily push SQL Server data to Excel Online using the CData SSIS Tasks for Excel Online.
-
Automated Continuous ShipEngine Replication to Oracle
Use CData Sync for automated, continuous, customizable ShipEngine replication to Oracle.
-
Connect to SAP SuccessFactors LMS Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP SuccessFactors LMS to connect to SAP SuccessFactors LMS and execute queries in PowerBuilder.
-
DataBind Charts to ClickTime Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ClickTime 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.
-
Use Dash to Build to Web Apps on SAP SuccessFactors Data
Create Python applications that use pandas and Dash to build SAP SuccessFactors-connected web apps.
-
Connect to ScrapingBee from Asprova with CData Software ODBC Driver for ScrapingBee
This article shows how to connect faster to ScrapingBee data from Asprova.
-
Migrating data from SAP Netweaver Gateway to Google BigQuery using CData SSIS Components.
Easily push SAP Netweaver Gateway to Google BigQuery using the CData SSIS Tasks for SAP Netweaver Gateway and Google BigQuery.
-
Import Real-Time Google Forms Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Forms in ColdFusion.
-
LINQ to WooCommerce 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 WooCommerce Data Provider.
-
How to Connect to Live IBM Informix Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your IBM Informix through natural language.
-
Access Live Bullhorn CRM Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Bullhorn CRM through MCP integration.
-
Integrate Oracle SCM Data in Pentaho Data Integration
Build ETL pipelines based on Oracle SCM in the Pentaho Data Integration tool.
-
Connect to Attio Data in HULFT Integrate
Connect to Attio as a JDBC data source in HULFT Integrate
-
Getting Started with the CData ODBC Driver for Apollo
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Apollo.
-
Create Power BI Reports on Real-Time CockroachDB Data
Use the CData ODBC Driver for CockroachDB to visualize CockroachDB in Power BI Desktop.
-
Migrating data from Greenplum to Google BigQuery using CData SSIS Components.
Easily push Pivotal GreenPlum to Google BigQuery using the CData SSIS Tasks for Greenplum and Google BigQuery.
-
How to connect to Tally Data from Spring Boot
Connect to Tally in a Spring Boot Application using the CData JDBC Driver for Tally
-
Establish a Live Connection with Twilio Data using Tableau Bridge
The CData ODBC Driver for Twilio enables you to integrate live Twilio into Tableau Cloud dashboards using the Tableau Bridge.
-
Publish Crystal Reports on Phoenix Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Apache Phoenix.
-
Connect Zoho CRM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Zoho CRM using the CData Python MCP Server.
-
How to Work with SAP ByDesign Data in ETL Validator JDBC
Connect to SAP ByDesign from ETL Validator jobs using the CData Software JDBC Driver.
-
Import Real-Time Autopilot Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Autopilot in ColdFusion.
-
Connecting GenSpark with Redshift Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Amazon Redshift without any replication or custom integration required.
-
Explore Geographical Relationships in CapsuleCRM Data with Power Map
Create data visualizations with CapsuleCRM in Power Map.
-
Visualize Parquet Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Apache Parquet.
-
Integrating Boomi Agentstudio with Oracle HCM Cloud Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Oracle HCM Cloud, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to connect to Sybase Data in DBVisualizer
Integrate Sybase with visual data analysis tools and data connection wizards in DBVisualizer
-
Access ZohoMarketingHub Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for ZohoMarketingHub.
-
How to update Square from Excel
This article explains how to transfer data from Excel to Square using the Excel Add-In for Square.
-
Analyze Azure Data Catalog Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Azure Data Catalog and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate with CockroachDB Data in JReport Designer
Create charts and reports based on CockroachDB in JReport Designer.
-
Access Live Zuora Data in Excel 365 Online (Excel for the web)
Connect to Zuora from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Pipelines with Live Oracle Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Oracle from Google Cloud Data Fusion, enabling the integration of live Oracle Database into the building and management of effective data pipelines.
-
How to Connect to Live Bullhorn CRM Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Bullhorn CRM for you.
-
Build Charts with Hive Data in Clear Analytics
Create dynamic charts and perform analytics based on Apache Hive in Clear Analytics.
-
How to connect to Spark Data with Squirrel SQL client
Connect to Apache Spark SQL and execute queries in the Squirrel SQL Client.
-
How to Query Live ClickTime Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ClickTime data in natural language using Python.
-
How to Connect to Live Google Drive 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 Google Drive for you.
-
Prepare, Blend, and Analyze Gorgias Data in Alteryx Designer (ODBC)
Build workflows to access live Gorgias for self-service data analytics.
-
Establish a Live Connection with Google Tasks Data using Tableau Bridge
The CData ODBC Driver for Google Tasks enables you to integrate live Google Tasks into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Live Templated Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Templated to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Connect MarkLogic Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live MarkLogic data in real time using natural language.
-
How to Connect to Live Jira Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Atlassian Jira through natural language.
-
Analyze GitHub Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of GitHub and visualize live GitHub in Infragistics Reveal.
-
How to connect PolyBase to Facebook Ads
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Facebook Ads.
-
Build Azure Table-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Azure Table Storage and build Azure Table-connected web apps with Axios.
-
Automate Azure Table Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Azure Table Storage and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Automate Microsoft Ads Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft Ads from PowerShell? This article demonstrates how to utilize the Microsoft Ads Cmdlets for tasks like connecting to Microsoft Ads, automating operations, downloading data, and more.
-
Integrating Antigravity CLI with Google Tasks via CData CLI
Connect Google Tasks to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating Claude Code CLI with ShipStation 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.
-
Getting Started with the CData Tableau Connector for Sage 200
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Sage 200.
-
Integrate Cline with Live Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Azure Synapse from within your IDE.
-
Replicate Microsoft Exchange Data in Heroku for Use in Salesforce Connect
Replicate Microsoft Exchange to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Publish Sentry-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Sentry.
-
How to Access Live Salesloft Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Salesloft enables you to integrate Salesloft into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData Python Connector for Demio
Learn to install and license the CData Python Connector
-
Integrate Reply.io Data in the Pentaho Report Designer
Publish reports based on Reply.io in the Pentaho BI tool.
-
Visualize Airtable Data in TIBCO Spotfire through ADO.NET
Integrate Airtable into dashboards in TIBCO Spotfire.
-
Create Informatica Mappings From/To an ODBC Data Source for Coinbase
Create an ODBC connection to Coinbase in Informatica and browse and transfer Coinbase.
-
Automated Continuous SAP ByDesign Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Snowflake.
-
Connect PagerDuty Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your PagerDuty using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Sybase Data in NetBeans
Connect to Sybase in NetBeans with the data source configuration wizard.
-
Create a Data Access Object for EmailOctopus Data using JDBI
A brief overview of creating a SQL Object API for EmailOctopus in JDBI.
-
Validate JotForm Data with QuerySurge
Access and validate JotForm in QuerySurge using the CData JDBC Driver.
-
Access Live Zoho Creator Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Zoho Creator data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Create Dynamic SAP ByDesign Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP ByDesign to Infragistics XamDataGrid to build dynamic grids.
-
Easily Integrate Miro Data in Lazarus Pascal IDE
Learn how to easily integrate live Miro in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData Excel Add-In for Adobe Analytics
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Adobe Analytics.
-
Access PhantomBuster Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access PhantomBuster from your Oracle system.
-
Build Agents in Relevance AI with Access to Live SQL Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SQL Analysis Services within intelligent agent workflows.
-
DataBind PolarTeamPro Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide PolarTeamPro to a chart.
-
Connect to Brex Data in CloverDX (formerly CloverETL)
Transfer Brex using the visual workflow in the CloverDX data integration tool.
-
Explore Geographical Relationships in Google Ad Manager Data with Power Map
Create data visualizations with Google Ad Manager in Power Map.
-
How to connect and process Tally ERP from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Tally ERP.
-
Create Dashboards and Visualize Live Snowflake Data in Geckoboard
Use CData Connect AI to connect to live Snowflake and create dashboards for real-time monitoring and visualization in Geckoboard.
-
A PostgreSQL Interface for Cassandra Data using the CData ODBC Driver
Use the SQL Gateway and Cassandra ODBC Driver to create a PostgreSQL entry-point for data access.