CData Software - Knowledge Base
Recent Articles
-
How to integrate Perigon with Apache Airflow
Access and process Perigon in Apache Airflow using the CData JDBC Driver.
-
How to integrate Metabase with Zuora Data
Use CData Connect AI to connect to live Zuora and create an interactive dashboard in Metabase from Zuora.
-
Connect to Real-Time Jira Assets Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Jira Assets and Dataflow to import and use Jira Assets in Power Apps.
-
Choosing the Best Method to Connect Microsoft Ads to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft Ads from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Asana Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Asana replication to AlloyDB.
-
Build Semantic Layer Views for Zoom Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Zoom.
-
How to Connect to Live BambooHR Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your BambooHR for you.
-
Build Dashboards with Hive Data in DBxtra
Create dynamic dashboards and perform analytics based on Apache Hive in DBxtra.
-
How to connect PolyBase to Postmark
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Postmark.
-
Access Live Impala Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Apache Impala from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Marketo
Provide connectivity to Marketo through an SAP BusinessObjects universe.
-
Automated Continuous Active Directory Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Active Directory replication to Azure SQL Database.
-
Automate GitLab Data Replication to Azure Synapse
Use CData Sync to customize and automate GitLab replication to Azure Synapse.
-
Connect to Lakebase Data in Claris FileMaker Pro
Use the CData ODBC Driver for Lakebase in FileMaker Pro to connect to Lakebase and work with Lakebase in your FileMaker applications.
-
Getting Started with the CData ODBC Driver for ElevenLabs
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ElevenLabs.
-
Natively Connect to Guru Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Guru. Leverage the native support for ODBC in PHP.
-
Connect to SAP HANA Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAP HANA in FileMaker Pro to connect to SAP HANA and work with SAP HANA in your FileMaker applications.
-
Integrating Claude Code CLI with Azure DevOps 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 Charts with Harvest Data in Clear Analytics
Create dynamic charts and perform analytics based on Harvest in Clear Analytics.
-
Enable the Autopilot JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Autopilot.
-
Prepare, Blend, and Analyze Elasticsearch Data in Alteryx Designer (ODBC)
Build workflows to access live Elasticsearch for self-service data analytics.
-
Getting Started with the CData ADO.NET Provider for Google Cloud Storage
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Google Cloud Storage.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Avalara AvaTax
Provide connectivity to Avalara AvaTax through an SAP BusinessObjects universe.
-
Connect to Salesforce CRM Analytics from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Salesforce CRM Analytics, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Analyze Adobe Commerce Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Adobe Commerce and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Feed Reply.io Data into FineReport
How to set Reply.io as a JDBC data source in FineReport.
-
Automated Continuous ChargeOver Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ChargeOver replication to Amazon Redshift.
-
How to integrate Metabase with GitHub Data
Use CData Connect AI to connect to live GitHub and create an interactive dashboard in Metabase from GitHub.
-
Getting Started with the CData ODBC Driver for Zoho Books
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Zoho Books.
-
Integrate Theia IDE with Live SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to Salesforce Pardot Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to connect to SparkPost Data in DBVisualizer
Integrate SparkPost with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Semantic Layer Views for IBM Cloud Object Storage Data in APOS Live Data Gateway
Use the CData Connector for IBM Cloud Object Storage in APOS Live Data Gateway to build Semantic Layer Views for IBM Cloud Object Storage.
-
Connect to Typeform Data in Ruby
Connect to Typeform in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect Box 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 Box data in real time using natural language.
-
How to Connect to & Open SurveyMonkey Data in Microsoft Excel
This article uses the CData ODBC driver for SurveyMonkey to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Natively Connect to Salesforce CRM Analytics Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Salesforce CRM Analytics. Leverage the native support for ODBC in PHP.
-
Integrating Boomi Agentstudio with Zoho Inventory Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Zoho Inventory, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Publish Reports with Asana Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Asana.
-
Explore Geographical Relationships in SAP Business Warehouse Data with Power Map
Create data visualizations with SAP Business Warehouse in Power Map.
-
Integrate Live WooCommerce Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live WooCommerce to Blue Prism using the CData ODBC Driver for WooCommerce to create automated workflows for repetitive business tasks.
-
Use Claude to Talk to Your Google Ads 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 Google Ads for you.
-
Import Real-Time Wrike Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Wrike in ColdFusion.
-
Getting Started with the CData Tableau Connector for EmailOctopus
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Deploy the ADO.NET Provider for Reckon on an SSRS Report Server
Connect to Reckon 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.
-
Connect to Opsgenie Data in NetBeans
Connect to Opsgenie in NetBeans with the data source configuration wizard.
-
Automated Continuous Ontraport Replication to MongoDB
Use CData Sync for automated, continuous, customizable Ontraport replication to MongoDB.
-
How to import Demio Data into Apache Solr
Use the CData Software JDBC Driver for Demio in Data Import Handler and create an automated import of Demio to Apache Solr Enterprise Search platform.
-
How to Query Clockify Data in MySQL Workbench
Execute MySQL queries against live Clockify from MySQL Workbench.
-
Publish Cloudant-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live IBM Cloudant.
-
Integrating Claude Code with LinkedIn Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on LinkedIn within assisted coding and automated development workflows.
-
Snowflake Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Snowflake facts in real time.
-
Prepare, Blend, and Analyze PostgreSQL Data in Alteryx Designer (ODBC)
Build workflows to access live PostgreSQL for self-service data analytics.
-
How to Connect Microsoft Teams 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 Microsoft Teams data in real time using natural language.
-
How to connect PolyBase to Optimizely
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Optimizely.
-
Automated Continuous Billsby Replication to SingleStore
Use CData Sync for automated, continuous, customizable Billsby replication to SingleStore.
-
Build Data Flows from SQL Server to Zoho Creator through SSIS
Easily push SQL Server data to Zoho Creator using the CData SSIS Tasks for Zoho Creator.
-
Build SharePoint-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft SharePoint.
-
How to update Bullhorn CRM from Excel
This article explains how to transfer data from Excel to Bullhorn CRM using the Excel Add-In for Bullhorn CRM.
-
Build AI Agents with Smartsheet 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 Smartsheet through CData Connect AI.
-
Build an OLAP Cube in SSAS from iContact Data
Establish a connection to iContact data from SQL Server Analysis Services, and use the iContact Data Provider to build OLAP cubes for use in analytics and reporting.
-
Object-Relational Mapping (ORM) with Sendwithus 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 Sendwithus into a Java-based ORM framework, Hibernate.
-
Query Databricks Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Databricks entities in PHP by modeling them as objects.
-
Import Real-Time SingleStore Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SingleStore in ColdFusion.
-
Object-Relational Mapping (ORM) with Act CRM 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 Act CRM into a Java-based ORM framework, Hibernate.
-
Integrate Theia IDE with Live Paylocity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to SendInBlue Data from a Connection Pool in Jetty
The SendInBlue JDBC Driver supports connection pooling: This article shows how to connect faster to SendInBlue from Web apps in Jetty.
-
How to Access Adobe Commerce Data Using Entity Framework
This article shows how to access Adobe Commerce using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Klaviyo Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Klaviyo.
-
Connect to SparkPost Data from PowerBuilder via ADO.NET
This article demonstrates how to access SparkPost from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Migrating data from Freshsales to Snowflake using CData SSIS Components.
Easily push Freshsales to Snowflake using the CData SSIS Tasks for Freshsales and Snowflake.
-
How to connect to Dynamics CRM Data in DBVisualizer
Integrate Microsoft Dynamics CRM with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect SharePoint with Shopify Data through external lists
Provide Shopify to SharePoint users as an external list.
-
Connect to Power BI XMLA Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Visualize Oracle SCM 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 Oracle SCM in Python.
-
How to Connect to Live Microsoft Entra ID Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Microsoft Entra ID without replication.
-
Integrate with Live Neo4J Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Neo4J from the MuleSoft Anypoint Platform to integrate live Neo4J into custom reports and dashboards.
-
Natively Connect to Strava Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Strava. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData Power BI Connector for Tally
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Tally.
-
Integrate Toggl Data in Pentaho Data Integration
Build ETL pipelines based on Toggl in the Pentaho Data Integration tool.
-
Getting Started with the CData Excel Add-In for Cloudant
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Cloudant.
-
Use the CData Software JDBC Driver for Adobe Commerce in MicroStrategy
Connect to Adobe Commerce in MicroStrategy Developer using the CData Software JDBC Driver for Adobe Commerce.
-
Provide OData Services of Todoist Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Todoist by developing a WCF Service Application.
-
Getting Started with the CData ADO.NET Provider for Excel Online
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Excel Online.
-
How to Seamlessly Import Vault CRM Data into IBM SPSS Modeler
Integrate Vault CRM data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use Dash to Build Web Apps on SingleStore Data via CData Connect AI
Build interactive Dash web apps on live SingleStore using pandas and the CData Connect AI Python SDK.
-
DataBind Controls to Confluence Data in Delphi
DataBind to Atlassian Confluence in Delphi with standard data access components and controls.
-
Getting Started with the CData Connect AI Python SDK for Salesforce Pardot
Install the CData Connect AI Python SDK to read and write live Salesforce Pardot with standard DB-API 2.0 Python code.
-
Consume Workday OData Feeds in PowerBuilder
This article demonstrates how to consume Workday as OData feeds from PowerBuilder using the API Server.
-
Replicate Pinterest Data to Multiple Databases via the CData Sync CLI
Replicate Pinterest to disparate databases with a single configuration.
-
Migrating data from Wrike to Snowflake using CData SSIS Components.
Easily push Wrike to Snowflake using the CData SSIS Tasks for Wrike and Snowflake.
-
Use the CData ODBC Driver for Zoho Recruit from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Zoho Recruit to connect to Zoho Recruit from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Zoho Recruit in Excel.
-
Replicate Multiple Intercom Accounts
Replicate multiple Intercom accounts to one or many databases.
-
Connect to Aircall Data in DBeaver
Use the CData ODBC Driver to connect to Aircall in DBeaver.
-
Build HubDB-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for HubDB to explore live HubDB Data in Gemini Code Assist to assist with building HubDB-powered applications.
-
Google Drive Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Drive through CData Connect AI using different applications and tools.
-
Automated Continuous Harvest Replication to MongoDB
Use CData Sync for automated, continuous, customizable Harvest replication to MongoDB.
-
How to work with Humanity Data in Apache Spark using SQL
Access and process Humanity Data in Apache Spark using the CData Software JDBC Driver.
-
Build Pipelines with Live MariaDB Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to MariaDB from Google Cloud Data Fusion, enabling the integration of live MariaDB into the building and management of effective data pipelines.
-
Getting Started with the CData Excel Add-In for Rootly
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Rootly.