CData Software - Knowledge Base
Recent Articles
-
Migrating data from Everhour to Snowflake using CData SSIS Components.
Easily push Everhour data to Snowflake using the CData SSIS Tasks for Everhour and Snowflake.
-
Visualize Live Microsoft Ads Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft Ads data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connecting Agentforce with SAP Hybris C4C 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 SAP Hybris C4C data for you.
-
Getting Started with the CData ODBC Driver for GetResponse
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for GetResponse.
-
Integrate Email Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Email data and integrate live Email data into your Power Automate tasks.
-
Import Real-Time Humanity Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Humanity data in ColdFusion.
-
Integrate Live Office 365 Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Office 365 from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Office 365 data.
-
Access Todoist Data from MySQL in PHP
Connect to Todoist through the standard MySQL libraries in PHP.
-
How to Connect to & Open Oracle Financials Cloud Data in Microsoft Excel
This article uses the CData ODBC driver for Oracle Financials Cloud to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use JayDeBeApi to access Pingdom Data in Python
Use standard Python scripting and the development environment of your choice to access live Pingdom data.
-
Add Snapchat Ads Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Snapchat Ads with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Voice Agents in ElevenLabs with access to Live NetSuite Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live NetSuite data.
-
Query Drip Data in DataGrip
Create a Data Source for Drip in DataGrip and use SQL to query live Drip data.
-
Import Real-Time ShipStation Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ShipStation data in ColdFusion.
-
How to connect to ZohoSubscriptions Data from IntelliJ
Integrate connectivity to ZohoSubscriptions data with wizards in IntelliJ.
-
Connecting Mastra with SAS xpt Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time SAS xpt data, no replication required.
-
Connect QuickBooks Online to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect QuickBooks Online with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Couchbase 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 Couchbase data.
-
Build WordPress-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for WordPress Data and create custom apps in Mendix.
-
Bridge Cassandra Connectivity with Apache NiFi
Access and process Cassandra data in Apache NiFi using the CData JDBC Driver.
-
How to Connect to Live Snowflake Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Snowflake data for you.
-
Build Freshdesk-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Freshdesk data.
-
Connect to Live Smartsheet Data in MicroStrategy through CData Connect AI
Create a live connection to Smartsheet Data in CData Connect AI and connect to your Smartsheet data from MicroStrategy.
-
Operational Reporting on LaunchDarkly Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote LaunchDarkly data.
-
How to Easily Query AlloyDB Data in OpenOffice Base
Connect to AlloyDB data in OpenOffice Base using the CData ODBC Driver for AlloyDB and generate reports with live data insights.
-
Create Reports with SAS Data Sets Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAS Data Sets data.
-
Connect to Float Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Float and the SQL Gateway to access Float data from Google Apps Script.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Demio
Provide connectivity to Demio data through an SAP BusinessObjects universe.
-
Connecting Agentforce with Jumpseller 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 Jumpseller data for you.
-
How to Query Live IBM Cloud Object Storage Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live IBM Cloud Object Storage data data in natural language using Python.
-
Connect to Amazon Marketplace Data in JRuby
Create a simple JRuby app with access to live Amazon Marketplace data.
-
Connect to Freshteam in SpagoBI
Create reports featuring live Freshteam data in SpagoBI Studio. Host Freshteam reports on SpagoBI Server.
-
Use the CData Software ODBC Driver for Google Search in MicroStrategy
Connect to Google Search results in MicroStrategy Developer using the CData Software ODBC Driver for Google Search.
-
How to connect Amazon QuickSight to Google Drive Data
Create a connection to Google Drive data in CData Connect AI and insert Google Drive data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Connect to Live Xero 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 Xero data for you.
-
Create Dynamic Mouseflow Grids Using the Infragistics XamDataGrid
Learn how you can connect Mouseflow to Infragistics XamDataGrid to build dynamic grids.
-
Create a Data Access Object for Customer.io Data using JDBI
A brief overview of creating a SQL Object API for Customer.io data in JDBI.
-
Query, Visualize, and Share live Exa Data in Redash
Use CData Connect AI to connect to live Exa data in Redash for querying, visualizing, and sharing.
-
Connect to Cassandra from Asprova with CData Software ODBC Driver for Cassandra
This article shows how to connect faster to Cassandra data from Asprova.
-
Automate Drip Data Replication to Azure Data Lake
Use CData Sync to customize and automate Drip data replication to Azure Data Lake.
-
Automated Continuous Todoist Replication to Databricks
Use CData Sync for automated, continuous, customizable Todoist replication to Databricks.
-
DataBind Controls to ZohoSubscriptions Data in Delphi
DataBind to ZohoSubscriptions data in Delphi with standard data access components and controls.
-
View Reports on Real-Time HelloSign Data in Power BI Report Server
Use the CData ODBC Driver for HelloSign to visualize HelloSign data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect to Live Zoho Inventory 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 Zoho Inventory data for you.
-
Connect to Gong Data in CloverDX (formerly CloverETL)
Transfer Gong data using the visual workflow in the CloverDX data integration tool.
-
Natively Connect to Close Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Close data. Leverage the native support for ODBC in PHP.
-
Extract, Transform, and Load Attio Data in Informatica PowerCenter
Create a simple Workflow for Attio data in Informatica PowerCenter.
-
Access Clari Data from MySQL in Amazon QuickSight
Connect to Clari and build visualizations of Clari data using a MySQL Connection in Amazon QuickSight.
-
How to Visualize Oracle Sales Data in Python with pandas
Use pandas and other modules to analyze and visualize live Oracle Sales data in Python.
-
Link Hugging Face with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Hugging Face data in Filemaker Pro for Mac or Windows.
-
Analyze PayPal Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of PayPal data and visualize live PayPal data in Infragistics Reveal.
-
Getting Started with the CData Tableau Connector for Google Translate
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Bridge PDFMonkey Connectivity with Apache NiFi
Access and process PDFMonkey data in Apache NiFi using the CData JDBC Driver.
-
Analyze Live IBM Informix Data in SAS Viya
Use CData Connect AI to connect to IBM Informix data from SAS Viya and deploy self-service analytics using live IBM Informix data.
-
Bridge ZohoInvoice Connectivity with Apache NiFi
Access and process ZohoInvoice data in Apache NiFi using the CData JDBC Driver.
-
Getting Started with the CData JDBC Driver for Reckon Accounts Hosted
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Reckon Accounts Hosted.
-
Connecting Pipedream with Stripe 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 Stripe data in real time.
-
Query MarkLogic Data as a SQL Server Database in Node.js
Execute SQL Server queries against MarkLogic data from Node.js.
-
Automated Continuous Yelp Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Yelp data replication to OneLake in Microsoft Fabric.
-
Feed LDAP Objects into FineReport
How to set LDAP objects as a JDBC data source in FineReport.
-
How to Access Browserless Data Using Entity Framework
This article shows how to access Browserless data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Connect DBeaver to Spark via a JDBC Driver
Manage Spark data with visual tools in DBeaver like the query browser.
-
Connect to Sugar CRM Data from PowerBuilder via ADO.NET
This article demonstrates how to access Sugar CRM data from Appeon PowerBuilder using the CData ADO.NET Provider for Sugar CRM.
-
Connect to Printify Data in DBeaver
Use the CData ODBC Driver to connect to Printify data in DBeaver.
-
Configure the CData JDBC Driver for MySQL in a Connection Pool in Tomcat
Connect to MySQL data from a connection pool in Tomcat.
-
Integrate LibreChat with Live SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SurveyMonkey data from within the chat interface.
-
Build Dashboards with Teamgate Data in DBxtra
Create dynamic dashboards and perform analytics based on Teamgate data in DBxtra.
-
Connect to Google Contacts Data from a Connection Pool in Jetty
The Google Contacts JDBC Driver supports connection pooling: This article shows how to connect faster to Google Contacts data from Web apps in Jetty.
-
Automated Continuous Aha! Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Aha! replication to delimited files (CSV/TSV).
-
Analyze Parallel Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Parallel data in Microsoft R Open.
-
Connect to Salesforce Data 360 Data in Aqua Data Studio
Access Salesforce Data 360 data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Import Mode Data Using Azure Data Factory
Use CData Connect AI to connect to Mode Data from Azure Data Factory and import live Mode data.
-
Load Jira Assets Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Jira Assets data to a database.
-
Enable the Jira Assets JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Jira Assets data.
-
How to Create Power BI Visual Reports with Real-Time Google Drive Data
Use CData Power BI Connectors to visualize Google Drive data in Power BI.
-
Create QuickBooks Time-Connected Dashboards in Grafana
Connect to QuickBooks Time Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to QuickBooks Time data.
-
Query NASA Data through ODBC in Node.js
Use node-odbc to execute SQL queries against NASA data from Node.js.
-
Connect to Rebilly Data in NetBeans
Connect to Rebilly data in NetBeans with the data source configuration wizard.
-
Replicate Multiple Email Accounts
Replicate multiple Email accounts to one or many databases.
-
DataBind Cassandra Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Cassandra with the DevExpress Windows Forms and Web controls to provide Cassandra data to a chart.
-
Build Voice Agents in ElevenLabs with access to Live Sybase Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Sybase data.
-
Connect Brex to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Brex data using the CData Python MCP Server.
-
Connect to Nethunt Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Nethunt data.
-
Use the CData ODBC Driver for IBM Cloud Object Storage from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for IBM Cloud Object Storage to connect to IBM Cloud Object Storage data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring IBM Cloud Object Storage data in Excel.
-
Connect to Asana Data in RapidMiner
Integrate Asana data with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Dashboards with Perplexity Data in DBxtra
Create dynamic dashboards and perform analytics based on Perplexity data in DBxtra.
-
Build Pipelines with Live Yelp Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Yelp from Google Cloud Data Fusion, enabling the integration of live Yelp data into the building and management of effective data pipelines.
-
Use the CData Software ODBC Driver for MailChimp in MicroStrategy Web
Connect to MailChimp data in MicroStrategy Web using the CData Software ODBC Driver for MailChimp.
-
Object-Relational Mapping (ORM) with Google Ads 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 Ads data into a Java-based ORM framework, Hibernate.
-
Automated Continuous Excel Replication to MySQL
Use CData Sync for automated, continuous, customizable Excel replication to MySQL.
-
Use Microsoft Copilot Studio to talk to your SFTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your SFTP data for you.
-
Connecting Mastra with Quickbase Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Quickbase data, no replication required.
-
Automate Tally Data Replication to Couchbase
Use CData Sync to Customize and automate Tally data replication to Couchbase.
-
Getting Started with the CData JDBC Driver for Notion
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Notion.
-
Replicate Multiple Certinia Accounts via the CData Sync CLI
Replicate multiple Certinia accounts to one or many databases.
-
Work with ConvertKit Data in FoxPro
Load ConvertKit data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Real-Time Phoenix Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Phoenix and Dataflow to import and use Phoenix data in Power Apps.
-
Query, Visualize, and Share live Bitbucket Data in Redash
Use CData Connect AI to connect to live Bitbucket data in Redash for querying, visualizing, and sharing.
-
A PostgreSQL Interface for Workday Data (MySQL Remoting via JDBC)
Use the Remoting features of the Workday JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Oracle HCM Cloud Replication to SingleStore
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to SingleStore.