CData Software - Knowledge Base
Recent Articles
-
How to Visualize FreshBooks Data in Python with pandas
Use pandas and other modules to analyze and visualize live FreshBooks data in Python.
-
A PostgreSQL Interface for SAP Ariba Source Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP Ariba Source JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to MarkLogic Data in JRuby
Create a simple JRuby app with access to live MarkLogic data.
-
Use the CData Software ODBC Driver for Gorgias in SAS for Real-Time Reporting and Analytics
Connect to real-time Gorgias data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Gorgias.
-
How to create an RPA flow for Sendwithus Data in UiPath Studio
Use the Sendwithus ODBC Driver to create workflows that access real-time Sendwithus data without any coding.
-
How to Connect DBeaver to Front via a JDBC Driver
Manage Front data with visual tools in DBeaver like the query browser.
-
Connect to Amazon Marketplace Data in DBArtisan
Use wizards in DBArtisan to configure Amazon Marketplace data as a data source.
-
Work with OpenWeatherMap Data in FoxPro
Load OpenWeatherMap data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Excel Spreadsheet Automation on Samanage Data with the QUERY Formula
Pull data from Samanage, automate spreadsheets, and more with the QUERY formula.
-
How to Seamlessly Import Twilio Data into IBM SPSS Modeler
Integrate Twilio data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Quaderno
Provide connectivity to Quaderno data through an SAP BusinessObjects universe.
-
Build Kafka-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Kafka Data and create custom apps in Bubble.
-
Connect to SAP Fieldglass Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP Fieldglass to connect to SAP Fieldglass data and execute queries in PowerBuilder.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for CircleCI
Provide connectivity to CircleCI data through an SAP BusinessObjects universe.
-
Replicate Zoho Books Data to Multiple Databases via the CData Sync CLI
Replicate Zoho Books data to disparate databases with a single configuration.
-
Integrate Goose with Live Dynamics 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Dynamics 365 data from within the local AI agent.
-
Automated Continuous Google Cloud Storage Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to Oracle.
-
How to create Visio diagrams from Google Sheets Data
Automatically update Google Sheets data with the changes you make to Visio master shapes.
-
Connect to Reckon Accounts Hosted from a Connection Pool in WebLogic
Use the CData JDBC Driver for Reckon Accounts Hosted to connect to Reckon Accounts Hosted data from Web applications running on WebLogic.
-
Viewing Zoho Creator Data in RAD Studio Data Explorer
How to view Zoho Creator data in RAD Studio Data Explorer using the CData ODBC Driver for Zoho Creator.
-
Integrate Dropbox Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Dropbox data and integrate live Dropbox data into your Power Automate tasks.
-
Import and Visualize ZohoInvoice Data in Power View
Create data visualizations based on ZohoInvoice data in Excel.
-
A PostgreSQL Interface for Grafana Data using the CData ODBC Driver
Use the SQL Gateway and Grafana ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData ODBC Driver for ZohoInvoice from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ZohoInvoice to connect to ZohoInvoice data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ZohoInvoice data in Excel.
-
Automated Continuous ZendeskSell Replication to Oracle
Use CData Sync for automated, continuous, customizable ZendeskSell replication to Oracle.
-
Automated Continuous AgileCRM Replication to Databricks
Use CData Sync for automated, continuous, customizable AgileCRM replication to Databricks.
-
Automated Continuous SparkPost Replication to SQLite
Use CData Sync for automated, continuous, customizable SparkPost replication to SQLite.
-
Access Asana Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Asana data from HeidiSQL.
-
Connect to Notion Data from PowerBuilder via JDBC
This article demonstrates how to access Notion data from PowerBuilder using the Notion JDBC Driver.
-
Visualize Live SAP Concur Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAP Concur data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Work with Live Zoom Data in Power Query
Use CData Connect AI to connect to Zoom data and work with live Zoom data in Microsoft Power Query.
-
Build Semantic Layer Views for Microsoft Ads Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Microsoft Ads data.
-
Connect to Amazon S3 from a Connection Pool in WebLogic
Use the CData JDBC Driver for Amazon S3 to connect to Amazon S3 data from Web applications running on WebLogic.
-
Use Agno to Talk to Your Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Greenplum data for you.
-
Create Salesloft-Connected Nintex Workflows
Use CData Connect AI to connect to Salesloft Data from Nintex Workflow Cloud and build custom workflows using live Salesloft data.
-
Query Pinterest Data as a SQL Server Database in Node.js
Execute SQL Server queries against Pinterest data from Node.js.
-
How to load Salesforce CRM Analytics data into Elasticsearch via Logstash
Introducing a simple method to load Salesforce CRM Analytics data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Shippo Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Shippo replication to PostgreSQL.
-
How to Connect to Live Presto 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 Presto data for you.
-
Getting Started with the CData JDBC Driver for Browserless
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Browserless.
-
Dynamics 365 Business Central Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Dynamics 365 Business Central data through CData Connect AI using different applications and tools.
-
Use the CData Software JDBC Driver for Splunk in MicroStrategy Desktop
Connect to Splunk data in MicroStrategy Desktop using the CData Software JDBC Driver for Splunk.
-
Establish a Live Connection with Mouseflow Data using Tableau Bridge
The CData ODBC Driver for Mouseflow enables you to integrate live Mouseflow data into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Codat Data in Sisense
Create an ElastiCube in Sisense app with access to Codat data.
-
Create Clio Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Clio from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect to Live Wave Financial 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 Wave Financial data for you.
-
How to create LinkedIn federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for LinkedIn data in MySQL .
-
Seamlessly Bring SAP Business One Data into Retool Using CData Connect AI
Integrate SAP Business One data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous Facebook Ads Replication to SQLite
Use CData Sync for automated, continuous, customizable Facebook Ads replication to SQLite.
-
Prepare, Blend, and Analyze Facebook Data in Alteryx Designer (Connect AI)
Build workflows to access live Facebook data for self-service data analytics.
-
Add Close Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Close with the Informatica Enterprise Data Catalog to classify and organize data.
-
Query Workable Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Workable data from Node.js.
-
Automated Continuous Spotify Replication to Vertica
Use CData Sync for automated, continuous, customizable Spotify replication to Vertica.
-
Build Apollo-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Apollo data and build Apollo-connected web apps with Axios.
-
Connect to Google Ad Manager Data in ACL Analytics
Connect to Google Ad Manager data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Ad Manager data.
-
Automated Continuous Lakebase Replication to MySQL
Use CData Sync for automated, continuous, customizable Lakebase replication to MySQL.
-
Getting Started with the CData Connect AI Python SDK for QuickBooks Online
Install the CData Connect AI Python SDK to read and write live QuickBooks Online data with standard DB-API 2.0 Python code.
-
Use the CData JDBC Drivers to Create New Data Sources in DbVisualizer
Connect to the CData JDBC Driver for QuickBooks through the DbVisualizer database management tool.
-
Integrate with ActiveCampaign Data in SnapLogic
Use CData Connect AI to connect to and integrate with live ActiveCampaign data in SnapLogic.
-
Access Live SAP Business One Data in Coginiti Pro
Connect to and query live SAP Business One data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Configure the CData JDBC Driver for Presto in a Connection Pool in Tomcat
Connect to Presto data from a connection pool in Tomcat.
-
How to create Visio diagrams from Cosmos DB Data
Automatically update Cosmos DB data with the changes you make to Visio master shapes.
-
How to connect to Sage Cloud Accounting Data from Spring Boot
Connect to Sage Cloud Accounting in a Spring Boot Application using the CData JDBC Driver for Sage Cloud Accounting
-
Getting Started with the CData Connect AI Python SDK for Splunk
Install the CData Connect AI Python SDK to read and write live Splunk data with standard DB-API 2.0 Python code.
-
Connect to Zoho Recruit Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Zoho Recruit data.
-
Integrate Google Calendar with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Calendar with External Services.
-
A PostgreSQL Interface for Power BI XMLA Data (MySQL Remoting via JDBC)
Use the Remoting features of the Power BI XMLA JDBC Driver to create a PostgreSQL entry-point for data access.
-
Moving Data from MailerSend to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live MailerSend data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Live Testmonitor Data in MicroStrategy through CData Connect AI
Create a live connection to Testmonitor Data in CData Connect AI and connect to your Testmonitor data from MicroStrategy.
-
Validate Jira Data with QuerySurge
Access and validate Jira data in QuerySurge using the CData JDBC Driver.
-
Viewing ElevenLabs Data in RAD Studio Data Explorer
How to view ElevenLabs data in RAD Studio Data Explorer using the CData ODBC Driver for ElevenLabs.
-
Edit and Search External Google Directory Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Directory data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Directory Data objects that you can access from apps and the dashboard.
-
Use the CData ODBC Driver for Salesloft in Microsoft Power Query
You can use the CData Salesloft ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Salesloft data into Microsoft Power Query.
-
Integrate Theia IDE with Live Google Sheets 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 Google Sheets data from within the development environment.
-
Build Optimizely-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Optimizely data.
-
Choosing the Best Method to Connect RabbitMQ to SQL Server: 5 Options Explained
Discover multiple ways to connect and use RabbitMQ data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Getting Started with the CData ODBC Driver for ZohoDesk
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ZohoDesk.
-
Integrate Google's Vertex AI Agent with Live CapsuleCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live CapsuleCRM data within intelligent workflows.
-
Connect to Stack Exchange Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Stack Exchange and the SQL Gateway to access Stack Exchange data from Google Apps Script.
-
Access Stripe Data from MySQL in Amazon QuickSight
Connect to Stripe and build visualizations of Stripe data using a MySQL Connection in Amazon QuickSight.
-
Choosing the Best Method to Connect OnePageCrm to SQL Server: 5 Options Explained
Discover multiple ways to connect and use OnePageCrm data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Sendwithus-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Sendwithus data and build web apps with connectivity to live Sendwithus data.
-
How to Access Live Foursquare Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Foursquare enables you to integrate Foursquare data into workflows built using Microsoft Power Automate Desktop.
-
Connect to ZohoPeople Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ZohoPeople data.
-
Connect to YouTube Analytics Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for YouTube Analytics data in Airbyte.
-
Use the CData ODBC Driver for FreeAgent from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for FreeAgent to connect to FreeAgent data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring FreeAgent data in Excel.
-
Use Manus AI to Talk to Your ZohoMarketingHub 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 ZohoMarketingHub data.
-
Validate ZeroBounce Data with QuerySurge
Access and validate ZeroBounce data in QuerySurge using the CData JDBC Driver.
-
Build MVC Applications with Connectivity to MongoDB Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access MongoDB from an ASP.NET MVC application.
-
Extract, Transform, and Load Humanity Data in Informatica PowerCenter
Create a simple Workflow for Humanity data in Informatica PowerCenter.
-
Build BambooHR-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to BambooHR Data from Zoho Analytics and import live BambooHR data.
-
How to Work with JobNimbus Data in ETL Validator JDBC
Connect to JobNimbus from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Cvent Data from Crystal Reports
Use CData Connect AI to connect to and report on live Cvent data from Crystal Reports.
-
Connect to Stack Exchange from a Connection Pool in WebLogic
Use the CData JDBC Driver for Stack Exchange to connect to Stack Exchange data from Web applications running on WebLogic.
-
Build Dashboards with SAS xpt Data in DBxtra
Create dynamic dashboards and perform analytics based on SAS xpt data in DBxtra.
-
Analyze VWO Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze VWO data with the CData JDBC Driver for VWO.
-
How to Work with Redis Data in ETL Validator JDBC
Connect to Redis from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Access Discourse Data Using Entity Framework
This article shows how to access Discourse data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Shippo Replication to MySQL
Use CData Sync for automated, continuous, customizable Shippo replication to MySQL.
-
Use ChatGPT to Talk to Your Redis 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 Redis data for you.