CData Software - Knowledge Base
Recent Articles
-
Prepare, Blend, and Analyze GitHub Data in Alteryx Designer (Connect AI)
Build workflows to access live GitHub data for self-service data analytics.
-
Automated Continuous Facebook Ads Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Facebook Ads replication to Amazon Redshift.
-
Interact with Live Egnyte Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Egnyte data.
-
Access Live Microsoft Planner 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 Microsoft Planner data through MCP integration.
-
Bind Live Authorize.Net Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Authorize.Net data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
DataBind LightSpeedRetail Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide LightSpeedRetail data to a chart.
-
Build a Singer.io Tap for Google Tasks With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Google Tasks data using the CData Python Connector.
-
Analyze Microsoft Planner Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Microsoft Planner from Power Pivot. You will use the Table Import Wizard to load Microsoft Planner data. You can visually build the import query or use any SQL supported by the driver.
-
Query Shippo Data in ColdFusion
Write standard ColdFusion data access code to connect to Shippo data.
-
Getting Started with the CData ODBC Driver for LinkedIn
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for LinkedIn.
-
Connect to Freshdesk Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Freshdesk as an External Source in Dremio.
-
Integrate Theia IDE with Live ZohoPeople Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live ZohoPeople data from within the development environment.
-
Build Apps with Live ZohoExpense data in Adalo using CData Connect AI
Use CData Connect AI to integrate live ZohoExpense data into the Adalo platform and build custom mobile and web applications with real-time ZohoExpense data.
-
Connect to Sybase Data from PowerBuilder via ADO.NET
This article demonstrates how to access Sybase data from Appeon PowerBuilder using the CData ADO.NET Provider for Sybase.
-
Connecting Agentforce with Slack 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 Slack data for you.
-
Import and Visualize Paddle Data in Power View
Create data visualizations based on Paddle data in Excel.
-
Connect to ZohoDesk 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 ZohoDesk data.
-
Create iContact Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time iContact data access from reports, embedded analytics, and more.
-
Build AI/ML Models with Live Sentry Data using Dataiku
Connect Sentry Data with Dataiku using the CData API Driver for JDBC.
-
Bridge VWO Connectivity with Apache NiFi
Access and process VWO data in Apache NiFi using the CData JDBC Driver.
-
Connect to GetResponse Data in RazorSQL
Connect to GetResponse from wizards and query GetResponse data from the GUI in the RazorSQL database management tool.
-
Integrating LangGraph with Excel Online Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Excel Online data within automated workflows.
-
Automate SAP BusinessObjects BI Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP BusinessObjects BI data from PowerShell? This article demonstrates how to utilize the SAP BusinessObjects BI Cmdlets for tasks like connecting to SAP BusinessObjects BI data, automating operations, downloading data, and more.
-
Use the CData Software JDBC Driver for SAP BusinessObjects BI in MicroStrategy
Connect to SAP BusinessObjects BI data in MicroStrategy Developer using the CData Software JDBC Driver for SAP BusinessObjects BI.
-
Connect to PayPal Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with PayPal Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automated Continuous Teamwork Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Teamwork replication to Azure SQL Database.
-
Use ChatGPT to Talk to Your QuickBooks 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 QuickBooks data for you.
-
Integrate Goose with Live Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Avro data from within the local AI agent.
-
Integrate Google Cloud Storage Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google Cloud Storage data from Informatica Cloud.
-
Use the CData ODBC Driver for Google Campaign Manager 360 in Microsoft Power Query
You can use the CData Google Campaign Manager 360 ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Campaign Manager 360 data into Microsoft Power Query.
-
Automated Continuous Eventbrite Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Eventbrite replication to Google BigQuery.
-
Write a Simple Go Application to work with ZarMoney Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ZarMoney data.
-
Bidirectional Access to Kafka Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Kafka data in Filemaker Pro for Mac or Windows.
-
Using the CData Software ODBC Driver for Auth0 in PyCharm
Connect to Auth0 as an ODBC data source in PyCharm using the CData Software ODBC Driver for Auth0.
-
Connect to Oracle Eloqua Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Oracle Eloqua data in Airbyte.
-
Automate GetResponse Data Replication to Azure Data Lake
Use CData Sync to customize and automate GetResponse data replication to Azure Data Lake.
-
Automated Continuous SAP Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP replication to delimited files (CSV/TSV).
-
Visualize Supabase Data in Sisense
Create an ElastiCube in Sisense app with access to Supabase data.
-
How to connect to Marketo Data from Spring Boot
Connect to Marketo in a Spring Boot Application using the CData JDBC Driver for Marketo
-
A PostgreSQL Interface for Nuclia Data using the CData ODBC Driver
Use the SQL Gateway and Nuclia ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Sugar CRM Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Sugar CRM data without replication.
-
Automated Continuous Impala Replication to MongoDB
Use CData Sync for automated, continuous, customizable Impala replication to MongoDB.
-
Integrate Demio Data in the Pentaho Report Designer
Publish reports based on Demio data in the Pentaho BI tool.
-
Object-Relational Mapping (ORM) with JSON Services 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 JSON services into a Java-based ORM framework, Hibernate.
-
How to Connect the Power BI Service to Stripe: Complete Guide
Connect to the CData Software Power BI Connector for Stripe from PowerBI.com to provide real-time Stripe data across the organization.
-
Connect to Lakebase Data from HeidiSQL
Use CData Connect AI to connect to and query live Lakebase data from HeidiSQL.
-
Natively Connect to ZohoInvoice Data in PHP
The CData ODBC driver for ZohoInvoice enables you to create PHP applications with connectivity to ZohoInvoice data. Leverage the native support for ODBC in PHP.
-
Object-Relational Mapping (ORM) with Placid 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 Placid data into a Java-based ORM framework, Hibernate.
-
Integrate Codat Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Codat data from Informatica Cloud.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Snapchat Ads
Provide connectivity to Snapchat Ads data through an SAP BusinessObjects universe.
-
Query Cosmos DB Data in DataGrip
Create a Data Source for Cosmos DB in DataGrip and use SQL to query live Cosmos DB data.
-
Query Autopilot Data in ColdFusion
Write standard ColdFusion data access code to connect to Autopilot data.
-
How to Use a Microsoft Access Database to Update Microsoft Entra ID Data in Real Time
Update Microsoft Entra ID data by creating a linked table in Microsoft Access with the CData Microsoft Entra ID ODBC Driver.
-
Moving Data from Typeform to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Typeform data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access Live GitLab Data in Excel 365 Online (Excel for the web)
Connect to GitLab data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Microsoft Ads Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Microsoft Ads as an External Source in Dremio.
-
Automate Exa Data Replication to Azure Data Lake
Use CData Sync to customize and automate Exa data replication to Azure Data Lake.
-
Connect and Visualize Live Microsoft OneDrive Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Microsoft OneDrive data into the Databricks platform and create visualization dashboards with real-time Microsoft OneDrive data.
-
DataBind Controls to PhantomBuster Data in Delphi
DataBind to PhantomBuster data in Delphi with standard data access components and controls.
-
Getting Started with the CData Excel Add-In for Flowlu
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Flowlu.
-
Use Databricks Agent Bricks to Talk to Your Google Cloud Storage Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Google Cloud Storage data for you.
-
Query Twilio Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Twilio data from Node.js.
-
How to Access Live REST Data in Power Automate Desktop via ODBC
The CData ODBC Driver for REST enables you to integrate REST data into workflows built using Microsoft Power Automate Desktop.
-
Replicate Act CRM Data in Heroku for Use in Salesforce Connect
Replicate Act CRM data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Live Smartsheet Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Smartsheet in CData Connect AI and connect to your Smartsheet data from PostgreSQL.
-
How to integrate Metabase with Google Ad Manager Data
Use CData Connect AI to connect to live Google Ad Manager data and create an interactive dashboard in Metabase from Google Ad Manager data.
-
Use JayDeBeApi to access MailerSend Data in Python
Use standard Python scripting and the development environment of your choice to access live MailerSend data.
-
Query Live Dynamics CRM Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Dynamics CRM data directly from the development environment.
-
Query Azure Data Lake Storage Data as a MySQL Database in Node.js
Execute MySQL queries against Azure Data Lake Storage data from Node.js.
-
Use the CData Software ODBC Driver for QuickBooks in SAS for Real-Time Reporting and Analytics
Connect to real-time QuickBooks data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for QuickBooks.
-
How to connect to Printify Data from Spring Boot
Connect to Printify in a Spring Boot Application using the CData API Driver for JDBC
-
Create Dashboards and Visualize Live Acumatica Data in Geckoboard
Use CData Connect AI to connect to live Acumatica data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Replicate Azure Data Lake Storage Data in Heroku for Use in Salesforce Connect
Replicate Azure Data Lake Storage data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Ontraport Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Ontraport replication to Apache Kafka.
-
Automated Continuous REST Replication to Vertica
Use CData Sync for automated, continuous, customizable REST replication to Vertica.
-
Automate Close Data Replication to Couchbase
Use CData Sync to Customize and automate Close data replication to Couchbase.
-
Connect to SurveyMonkey Data in Aqua Data Studio
Access SurveyMonkey data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Salesforce Data 360 Data from a Connection Pool in JBoss
Integrate Salesforce Data 360 data into Java servlets: Use the Management Console in JBoss to install the Salesforce Data 360 JDBC Driver.
-
Connect to FTP from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from FTP data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Analyze Close Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Close from Power Pivot. You will use the Table Import Wizard to load Close data. You can visually build the import query or use any SQL supported by the driver.
-
How to Visualize WordPress Data in Python with pandas
Use pandas and other modules to analyze and visualize live WordPress data in Python.
-
Publish Google Contacts-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Contacts data.
-
Use CData Connect AI to Access Egnyte Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Egnyte data in the Power Pivot business intelligence tool.
-
Build Automated Sybase-Connected Workflows in Zapier
Use CData Connect AI to connect to live Sybase data and build automated workflows in Zapier.
-
How to connect to Insightly Data in DBVisualizer
Integrate Insightly data with visual data analysis tools and data connection wizards in DBVisualizer
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Webex
Provide connectivity to Webex data through an SAP BusinessObjects universe.
-
Replicate Microsoft Planner Data to Multiple Databases via the CData Sync CLI
Replicate Microsoft Planner data to disparate databases with a single configuration.
-
Build Apps with Live Zoho Creator data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Zoho Creator data into the Adalo platform and build custom mobile and web applications with real-time Zoho Creator data.
-
Use the CData Software ODBC Driver for Clari in MicroStrategy Desktop
Connect to Clari data in MicroStrategy Desktop using the CData Software ODBC Driver for Clari.
-
Use the CData Software ODBC Driver for Cohere in MicroStrategy Desktop
Connect to Cohere data in MicroStrategy Desktop using the CData Software ODBC Driver for Cohere.
-
Analyze Samanage Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Samanage data in Microsoft R Open.
-
Access Live SurveyMonkey Data in Coginiti Pro
Connect to and query live SurveyMonkey data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software ODBC Driver for Templated in MicroStrategy Web
Connect to Templated data in MicroStrategy Web using the CData Software ODBC Driver for Templated.
-
Connect to HBase Data in DBeaver
Use the CData ODBC Driver to connect to HBase data in DBeaver.
-
Visualize TaxJar Data in Tableau
The CData ODBC driver for TaxJar enables you integrate TaxJar data into Tableau dashboards.
-
Migrating data from HubDB to Snowflake using CData SSIS Components.
Easily push HubDB data to Snowflake using the CData SSIS Tasks for HubDB and Snowflake.
-
Integrate Live Microsoft Dataverse Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Microsoft Dataverse from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Microsoft Dataverse data.
-
Integrating LangGraph with Tavily Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Tavily data within automated workflows.
-
Build Google Analytics-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Analytics data.
-
Query Gmail Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Gmail entities in PHP by modeling them as objects.