CData Software - Knowledge Base
Recent Articles
-
Use Manus AI to Talk to Your Google Calendar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Google Calendar data.
-
Integrate Real-Time Access to SAP SuccessFactors LMS in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP SuccessFactors LMS data in real time.
-
Create Power BI Reports on Real-Time Keap Data
Use the CData ODBC Driver for Keap to visualize Keap data in Power BI Desktop.
-
Use the CData ODBC Driver for Oracle Service Cloud in Microsoft Power Query
You can use the CData Oracle Service Cloud ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Oracle Service Cloud data into Microsoft Power Query.
-
How to Connect to Live Kafka Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Kafka data for you.
-
Create Apps from Apify Data in Qlik Sense Cloud
Use CData Connect AI to connect to Apify Data and build apps from live Apify data in Qlik Sense Cloud.
-
Automated Continuous Oracle Eloqua Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Oracle Eloqua data replication to OneLake in Microsoft Fabric.
-
Integrating OpenCode with Pinterest 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 Access SuiteCRM Data Using Entity Framework
This article shows how to access SuiteCRM data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Query Google Ads Data in MySQL Workbench
Execute MySQL queries against live Google Ads data from MySQL Workbench.
-
Connecting Mastra with GitHub 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 GitHub data, no replication required.
-
Creating XML-Connected Applications in Unqork
You can use CData Connect AI to feed XML data to Unqork and build custom business apps.
-
Connect to PDFMonkey Data from a Connection Pool in JBoss
Integrate PDFMonkey data into Java servlets: Use the Management Console in JBoss to install the PDFMonkey JDBC Driver.
-
Connect to Blackbaud FE NXT Data in DBArtisan
Use wizards in DBArtisan to configure Blackbaud FE NXT data as a data source.
-
Use CData Connect AI to Access Freshteam Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Freshteam data in the Power Pivot business intelligence tool.
-
Connect to Dropbox Data from PowerBuilder via ADO.NET
This article demonstrates how to access Dropbox data from Appeon PowerBuilder using the CData ADO.NET Provider for Dropbox.
-
Visualize Superchat Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Superchat data.
-
Model Zoho Inventory Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Zoho Inventory, enabling the direct import of real-time Zoho Inventory data.
-
Create Customer.io Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Customer.io data access from reports, embedded analytics, and more.
-
Back Up SAP Hybris C4C data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP Hybris C4C. In this article, we will employ an SSIS workflow to populate a database with SAP Hybris C4C data data.
-
How to load HubDB data into Elasticsearch via Logstash
Introducing a simple method to load HubDB data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect to Live JSON Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live JSON services securely in real time.
-
Connect to Live Shopify Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Shopify in CData Connect AI and connect to your Shopify data from PostgreSQL.
-
Build Sentry-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Sentry data and build web apps with connectivity to live Sentry data.
-
Connect to Freshteam Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Freshteam data.
-
Integrate Float Data in the Pentaho Report Designer
Publish reports based on Float data in the Pentaho BI tool.
-
Automated Continuous CockroachDB Replication to Vertica
Use CData Sync for automated, continuous, customizable CockroachDB replication to Vertica.
-
Connect to Redshift Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Redshift to connect to Redshift data and execute queries in PowerBuilder.
-
Automated Continuous ZohoMarketingHub Replication to SQLite
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to SQLite.
-
ETL Microsoft Teams in Oracle Data Integrator
This article shows how to transfer Microsoft Teams data into a data warehouse using Oracle Data Integrator.
-
How to connect to ChartMogul Data in DBVisualizer
Integrate ChartMogul data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automate Customer.io Data Replication to Couchbase
Use CData Sync to Customize and automate Customer.io data replication to Couchbase.
-
Connect to Jira Assets Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Jira Assets Data and connect to Jira Assets data in Akorbi Digital RunMyProcess.
-
Create Twilio-Connected Nintex Workflows
Use CData Connect AI to connect to Twilio Data from Nintex Workflow Cloud and build custom workflows using live Twilio data.
-
Build Apps with Live Azure Data Lake Storage Data Using the Low-Code Development Platform of Mendix
Connect Azure Data Lake Storage data with Mendix to build apps using the CData JDBC Driver for Azure Data Lake Storage.
-
Build HubDB-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for HubDB Data and create custom apps in Bubble.
-
Use the CData Software ODBC Driver for AdRoll in MicroStrategy Web
Connect to AdRoll data in MicroStrategy Web using the CData Software ODBC Driver for AdRoll.
-
Connect Azure DevOps to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Azure DevOps data using the CData Python MCP Server.
-
Integrate with live Salesforce Data in Jitterbit
Use CData Connect AI to connect to and integrate live Salesforce data in Jitterbit.
-
Integrate Real-Time Access to Outreach.io in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Outreach.io data in real time.
-
Use ChatGPT to Talk to Your Klaviyo 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 Klaviyo data for you.
-
How to Access Slack Data Using Entity Framework
This article shows how to access Slack data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrating Antigravity CLI with CampaignMonitor data via CData CLI
Connect CampaignMonitor data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize SAP HANA XS Advanced Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load SAP HANA XS Advanced data into TIBCO Spotfire.
-
Automated Continuous ZohoMarketingHub Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to Amazon Redshift.
-
Build AI/ML Models with Live Superchat Data using Dataiku
Connect Superchat Data with Dataiku using the CData API Driver for JDBC.
-
Access Gorgias Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Gorgias data from HeidiSQL.
-
Connect and Visualize Live ZohoSubscriptions Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live ZohoSubscriptions data into the Databricks platform and create visualization dashboards with real-time ZohoSubscriptions data.
-
Guru Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Guru data through CData Connect AI using different applications and tools.
-
Operational Reporting on RSS Feeds from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote RSS feeds.
-
Integrating Gumloop with ZohoMarketingHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on ZohoMarketingHub data within automated workflows.
-
Connect to Apify Data in RapidMiner
Integrate Apify data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Reckon Accounts Hosted with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Reckon Accounts Hosted with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Reckon Accounts Hosted data.
-
Connect to Live SAP Fieldglass Data in MicroStrategy through CData Connect AI
Create a live connection to SAP Fieldglass Data in CData Connect AI and connect to your SAP Fieldglass data from MicroStrategy.
-
Integrate Trae with Live ActiveCampaign Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live ActiveCampaign data from within the AI-powered IDE.
-
How to Work with Keap Data in ETL Validator JDBC
Connect to Keap from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Epicor Kinetic Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Epicor Kinetic data replication to OneLake in Microsoft Fabric.
-
Build Semantic Layer Views for ChargeOver Data in APOS Live Data Gateway
Use the CData Connector for ChargeOver in APOS Live Data Gateway to build Semantic Layer Views for ChargeOver data.
-
Getting Started with the CData Python Connector for Codat
Learn to install and license the CData Python Connector and configure a connection to live Codat data.
-
Connect to DocuSign Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for DocuSign data.
-
Access Live FTP Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live FTP data from your Excel spreadsheets.
-
Automated Continuous Neo4J Replication to SQL Server
Use CData Sync for automated, continuous, customizable Neo4J replication to SQL Server.
-
Replicate Yelp Data in Heroku for Use in Salesforce Connect
Replicate Yelp data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Cvent Replication to MySQL
Use CData Sync for automated, continuous, customizable Cvent replication to MySQL.
-
How to Connect the Power BI Service to OData: Complete Guide
Connect to the CData Software Power BI Connector for OData from PowerBI.com to provide real-time OData services across the organization.
-
Build Semantic Layer Views for Oracle HCM Cloud Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Oracle HCM Cloud data.
-
Automated Pingdom Data Replication to Teradata
Use CData Sync to Customize and automate Pingdom data replication to Teradata.
-
How to connect PolyBase to ScrapingBee
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ScrapingBee data.
-
How to Connect to Live Jira 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 Jira data without replication.
-
Connect to SAP BusinessObjects BI Data in Aqua Data Studio
Access SAP BusinessObjects BI data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Easily Integrate Oracle HCM Cloud Data in Lazarus Pascal IDE
Learn how to easily integrate live Oracle HCM Cloud data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating Cursor with Office 365 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.
-
Analyze Vimeo Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Vimeo data in Microsoft R Open.
-
How to integrate Metabase with Microsoft Planner Data
Use CData Connect AI to connect to live Microsoft Planner data and create an interactive dashboard in Metabase from Microsoft Planner data.
-
Access Live Stripe Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Stripe data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Real-Time SuiteCRM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SuiteCRM and Dataflow to import and use SuiteCRM data in Power Apps.
-
Integrating GitHub Copilot with SurveyMonkey 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 Miro to Databricks using CData SSIS Components.
Easily push Miro data to Databricks using the CData SSIS Tasks for Miro and Databricks.
-
Build an OLAP Cube in SSAS from Parallel Data
Establish a connection to Parallel data data from SQL Server Analysis Services, and use the Parallel Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Cloudant with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Cloudant with External Services.
-
How to Connect to & Open Workable Data in Microsoft Excel
This article uses the CData ODBC driver for Workable to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Box with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Box with External Services.
-
How to use SQLAlchemy ORM to access Google Ad Manager Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Ad Manager data.
-
Create Apps from Active Directory Data in Qlik Sense Cloud
Use CData Connect AI to connect to Active Directory Data and build apps from live Active Directory data in Qlik Sense Cloud.
-
Access Act CRM Data from MySQL in PHP
Connect to Act CRM through the standard MySQL libraries in PHP.
-
Build Pipelines with Live Jumpseller Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Jumpseller from Google Cloud Data Fusion, enabling the integration of live Jumpseller data into the building and management of effective data pipelines.
-
How to integrate Metabase with Epicor Kinetic Data
Use CData Connect AI to connect to live Epicor Kinetic data and create an interactive dashboard in Metabase from Epicor Kinetic data.
-
Work with LinkedIn Data in FoxPro
Load LinkedIn data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Deploy the ADO.NET Provider for Printify on an SSRS Report Server
Connect to Printify data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect to SharePoint from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SharePoint data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Enable the Gong JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Gong data.
-
Using the CData Software ODBC Driver for Timely in PyCharm
Connect to Timely as an ODBC data source in PyCharm using the CData Software ODBC Driver for Timely.
-
Create Informatica Mappings From/To a JDBC Data Source for Freshdesk
Create Freshdesk data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Datadog Data in CloverDX (formerly CloverETL)
Transfer Datadog data using the visual workflow in the CloverDX data integration tool.
-
Build Apps with Live Adobe Target data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Adobe Target data into the Adalo platform and build custom mobile and web applications with real-time Adobe Target data.
-
Replicate Multiple LaunchDarkly Accounts
Replicate multiple LaunchDarkly accounts to one or many databases.
-
Migrating data from Facebook Ads to Google BigQuery using CData SSIS Components.
Easily push Facebook Ads data to Google BigQuery using the CData SSIS Tasks for Facebook Ads and Google BigQuery.
-
Build a Simple VCL Application for Bugsnag Data
How to build a simple VCL Application to view Bugsnag data in RAD Studio using the CData ODBC Driver for Bugsnag.
-
Getting Started with the CData ADO.NET Provider for Discourse
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Use Databricks Agent Bricks to Talk to Your Microsoft Dataverse Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Microsoft Dataverse data for you.