CData Software - Knowledge Base
Recent Articles
-
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 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
-
Integrating Boomi Agentstudio with Greenhouse Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Greenhouse, 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 Desktop 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.
-
Replicate ChargeOver Data to Multiple Databases via the CData Sync CLI
Replicate ChargeOver 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 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 into the building and management of effective data pipelines.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Greenplum
Provide connectivity to Pivotal GreenPlum through an SAP BusinessObjects universe.
-
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 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 CLI with Stripe 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 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 Atlassian Jira 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 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 as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create SSAS Tabular Models from Google Drive Data
How to build a SQL Server Analysis Service Tabular Model from Google Drive 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 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 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 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. 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 using pandas and the CData Connect AI Python SDK.
-
Integrating Cursor CLI 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 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 in MySQL .
-
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 from within the chat interface.
-
Connect to SAP Fieldglass Data in JRuby
Create a simple JRuby app with access to live SAP Fieldglass.
-
Automate Opsgenie Data Replication to Azure Data Lake
Use CData Sync to customize and automate Opsgenie 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.
-
Visualize Azure Data Lake Storage Data in Sisense
Create an ElastiCube in Sisense app with access to Azure Data Lake Storage.
-
Publish Crystal Reports on Impala Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Apache Impala.
-
Integrating Kiro CLI 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
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP HANA using the Model Context Protocol.
-
Connect to Google Spanner Data from PowerBuilder via ADO.NET
This article demonstrates how to access Google Spanner 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 in Dundas BI.
-
How to Create Power BI Visual Reports with Real-Time Rootly Data
Use CData Power BI Connectors to visualize Rootly in Power BI.
-
Extract, Transform, and Load SAP SuccessFactors Data in Informatica PowerCenter
Create a simple Workflow for SAP SuccessFactors in Informatica PowerCenter.
-
Build Apps with Live Paylocity Data Using the Low-Code Development Platform of Mendix
Connect Paylocity 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 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 Cloud 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.
-
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
-
Connect to Avro Data in NetBeans
Connect to Apache Avro 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 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.
-
DataBind Controls to Access Data in Delphi
DataBind to Microsoft Access in Delphi with standard data access components and controls.
-
Visualize HBase Data in TIBCO Spotfire through ADO.NET
Integrate Apache HBase 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 in MicroStrategy Desktop using the CData Software JDBC Driver for Omnisend.
-
How to connect to Exa Data with Squirrel SQL client
Connect to Exa and execute queries in the Squirrel SQL Client.
-
Connect to Highrise Data from PowerBuilder via JDBC
This article demonstrates how to access Highrise CRM 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.
-
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.
-
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 in your FileMaker application.
-
Access Mixpanel Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Mixpanel 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 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 for you.
-
Publish Excel-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Excel.
-
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 into Microsoft Power Query.
-
Migrating data from MailChimp to Databricks using CData SSIS Components.
Easily push MailChimp 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 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 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.
-
Integrating Antigravity CLI with Amazon Athena via CData CLI
Connect Amazon Athena 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 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.
-
Integrating Kiro CLI 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 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.
-
Getting Started with the CData Tableau Connector for Elasticsearch
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Elasticsearch.
-
Connect to Rootly Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Rootly in the Denodo Virtual DataPort Administrator.
-
How to Connect to Live Twitter Ads Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Twitter Ads for you.
-
Integrate with Yelp Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Yelp to a JSON file on disk.
-
How to Visualize Redis 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 Redis in Python.
-
Visualize Live Cosmos DB Data in the Power BI Service
Use CData Connect AI to connect to live Azure Cosmos DB and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Google Campaign Manager 360 Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Vertica.
-
Create Datasets from Office 365 in Domo Workbench and Build Visualizations of Office 365 Data in Domo
Use the CData Software ODBC Driver for Office 365 to create datasets from Microsoft Office 365 in Domo Workbench and then build visualizations in the Domo service.
-
Visualize Live JobNimbus Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live JobNimbus.
-
Use Claude to Talk to Your Microsoft 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 Microsoft Ads for you.
-
How to Work with Paymo Data in AWS Glue Jobs Using JDBC
Connect to Paymo from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to ClickTime Data in Aqua Data Studio
Access ClickTime from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Creating DB2-Connected Applications in Unqork
You can use CData Connect AI to feed IBM DB2 to Unqork and build custom business apps.
-
Create a Data Access Object for Reply.io Data using JDBI
A brief overview of creating a SQL Object API for Reply.io in JDBI.
-
Replicate Multiple Box Accounts via the CData Sync CLI
Replicate multiple Box accounts to one or many databases.
-
Use the CData Software JDBC Driver for Confluence in MicroStrategy Desktop
Connect to Atlassian Confluence in MicroStrategy Desktop using the CData Software JDBC Driver for Confluence.