CData Software - Knowledge Base
Recent Articles
-
View Reports on Real-Time Zoom Data in Power BI Report Server
Use the CData ODBC Driver for Zoom to visualize Zoom data in Power BI Desktop and then publish them to Power BI Report Server.
-
Analyze SendInBlue Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SendInBlue from Power Pivot. You will use the Table Import Wizard to load SendInBlue data. You can visually build the import query or use any SQL supported by the driver.
-
Integrate ZarMoney with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ZarMoney with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ZarMoney data.
-
Automate Redis Data Replication to SAP HANA
Use CData Sync to customize and automate Redis data replication to SAP HANA.
-
Integrate Live Instagram Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Instagram data to Blue Prism using the CData ODBC Driver for Instagram to create automated workflows for repetitive business tasks.
-
Connect to Google Ads Data from a Connection Pool in Jetty
The Google Ads JDBC Driver supports connection pooling: This article shows how to connect faster to Google Ads data from Web apps in Jetty.
-
Analyze Pipedrive Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Pipedrive data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Apps with Live Pipedrive Data Using the Low-Code Development Platform of Mendix
Connect Pipedrive data with Mendix to build apps using the CData JDBC Driver for Pipedrive.
-
Connect to XML from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from XML data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Teradata Data in Ruby
Connect to Teradata data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrating OpenCode with Salesforce 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.
-
Use Dash to Build Web Apps on Office 365 Data via CData Connect AI
Build interactive Dash web apps on live Office 365 data using pandas and the CData Connect AI Python SDK.
-
Use the CData Software JDBC Driver for DB2 in MicroStrategy Web
Connect to DB2 data in MicroStrategy Web using the CData Software JDBC Driver for DB2.
-
Connect to and Visualize Live Bitbucket Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Bitbucket data.
-
Create Data Visualizations in Cognos BI with Hive Data
Access Hive data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Dashboards with Square Data in Dundas BI
Create dynamic dashboards and perform analytics based on Square data in Dundas BI.
-
Automated Continuous Pipedrive Replication to Databricks
Use CData Sync for automated, continuous, customizable Pipedrive replication to Databricks.
-
How to Work with FTP Data in ETL Validator JDBC
Connect to FTP from ETL Validator jobs using the CData Software JDBC Driver.
-
Visualize Live Paylocity Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Paylocity data into custom reports in Power BI.
-
Automated Continuous Teamgate Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Teamgate replication to Google BigQuery.
-
Build Voice Agents in ElevenLabs with access to Live Anaplan Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Anaplan data.
-
Automated Continuous Teamwork Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Teamwork replication to AlloyDB.
-
Automated Continuous Square Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Square replication to Amazon Redshift.
-
Use Claude to Talk to Your Avalara AvaTax 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 Avalara AvaTax data for you.
-
How to Connect Quickbase 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 Quickbase data in real time using natural language.
-
ETL HDFS in Oracle Data Integrator
This article shows how to transfer HDFS data into a data warehouse using Oracle Data Integrator.
-
Process & Analyze Wrike Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Wrike Data.
-
Integrate Goose with Live Egnyte Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Egnyte data from within the local AI agent.
-
How to connect to RabbitMQ Data with Squirrel SQL client
Connect to RabbitMQ data and execute queries in the Squirrel SQL Client.
-
Prepare, Blend, and Analyze FreshBooks Data in Alteryx Designer (Connect AI)
Build workflows to access live FreshBooks data for self-service data analytics.
-
Use Biml to Build SSIS Tasks to Replicate Azure Analysis Services Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Azure Analysis Services data to SQL Server.
-
Query MarkLogic Data in DataGrip
Create a Data Source for MarkLogic in DataGrip and use SQL to query live MarkLogic data.
-
Design BIRT Reports on Placid Data
Provide current Placid data to your embedded analytics.
-
ETL Google Directory in Oracle Data Integrator
This article shows how to transfer Google Directory data into a data warehouse using Oracle Data Integrator.
-
Connect GitHub to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live GitHub data using the CData Python MCP Server.
-
Build MailChimp-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live MailChimp data without replication.
-
Connect to ZohoSubscriptions Data in DBeaver
Use the CData ODBC Driver to connect to ZohoSubscriptions data in DBeaver.
-
How to Connect the Power BI Service to Excel Online: Complete Guide
Connect to the CData Software Power BI Connector for Excel Online from PowerBI.com to provide real-time Excel Online data across the organization.
-
Viewing QuickBooks Data in RAD Studio Data Explorer
How to view QuickBooks data in RAD Studio Data Explorer using the CData ODBC Driver for QuickBooks.
-
Integrate Live DB2 Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live DB2 data to Blue Prism using the CData ODBC Driver for DB2 to create automated workflows for repetitive business tasks.
-
Connect to PingOne from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from PingOne data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Data Flows from SQL Server to Outreach.io through SSIS
Easily push SQL Server data to Outreach.io using the CData SSIS Tasks for Outreach.io.
-
Automated Continuous Amazon Marketplace Replication to SQL Server
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to SQL Server.
-
Replicate Amazon S3 Data to Multiple Databases
Replicate Amazon S3 data to disparate databases with a point-and-click configuration.
-
Connect to JotForm from Asprova with CData Software ODBC Driver for JotForm
This article shows how to connect faster to JotForm data from Asprova.
-
Use Biml to Build SSIS Tasks to Replicate Superchat Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Superchat data to SQL Server.
-
Create Lakebase-Connected Business Apps in AppSheet
Connect to Lakebase Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Lakebase data.
-
Connect to Mailgun in SpagoBI
Create reports featuring live Mailgun data in SpagoBI Studio. Host Mailgun reports on SpagoBI Server.
-
Create Productboard Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Productboard from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect the Power BI Service to Box: Complete Guide
Connect to the CData Software Power BI Connector for Box from PowerBI.com to provide real-time Box data across the organization.
-
Use Agno to Talk to Your Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Reckon Accounts Hosted data for you.
-
Connect Snowflake to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Snowflake data using the CData Python MCP Server.
-
Query, Visualize, and Share live LinkedIn Ads Data in Redash
Use CData Connect AI to connect to live LinkedIn Ads data in Redash for querying, visualizing, and sharing.
-
Build Data Flows from Insightly to SQL Server using SSIS
Easily back up Insightly data to SQL Server using the SSIS components for Insightly.
-
How to Query CouchDB Data in MySQL Workbench
Execute MySQL queries against live CouchDB data from MySQL Workbench.
-
Build MVC Applications with Connectivity to ZohoInvoice Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ZohoInvoice from an ASP.NET MVC application.
-
Connect to Suadeo Data in ACL Analytics
Connect to Suadeo data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Suadeo data.
-
Build Wrike-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Wrike data and build web apps with connectivity to live Wrike data.
-
Create Informatica Mappings From/To an ODBC Data Source for Guru
Create an ODBC connection to Guru in Informatica and browse and transfer Guru data.
-
Connect to Strava Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Strava as an External Source in Dremio.
-
Integrating Gumloop with SAP BusinessObjects BI Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP BusinessObjects BI data within automated workflows.
-
Build Apps with Live Zoho Projects Data Using the Low-Code Development Platform of Mendix
Connect Zoho Projects data with Mendix to build apps using the CData JDBC Driver for Zoho Projects.
-
Connect to Toggl in SpagoBI
Create reports featuring live Toggl data in SpagoBI Studio. Host Toggl reports on SpagoBI Server.
-
How to connect to SAP Hybris C4C Data in DBVisualizer
Integrate SAP Hybris C4C data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Agents in Relevance AI with Access to Live Zoho Inventory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Zoho Inventory data within intelligent agent workflows.
-
Build Avalara AvaTax-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Avalara AvaTax data and build web apps with connectivity to live Avalara AvaTax data.
-
Integrating LangGraph with API Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on API data within automated workflows.
-
Connect and Visualize Live XML Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live XML data into the Databricks platform and create visualization dashboards with real-time XML data.
-
Establish a Live Connection with Teradata Data using Tableau Bridge
The CData ODBC Driver for Teradata enables you to integrate live Teradata data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating Dataiku with Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Outreach.io data.
-
Connecting Agentforce with Azure Data Lake Storage 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 Azure Data Lake Storage data for you.
-
Create SSAS Tabular Models from Auth0 Data
How to build a SQL Server Analysis Service Tabular Model from Auth0 data using CData drivers.
-
Use JayDeBeApi to access Salesloft Data in Python
Use standard Python scripting and the development environment of your choice to access live Salesloft data.
-
Build a Singer.io Tap for Square With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Square data using the CData Python Connector.
-
Interact with Live FreshBooks Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live FreshBooks data.
-
A PostgreSQL Interface for Neo4J Data (MySQL Remoting via JDBC)
Use the Remoting features of the Neo4J JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData ODBC Driver for Google Analytics in Microsoft Power Query
You can use the CData Google Analytics ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Analytics data into Microsoft Power Query.
-
Object-Relational Mapping (ORM) with Greenplum Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Greenplum data into a Java-based ORM framework, Hibernate.
-
Access Live Discourse Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Discourse data into the statistical analysis tools available in SAS JMP. This article shows how to use Discourse data in the Graph Builder and Query Builder.
-
Build a Singer.io Tap for Amplitude With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Amplitude data using the CData Python Connector.
-
Connect Zoho Books Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Zoho Books data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Access Live MessageBird Data in Power Automate Desktop via ODBC
The CData ODBC Driver for MessageBird enables you to integrate MessageBird data into workflows built using Microsoft Power Automate Desktop.
-
Access Parallel Data from MySQL in Amazon QuickSight
Connect to Parallel and build visualizations of Parallel data using a MySQL Connection in Amazon QuickSight.
-
Integrate Live Raisers Edge NXT Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Raisers Edge NXT from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Raisers Edge NXT data.
-
Getting Started with the CData ODBC Driver for LinkedIn Ads
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for LinkedIn Ads.
-
Query, Visualize, and Share live Salesforce Pardot Data in Redash
Use CData Connect AI to connect to live Salesforce Pardot data in Redash for querying, visualizing, and sharing.
-
Access Live Basecamp Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Basecamp data into the statistical analysis tools available in SAS JMP. This article shows how to use Basecamp data in the Graph Builder and Query Builder.
-
Process & Analyze Google Calendar Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Calendar Data.
-
How to Build an ETL App for Airtable Data in Python with CData
Create ETL applications and real-time data pipelines for Airtable data in Python with petl.
-
How to connect and process Amazon DynamoDB data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Amazon DynamoDB data.
-
Access Live GetResponse Data in Coginiti Pro
Connect to and query live GetResponse data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Process & Analyze SuiteCRM Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SuiteCRM Data.
-
Build a PostgreSQL Interface for Microsoft Teams Data using the CData JDBC Driver
Use the Remoting features of the Microsoft Teams JDBC Driver to create a PostgreSQL entry-point for data access.
-
A PostgreSQL Interface for SAP Ariba Source Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP Ariba Source JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Asana Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Asana data. Leverage the pyodbc module for ODBC in Python.
-
How to Connect DBeaver to Front via a JDBC Driver
Manage Front data with visual tools in DBeaver like the query browser.
-
Visualize Salesforce Data 360 Data in TIBCO Spotfire through OData
Integrate Salesforce Data 360 data into dashboards in TIBCO Spotfire.
-
How to connect to SAP SuccessFactors Data from IntelliJ
Integrate connectivity to SAP SuccessFactors data with wizards in IntelliJ.
-
Integrating LangGraph with Sage 200 Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Sage 200 data within automated workflows.
-
Build Xero-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Xero data and build web apps with connectivity to live Xero data.