CData Software - Knowledge Base
Recent Articles
-
Create Reports with Greenplum Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Greenplum data.
-
Use the CData Software ODBC Driver for Codat in MicroStrategy Web
Connect to Codat data in MicroStrategy Web using the CData Software ODBC Driver for Codat.
-
Connect to Odoo Data in Ruby
Connect to Odoo data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Cursor with Live Campaigner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Campaigner data from within the editor.
-
Rapidly Develop Anaplan-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Anaplan.
-
Object-Relational Mapping (ORM) with Yelp 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 Yelp data into a Java-based ORM framework, Hibernate.
-
Configure the CData JDBC Driver for Salesforce Data 360 in a Connection Pool in Tomcat
Connect to Salesforce Data 360 data from a connection pool in Tomcat.
-
How to create Visio diagrams from LDAP Objects
Automatically update LDAP objects with the changes you make to Visio master shapes.
-
Integrate Beeminder with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Beeminder with External Services.
-
Integrating Claude Code CLI with HelloSign 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 the CData Software JDBC Driver for Instantly in MicroStrategy Web
Connect to Instantly data in MicroStrategy Web using the CData Software JDBC Driver for Instantly.
-
Use Dash to Build to Web Apps on Google Ads Data
Create Python applications that use pandas and Dash to build Google Ads-connected web apps.
-
How to Connect to Live Salesforce Pardot 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 Salesforce Pardot data for you.
-
Integrating Claude Code with LDAP Objects via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on LDAP objects within assisted coding and automated development workflows.
-
Automated Continuous ZohoExpense Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ZohoExpense replication to IBM DB2.
-
Use Grok to Talk to Your SAP Business One 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 SAP Business One data for you.
-
Access Live Elasticsearch Data in Coginiti Pro
Connect to and query live Elasticsearch data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Use a Microsoft Access Database to Update MongoDB Data in Real Time
Update MongoDB data by creating a linked table in Microsoft Access with the CData MongoDB ODBC Driver.
-
Back Up Airtable data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Airtable. In this article, we will employ an SSIS workflow to populate a database with Airtable data data.
-
Create SSAS Tabular Models from MariaDB Data
How to build a SQL Server Analysis Service Tabular Model from MariaDB data using CData drivers.
-
Build Data Flows from Trello to SQL Server using SSIS
Easily back up Trello data to SQL Server using the SSIS components for Trello.
-
Connect to Parallel from a Connection Pool in WebLogic
Use the CData JDBC Driver for Parallel to connect to Parallel data from Web applications running on WebLogic.
-
View Reports on Real-Time Dynamics 365 Business Central Data in Power BI Report Server
Use the CData ODBC Driver for Dynamics 365 Business Central to visualize Dynamics 365 Business Central data in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData Connect AI Python SDK for Yelp
Install the CData Connect AI Python SDK to read live Yelp data with standard DB-API 2.0 Python code.
-
Moving Data from Pingdom to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Pingdom data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to SAP SuccessFactors 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 SAP SuccessFactors data.
-
Connect to Perigon from a Connection Pool in WebLogic
Use the CData JDBC Driver for Perigon to connect to Perigon data from Web applications running on WebLogic.
-
Replicate Multiple SAS xpt Accounts via the CData Sync CLI
Replicate multiple SAS xpt accounts to one or many databases.
-
Query Google Ad Manager Data as a MySQL Database in Node.js
Execute MySQL queries against Google Ad Manager data from Node.js.
-
Automated Continuous Factorial Replication to Snowflake
Use CData Sync for automated, continuous, customizable Factorial replication to Snowflake.
-
Natively Connect to SAP HANA Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SAP HANA data. Leverage the native support for ODBC in PHP.
-
Visualize PingOne Data in TIBCO Spotfire through ADO.NET
Integrate PingOne data into dashboards in TIBCO Spotfire.
-
Analyze Simplesat Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Simplesat from Power Pivot. You will use the Table Import Wizard to load Simplesat data. You can visually build the import query or use any SQL supported by the driver.
-
How to load Google Calendar data into Elasticsearch via Logstash
Introducing a simple method to load Google Calendar data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software ODBC Driver for Todoist in MicroStrategy Web
Connect to Todoist data in MicroStrategy Web using the CData Software ODBC Driver for Todoist.
-
Build Automated Airtable-Connected Workflows in Zapier
Use CData Connect AI to connect to live Airtable data and build automated workflows in Zapier.
-
Using the CData Software ODBC Driver for Square in PyCharm
Connect to Square as an ODBC data source in PyCharm using the CData Software ODBC Driver for Square.
-
Use CData Connect AI to Access Stripe Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Stripe data in the Power Pivot business intelligence tool.
-
Migrating data from xBase to Google BigQuery using CData SSIS Components.
Easily push xBase data to Google BigQuery using the CData SSIS Tasks for xBase and Google BigQuery.
-
Connect to Greenplum Data in Aqua Data Studio
Access Greenplum data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Analyze Live ZohoMarketingHub Data in SAS Viya
Use CData Connect AI to connect to ZohoMarketingHub data from SAS Viya and deploy self-service analytics using live ZohoMarketingHub data.
-
Connect to Quickbase Data from HeidiSQL
Use CData Connect AI to connect to and query live Quickbase data from HeidiSQL.
-
Connect OData to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect OData with IBM WebSphere for seamless data integration and connectivity.
-
Build a PostgreSQL Interface for Asana Data using the CData JDBC Driver
Use the Remoting features of the Asana JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData ODBC Driver for TaxJar in Microsoft Power Query
You can use the CData TaxJar ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import TaxJar data into Microsoft Power Query.
-
Integrate Trae with Live Gmail Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Gmail data from within the AI-powered IDE.
-
Visualize Clio Data in TIBCO Spotfire through ADO.NET
Integrate Clio data into dashboards in TIBCO Spotfire.
-
Build Semantic Layer Views for Exact Online Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Exact Online data.
-
Automated Continuous Zoho Projects Replication to MongoDB
Use CData Sync for automated, continuous, customizable Zoho Projects replication to MongoDB.
-
Create Reports with Pinecone Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pinecone data.
-
Automated Continuous Google Search Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Google Search replication to Apache Cassandra.
-
Working with ChargeOver Data in LINQPad
Execute LINQ queries to ChargeOver data in LINQPad.
-
Creating GitHub-Connected Applications in Unqork
You can use CData Connect AI to feed GitHub data to Unqork and build custom business apps.
-
How to Connect the Power BI Service to ZarMoney: Complete Guide
Connect to the CData Software Power BI Connector for ZarMoney from PowerBI.com to provide real-time ZarMoney data across the organization.
-
Replicate LightSpeedRetail Data in Heroku for Use in Salesforce Connect
Replicate LightSpeedRetail data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to connect PolyBase to Reply.io
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Reply.io data.
-
Add Reckon Accounts Hosted Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Reckon Accounts Hosted with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Live AlloyDB Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live AlloyDB data from within the IDE.
-
Connect to SendInBlue from a Connection Pool in WebLogic
Use the CData JDBC Driver for SendInBlue to connect to SendInBlue data from Web applications running on WebLogic.
-
How to connect to Apollo Data from Spring Boot
Connect to Apollo in a Spring Boot Application using the CData API Driver for JDBC
-
Connect and Visualize Live Apollo Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Apollo data into the Databricks platform and create visualization dashboards with real-time Apollo data.
-
Access Outreach.io Data from MySQL in Amazon QuickSight
Connect to Outreach.io and build visualizations of Outreach.io data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Templated Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Templated replication to Google BigQuery.
-
Connect to Zoom Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Zoom data from Filemaker Pro on Mac.
-
Create Act CRM-Connected Business Apps in AppSheet
Connect to Act CRM Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Act CRM data.
-
Connect to Amazon Marketplace from Asprova with CData Software ODBC Driver for Amazon Marketplace
This article shows how to connect faster to Amazon Marketplace data from Asprova.
-
Access Omnisend 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 Omnisend data.
-
Choosing the Best Method to Connect WooCommerce to SQL Server: 5 Options Explained
Discover multiple ways to connect and use WooCommerce data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate CockroachDB Data in the Pentaho Report Designer
Publish reports based on CockroachDB data in the Pentaho BI tool.
-
Access Cvent Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Cvent data from HeidiSQL.
-
Easily Integrate AgileCRM Data in Lazarus Pascal IDE
Learn how to easily integrate live AgileCRM data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect to Teamgate Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Teamgate data. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous GraphQL Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable GraphQL data replication to OneLake in Microsoft Fabric.
-
Connect to Apify from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Apify data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Explore Geographical Relationships in Testmonitor Data with Power Map
Create data visualizations with Testmonitor data in Power Map.
-
Integrate Live SAP Hybris C4C Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP Hybris C4C data and integrate live SAP Hybris C4C data into apps built in Microsoft Power Apps.
-
Visualize Blackbaud FE NXT Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Blackbaud FE NXT data.
-
Connect to PhantomBuster Data in DBeaver
Use the CData ODBC Driver to connect to PhantomBuster data in DBeaver.
-
Build Google Sheets Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Sheets data and build visualizations in Tableau Cloud.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Xero
Provide connectivity to Xero data through an SAP BusinessObjects universe.
-
Publish Sage 200-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Sage 200 data.
-
Analyze Pinecone Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Pinecone data with the CData JDBC Driver for Pinecone.
-
Use the CData ODBC Driver for SingleStore from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SingleStore to connect to SingleStore data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SingleStore data in Excel.
-
Connect to CircleCI Data in Ruby
Connect to CircleCI data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize GraphQL Data in TIBCO Spotfire through OData
Integrate GraphQL data into dashboards in TIBCO Spotfire.
-
How to Connect to Live PolarTeamPro 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 PolarTeamPro data through natural language.
-
Configure the CData JDBC Driver for MarkLogic in a Connection Pool in Tomcat
Connect to MarkLogic data from a connection pool in Tomcat.
-
Build Bitly-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Bitly Data and create custom apps in Mendix.
-
Connect to Toggl Data from HeidiSQL
Use CData Connect AI to connect to and query live Toggl data from HeidiSQL.
-
How to Seamlessly Import HDFS Data into IBM SPSS Modeler
Integrate HDFS data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build a Simple VCL Application for LinkedIn Ads Data
How to build a simple VCL Application to view LinkedIn Ads data in RAD Studio using the CData ODBC Driver for LinkedIn Ads.
-
How to create TaxJar federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for TaxJar data in MySQL .
-
Visualize Aircall Data in Tableau
The CData ODBC driver for Aircall enables you integrate Aircall data into Tableau dashboards.
-
Perform Batch Operations with HubSpot Data in Apache NiFi
Connect to HubSpot data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to VWO Data in Aqua Data Studio
Access VWO data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to PayPal Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live PayPal data.
-
Automated Continuous Clio Replication to Vertica
Use CData Sync for automated, continuous, customizable Clio replication to Vertica.
-
Build MVC Applications with Connectivity to Avaza Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Avaza from an ASP.NET MVC application.
-
Query Shopify Data as a MySQL Database in Node.js
Execute MySQL queries against Shopify data from Node.js.
-
Use Biml to Build SSIS Tasks to Replicate Teradata Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Teradata data to SQL Server.