CData Software - Knowledge Base
Recent Articles
-
Create Apps from FHIR Data in Qlik Sense Cloud
Use CData Connect AI to connect to FHIR Data and build apps from live FHIR data in Qlik Sense Cloud.
-
Visualize Live Accelo Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Accelo data.
-
Connect to Sage 200 Data in HULFT Integrate
Connect to Sage 200 as a JDBC data source in HULFT Integrate
-
Create Adobe Experience Manager Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Adobe Experience Manager from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Microsoft Ads Replication to Snowflake
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to Snowflake.
-
Connect Reckon Accounts Hosted to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Reckon Accounts Hosted data using the CData Python MCP Server.
-
Publish Reports with Email Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Email data.
-
Build Apps with Live WooCommerce data in Adalo using CData Connect AI
Use CData Connect AI to integrate live WooCommerce data into the Adalo platform and build custom mobile and web applications with real-time WooCommerce data.
-
Connect ActiveCampaign to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ActiveCampaign data using the CData Python MCP Server.
-
Enable the Elasticsearch JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Elasticsearch data.
-
Connecting GenSpark with NetSuite SuiteAnalytics Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to NetSuite SuiteAnalytics data without any replication or custom integration required.
-
Query Short.io Data in DataGrip
Create a Data Source for Short.io in DataGrip and use SQL to query live Short.io data.
-
Publish Pingdom-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Pingdom data.
-
Integrating Claude Code with Bullhorn CRM Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Bullhorn CRM data within assisted coding and automated development workflows.
-
Add Grafana Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Grafana with the Informatica Enterprise Data Catalog to classify and organize data.
-
Analyze SpaceX Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SpaceX from Power Pivot. You will use the Table Import Wizard to load SpaceX data. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Opsgenie Data in Sisense
Create an ElastiCube in Sisense app with access to Opsgenie data.
-
Connect to FHIR Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for FHIR Data and connect to FHIR data in Akorbi Digital RunMyProcess.
-
Work with Live Jira Assets Data in Power Query
Use CData Connect AI to connect to Jira Assets data and work with live Jira Assets data in Microsoft Power Query.
-
Integrating Claude Code CLI with MarkLogic 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.
-
Connect to CircleCI Data from a Connection Pool in Jetty
The CircleCI JDBC Driver supports connection pooling: This article shows how to connect faster to CircleCI data from Web apps in Jetty.
-
How to Connect the Power BI Service to LaunchDarkly: Complete Guide
Connect to the CData Software Power BI Connector for LaunchDarkly from PowerBI.com to provide real-time LaunchDarkly data across the organization.
-
Connect Pushbullet to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Pushbullet with IBM WebSphere for seamless data integration and connectivity.
-
Visualize Live Hubstaff Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Hubstaff data.
-
Integrate Google's Vertex AI Agent with Live Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Azure Data Lake Storage data within intelligent workflows.
-
Import BigQuery Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to BigQuery Data and provide access to live BigQuery data for custom reports in the Power BI Service.
-
Use the CData Software JDBC Driver for QuickBooks Time in MicroStrategy Desktop
Connect to QuickBooks Time data in MicroStrategy Desktop using the CData Software JDBC Driver for QuickBooks Time.
-
Integrate OpenCode with Live Figshare Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Figshare data from within your AI coding agent.
-
Integrate ChargeOver with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ChargeOver with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ChargeOver data.
-
How to Visualize Hugging Face Data in Python with pandas
Use pandas and other modules to analyze and visualize live Hugging Face data in Python.
-
Trigger MongoDB IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for MongoDB with standard wizards in Logic Apps.
-
Connecting Pipedream with Notion 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 Notion data in real time.
-
Use the CData Software JDBC Driver for Simplesat in MicroStrategy Desktop
Connect to Simplesat data in MicroStrategy Desktop using the CData Software JDBC Driver for Simplesat.
-
Bridge Impala Connectivity with Apache NiFi
Access and process Impala data in Apache NiFi using the CData JDBC Driver.
-
Integrate OpenCode with Live Google Calendar Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Google Calendar data from within your AI coding agent.
-
Object-Relational Mapping (ORM) with Google Cloud Storage 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 Google Cloud Storage data into a Java-based ORM framework, Hibernate.
-
Visualize MySQL Data in Sisense
Create an ElastiCube in Sisense app with access to MySQL data.
-
Prepare, Blend, and Analyze Slack Data in Alteryx Designer (ODBC)
Build workflows to access live Slack data for self-service data analytics.
-
Publish Crystal Reports on Authorize.Net Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Authorize.Net data.
-
Use the CData Software JDBC Driver for GetResponse in MicroStrategy Web
Connect to GetResponse data in MicroStrategy Web using the CData Software JDBC Driver for GetResponse.
-
Excel Spreadsheet Automation on Google Ads Data with the QUERY Formula
Pull data from Google Ads, automate spreadsheets, and more with the QUERY formula.
-
How to Connect Flowise AI Agents to Live Outreach.io 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 Outreach.io data without replication.
-
Integrate with SAP BusinessObjects BI Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP BusinessObjects BI data to a JSON file on disk.
-
Use the CData Software JDBC Driver for SAP Ariba Source in MicroStrategy
Connect to SAP Ariba Source data in MicroStrategy Developer using the CData Software JDBC Driver for SAP Ariba Source.
-
How to work with Clio Data in Apache Spark using SQL
Access and process Clio Data in Apache Spark using the CData Software JDBC Driver.
-
Build Cloudflare Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Cloudflare data and build visualizations in Tableau.
-
Validate OnePageCrm Data with QuerySurge
Access and validate OnePageCrm data in QuerySurge using the CData JDBC Driver.
-
Analyze Guru Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Guru from Power Pivot. You will use the Table Import Wizard to load Guru data. You can visually build the import query or use any SQL supported by the driver.
-
Query Square Data in DataGrip
Create a Data Source for Square in DataGrip and use SQL to query live Square data.
-
Connect Copper Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Copper data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Live ZendeskSell Data in AWS Lambda
Connect to live ZendeskSell data in AWS Lambda using the CData JDBC Driver.
-
Back Up SAP Concur data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP Concur. In this article, we will employ an SSIS workflow to populate a database with SAP Concur data data.
-
Use Grok to Talk to Your Oracle Eloqua 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 Oracle Eloqua data for you.
-
Create Informatica Mappings From/To an ODBC Data Source for HBase
Create an ODBC connection to HBase in Informatica and browse and transfer HBase data.
-
Connect to Act CRM Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Act CRM to connect to Act CRM data and execute queries in PowerBuilder.
-
Connect to Real-Time Testmonitor Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Testmonitor data in Power Apps.
-
Visualize ActiveCampaign Data in Sisense
Create an ElastiCube in Sisense app with access to ActiveCampaign data.
-
Getting Started with the CData Python Connector for CSV
Learn to install and license the CData Python Connector and configure a connection to live CSV data.
-
Automated Continuous Accelo Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Accelo data replication to OneLake in Microsoft Fabric.
-
Build Sage 200-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Sage 200 data.
-
Replicate Multiple BigCommerce Accounts via the CData Sync CLI
Replicate multiple BigCommerce accounts to one or many databases.
-
Create Freshservice-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Freshservice Data from Klipfolio and build custom visualizations using live Freshservice data.
-
Use Azure AI Foundry to Talk to Your Avro 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 Avro data for you.
-
Connect to Klaviyo Data in Jaspersoft Studio
Execute SQL to remote Klaviyo data in Jaspersoft Studio.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Raisers Edge NXT
Provide connectivity to Raisers Edge NXT data through an SAP BusinessObjects universe.
-
Create Informatica Mappings From/To a JDBC Data Source for Azure Synapse
Create Azure Synapse data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating LlamaIndex with SAP Ariba Procurement Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SAP Ariba Procurement data in real time.
-
Add VWO Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for VWO with the Informatica Enterprise Data Catalog to classify and organize data.
-
Using the CData Software ODBC Driver for Airtable in PyCharm
Connect to Airtable as an ODBC data source in PyCharm using the CData Software ODBC Driver for Airtable.
-
Analyze Freshservice Data in Looker
Use CData Connect AI to connect to Freshservice Data from Looker and build custom apps using live Freshservice data.
-
Import Google Campaign Manager 360 Data Using Azure Data Factory
Use CData Connect AI to connect to Google Campaign Manager 360 Data from Azure Data Factory and import live Google Campaign Manager 360 data.
-
Automated Continuous Drip Replication to SQL Server
Use CData Sync for automated, continuous, customizable Drip replication to SQL Server.
-
Getting Started with the CData JDBC Driver for Sage 200
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Sage 200.
-
Integrate with Avaza Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Avaza data to a JSON file on disk.
-
Seamlessly Bring SAP SuccessFactors Data into Retool Using CData Connect AI
Integrate SAP SuccessFactors data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Access Live Spark Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Spark data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Use the CData Software ODBC Driver for Bright Data in MicroStrategy Web
Connect to Bright Data data in MicroStrategy Web using the CData Software ODBC Driver for Bright Data.
-
How to Query Dropbox Data in MySQL Workbench
Execute MySQL queries against live Dropbox data from MySQL Workbench.
-
Connect and Query Live Wistia Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Wistia data into Databricks and enable direct, live querying and analysis without replication.
-
Integrate Yelp Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Yelp data and integrate live Yelp data into your Power Automate tasks.
-
How to work with YouTube Analytics Data in Apache Spark using SQL
Access and process YouTube Analytics Data in Apache Spark using the CData Software JDBC Driver.
-
Build Dashboards with Google Analytics Data in Dundas BI
Create dynamic dashboards and perform analytics based on Google Analytics data in Dundas BI.
-
Process & Analyze Twitter Ads Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Twitter Ads Data.
-
Connect to Aircall Data in DBArtisan
Use wizards in DBArtisan to configure Aircall data as a data source.
-
Link SAP with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP data in Filemaker Pro for Mac or Windows.
-
Integrate with Impala Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Impala data to a JSON file on disk.
-
How to use SQLAlchemy ORM to access FTP Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of FTP data.
-
Connect to Outlook Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Outlook data.
-
Automated Continuous MariaDB Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable MariaDB replication to Apache Kafka.
-
Connect to Live Gmail Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Gmail in CData Connect AI and connect to your Gmail data from PostgreSQL.
-
Build Semantic Layer Views for Dynamics 365 Business Central Data in APOS Live Data Gateway
Use the CData Connector for Dynamics 365 Business Central in APOS Live Data Gateway to build Semantic Layer Views for Dynamics 365 Business Central data.
-
Automate ServiceNow Data Replication to Azure Data Lake
Use CData Sync to customize and automate ServiceNow data replication to Azure Data Lake.
-
Connect to Freshservice 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 Freshservice and work with Freshservice data in your FileMaker application.
-
How to Connect to & Open Quaderno Data in Microsoft Excel
This article uses the CData ODBC driver for Quaderno to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Open WebUI with Live Epicor Kinetic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Epicor Kinetic data from within the chat interface.
-
Bridge ZohoDesk Connectivity with Apache NiFi
Access and process ZohoDesk data in Apache NiFi using the CData JDBC Driver.
-
How to Connect to Live MySQL Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your MySQL data for you.
-
Build Data Flows from Active Directory to SQL Server using SSIS
Easily back up Active Directory data to SQL Server using the SSIS components for Active Directory.
-
Integrate with live Avalara AvaTax Data in Jitterbit
Use CData Connect AI to connect to and integrate live Avalara AvaTax data in Jitterbit.
-
Connect to Sybase Data from Crystal Reports
Use CData Connect AI to connect to and report on live Sybase data from Crystal Reports.