CData Software - Knowledge Base
Recent Articles
-
How to Import Data from Azure Data Catalog into Google Sheets
Import Azure Data Catalog into a Google spreadsheet that is automatically refreshed.
-
Integrate Live Elasticsearch Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Elasticsearch from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Elasticsearch.
-
Integrate Cline with Live GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live GitHub from within your IDE.
-
Connect to IBM Informix Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for IBM Informix in Airbyte.
-
Analyze Mixpanel Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Mixpanel in Microsoft R Open.
-
Connecting Mastra with Amazon Athena 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 Amazon Athena, no replication required.
-
Query Mistral AI Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Mistral AI entities in PHP by modeling them as objects.
-
Bridge PabblySubscriptions Connectivity with Apache NiFi
Access and process PabblySubscriptions in Apache NiFi using the CData JDBC Driver.
-
How to Seamlessly Import Oracle Eloqua Reporting Data into IBM SPSS Modeler
Integrate Oracle Eloqua Reporting data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Visualize Basecamp Data in Python with pandas
Use pandas and other modules to analyze and visualize live Basecamp in Python.
-
Create Dynamic Productboard Grids Using the Infragistics XamDataGrid
Learn how you can connect Productboard to Infragistics XamDataGrid to build dynamic grids.
-
A PostgreSQL Interface for Freshteam Data (MySQL Remoting via JDBC)
Use the Remoting features of the Freshteam JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live Asana Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Asana into custom reports in Power BI.
-
Connect to Copper Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Copper using standard SQL.
-
Use the CData Software JDBC Driver for SFTP in MicroStrategy Web
Connect to SFTP in MicroStrategy Web using the CData Software JDBC Driver for SFTP.
-
How to Connect to Live Trello 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 Trello for you.
-
Build Dynamics 365-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft Dynamics 365 and build Dynamics 365-connected web apps with Axios.
-
Integrating Gumloop with Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Dropbox within automated workflows.
-
How to Work with Sendwithus Data in ETL Validator JDBC
Connect to Sendwithus from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Live Oracle Sales Data in MicroStrategy through CData Connect AI
Create a live connection to Oracle Sales Data in CData Connect AI and connect to your Oracle Sales from MicroStrategy.
-
Getting Started with the CData ODBC Driver for Adobe Analytics
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Adobe Analytics.
-
Create FreshBooks-Connected Applications in Appsmith
Connect to FreshBooks Data via CData Connect AI in Appsmith and create custom business applications with real-time access to FreshBooks.
-
Prepare, Blend, and Analyze SAP Fieldglass Data in Alteryx Designer (ODBC)
Build workflows to access live SAP Fieldglass for self-service data analytics.
-
Use the CData SSIS Components to Insert New or Update Existing Google Spanner Records from SQL Server
Easily push SQL Server data to Google Spanner using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Google Spanner or update existing records with data from a SQL Server database.
-
Query SAP Netweaver Gateway Data as a MySQL Database in Node.js
Execute MySQL queries against SAP Netweaver Gateway from Node.js.
-
Analyze HCL Domino Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze HCL Domino with the CData JDBC Driver for HCL Domino.
-
Natively Connect to Drift Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Drift. Leverage the native support for ODBC in PHP.
-
Validate REST Data with QuerySurge
Access and validate REST in QuerySurge using the CData JDBC Driver.
-
Validate Zoho Books Data with QuerySurge
Access and validate Zoho Books in QuerySurge using the CData JDBC Driver.
-
Import Real-Time Datadog Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Datadog in ColdFusion.
-
Build MVC Applications with Connectivity to Webex Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Webex from an ASP.NET MVC application.
-
How to Query Live ZarMoney Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ZarMoney data in natural language using Python.
-
Use ChatGPT to Talk to Your Tally 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 Tally ERP for you.
-
Connect to Real-Time Asana Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Asana and Dataflow to import and use Asana in Power Apps.
-
How to Connect to MySQL Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to MySQL. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous LionDesk Replication to Amazon S3
Use CData Sync for automated, continuous, customizable LionDesk replication to Amazon S3.
-
Build Dashboards with QuickBooks Data in DBxtra
Create dynamic dashboards and perform analytics based on QuickBooks Desktop in DBxtra.
-
Bridge MessageBird Connectivity with Apache NiFi
Access and process MessageBird in Apache NiFi using the CData JDBC Driver.
-
Bind Live IBM Cloud Object Storage Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live IBM Cloud Object Storage data
-
Connect to and Query Azure Synapse Data in QlikView over ODBC
Create data visualizations with Azure Synapse in QlikView.
-
How to update HubDB from Excel
This article explains how to transfer data from Excel to HubDB using the Excel Add-In for HubDB.
-
DataBind Charts to Optimizely Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Optimizely 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.
-
Publish Crystal Reports on HubSpot Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date HubSpot.
-
Connect to Telegram Data in Aqua Data Studio
Access Telegram from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automate Codat Data Replication to Couchbase
Use CData Sync to Customize and automate Codat replication to Couchbase.
-
How to Query Live SparkPost Data in Claude Desktop
Connect to and query live SparkPost Data in Claude Desktop using CData MCP Server.
-
How to Connect to Live Vertica Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Vertica for you.
-
Connect to Attio Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Attio in the Denodo Virtual DataPort Administrator.
-
Create Informatica Mappings From/To an ODBC Data Source for Pipeline CRM
Create an ODBC connection to Pipeline CRM in Informatica and browse and transfer Pipeline CRM.
-
Getting Started with the CData JDBC Driver for Reply.io
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Reply.io.
-
Validate PostgreSQL Data with QuerySurge
Access and validate PostgreSQL in QuerySurge using the CData JDBC Driver.
-
Use the CData ODBC Driver for Campaigner from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Campaigner to connect to Campaigner from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Campaigner in Excel.
-
How to Connect the Power BI Service to BenchmarkEmail: Complete Guide
Connect to the CData Software Power BI Connector for BenchmarkEmail from PowerBI.com to provide real-time BenchmarkEmail across the organization.
-
How to Connect to Live Oracle Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Oracle Database without replication.
-
Query Pipeliner CRM Data in DataGrip
Create a Data Source for Pipeliner CRM in DataGrip and use SQL to query live Pipeliner CRM.
-
Connect to Smartsheet Data in Google Apps Script via Connect AI
Use CData Connect AI to access Smartsheet in Google Apps Script.
-
Connect to SAP Concur Data in HULFT Integrate
Connect to SAP Concur as a JDBC data source in HULFT Integrate
-
Automate YouTube Analytics Data Replication to Azure Synapse
Use CData Sync to customize and automate YouTube Analytics replication to Azure Synapse.
-
How to work with Google Forms Data in Apache Spark using SQL
Access and process Google Forms Data in Apache Spark using the CData Software JDBC Driver.
-
Configure the CData JDBC Driver for Avaza in a Connection Pool in Tomcat
Connect to Avaza from a connection pool in Tomcat.
-
Query Live NetSuite 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 NetSuite CRM & ERP directly from the development environment.
-
Getting Started with the CData JDBC Driver for Printful
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Printful.
-
Integrate MailChimp Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MailChimp from Informatica Cloud.
-
Automated Continuous Avalara AvaTax Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to OneLake in Microsoft Fabric.
-
Build an OLAP Cube in SSAS from Google Forms Data
Establish a connection to Google Forms data from SQL Server Analysis Services, and use the Google Forms Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect Google Ad Manager to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Ad Manager using the CData Python MCP Server.
-
Model Sybase IQ Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Sybase IQ, enabling the direct import of real-time Sybase IQ.
-
How to connect SharePoint with Parquet Data through external lists
Provide Apache Parquet to SharePoint users as an external list.
-
How to Create Power BI Visual Reports with Real-Time CockroachDB Data
Use CData Power BI Connectors to visualize CockroachDB in Power BI.
-
Query Mailjet Data in DataGrip
Create a Data Source for Mailjet in DataGrip and use SQL to query live Mailjet.
-
Automated Continuous PabblySubscriptions Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to PostgreSQL.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle Eloqua Reporting
Provide connectivity to Oracle Eloqua Reporting through an SAP BusinessObjects universe.
-
Access Live Klaviyo Data in Excel 365 Online (Excel for the web)
Connect to Klaviyo from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Edit and Search External DB2 Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of IBM DB2 to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create DB2 Data objects that you can access from apps and the dashboard.
-
Build SendGrid-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SendGrid Data from Zoho Analytics and import live SendGrid.
-
Automated Continuous ZohoPeople Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ZohoPeople replication to OneLake in Microsoft Fabric.
-
Create Datasets from Google Calendar in Domo Workbench and Build Visualizations of Google Calendar Data in Domo
Use the CData Software ODBC Driver for Google Calendar to create datasets from Google Calendar in Domo Workbench and then build visualizations in the Domo service.
-
How to connect to Greenhouse Data in DBVisualizer
Integrate Greenhouse with visual data analysis tools and data connection wizards in DBVisualizer
-
Replicate Typeform Data to Multiple Databases
Replicate Typeform to disparate databases with a point-and-click configuration.
-
Build a PostgreSQL Interface for eBay Analytics Data using the CData JDBC Driver
Use the Remoting features of the eBay Analytics JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create SAP Concur-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP Concur Data from OutSystems and build custom enterprise apps using live SAP Concur.
-
Integrate Open WebUI with Live Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Instagram from within the chat interface.
-
Build AI/ML Models with Live ConstantContact Data using Dataiku
Connect ConstantContact Data with Dataiku using the CData API Driver for JDBC.
-
Excel Spreadsheet Automation on PagerDuty Data with the QUERY Formula
Pull data from PagerDuty, automate spreadsheets, and more with the QUERY formula.
-
Automate Sybase Data Replication to Azure Data Lake
Use CData Sync to customize and automate Sybase replication to Azure Data Lake.
-
Connect to SAS xpt Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAS XPORT in Google Apps Script.
-
How to connect SharePoint with Google Forms Data through external lists
Provide Google Forms to SharePoint users as an external list.
-
Connect to SendPulse Data in RazorSQL
Connect to SendPulse from wizards and query SendPulse from the GUI in the RazorSQL database management tool.
-
Migrating data from Cvent to Google BigQuery using CData SSIS Components.
Easily push Cvent to Google BigQuery using the CData SSIS Tasks for Cvent and Google BigQuery.
-
Bridge Box Connectivity with Apache NiFi
Access and process Box in Apache NiFi using the CData JDBC Driver.
-
Connect to Acumatica in SpagoBI
Create reports featuring live Acumatica ERP in SpagoBI Studio. Host Acumatica reports on SpagoBI Server.
-
Edit and Search Optimizely External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Optimizely to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Optimizely objects that you can access from apps and the dashboard.
-
Replicate Multiple Dotmailer Accounts
Replicate multiple Dotmailer accounts to one or many databases.
-
Connect to LDAP Objects in DBArtisan
Use wizards in DBArtisan to configure LDAP as a data source.
-
Use Grok to Talk to Your WordPress 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 WordPress for you.
-
How to connect PolyBase to PhantomBuster
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live PhantomBuster.
-
Connect to Greenhouse Data from Crystal Reports
Use CData Connect AI to connect to and report on live Greenhouse from Crystal Reports.
-
Validate Postmark Data with QuerySurge
Access and validate Postmark in QuerySurge using the CData JDBC Driver.
-
Analyze HCL Domino Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of HCL Domino and visualize HCL Domino in SAP Analytics Cloud.
-
How to Use a Microsoft Access Database to Update Act-On Data in Real Time
Update Act-On data by creating a linked table in Microsoft Access with the CData Act-On ODBC Driver.