CData Software - Knowledge Base
Recent Articles
-
A PostgreSQL Interface for Webex Data using the CData ODBC Driver
Use the SQL Gateway and Webex ODBC Driver to create a PostgreSQL entry-point for data access.
-
Choosing the Best Method to Connect Instagram to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Instagram from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Replicate Dynamics 365 Business Central Data to Multiple Databases
Replicate Dynamics 365 Business Central to disparate databases with a point-and-click configuration.
-
DataBind Controls to ZohoMarketingHub Data in C++Builder
DataBind to ZohoMarketingHub in C++Builder with standard components and controls.
-
Automated Continuous Aweber Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Aweber replication to Apache Cassandra.
-
How to import Brex Data into Apache Solr
Use the CData Software JDBC Driver for Brex in Data Import Handler and create an automated import of Brex to Apache Solr Enterprise Search platform.
-
Use Databricks Agent Bricks to Talk to Your SAP Ariba Source Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP Ariba Source for you.
-
Build an OLAP Cube in SSAS from Foursquare Data
Establish a connection to Foursquare data from SQL Server Analysis Services, and use the Foursquare Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Theia IDE with Live Klaviyo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Replicate Xero Data from PowerShell
Write a quick PowerShell script to query Xero Accounting. Use connectivity to the live data to replicate Xero Accounting to SQL Server.
-
Visualize ShipStation Data in TIBCO Spotfire through ADO.NET
Integrate ShipStation into dashboards in TIBCO Spotfire.
-
Connect to and Query ZeroBounce Data in QlikView over ODBC
Create data visualizations with ZeroBounce in QlikView.
-
Connect to Aircall Data in Aqua Data Studio
Access Aircall from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Copper Data in CloverDX (formerly CloverETL)
Transfer Copper using the visual workflow in the CloverDX data integration tool.
-
Use JayDeBeApi to access Sage Cloud Accounting Data in Python
Use standard Python scripting and the development environment of your choice to access live Sage Business Cloud Accounting.
-
Integrate Act CRM Data in the Pentaho Report Designer
Publish reports based on Act CRM in the Pentaho BI tool.
-
Automated Continuous Salesforce Pardot Replication to Snowflake
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Snowflake.
-
Connect Bullhorn CRM Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Bullhorn CRM using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Live IBM Informix Data in AWS Lambda (with IntelliJ IDEA)
Connect to live IBM Informix in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Getting Started with the CData ODBC Driver for Office 365
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Office 365.
-
Automated Continuous CapsuleCRM Replication to Oracle
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Oracle.
-
Integrate GitHub Data in the Pentaho Report Designer
Publish reports based on GitHub in the Pentaho BI tool.
-
How to Easily Query Close Data in OpenOffice Base
Connect to Close data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous Azure Data Lake Storage Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Apache Cassandra.
-
Integrating GitHub Copilot CLI with SAP Business Warehouse 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 Google Calendar Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Calendar from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use ChatGPT to Talk to Your Microsoft Exchange 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 Microsoft Exchange for you.
-
Deploy the ADO.NET Provider for SageHR on an SSRS Report Server
Connect to SageHR 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.
-
DataBind Controls to Sage 300 Data in C++Builder
DataBind to Sage 300 in C++Builder with standard components and controls.
-
How to integrate CapsuleCRM with Apache Airflow
Access and process CapsuleCRM in Apache Airflow using the CData JDBC Driver.
-
Connect to Demio Data in RapidMiner
Integrate Demio with standard components and data source configuration wizards in RapidMiner Studio.
-
Feed SharePoint Excel Services Data into FineReport
How to set SharePoint Excel Services as a JDBC data source in FineReport.
-
Connect to Presto Data in Ruby
Connect to Presto in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connecting Agentforce with Airtable Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Airtable for you.
-
Bind Live Kintone Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Kintone data
-
How to connect to Exa Data in DBVisualizer
Integrate Exa with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze Salesforce CRM Analytics Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Salesforce CRM Analytics and visualize live Salesforce CRM Analytics in Infragistics Reveal.
-
Access Live Spotify Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Spotify data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to integrate Metabase with Power BI XMLA Data
Use CData Connect AI to connect to live Power BI XMLA and create an interactive dashboard in Metabase from Power BI XMLA.
-
Write a Simple Go Application to work with Sage Cloud Accounting Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Sage Business Cloud Accounting.
-
Automated Continuous Redis Replication to Vertica
Use CData Sync for automated, continuous, customizable Redis replication to Vertica.
-
Use the CData SSIS Components to Insert New or Update Existing Salesloft Records from SQL Server
Easily push SQL Server data to Salesloft using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Salesloft or update existing records with data from a SQL Server database.
-
Build Visualizations of GitLab Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of GitLab in Birst.
-
Automated Continuous Printify Replication to SingleStore
Use CData Sync for automated, continuous, customizable Printify replication to SingleStore.
-
Creating Act-On-Connected Applications in Unqork
You can use CData Connect AI to feed Act-On to Unqork and build custom business apps.
-
Connect to Amazon S3 Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Amazon S3.
-
Use Dash to Build to Web Apps on Dynamics 365 Business Central Data
Create Python applications that use pandas and Dash to build Dynamics 365 Business Central-connected web apps.
-
Access Live ServiceNow Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ServiceNow into the statistical analysis tools available in SAS JMP. This article shows how to use ServiceNow in the Graph Builder and Query Builder.
-
How to connect to Pinecone Data from Spring Boot
Connect to Pinecone in a Spring Boot Application using the CData API Driver for JDBC
-
Create Power BI Reports on Real-Time MYOB AccountRight Data
Use the CData ODBC Driver for MYOB AccountRight to visualize MYOB AccountRight in Power BI Desktop.
-
Integrating Claude Code CLI with Testmonitor 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 Tally-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Tally Data from Zoho Analytics and import live Tally ERP.
-
Integrating Kiro CLI with Mocean 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.
-
Visualize Greenhouse Data in Tableau
The CData ODBC driver for Greenhouse enables you integrate Greenhouse into Tableau dashboards.
-
Publish Crystal Reports on XML Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date XML Files.
-
Feed Keap Data into FineReport
How to set Keap as a JDBC data source in FineReport.
-
Connect to SAP HANA XS Advanced Data from PowerBuilder via JDBC
This article demonstrates how to access SAP HANA XS Advanced from PowerBuilder using the SAP HANA XS Advanced JDBC Driver.
-
Bind Live Qualaroo Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Qualaroo data
-
Connect to SAS xpt Data in DBArtisan
Use wizards in DBArtisan to configure SAS XPORT as a data source.
-
Automated Continuous iContact Replication to Databricks
Use CData Sync for automated, continuous, customizable iContact replication to Databricks.
-
Build Zoho CRM-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Zoho CRM and build web apps with connectivity to live Zoho CRM.
-
Connect to HelloSign Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time HelloSign using standard SQL.
-
Easily Integrate Paymo Data in Lazarus Pascal IDE
Learn how to easily integrate live Paymo in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Apps from Marketo Data in Qlik Sense Cloud
Use CData Connect AI to connect to Marketo Data and build apps from live Marketo in Qlik Sense Cloud.
-
Visualize ServiceNow Data in Sisense
Create an ElastiCube in Sisense app with access to ServiceNow.
-
Build a Singer.io Tap for Aweber With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Aweber data using
-
Build Automated Amazon DynamoDB-Connected Workflows in Zapier
Use CData Connect AI to connect to live Amazon DynamoDB and build automated workflows in Zapier.
-
Replicate LinkedIn Data to Multiple Databases via the CData Sync CLI
Replicate LinkedIn to disparate databases with a single configuration.
-
Visualize ShipEngine Data in TIBCO Spotfire through ADO.NET
Integrate ShipEngine into dashboards in TIBCO Spotfire.
-
Natively Connect to OneNote Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft OneNote. Leverage the native support for ODBC in PHP.
-
Access Live Elasticsearch Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Elasticsearch from your Excel spreadsheets.
-
Migrating data from AgileCRM to Google BigQuery using CData SSIS Components.
Easily push AgileCRM to Google BigQuery using the CData SSIS Tasks for AgileCRM and Google BigQuery.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Drift
Provide connectivity to Drift through an SAP BusinessObjects universe.
-
Seamlessly Bring FHIR Data into Retool Using CData Connect AI
Integrate FHIR data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Access Live HubSpot Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live HubSpot from your Excel spreadsheets.
-
Explore Geographical Relationships in Quickbase Data with Power Map
Create data visualizations with Quickbase in Power Map.
-
Easily Integrate LinkedIn Ads Data in Lazarus Pascal IDE
Learn how to easily integrate live LinkedIn Ads in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData Software JDBC Driver for OpenWeatherMap in MicroStrategy Desktop
Connect to OpenWeatherMap in MicroStrategy Desktop using the CData Software JDBC Driver for OpenWeatherMap.
-
Consume Delighted OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Delighted feeds that reflect any changes in SAP Lumira.
-
Create Zoho Inventory-Connected Nintex Workflows
Use CData Connect AI to connect to Zoho Inventory Data from Nintex Workflow Cloud and build custom workflows using live Zoho Inventory.
-
Viewing Notion Data in RAD Studio Data Explorer
How to view Notion in RAD Studio Data Explorer using the CData ODBC Driver for Notion.
-
Create Datasets from Redis in Domo Workbench and Build Visualizations of Redis Data in Domo
Use the CData Software ODBC Driver for Redis to create datasets from Redis in Domo Workbench and then build visualizations in the Domo service.
-
How to Create Power BI Visual Reports with Real-Time PivotalTracker Data
Use CData Power BI Connectors to visualize PivotalTracker in Power BI.
-
How to Easily Query Bugsnag Data in OpenOffice Base
Connect to Bugsnag data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Connect the Power BI Service to Strava: Complete Guide
Connect to the CData Software Power BI Connector for Strava from PowerBI.com to provide real-time Strava across the organization.
-
Analyze JSON Services in Looker
Use CData Connect AI to connect to JSON Services from Looker and build custom apps using live JSON.
-
Create Datasets from Jodoo in Domo Workbench and Build Visualizations of Jodoo Data in Domo
Use the CData Software ODBC Driver for Jodoo to create datasets from Jodoo in Domo Workbench and then build visualizations in the Domo service.
-
Build Apollo-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Apollo Data from Zoho Analytics and import live Apollo.
-
Connect to LinkedIn Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live LinkedIn.
-
Edit and Search External Presto Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Presto to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Presto Data objects that you can access from apps and the dashboard.
-
Connect to Microsoft Ads Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Microsoft Ads Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build Voice Agents in ElevenLabs with access to Live Bullhorn CRM Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Bullhorn CRM.
-
Connect Clari Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Clari using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Excel Spreadsheet Automation on Facebook Data with the QUERY Formula
Pull data from Facebook, automate spreadsheets, and more with the QUERY formula.
-
Build Amazon Athena-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Amazon Athena Data from Zoho Analytics and import live Amazon Athena.
-
How to work with AdRoll Data in Apache Spark using SQL
Access and process AdRoll Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to & Open HubDB Data in Microsoft Excel
This article uses the CData ODBC driver for HubDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connecting Moonlit Workflow with Odoo Data 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 Odoo ERP in real time.
-
Query Everhour Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Everhour from Node.js.
-
Use the CData Software JDBC Driver for Databricks in MicroStrategy Web
Connect to Databricks in MicroStrategy Web using the CData Software JDBC Driver for Databricks.