CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Couchbase Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Couchbase replication to Google Cloud SQL.
-
How to connect to Outlook Data from IntelliJ
Integrate connectivity to Outlook with wizards in IntelliJ.
-
Query Live SharePoint Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Microsoft SharePoint directly from the development environment.
-
Replicate Wave Financial Data from PowerShell
Write a quick PowerShell script to query Wave Financial. Use connectivity to the live data to replicate Wave Financial to SQL Server.
-
Migrating data from Demio to Google BigQuery using CData SSIS Components.
Easily push Demio to Google BigQuery using the CData SSIS Tasks for Demio and Google BigQuery.
-
Create Informatica Mappings From/To a JDBC Data Source for IBM Cloud Object Storage
Create IBM Cloud Object Storage data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Build an ETL App for Invoiced Data in Python with CData
Create ETL applications and real-time data pipelines for Invoiced in Python with petl.
-
Use CData Connect AI to Access Google Sheets Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Sheets in the Power Pivot business intelligence tool.
-
Connect to Raisers Edge NXT Data in Aqua Data Studio
Access Raisers Edge NXT from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Query, Visualize, and Share live Elasticsearch Data in Redash
Use CData Connect AI to connect to live Elasticsearch in Redash for querying, visualizing, and sharing.
-
How to connect to Quickbase Data from Spring Boot
Connect to Quickbase in a Spring Boot Application using the CData JDBC Driver for Quickbase
-
Publish Crystal Reports on Zendesk Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zendesk.
-
Connect Pipedrive to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Pipedrive using the CData Python MCP Server.
-
Query Live Oracle Sales Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Oracle Sales directly from the development environment.
-
Access Live SFTP Data in TIBCO Data Virtualization
Use the SFTP Tibco DV Adapter to create a SFTP data source in TIBCO Data Virtualization Studio and gain access to live SFTP from your TDV Server.
-
Connect to Float Data from PowerBuilder via JDBC
This article demonstrates how to access Float from PowerBuilder using the Float JDBC Driver.
-
Connect to Shopify Data from a Connection Pool in Jetty
The Shopify JDBC Driver supports connection pooling: This article shows how to connect faster to Shopify from Web apps in Jetty.
-
Work with Ontraport Data in FoxPro
Load Ontraport into a FoxPro database. This article includes full code and a walk-through of the process.
-
Import and Visualize Insightly Data in Power View
Create data visualizations based on Insightly in Excel.
-
How to Connect to Live WordPress 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 WordPress for you.
-
ETL Google Tasks in Oracle Data Integrator
This article shows how to transfer Google Tasks into a data warehouse using Oracle Data Integrator.
-
Migrating data from ClickUp to Databricks using CData SSIS Components.
Easily push ClickUp to Databricks using the CData SSIS Tasks for ClickUp and Databricks.
-
How to create an RPA flow for YouTube Analytics Data in UiPath Studio
Use the YouTube Analytics ODBC Driver to create workflows that access real-time YouTube Analytics without any coding.
-
Analyze Sugar CRM Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Sugar CRM and visualize live Sugar CRM in Infragistics Reveal.
-
How to Visualize ZarMoney Data in Python with pandas
Use pandas and other modules to analyze and visualize live ZarMoney in Python.
-
How to Connect Google Cloud Storage Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Google Cloud Storage data in real time using natural language.
-
Integrate Beeminder Data in Pentaho Data Integration
Build ETL pipelines based on Beeminder in the Pentaho Data Integration tool.
-
Prepare, Blend, and Analyze Adobe Target Data in Alteryx Designer (ODBC)
Build workflows to access live Adobe Target for self-service data analytics.
-
How to use SQLAlchemy ORM to access GitHub Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of GitHub.
-
Build Billsby-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Billsby.
-
How to Connect to Live Asana Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Asana for you.
-
Natively Connect to ChargeOver Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ChargeOver. Leverage the native support for ODBC in PHP.
-
Build a PostgreSQL Interface for CouchDB Data using the CData JDBC Driver
Use the Remoting features of the CouchDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Controls to Stripe Data in Delphi
DataBind to Stripe in Delphi with standard data access components and controls.
-
Use the CData ODBC Driver for Reckon Accounts Hosted from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Reckon Accounts Hosted to connect to Reckon Accounts Hosted from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Reckon Accounts Hosted in Excel.
-
How to connect Amazon QuickSight to Azure Data Lake Storage Data
Create a connection to Azure Data Lake Storage in CData Connect AI and insert Azure Data Lake Storage into Amazon QuickSight SPICE to build interactive dashboards.
-
Access HCL Domino Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access HCL Domino from your Oracle system.
-
Integrating Dataiku with Google Contacts Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Google Contacts.
-
Using the CData Software ODBC Driver for SAP Ariba Procurement in PyCharm
Connect to SAP Ariba Procurement as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP Ariba Procurement.
-
Build Visualizations of Wrike Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Wrike in Birst.
-
Design BIRT Reports on Smartsheet Data
Provide current Smartsheet to your embedded analytics.
-
Edit and Search Oracle Eloqua External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Oracle Eloqua to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Oracle Eloqua objects that you can access from apps and the dashboard.
-
How to create Todoist federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Todoist in MySQL .
-
How to Connect DBeaver to Hubstaff via a JDBC Driver
Manage Hubstaff with visual tools in DBeaver like the query browser.
-
Consume Sybase IQ OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Sybase IQ feeds that reflect any changes in SAP Lumira.
-
Excel Spreadsheet Automation on Printify Data with the QUERY Formula
Pull data from Printify, automate spreadsheets, and more with the QUERY formula.
-
Use Microsoft Copilot Studio to talk to your FreshBooks 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 FreshBooks for you.
-
How to connect and process OnePageCrm from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live OnePageCrm.
-
Create Datasets from Freshteam in Domo Workbench and Build Visualizations of Freshteam Data in Domo
Use the CData Software ODBC Driver for Freshteam to create datasets from Freshteam in Domo Workbench and then build visualizations in the Domo service.
-
How to connect to Dynamics 365 Business Central Data from IntelliJ
Integrate connectivity to Dynamics 365 Business Central with wizards in IntelliJ.
-
Integrating LangChain with Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Vertica within automated workflows.
-
Integrating Nuclia Data in Talend Cloud Data Management Platform
Connect Nuclia Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Load Dynamics CRM Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Dynamics CRM to a database.
-
Import Real-Time Clockify Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Clockify in ColdFusion.
-
Access LaunchDarkly Data from MySQL in PHP
Connect to LaunchDarkly through the standard MySQL libraries in PHP.
-
Access Sage Intacct Data from MySQL in PHP
Connect to Sage Intacct through the standard MySQL libraries in PHP.
-
Getting Started with the CData SSIS Components for SAP Netweaver Gateway
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP Netweaver Gateway.
-
Create CloudConvert Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time CloudConvert data access from reports, embedded analytics, and more.
-
How to Connect the Power BI Service to Smartsheet: Complete Guide
Connect to the CData Software Power BI Connector for Smartsheet from PowerBI.com to provide real-time Smartsheet across the organization.
-
How to Query Email Data in MySQL Workbench
Execute MySQL queries against live Email from MySQL Workbench.
-
Connect to ZeroBounce Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ZeroBounce using standard SQL.
-
How to Connect to Live Splunk Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Splunk for you.
-
How to Seamlessly Import Front Data into IBM SPSS Modeler
Integrate Front data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build a Singer.io Tap for Wistia With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Wistia data using
-
How to Connect the Power BI Service to Vimeo: Complete Guide
Connect to the CData Software Power BI Connector for Vimeo from PowerBI.com to provide real-time Vimeo across the organization.
-
Create Codat Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Codat data access from reports, embedded analytics, and more.
-
Building Dynamic Web Pages with Redshift Data Using AngularJS
Create single-page applications with live connectivity to Redshift using the CData API Server.
-
Connect Google Sheets to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Sheets using the CData Python MCP Server.
-
Design BIRT Reports on Dropbox Data
Provide current Dropbox to your embedded analytics.
-
Connect to SAP Ariba Source Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP Ariba Source from HeidiSQL.
-
How to Connect to Live Salesforce Pardot Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Salesforce Pardot for you.
-
How to Visualize GitHub Data in Python with pandas
Use pandas and other modules to analyze and visualize live GitHub in Python.
-
Connect to Anaplan Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Anaplan.
-
Connect to Google Translate from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Translate to connect to Google Translate from Web applications running on WebLogic.
-
Create Datasets from LaunchDarkly in Domo Workbench and Build Visualizations of LaunchDarkly Data in Domo
Use the CData Software ODBC Driver for LaunchDarkly to create datasets from LaunchDarkly in Domo Workbench and then build visualizations in the Domo service.
-
Use JayDeBeApi to access ZohoExpense Data in Python
Use standard Python scripting and the development environment of your choice to access live ZohoExpense.
-
How to connect to Outreach.io Data from IntelliJ
Integrate connectivity to Outreach.io with wizards in IntelliJ.
-
Feed Recurly Data into FineReport
How to set Recurly as a JDBC data source in FineReport.
-
Automated Continuous Adobe Commerce Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Apache Cassandra.
-
Publish SAP SuccessFactors LMS-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAP SuccessFactors LMS.
-
View Reports on Real-Time Outreach.io Data in Power BI Report Server
Use the CData ODBC Driver for Outreach.io to visualize Outreach.io in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect to Pinterest Data in DBVisualizer
Integrate Pinterest with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Zendesk-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Zendesk Data from Klipfolio and build custom visualizations using live Zendesk.
-
LINQ to Microsoft Entra ID 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 Microsoft Entra ID Data Provider.
-
Use the CData Software JDBC Driver for Shippo in MicroStrategy Web
Connect to Shippo in MicroStrategy Web using the CData Software JDBC Driver for Shippo.
-
Use Dash to Build to Web Apps on ConvertAPI Data
Create Python applications that use pandas and Dash to build ConvertAPI-connected web apps.
-
Connect to Microsoft Exchange Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Microsoft Exchange.
-
Connect to and Query ScrapingBee Data in QlikView over ODBC
Create data visualizations with ScrapingBee in QlikView.
-
Easily Integrate Aircall Data in Lazarus Pascal IDE
Learn how to easily integrate live Aircall in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Rapidly Develop Mailgun-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 Mailgun.
-
Use CData Connect AI to Access HBase Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Apache HBase in the Power Pivot business intelligence tool.
-
Connecting Mastra with FHIR 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 FHIR, no replication required.
-
Automate SAP Ariba Procurement Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP Ariba Procurement replication to Azure Data Lake.
-
How to Connect Azure Analysis Services Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Azure Analysis Services data in real time using natural language.
-
How to Create Power BI Visual Reports with Real-Time Google Forms Data
Use CData Power BI Connectors to visualize Google Forms in Power BI.
-
Connect to Gorgias from Asprova with CData Software ODBC Driver for Gorgias
This article shows how to connect faster to Gorgias data from Asprova.
-
Publish CampaignMonitor-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live CampaignMonitor.
-
Import Sage Intacct Data Using Azure Data Factory
Use CData Connect AI to connect to Sage Intacct Data from Azure Data Factory and import live Sage Intacct.
-
Easily Integrate Apollo Data in Lazarus Pascal IDE
Learn how to easily integrate live Apollo in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Cosmos DB Data in JRuby
Create a simple JRuby app with access to live Azure Cosmos DB.