CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Bullhorn CRM Replication to MySQL
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to MySQL.
-
Access Parallel Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Parallel data from HeidiSQL.
-
Visualize Oracle HCM Cloud Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Oracle HCM Cloud data.
-
Automated Continuous Google Sheets Replication to Snowflake
Use CData Sync for automated, continuous, customizable Google Sheets replication to Snowflake.
-
Build SAS Data Sets-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAS Data Sets data and build web apps with connectivity to live SAS Data Sets data.
-
Automated Continuous PabblySubscriptions Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Apache Cassandra.
-
Automated Continuous MailChimp Replication to MySQL
Use CData Sync for automated, continuous, customizable MailChimp replication to MySQL.
-
Query Front Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Front data from Node.js.
-
Connect to Shippo Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Shippo data.
-
Access Google Contacts Data from MySQL in PHP
Connect to Google Contacts through the standard MySQL libraries in PHP.
-
Build Dashboards with Sage Cloud Accounting Data in Dundas BI
Create dynamic dashboards and perform analytics based on Sage Cloud Accounting data in Dundas BI.
-
Access Live Monday.com Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Monday.com data from your Excel spreadsheets.
-
Integrate Google Spanner Data in the Pentaho Report Designer
Publish reports based on Google Spanner data in the Pentaho BI tool.
-
Analyze SparkPost Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SparkPost data and visualize SparkPost data in SAP Analytics Cloud.
-
Access Live Optimizely Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Optimizely data from your Excel spreadsheets.
-
How to connect PolyBase to LinkedIn
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live LinkedIn data.
-
Easily Integrate Zoho Creator Data in Lazarus Pascal IDE
Learn how to easily integrate live Zoho Creator data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Live Pipedrive Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Pipedrive data from within the IDE.
-
Connect to LinkedIn Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for LinkedIn and the Script function in FileMaker Pro to connect to LinkedIn and work with LinkedIn data in your FileMaker application.
-
Use the CData ODBC Driver for ZohoDesk from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ZohoDesk to connect to ZohoDesk data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ZohoDesk data in Excel.
-
How to Connect the Power BI Service to SharePoint Excel Services: Complete Guide
Connect to the CData Software Power BI Connector for SharePoint Excel Services from PowerBI.com to provide real-time SharePoint Excel Services data across the organization.
-
Create Informatica Mappings From/To a JDBC Data Source for Flowlu
Create Flowlu data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Provide OData Services of Oracle Eloqua Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Oracle Eloqua data by developing a WCF Service Application.
-
How to connect to Cosmos DB Data with Squirrel SQL client
Connect to Cosmos DB data and execute queries in the Squirrel SQL Client.
-
Connect to PhantomBuster in SpagoBI
Create reports featuring live PhantomBuster data in SpagoBI Studio. Host PhantomBuster reports on SpagoBI Server.
-
How to Connect to Live Sybase 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 Sybase data for you.
-
Query Google Analytics Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Analytics data from Node.js.
-
Integrating Cursor with Google Translate 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 Build an ETL App for Oracle HCM Cloud Data in Python with CData Connect AI
Extract and transform live Oracle HCM Cloud data in Python with petl and the CData Connect AI Python SDK.
-
Replicate Multiple Pipeline CRM Accounts
Replicate multiple Pipeline CRM accounts to one or many databases.
-
Build Apps with Live Email data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Email data into the Adalo platform and build custom mobile and web applications with real-time Email data.
-
Build Microsoft OneDrive-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft OneDrive data.
-
Connect to DB2 Data in Ruby
Connect to DB2 data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to LeadDesk Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time LeadDesk data using standard SQL.
-
How to Work with Mixpanel Data in ETL Validator JDBC
Connect to Mixpanel from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData JDBC Driver for FTP
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for FTP.
-
Integrating Gumloop with AgileCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on AgileCRM data within automated workflows.
-
Integrate Devin with Live Vertica Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Vertica data.
-
Automate FHIR Data Replication to Couchbase
Use CData Sync to Customize and automate FHIR data replication to Couchbase.
-
Replicate Multiple Jira Accounts
Replicate multiple Jira accounts to one or many databases.
-
Connect to Paymo Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Paymo Data and connect to Paymo data in Akorbi Digital RunMyProcess.
-
Use the CData Software ODBC Driver for Vercel in MicroStrategy Web
Connect to Vercel data in MicroStrategy Web using the CData Software ODBC Driver for Vercel.
-
Connect to GitLab Data from AWS Glue
Use CData Connect AI to gain access to live GitLab data from your AWS Glue jobs.
-
View Reports on Real-Time Procore Data in Power BI Report Server
Use the CData ODBC Driver for Procore to visualize Procore data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to import Onfleet Data into Apache Solr
Use the CData Software JDBC Driver for Onfleet in Data Import Handler and create an automated import of Onfleet data to Apache Solr Enterprise Search platform.
-
Getting Started with the CData ADO.NET Provider for PhantomBuster
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Samanage Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Samanage data through CData Connect AI using different applications and tools.
-
Create Power BI Reports on Real-Time Bitbucket Data
Use the CData ODBC Driver for Bitbucket to visualize Bitbucket data in Power BI Desktop.
-
Use the CData Software ODBC Driver for MessageBird in MicroStrategy Desktop
Connect to MessageBird data in MicroStrategy Desktop using the CData Software ODBC Driver for MessageBird.
-
Connect to Klipfolio Data in Jaspersoft Studio
Execute SQL to remote Klipfolio data in Jaspersoft Studio.
-
Access Live Zoho CRM Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Zoho CRM data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build CouchDB-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 CouchDB data without replication.
-
How to Access Google Translate Data Using Entity Framework
This article shows how to access Google Translate data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Marketo Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Marketo Data and connect to Marketo data in Akorbi Digital RunMyProcess.
-
Create Data Visualizations in Cognos BI with Adobe Target Data
Access Adobe Target data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live Amazon DynamoDB 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 Amazon DynamoDB data through MCP integration.
-
Create Reports from Salesforce CRM Analytics Data in Looker Studio
Use CData Connect AI to gain access to live Salesforce CRM Analytics data and create custom reports in Looker Studio.
-
How to Work with SAP BusinessObjects BI Data in ETL Validator JDBC
Connect to SAP BusinessObjects BI from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate OpenCode with Live Email Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Email data from within your AI coding agent.
-
Connect to Optimizely Data in Ruby
Connect to Optimizely data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Visualize Salesforce Data 360 Data in Python with pandas
Use pandas and other modules to analyze and visualize live Salesforce Data 360 data in Python.
-
Use Biml to Build SSIS Tasks to Replicate Stack Exchange Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Stack Exchange data to SQL Server.
-
Connect to REST Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for REST to connect to REST data and execute queries in PowerBuilder.
-
Operational Reporting on SendPulse Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SendPulse data.
-
How to connect SharePoint with xBase Data through external lists
Provide xBase data to SharePoint users as an external list.
-
Access Google Campaign Manager 360 Data from MySQL in Amazon QuickSight
Connect to Google Campaign Manager 360 and build visualizations of Google Campaign Manager 360 data using a MySQL Connection in Amazon QuickSight.
-
Integrating Antigravity CLI with Salesforce data via CData CLI
Connect Salesforce data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Publish Reports with Microsoft Entra ID Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Entra ID data.
-
Process & Analyze HBase Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live HBase Data.
-
Build Automated Workflows with Live Amazon Athena Data in Workato
Use CData Connect AI to connect to live Amazon Athena data and build automated workflows in Workato.
-
Automated Continuous Jira Replication to Databricks
Use CData Sync for automated, continuous, customizable Jira replication to Databricks.
-
Build Sendwithus-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 Sendwithus data without replication.
-
Connecting Moonlit Workflow with Stripe Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Stripe data in real time.
-
Publish Reports with Zoho Inventory Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoho Inventory data.
-
Query SharePoint Data as a SQL Server Database in Node.js
Execute SQL Server queries against SharePoint data from Node.js.
-
Connect to and Query Wistia Data in QlikView over ODBC
Create data visualizations with Wistia data in QlikView.
-
Integrate Live Parallel Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Parallel data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Access Templated Data Using Entity Framework
This article shows how to access Templated data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Live ActiveCampaign Data in MicroStrategy through CData Connect AI
Create a live connection to ActiveCampaign Data in CData Connect AI and connect to your ActiveCampaign data from MicroStrategy.
-
Build Clockify-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Clockify data.
-
Connect to Square Data in Jaspersoft Studio
Execute SQL to remote Square data in Jaspersoft Studio.
-
Automated Google Spanner Data Replication to Teradata
Use CData Sync to Customize and automate Google Spanner data replication to Teradata.
-
Create Sybase IQ-Connected Business Apps in AppSheet
Connect to Sybase IQ Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Sybase IQ data.
-
How to Access SAP Business Warehouse Data Using Entity Framework
This article shows how to access SAP Business Warehouse data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData ODBC Driver for MailChimp
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for MailChimp.
-
Integrate LightSpeedRetail with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate LightSpeedRetail with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to LightSpeedRetail data.
-
Connect to Webflow from a Connection Pool in WebLogic
Use the CData JDBC Driver for Webflow to connect to Webflow data from Web applications running on WebLogic.
-
Connect to Azure DevOps from a Connection Pool in WebLogic
Use the CData JDBC Driver for Azure DevOps to connect to Azure DevOps data from Web applications running on WebLogic.
-
Rapidly Develop XML-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by XML.
-
Analyze Telegram Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Telegram data in Microsoft R Open.
-
Integrating OpenCode with SAP Hybris C4C 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 LibreChat with Live ShipStation Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live ShipStation data from within the chat interface.
-
Getting Started with the CData JDBC Driver for Salesforce CRM Analytics
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Salesforce CRM Analytics.
-
Connect to SAP SuccessFactors Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP SuccessFactors data in the Denodo Virtual DataPort Administrator.
-
Create Apps from Reckon Data in Qlik Sense Cloud
Use CData Connect AI to connect to Reckon Data and build apps from live Reckon data in Qlik Sense Cloud.
-
Work with Live SQL Analysis Services Data in Power Query
Use CData Connect AI to connect to SQL Analysis Services data and work with live SQL Analysis Services data in Microsoft Power Query.
-
Operational Reporting on Datadog Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Datadog data.
-
Prepare, Blend, and Analyze Accelo Data in Alteryx Designer (ODBC)
Build workflows to access live Accelo data for self-service data analytics.
-
How to load Slack data into Elasticsearch via Logstash
Introducing a simple method to load Slack data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Query DocuSign Data in ColdFusion
Write standard ColdFusion data access code to connect to DocuSign data.