CData Software - Knowledge Base
Recent Articles
-
Create Avalara AvaTax-Connected Business Apps in AppSheet
Connect to Avalara AvaTax Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Avalara AvaTax data.
-
Use the CData ODBC Driver for AlloyDB from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for AlloyDB to connect to AlloyDB data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring AlloyDB data in Excel.
-
Integrating Dataiku with Jumpseller Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Jumpseller data.
-
Connect to Dotmailer Data in DBArtisan
Use wizards in DBArtisan to configure Dotmailer data as a data source.
-
Connect to EmailOctopus Data in Aqua Data Studio
Access EmailOctopus data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Odoo Data from MySQL in PHP
Connect to Odoo through the standard MySQL libraries in PHP.
-
Access Live MarkLogic Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live MarkLogic data through MCP integration.
-
Build a Singer.io Tap for Phoenix With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Phoenix data using the CData Python Connector.
-
Integrating Boomi Agentstudio with Greenhouse Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Greenhouse data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to connect to QuickBooks Data in DBVisualizer
Integrate QuickBooks data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Work with LaunchDarkly Data in ETL Validator JDBC
Connect to LaunchDarkly from ETL Validator jobs using the CData Software JDBC Driver.
-
Build SAS Data Sets-Connected Apps in Choreo
Use CData Connect AI to connect to SAS Data Sets Data from Choreo and build custom apps using live SAS Data Sets data.
-
Replicate ChargeOver Data to Multiple Databases via the CData Sync CLI
Replicate ChargeOver data to disparate databases with a single configuration.
-
Access Live LinkedIn Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live LinkedIn data from your Excel spreadsheets.
-
Build Pipelines with Live Amazon Athena Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Amazon Athena from Google Cloud Data Fusion, enabling the integration of live Amazon Athena data into the building and management of effective data pipelines.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Greenplum
Provide connectivity to Greenplum data through an SAP BusinessObjects universe.
-
How to integrate Metabase with Azure Data Catalog Data
Use CData Connect AI to connect to live Azure Data Catalog data and create an interactive dashboard in Metabase from Azure Data Catalog data.
-
Connect to MailerSend Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to MailerSend and work with MailerSend data in your FileMaker application.
-
Create Google Translate Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Translate from PowerBI.com to create Power BI Dataflows with real-time data.
-
Seamlessly Bring Epicor Kinetic Data into Retool Using CData Connect AI
Integrate Epicor Kinetic data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrating GitHub Copilot with Stripe 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.
-
How to Work with Outlook Data in AWS Glue Jobs Using JDBC
Connect to Outlook from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Viewing Redis Data in RAD Studio Data Explorer
How to view Redis data in RAD Studio Data Explorer using the CData ODBC Driver for Redis.
-
Use the CData Software ODBC Driver for Jira in SAS for Real-Time Reporting and Analytics
Connect to real-time Jira data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Jira.
-
How to Seamlessly Import iContact Data into IBM SPSS Modeler
Integrate iContact data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build an OLAP Cube in SSAS from Outreach.io Data
Establish a connection to Outreach.io data data from SQL Server Analysis Services, and use the Outreach.io Data Provider to build OLAP cubes for use in analytics and reporting.
-
Replicate Multiple CouchDB Accounts
Replicate multiple CouchDB accounts to one or many databases.
-
Create Data Visualizations in Cognos BI with Demio Data
Access Demio data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live Apify Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Apify data from your Excel spreadsheets.
-
Create SSAS Tabular Models from Google Drive Data
How to build a SQL Server Analysis Service Tabular Model from Google Drive data using CData drivers.
-
How to Work with ZendeskSell Data in ETL Validator JDBC
Connect to ZendeskSell from ETL Validator jobs using the CData Software JDBC Driver.
-
Explore Geographical Relationships in Neo4J Data with Power Map
Create data visualizations with Neo4J data in Power Map.
-
Build Visualizations of GetResponse Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of GetResponse data in Birst.
-
How to Connect Flowise AI Agents to Live Neo4J Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Neo4J data without replication.
-
Analyze OnePageCrm Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for OnePageCrm from Power Pivot. You will use the Table Import Wizard to load OnePageCrm data. You can visually build the import query or use any SQL supported by the driver.
-
LINQ to Zoho Projects Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Zoho Projects Data Provider.
-
Use Dash to Build Web Apps on Microsoft Planner Data via CData Connect AI
Build interactive Dash web apps on live Microsoft Planner data using pandas and the CData Connect AI Python SDK.
-
Integrating Cursor with Productboard 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.
-
Seamlessly Bring Reckon Accounts Hosted Data into Retool Using CData Connect AI
Integrate Reckon Accounts Hosted data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to and Query BenchmarkEmail Data in QlikView over ODBC
Create data visualizations with BenchmarkEmail data in QlikView.
-
Integrating Claude Code CLI with Aha! 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.
-
How to create YouTube Analytics federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for YouTube Analytics data in MySQL .
-
Work with Live Mailgun Data in Power Query
Use CData Connect AI to connect to Mailgun data and work with live Mailgun data in Microsoft Power Query.
-
Integrate LibreChat with Live Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Basecamp data from within the chat interface.
-
Connect to SAP Fieldglass Data in JRuby
Create a simple JRuby app with access to live SAP Fieldglass data.
-
Automate Opsgenie Data Replication to Azure Data Lake
Use CData Sync to customize and automate Opsgenie data replication to Azure Data Lake.
-
Create BigCommerce-Connected Nintex Workflows
Use CData Connect AI to connect to BigCommerce Data from Nintex Workflow Cloud and build custom workflows using live BigCommerce data.
-
Visualize Azure Data Lake Storage Data in Sisense
Create an ElastiCube in Sisense app with access to Azure Data Lake Storage data.
-
Publish Crystal Reports on Impala Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Impala data.
-
Integrating Kiro with Yelp 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.
-
Integrate Google's Antigravity Agent with Live SAP HANA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP HANA data using the Model Context Protocol.
-
Connect to Google Spanner Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google Spanner data from Appeon PowerBuilder using the CData ADO.NET Provider for Google Spanner.
-
Build Dashboards with ClickTime Data in Dundas BI
Create dynamic dashboards and perform analytics based on ClickTime data in Dundas BI.
-
How to Create Power BI Visual Reports with Real-Time Rootly Data
Use CData Power BI Connectors to visualize Rootly data in Power BI.
-
Use Azure AI Foundry to Talk to Your Mailjet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Mailjet data for you.
-
Extract, Transform, and Load SAP SuccessFactors Data in Informatica PowerCenter
Create a simple Workflow for SAP SuccessFactors data in Informatica PowerCenter.
-
How to Connect to Live Jumpseller Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Jumpseller data for you.
-
Build Apps with Live Paylocity Data Using the Low-Code Development Platform of Mendix
Connect Paylocity data with Mendix to build apps using the CData JDBC Driver for Paylocity.
-
Use the CData Software JDBC Driver for Raisers Edge NXT in MicroStrategy
Connect to Raisers Edge NXT data in MicroStrategy Developer using the CData Software JDBC Driver for Raisers Edge NXT.
-
Import Salesforce Marketing Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Salesforce Marketing Data and provide access to live Salesforce Marketing data for custom reports in the Power BI Service.
-
Excel Spreadsheet Automation on ServiceNow Data with the QUERY Formula
Pull data from ServiceNow, automate spreadsheets, and more with the QUERY formula.
-
Build Pipedrive-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Pipedrive data.
-
Create Data Visualizations Based On BigQuery Data in Mode
Use CData Connect AI to connect to BigQuery Data from Mode and build visualizations using live BigQuery data.
-
Build Microsoft Dataverse-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 Microsoft Dataverse data without replication.
-
Connect to Avro Data in NetBeans
Connect to Avro data in NetBeans with the data source configuration wizard.
-
Automated Continuous Email Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Email replication to Google Cloud SQL.
-
Automate Aweber Data Replication to Azure Data Lake
Use CData Sync to customize and automate Aweber data replication to Azure Data Lake.
-
Use Dash to Build to Web Apps on ScrapingBee Data
Create Python applications that use pandas and Dash to build ScrapingBee-connected web apps.
-
Publish Reports with Strava Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Strava data.
-
DataBind Controls to Access Data in Delphi
DataBind to Access data in Delphi with standard data access components and controls.
-
Connect to Optimizely Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Optimizely data in Airbyte.
-
Visualize HBase Data in TIBCO Spotfire through ADO.NET
Integrate HBase data into dashboards in TIBCO Spotfire.
-
Automated Continuous Avaza Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Avaza replication to Amazon S3.
-
Use the CData Software JDBC Driver for Omnisend in MicroStrategy Desktop
Connect to Omnisend data in MicroStrategy Desktop using the CData Software JDBC Driver for Omnisend.
-
How to connect to Exa Data with Squirrel SQL client
Connect to Exa data and execute queries in the Squirrel SQL Client.
-
Connect to Highrise Data from PowerBuilder via JDBC
This article demonstrates how to access Highrise data from PowerBuilder using the Highrise JDBC Driver.
-
Getting Started with the CData SSIS Components for Postmark
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Postmark.
-
Integrate Dify with Live Neo4J Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Neo4J data.
-
Build Semantic Layer Views for Zoom Data in APOS Live Data Gateway
Use the CData Connector for Zoom in APOS Live Data Gateway to build Semantic Layer Views for Zoom data.
-
Connect to Zoho Inventory Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Zoho Inventory and the Script function in FileMaker Pro to connect to Zoho Inventory and work with Zoho Inventory data in your FileMaker application.
-
Access Mixpanel Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Mixpanel data from your Oracle system.
-
Integrating Gumloop with Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Kintone data within automated workflows.
-
Use Dash to Build to Web Apps on JSON Services
Create Python applications that use pandas and Dash to build JSON-connected web apps.
-
Use Azure AI Foundry to Talk to Your Salesforce CRM Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Salesforce CRM Analytics data for you.
-
Publish Excel-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Excel data.
-
Use the CData ODBC Driver for REST in Microsoft Power Query
You can use the CData REST ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import REST data into Microsoft Power Query.
-
Migrating data from MailChimp to Databricks using CData SSIS Components.
Easily push MailChimp data to Databricks using the CData SSIS Tasks for MailChimp and Databricks.
-
Build SAP Hybris C4C-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SAP Hybris C4C data and build SAP Hybris C4C-connected web apps with Axios.
-
Connect to Sybase Data from AWS Glue
Use CData Connect AI to gain access to live Sybase data from your AWS Glue jobs.
-
Operational Reporting on ShipStation Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ShipStation data.
-
Integrating Antigravity CLI with Amazon Athena data via CData CLI
Connect Amazon Athena data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous MarkLogic Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable MarkLogic replication to PostgreSQL.
-
Use Biml to Build SSIS Tasks to Replicate Helpscout Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Helpscout data to SQL Server.
-
Create Reports with SpaceX Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SpaceX data.
-
Integrating Kiro with HubDB 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.
-
Migrating data from Grafana to Snowflake using CData SSIS Components.
Easily push Grafana data to Snowflake using the CData SSIS Tasks for Grafana and Snowflake.
-
Connect to SAP SuccessFactors LMS 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 LMS data.
-
Getting Started with the CData Tableau Connector for Elasticsearch
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Elasticsearch.
-
Connecting Pipedream with ZohoExpense Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on ZohoExpense data in real time.
-
Connect to Rootly Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Rootly data in the Denodo Virtual DataPort Administrator.