CData Software - Knowledge Base
Recent Articles
-
Access Live Zoho Projects Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Zoho Projects data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Build an ETL App for Avaza Data in Python with CData
Create ETL applications and real-time data pipelines for Avaza in Python with petl.
-
Integrate QuickBooks Time with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate QuickBooks Time with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to QuickBooks Time.
-
How to connect to OpenWeatherMap Data from Spring Boot
Connect to OpenWeatherMap in a Spring Boot Application using the CData API Driver for JDBC
-
Visualize Live Microsoft OneDrive Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft OneDrive and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Bridge Instantly Connectivity with Apache NiFi
Access and process Instantly in Apache NiFi using the CData JDBC Driver.
-
Replicate Elorus Data in Heroku for Use in Salesforce Connect
Replicate Elorus to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Build an ETL App for SuiteCRM Data in Python with CData
Create ETL applications and real-time data pipelines for SuiteCRM in Python with petl.
-
Automated Continuous Workday Replication to Vertica
Use CData Sync for automated, continuous, customizable Workday replication to Vertica.
-
How to connect PolyBase to Raisers Edge NXT
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Raisers Edge NXT.
-
Integrate Live Instagram Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Instagram from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Instagram.
-
Automated Continuous Sendwithus Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Sendwithus replication to PostgreSQL.
-
Create Power BI Reports on Real-Time Wrike Data
Use the CData ODBC Driver for Wrike to visualize Wrike in Power BI Desktop.
-
How to Connect to Live OneNote 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 Microsoft OneNote for you.
-
How to Connect Flowise AI Agents to Live Power BI XMLA 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 Power BI XMLA without replication.
-
Automated Continuous Exact Online Replication to MySQL
Use CData Sync for automated, continuous, customizable Exact Online replication to MySQL.
-
Use the CData Software ODBC Driver for Clockify in SAS for Real-Time Reporting and Analytics
Connect to real-time Clockify in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Clockify.
-
Use Biml to Build SSIS Tasks to Replicate HubDB Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate HubDB to SQL Server.
-
Integrate Helpscout Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Helpscout from Informatica Cloud.
-
Use Dash to Build to Web Apps on Quaderno Data
Create Python applications that use pandas and Dash to build Quaderno-connected web apps.
-
Manage Sage 200 Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Sage 200.
-
Automated Continuous Azure DevOps Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Amazon Redshift.
-
DataBind Controls to Attio Data in C++Builder
DataBind to Attio in C++Builder with standard components and controls.
-
Bind Live SAP Concur Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP Concur data
-
How to connect to Splunk Data with Squirrel SQL client
Connect to Splunk and execute queries in the Squirrel SQL Client.
-
How to Connect to Live HubSpot 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 HubSpot for you.
-
Write a Simple Go Application to work with Elorus Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Elorus.
-
Connect to ConvertAPI Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ConvertAPI as an External Source in Dremio.
-
Building Dynamic Web Pages with Google Contacts Data Using AngularJS
Create single-page applications with live connectivity to Google Contacts using the CData API Server.
-
Explore Geographical Relationships in FHIR Data with Power Map
Create data visualizations with FHIR in Power Map.
-
How to integrate Shortcut with Apache Airflow
Access and process Shortcut in Apache Airflow using the CData JDBC Driver.
-
How to Import Data from Gmail into Google Sheets
Import Gmail into a Google spreadsheet that is automatically refreshed.
-
Connecting Agentforce with HubSpot Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your HubSpot for you.
-
Integrate Oracle Sales Data in Pentaho Data Integration
Build ETL pipelines based on Oracle Sales in the Pentaho Data Integration tool.
-
Integrate Live Deel Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Deel to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Mocean Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Mocean and work with Mocean in your FileMaker applications.
-
Use the CData Software JDBC Driver for Google Spanner in MicroStrategy Web
Connect to Google Spanner in MicroStrategy Web using the CData Software JDBC Driver for Google Spanner.
-
How to Access NASA Data Using Entity Framework
This article shows how to access NASA using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Azure Data Catalog Data from MySQL in PHP
Connect to Azure Data Catalog through the standard MySQL libraries in PHP.
-
Bidirectional Access to Unbounce Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Unbounce in Filemaker Pro for Mac or Windows.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Superchat
Provide connectivity to Superchat through an SAP BusinessObjects universe.
-
Integrate with Azure Data Lake Storage Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Azure Data Lake Storage to a JSON file on disk.
-
How to work with Sugar CRM Data in Apache Spark using SQL
Access and process Sugar CRM Data in Apache Spark using the CData Software JDBC Driver.
-
Access SAP SuccessFactors Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP SuccessFactors from HeidiSQL.
-
Extend Google Sheets with Email Data
Make calls to Email from Google Apps Script via the API Server.
-
Connect to Oracle Financials Cloud from Asprova with CData Software ODBC Driver for Oracle Financials Cloud
This article shows how to connect faster to Oracle Financials Cloud data from Asprova.
-
Replicate LinkedIn Ads Data to Multiple Databases via the CData Sync CLI
Replicate LinkedIn Ads to disparate databases with a single configuration.
-
Visualize Live Mailjet Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Mailjet using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData ODBC Driver for Google Search from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Search to connect to Google Search from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Search in Excel.
-
Getting Started with the CData SSIS Components for Mailgun
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Mailgun.
-
Connect to OpenWeatherMap Data in Ruby
Connect to OpenWeatherMap in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Natively Connect to Phoenix Data in PHP
The CData ODBC driver for Phoenix enables you to create PHP applications with connectivity to Apache Phoenix. Leverage the native support for ODBC in PHP.
-
Access Quaderno Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Quaderno from your Oracle system.
-
Getting Started with the CData ADO.NET Provider for Azure Data Lake Storage
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Azure Data Lake Storage.
-
Build Apps with Live Apache Cassandra in Adalo using CData Connect AI
Use CData Connect AI to integrate live Apache Cassandra into the Adalo platform and build custom mobile and web applications with real-time Apache Cassandra.
-
Configure the CData JDBC Driver for Paymo in a Connection Pool in Tomcat
Connect to Paymo from a connection pool in Tomcat.
-
How to Build an ETL App for Keap Data in Python with CData
Create ETL applications and real-time data pipelines for Keap in Python with petl.
-
Build a Singer.io Tap for Egnyte With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Egnyte data using
-
Build AI/ML Models with Live Rootly Data using Dataiku
Connect Rootly Data with Dataiku using the CData API Driver for JDBC.
-
How to create GitLab federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for GitLab in MySQL .
-
Getting Started with the CData SSIS Components for SendGrid
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SendGrid.
-
Query Google Ads Data as a MySQL Database in Node.js
Execute MySQL queries against Google Ads from Node.js.
-
Integrate Gorgias Data in the Pentaho Report Designer
Publish reports based on Gorgias in the Pentaho BI tool.
-
Integrating Boomi Agentstudio with Zoho Projects Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Zoho Projects, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Import Adobe Analytics Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Adobe Analytics. In this article, you will use the OData format to import Adobe Analytics into Microsoft Power Query.
-
Moving Data from Excel Online to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Excel Online data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to HBase Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Apache HBase from Filemaker Pro on Mac.
-
Create ClickUp Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ClickUp data access from reports, embedded analytics, and more.
-
How to connect to Amazon Marketplace Data from IntelliJ
Integrate connectivity to Amazon Marketplace with wizards in IntelliJ.
-
How to integrate Clockify with Apache Airflow
Access and process Clockify in Apache Airflow using the CData JDBC Driver.
-
How to Access Live PhantomBuster Data in Power Automate Desktop via ODBC
The CData ODBC Driver for PhantomBuster enables you to integrate PhantomBuster into workflows built using Microsoft Power Automate Desktop.
-
Use Azure AI Foundry to Talk to Your Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Acumatica ERP for you.
-
Connect to Google Search Results in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Search in Airbyte.
-
Integrate Live MarkLogic Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to MarkLogic and integrate live MarkLogic into apps built in Microsoft Power Apps.
-
Connect to SQL Server from a Connection Pool in WebLogic
Use the CData JDBC Driver for SQL Server to connect to Microsoft SQL Server from Web applications running on WebLogic.
-
Access Live Dropbox Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Dropbox into the statistical analysis tools available in SAS JMP. This article shows how to use Dropbox in the Graph Builder and Query Builder.
-
Use Agno to Talk to Your Google Drive 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 Google Drive for you.
-
Integrate Goose with Live Hive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Apache Hive from within the local AI agent.
-
Connect to Sybase IQ in SpagoBI
Create reports featuring live Sybase IQ in SpagoBI Studio. Host Sybase IQ reports on SpagoBI Server.
-
Use the CData Software ODBC Driver for ServiceDesk Plus in MicroStrategy Desktop
Connect to ServiceDesk Plus in MicroStrategy Desktop using the CData Software ODBC Driver for ServiceDesk Plus.
-
Integrating Cursor CLI with Dotmailer 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.
-
Getting Started with the CData SSIS Components for Google Ads
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Ads.
-
How to Connect to Live Avro 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 Apache Avro for you.
-
Integrating GitHub Copilot CLI with Keap 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.
-
Connect to Salesforce CRM Analytics Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Salesforce CRM Analytics in Airbyte.
-
Natively Connect to IBM Informix Data in PHP
The CData ODBC driver for IBM Informix enables you to create PHP applications with connectivity to IBM Informix. Leverage the native support for ODBC in PHP.
-
Connect to MailerLite from a Connection Pool in WebLogic
Use the CData JDBC Driver for MailerLite to connect to MailerLite from Web applications running on WebLogic.
-
Load Salesloft Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Salesloft to a database.
-
How to Connect Smartsheet 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 Smartsheet data in real time using natural language.
-
Connect to Snowflake Data in RazorSQL
Connect to Snowflake from wizards and query Snowflake from the GUI in the RazorSQL database management tool.
-
Access Microsoft Entra ID Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Entra ID from HeidiSQL.
-
View Reports on Real-Time Avro Data in Power BI Report Server
Use the CData ODBC Driver for Avro to visualize Apache Avro in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating GitHub Copilot CLI with Cohere 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 Easily Query Microsoft Dataverse Data in OpenOffice Base
Connect to Microsoft Dataverse data in OpenOffice Base using the CData ODBC Driver for Microsoft Dataverse and generate reports with live data insights.
-
Process & Analyze Oracle Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Oracle Data.
-
Integrate Theia IDE with Live Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Build AI Agents with Presto Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Presto through CData Connect AI.
-
Create a Data Access Object for Microsoft Teams Data using JDBI
A brief overview of creating a SQL Object API for Microsoft Teams in JDBI.
-
Create Gmail-Connected Nintex Workflows
Use CData Connect AI to connect to Gmail Data from Nintex Workflow Cloud and build custom workflows using live Gmail.
-
How to Connect to Live JSON Services in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your JSON for you.