CData Software - Knowledge Base
Recent Articles
-
Use the CData ODBC Driver for Perigon from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Perigon to connect to Perigon data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Perigon data in Excel.
-
Connect to Simplesat Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Simplesat data using standard SQL.
-
Migrating data from Greenplum to Snowflake using CData SSIS Components.
Easily push Greenplum data to Snowflake using the CData SSIS Tasks for Greenplum and Snowflake.
-
Query SparkPost Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SparkPost data from Node.js.
-
Import Real-Time MailChimp Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use MailChimp data in ColdFusion.
-
Create Reports with Pinterest Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pinterest data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Bright Data
Provide connectivity to Bright Data data through an SAP BusinessObjects universe.
-
Integrate Google Ad Manager with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Ad Manager with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Ad Manager data.
-
Establish a Live Connection with MessageBird Data using Tableau Bridge
The CData ODBC Driver for MessageBird enables you to integrate live MessageBird data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to SAS xpt Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAS xpt data.
-
Connect to Oracle Service Cloud Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Oracle Service Cloud.
-
Visualize Oracle Eloqua Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Oracle Eloqua data.
-
Build SAP Netweaver Gateway Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP Netweaver Gateway data and build visualizations in Tableau Cloud.
-
Query MYOB AccountRight Data through ODBC in Node.js
Use node-odbc to execute SQL queries against MYOB AccountRight data from Node.js.
-
Visualize Live Microsoft Planner Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft Planner data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Oracle Eloqua-Connected Nintex Workflows
Use CData Connect AI to connect to Oracle Eloqua Data from Nintex Workflow Cloud and build custom workflows using live Oracle Eloqua data.
-
Create Data Visualizations in Cognos BI with Browserless Data
Access Browserless data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Model, Search, and Visualize Live EnterpriseDB Data in ThoughtSpot
Use CData Connect AI to connect to live EnterpriseDB data for modeling, searching, and visualizing.
-
Use the CData Software ODBC Driver for SendGrid in MicroStrategy Desktop
Connect to SendGrid data in MicroStrategy Desktop using the CData Software ODBC Driver for SendGrid.
-
Integrating Claude Code with Mode Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Mode data within assisted coding and automated development workflows.
-
Use the CData ODBC Driver for Stack Exchange in Microsoft Power Query
You can use the CData Stack Exchange ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Stack Exchange data into Microsoft Power Query.
-
Analyze Wave Financial Data in Looker
Use CData Connect AI to connect to Wave Financial Data from Looker and build custom apps using live Wave Financial data.
-
Connecting GenSpark with Cloudant Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Cloudant data without any replication or custom integration required.
-
Query SurveyMonkey Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SurveyMonkey entities in PHP by modeling them as objects.
-
Work with Live Shippo Data in Power Query
Use CData Connect AI to connect to Shippo data and work with live Shippo data in Microsoft Power Query.
-
Integrating Kiro with Float 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.
-
Automated Continuous GraphQL Replication to AlloyDB
Use CData Sync for automated, continuous, customizable GraphQL replication to AlloyDB.
-
Build Asana-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Asana data.
-
How to create an RPA flow for ElevenLabs Data in UiPath Studio
Use the ElevenLabs ODBC Driver to create workflows that access real-time ElevenLabs data without any coding.
-
Publish Crystal Reports on Dynamics 365 Business Central Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Dynamics 365 Business Central data.
-
Build Dashboards with REST Data in Dundas BI
Create dynamic dashboards and perform analytics based on REST data in Dundas BI.
-
Integrate Google's Antigravity Agent with Live SageHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SageHR data using the Model Context Protocol.
-
Bind Live HDFS Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live HDFS data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connect to Figshare Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Figshare and the SQL Gateway to access Figshare data from Google Apps Script.
-
Automated Continuous SAP HANA XS Advanced Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to delimited files (CSV/TSV).
-
Integrate Salesforce Marketing with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Salesforce Marketing with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Salesforce Marketing data.
-
Connect to Drip Data in CloverDX (formerly CloverETL)
Transfer Drip data using the visual workflow in the CloverDX data integration tool.
-
Integrating Claude Code CLI with VWO 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 SurveyMonkey Data in Python with CData
Create ETL applications and real-time data pipelines for SurveyMonkey data in Python with petl.
-
Search External QuickBooks Time Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of QuickBooks Time data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create QuickBooks Time Data objects that you can access from apps and the dashboard.
-
Connect to Unbounce Data in RapidMiner
Integrate Unbounce data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Microsoft OneLake Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to delimited files (CSV/TSV).
-
Connect to Amazon S3 Data in DBArtisan
Use wizards in DBArtisan to configure Amazon S3 data as a data source.
-
Automated Continuous Email Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Email replication to Apache Cassandra.
-
Connect to Zuora Data in Jaspersoft Studio
Execute SQL to remote Zuora data in Jaspersoft Studio.
-
Visualize Google Drive Data in TIBCO Spotfire through OData
Integrate Google Drive data into dashboards in TIBCO Spotfire.
-
Getting Started with the CData ODBC Driver for EnterpriseDB
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for EnterpriseDB.
-
Automate EmailOctopus Data Replication to SAP HANA
Use CData Sync to customize and automate EmailOctopus data replication to SAP HANA.
-
Analyze Certinia Data in Cognos Analytics
Use CData Connect AI to connect to Certinia Data from Cognos Analytics and analyze live Certinia data.
-
Automated Continuous Kintone Replication to Snowflake
Use CData Sync for automated, continuous, customizable Kintone replication to Snowflake.
-
Analyze OneNote Data in Cognos Analytics
Use CData Connect AI to connect to OneNote Data from Cognos Analytics and analyze live OneNote data.
-
How to Connect to Live Kafka 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 Kafka data without replication.
-
Migrating data from Amazon S3 to Snowflake using CData SSIS Components.
Easily push Amazon S3 data to Snowflake using the CData SSIS Tasks for Amazon S3 and Snowflake.
-
Build Semantic Layer Views for Codat Data in APOS Live Data Gateway
Use the CData Connector for Codat in APOS Live Data Gateway to build Semantic Layer Views for Codat data.
-
Natively Connect to Egnyte Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Egnyte data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Avro Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Avro replication to IBM DB2.
-
Migrating data from CapsuleCRM to Databricks using CData SSIS Components.
Easily push CapsuleCRM data to Databricks using the CData SSIS Tasks for CapsuleCRM and Databricks.
-
Build Automated Workflows with Live Outreach.io Data in Workato
Use CData Connect AI to connect to live Outreach.io data and build automated workflows in Workato.
-
Use the CData Software JDBC Driver for Vault CRM in MicroStrategy
Connect to Vault CRM data in MicroStrategy Developer using the CData Software JDBC Driver for Vault CRM.
-
Connect to Toggl Data from PowerBuilder via JDBC
This article demonstrates how to access Toggl data from PowerBuilder using the Toggl JDBC Driver.
-
Migrating data from Freshservice to Databricks using CData SSIS Components.
Easily push Freshservice data to Databricks using the CData SSIS Tasks for Freshservice and Databricks.
-
Use the CData ODBC Driver for SpaceX from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SpaceX to connect to SpaceX data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SpaceX data in Excel.
-
How to Build an ETL App for Sage Cloud Accounting Data in Python with CData Connect AI
Build ETL pipelines that read and write live Sage Cloud Accounting data in Python with petl and the CData Connect AI Python SDK.
-
Connect to Pingdom Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Pingdom as an External Source in Dremio.
-
Query Dynamics CRM Data in ColdFusion
Write standard ColdFusion data access code to connect to Dynamics CRM data.
-
Create Power BI Reports on Real-Time Bugsnag Data
Use the CData ODBC Driver for Bugsnag to visualize Bugsnag data in Power BI Desktop.
-
How to Connect the Power BI Service to Opsgenie: Complete Guide
Connect to the CData Software Power BI Connector for Opsgenie from PowerBI.com to provide real-time Opsgenie data across the organization.
-
Access Live Zoho Books 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 Zoho Books data through MCP integration.
-
Access Live EnterpriseDB Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live EnterpriseDB data from your Excel spreadsheets.
-
Connect to Cohere Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Cohere data.
-
DataBind Charts to Timely Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Timely data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Integrating GitHub Copilot with Gumroad 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.
-
Access Live Freshsales Data in AWS Lambda
Connect to live Freshsales data in AWS Lambda using the CData JDBC Driver.
-
Integrating LangChain with Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Apollo data within automated workflows.
-
Use Claude to Talk to Your ClickUp 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 ClickUp data for you.
-
Integrate Theia IDE with Live Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Azure Data Lake Storage data from within the development environment.
-
Build RSS-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live RSS feeds and build RSS-connected web apps with Axios.
-
Choosing the Best Method to Connect PDFMonkey to SQL Server: 5 Options Explained
Discover multiple ways to connect and use PDFMonkey data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Wave Financial Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Wave Financial replication to Google Cloud SQL.
-
Import Google Ad Manager Data Using Azure Data Factory
Use CData Connect AI to connect to Google Ad Manager Data from Azure Data Factory and import live Google Ad Manager data.
-
Connect to Raisers Edge NXT Data in NetBeans
Connect to Raisers Edge NXT data in NetBeans with the data source configuration wizard.
-
Replicate Multiple Rebilly Accounts via the CData Sync CLI
Replicate multiple Rebilly accounts to one or many databases.
-
Create Dashboards and Visualize Live BenchmarkEmail Data in Geckoboard
Use CData Connect AI to connect to live BenchmarkEmail data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate Reply.io with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Reply.io with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Reply.io data.
-
Analyze Excel Online Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Excel Online data in Microsoft R Open.
-
Use Grok to Talk to Your Dynamics 365 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 Dynamics 365 data for you.
-
Manage ZohoExpense Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ZohoExpense.
-
Prepare, Blend, and Analyze Google Drive Data in Alteryx Designer (ODBC)
Build workflows to access live Google Drive data for self-service data analytics.
-
Connect to Oracle from a Connection Pool in WebLogic
Use the CData JDBC Driver for Oracle to connect to Oracle data from Web applications running on WebLogic.
-
Getting Started with the CData ODBC Driver for Instantly
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Instantly.
-
Building Dynamic Web Pages with IBM Informix Data Using AngularJS
Create single-page applications with live connectivity to IBM Informix using the CData API Server.
-
Create Informatica Mappings From/To a JDBC Data Source for Klaviyo
Create Klaviyo data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Explore Geographical Relationships in Freshservice Data with Power Map
Create data visualizations with Freshservice data in Power Map.
-
How to Access LinkedIn Data Using Entity Framework
This article shows how to access LinkedIn data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate with CSV Data in SnapLogic
Use CData Connect AI to connect to and integrate with live CSV data in SnapLogic.
-
Build Office 365-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Office 365 Data and create custom apps in Mendix.
-
Visualize Raisers Edge NXT 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 Raisers Edge NXT data into TIBCO Spotfire.
-
Access Live Figshare Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Figshare data from your Excel spreadsheets.
-
Import SuiteCRM Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SuiteCRM Data and provide access to live SuiteCRM data for custom reports in the Power BI Service.
-
How to connect PolyBase to Front
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Front data.