CData Software - Knowledge Base
Recent Articles
-
Automate Moosend Data Replication to Couchbase
Use CData Sync to Customize and automate Moosend replication to Couchbase.
-
Using the CData Software ODBC Driver for Oracle in PyCharm
Connect to Oracle as an ODBC data source in PyCharm using the CData Software ODBC Driver for Oracle.
-
Choosing the Best Method to Connect SendPulse to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SendPulse from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Publish Reports with Short.io Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Short.io.
-
Build Dashboards with Chargebee Data in DBxtra
Create dynamic dashboards and perform analytics based on Chargebee in DBxtra.
-
Access Live Email Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Email from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Replicate Hubstaff Data to Multiple Databases
Replicate Hubstaff to disparate databases with a point-and-click configuration.
-
Connect to Sentry Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Sentry and work with Sentry in your FileMaker applications.
-
Validate Klaviyo Data with QuerySurge
Access and validate Klaviyo in QuerySurge using the CData JDBC Driver.
-
Connect to Gmail Data in DBeaver
Use the CData ODBC Driver to connect to Gmail in DBeaver.
-
Access Live Dynamics 365 Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft Dynamics 365 into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Dynamics 365 in the Graph Builder and Query Builder.
-
Using the CData Software ODBC Driver for Attio in PyCharm
Connect to Attio as an ODBC data source in PyCharm using the CData Software ODBC Driver for Attio.
-
Object-Relational Mapping (ORM) with Bugsnag 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 Bugsnag into a Java-based ORM framework, Hibernate.
-
Visualize Vimeo Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Vimeo.
-
How to Access Live Azure Data Lake Storage Data in Visual Studio Code via Cline
Run CData MCP Server for Azure Data Lake Storage on Windows Subsytem for Linux (WSL) and connect to live Azure Data Lake Storage from the Cline extension in Visual Studio Code.
-
Bridge Act-On Connectivity with Apache NiFi
Access and process Act-On in Apache NiFi using the CData JDBC Driver.
-
Work with Live Azure Data Lake Storage Data in Power Query
Use CData Connect AI to connect to Azure Data Lake Storage and work with live Azure Data Lake Storage in Microsoft Power Query.
-
Connect to Short.io Data from a Connection Pool in Jetty
The Short.io JDBC Driver supports connection pooling: This article shows how to connect faster to Short.io from Web apps in Jetty.
-
Explore Geographical Relationships in Browserless Data with Power Map
Create data visualizations with Browserless in Power Map.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live BambooHR using the Model Context Protocol.
-
Build AI/ML Models with Live Pinterest Data using Dataiku
Connect Pinterest Data with Dataiku using the CData JDBC Driver for Pinterest.
-
How to work with Adobe Experience Manager Data in Apache Spark using SQL
Access and process Adobe Experience Manager Data in Apache Spark using the CData Software JDBC Driver.
-
Bridge Jumpseller Connectivity with Apache NiFi
Access and process Jumpseller in Apache NiFi using the CData JDBC Driver.
-
How to import Azure DevOps Data into Apache Solr
Use the CData Software JDBC Driver for Azure DevOps in Data Import Handler and create an automated import of Azure DevOps to Apache Solr Enterprise Search platform.
-
Bridge Pipedrive Connectivity with Apache NiFi
Access and process Pipedrive in Apache NiFi using the CData JDBC Driver.
-
Connect to Wave Financial Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Wave Financial in the Denodo Virtual DataPort Administrator.
-
Visualize Live HBase Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Apache HBase into custom reports in Power BI.
-
Integrating Antigravity CLI with Hugging Face via CData CLI
Connect Hugging Face to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Work with Smartsheet Data in AWS Glue Jobs Using JDBC
Connect to Smartsheet from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
LINQ to NASA Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the NASA Data Provider.
-
How to Query Live ConvertAPI Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ConvertAPI data in natural language using Python.
-
Automated Continuous Monday.com Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Monday.com replication to Google Cloud SQL.
-
Connect to Egnyte from a Connection Pool in WebLogic
Use the CData JDBC Driver for Egnyte to connect to Egnyte from Web applications running on WebLogic.
-
How to Connect Flowise AI Agents to Live SQL Server 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 Microsoft SQL Server without replication.
-
Visualize Wistia Data in TIBCO Spotfire through ADO.NET
Integrate Wistia into dashboards in TIBCO Spotfire.
-
Use the CData ODBC Driver for JotForm from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for JotForm to connect to JotForm from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring JotForm in Excel.
-
Extract, Transform, and Load Tanda Data in Informatica PowerCenter
Create a simple Workflow for Tanda in Informatica PowerCenter.
-
Query Adobe Analytics Data as a MySQL Database in Node.js
Execute MySQL queries against Adobe Analytics from Node.js.
-
Create Informatica Mappings From/To an ODBC Data Source for Bannerbear
Create an ODBC connection to Bannerbear in Informatica and browse and transfer Bannerbear.
-
Create Informatica Mappings From/To a JDBC Data Source for REST
Create REST data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Getting Started with the CData JDBC Driver for Phoenix
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Phoenix.
-
How to Access Google Spanner Data Using Entity Framework
This article shows how to access Google Spanner using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Replicate PabblySubscriptions Data from PowerShell
Write a quick PowerShell script to query PabblySubscriptions. Use connectivity to the live data to replicate PabblySubscriptions to SQL Server.
-
Automated Continuous Neo4J Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Neo4J replication to Amazon S3.
-
Build DocuSign-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for DocuSign to explore live DocuSign Data in GitHub Copilot to assist with building DocuSign-powered applications.
-
Connect to SAP BusinessObjects BI from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP BusinessObjects BI, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Access Jira Assets Data from MySQL in Amazon QuickSight
Connect to Jira Assets and build visualizations of Jira Assets using a MySQL Connection in Amazon QuickSight.
-
Build MVC Applications with Connectivity to LightSpeedRetail Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access LightSpeedRetail from an ASP.NET MVC application.
-
Access Live Google Drive Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Drive from your Google Sheets.
-
Create Data Visualizations in Cognos BI with Printful Data
Access Printful as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to and Query SAP ByDesign Data in QlikView over ODBC
Create data visualizations with SAP Business ByDesign in QlikView.
-
Connect to Oracle Financials Cloud Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Oracle Financials Cloud Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Connect DBeaver to Amazon DynamoDB via a JDBC Driver
Manage Amazon DynamoDB with visual tools in DBeaver like the query browser.
-
Integrate Cline with Live Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Dynamics CRM from within your IDE.
-
Add Autopilot Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Autopilot with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous FormSite Replication to AlloyDB
Use CData Sync for automated, continuous, customizable FormSite replication to AlloyDB.
-
Connect to LinkedIn Ads Data in ACL Analytics
Connect to LinkedIn Ads via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to LinkedIn Ads.
-
Connect to and Visualize Live Mixpanel Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Mixpanel.
-
How to create Visio diagrams from Access Data
Automatically update Microsoft Access with the changes you make to Visio master shapes.
-
Integrate Sage 200 with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Sage 200 with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Sage 200.
-
Integrating OData Services in Talend Cloud Data Management Platform
Connect OData Services with Talend Cloud Data Management Platform using the CData JDBC Driver for OData.
-
How to Visualize Monday.com Data in Python with pandas
Use pandas and other modules to analyze and visualize live Monday.com in Python.
-
Analyze IBM Informix Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of IBM Informix and visualize IBM Informix in SAP Analytics Cloud.
-
Use Manus AI to Talk to Your SAP Business One 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 SAP Business One.
-
Connect to Pinterest Data in Aqua Data Studio
Access Pinterest from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Microsoft Planner Data from HeidiSQL
Use CData Connect AI to connect to and query live Microsoft Planner from HeidiSQL.
-
Connect to eBay Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for eBay.
-
DataBind Controls to Azure DevOps Data in Delphi
DataBind to Azure DevOps in Delphi with standard data access components and controls.
-
Manage Couchbase Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Couchbase.
-
Integrate Bugsnag Data in the Pentaho Report Designer
Publish reports based on Bugsnag in the Pentaho BI tool.
-
Process & Analyze Guru Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Guru Data.
-
Use Claude to Talk to Your SAS xpt 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 SAS XPORT for you.
-
Design BIRT Reports on PayPal Data
Provide current PayPal to your embedded analytics.
-
Building Dynamic Web Pages with ShipStation Data Using AngularJS
Create single-page applications with live connectivity to ShipStation using the CData API Server.
-
Automated Continuous Adobe Analytics Replication to MySQL
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to MySQL.
-
Integrating LangChain with Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Power BI XMLA within automated workflows.
-
Consume Zoho Inventory OData Feeds in PowerBuilder
This article demonstrates how to consume Zoho Inventory as OData feeds from PowerBuilder using the API Server.
-
Replicate Bannerbear Data to Multiple Databases via the CData Sync CLI
Replicate Bannerbear to disparate databases with a single configuration.
-
Rapidly Develop Zuora-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 Zuora.
-
Create Data Visualizations in Cognos BI with FormSite Data
Access FormSite as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Boomi Agentstudio with Google Drive Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Drive, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Import and Visualize Webflow Data in Power View
Create data visualizations based on Webflow in Excel.
-
Connect to Freshservice Data from PowerBuilder via ADO.NET
This article demonstrates how to access Freshservice from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrating GitHub Copilot CLI with RSS Feeds 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.
-
Getting Started with the CData SSIS Components for DB2
Complete guide to installing, licensing, and connecting with the CData SSIS Components for DB2.
-
Connect to AgileCRM Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time AgileCRM using standard SQL.
-
Access Hubstaff Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Hubstaff from HeidiSQL.
-
Bridge Google Translate Connectivity with Apache NiFi
Access and process Google Translate in Apache NiFi using the CData JDBC Driver.
-
Process & Analyze Salesforce Marketing Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Salesforce Marketing Data.
-
Use the CData API Server to Access Act CRM Data in Microsoft PowerPivot
Use the CData API Server to connect to live Act CRM in the Power Pivot business intelligence tool.
-
Moving Data from Marketo to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Marketo data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate with SAP SuccessFactors LMS Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP SuccessFactors LMS to a JSON file on disk.
-
Connect to Browserless from Asprova with CData Software ODBC Driver for Browserless
This article shows how to connect faster to Browserless data from Asprova.
-
Connect to Basecamp Data in NetBeans
Connect to Basecamp in NetBeans with the data source configuration wizard.
-
Moving Data from Twitter Ads to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Twitter Ads data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Microsoft Teams-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Teams.
-
Query Tavily Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Tavily from Node.js.
-
Bind Live ServiceNow Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live ServiceNow data
-
Work with Rebilly Data in FoxPro
Load Rebilly into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Avaza-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Avaza.