CData Software - Knowledge Base
Recent Articles
-
Load PagerDuty Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load PagerDuty data to a database.
-
How to connect to Adobe Commerce Data from IntelliJ
Integrate connectivity to Adobe Commerce data with wizards in IntelliJ.
-
Replicate Yelp Data to Multiple Databases
Replicate Yelp data to disparate databases with a point-and-click configuration.
-
Integrate OpenCode with Live OData Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live OData services from within your AI coding agent.
-
Build Teradata-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Teradata data.
-
Build Adobe Target-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Adobe Target Data and create custom apps in Bubble.
-
Build Automated Workflows with Live Klipfolio Data in Workato
Use CData Connect AI to connect to live Klipfolio data and build automated workflows in Workato.
-
Access Freshsales Data from MySQL in PHP
Connect to Freshsales through the standard MySQL libraries in PHP.
-
Connect to Unbounce Data in Ruby
Connect to Unbounce data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Extending QuickBooks Desktop Reporting
The CData ADO.NET Provider for QuickBooks Desktop make it easy for you to create new reports and customize existing ones. This article demonstrates how to create a new Profit and Loss Report. Using the ADO.NET provider, you can then retrieve it directly from Server Explorer in Visual Studio.
-
Automated Continuous SpaceX Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SpaceX replication to Google Cloud SQL.
-
Visualize Landbot Data in TIBCO Spotfire through ADO.NET
Integrate Landbot data into dashboards in TIBCO Spotfire.
-
Enable the Epicor Kinetic JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Epicor Kinetic data.
-
Analyze Helpscout Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Helpscout data with the CData JDBC Driver for Helpscout.
-
How to Connect to Live SendGrid Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your SendGrid data through natural language.
-
Azure Table Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Azure Table facts in real time.
-
Analyze Salesloft Data in Cognos Analytics
Use CData Connect AI to connect to Salesloft Data from Cognos Analytics and analyze live Salesloft data.
-
Provide OData Services of Foursquare Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Foursquare data by developing a WCF Service Application.
-
Create Informatica Mappings From/To an ODBC Data Source for Sentry
Create an ODBC connection to Sentry in Informatica and browse and transfer Sentry data.
-
Use Azure AI Foundry to Talk to Your Email 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 Email data for you.
-
How to Connect DBeaver to HBase via a JDBC Driver
Manage HBase data with visual tools in DBeaver like the query browser.
-
Integrate Live VWO Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to VWO data and integrate live VWO data into apps built in Microsoft Power Apps.
-
Integrate Mouseflow with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Mouseflow with External Services.
-
Query MariaDB Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume MariaDB entities in PHP by modeling them as objects.
-
Connect to Real-Time Outreach.io Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Outreach.io and Dataflow to import and use Outreach.io data in Power Apps.
-
Connect to CircleCI Data in RapidMiner
Integrate CircleCI data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Auth0 Data in the Pentaho Report Designer
Publish reports based on Auth0 data in the Pentaho BI tool.
-
A PostgreSQL Interface for Parallel Data using the CData ODBC Driver
Use the SQL Gateway and Parallel ODBC Driver to create a PostgreSQL entry-point for data access.
-
A PostgreSQL Interface for Deel Data (MySQL Remoting via JDBC)
Use the Remoting features of the Deel JDBC Driver to create a PostgreSQL entry-point for data access.
-
Excel Spreadsheet Automation on Adobe Analytics Data with the QUERY Formula
Pull data from Adobe Analytics, automate spreadsheets, and more with the QUERY formula.
-
Connect to SAP SuccessFactors from Asprova with CData Software ODBC Driver for SAP SuccessFactors
This article shows how to connect faster to SAP SuccessFactors data from Asprova.
-
Create Grafana-Connected Applications in Appsmith
Connect to Grafana Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Grafana data.
-
How to connect to Amplitude Data from Spring Boot
Connect to Amplitude in a Spring Boot Application using the CData API Driver for JDBC
-
How to Access Live IBM Cloud Object Storage Data in Power Automate Desktop via ODBC
The CData ODBC Driver for IBM Cloud Object Storage enables you to integrate IBM Cloud Object Storage data into workflows built using Microsoft Power Automate Desktop.
-
Build Agents in Relevance AI with Access to Live SAP SuccessFactors Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP SuccessFactors data within intelligent agent workflows.
-
Connect to Yelp Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Yelp to connect to Yelp data and execute queries in PowerBuilder.
-
Connect to Google Drive Data in ACL Analytics
Connect to Google Drive data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Drive data.
-
How to Work with Hubstaff Data in ETL Validator JDBC
Connect to Hubstaff from ETL Validator jobs using the CData Software JDBC Driver.
-
Load Zoho Projects Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Zoho Projects data to a database.
-
Automate Cosmos DB Data Replication to SAP HANA
Use CData Sync to customize and automate Cosmos DB data replication to SAP HANA.
-
Create Power BI Reports on Real-Time SAP HANA XS Advanced Data
Use the CData ODBC Driver for SAP HANA XS Advanced to visualize SAP HANA XS Advanced data in Power BI Desktop.
-
How to connect to Google Forms Data with Squirrel SQL client
Connect to Google Forms data and execute queries in the Squirrel SQL Client.
-
Integrating Kiro with QuickBooks 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.
-
How to Connect to Live Optimizely 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 Optimizely data for you.
-
Connect to Google Drive Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Drive Data and connect to Google Drive data in Akorbi Digital RunMyProcess.
-
How to connect to PingOne Data with Squirrel SQL client
Connect to PingOne data and execute queries in the Squirrel SQL Client.
-
Moving Data from LeadDesk to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live LeadDesk data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating Gumloop with SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP SuccessFactors LMS data within automated workflows.
-
DataBind SAP Business Warehouse Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAP Business Warehouse with the DevExpress Windows Forms and Web controls to provide SAP Business Warehouse data to a chart.
-
Automated Continuous Workable Replication to MySQL
Use CData Sync for automated, continuous, customizable Workable replication to MySQL.
-
Access HelloSign Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access HelloSign data from your Oracle system.
-
Connect to CircleCI Data in DBeaver
Use the CData ODBC Driver to connect to CircleCI data in DBeaver.
-
Automated Continuous Insightly Replication to SingleStore
Use CData Sync for automated, continuous, customizable Insightly replication to SingleStore.
-
Connect to Avro Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Avro data in Airbyte.
-
Explore Geographical Relationships in Tanda Data with Power Map
Create data visualizations with Tanda data in Power Map.
-
Build Pipedrive-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Pipedrive data and build Pipedrive-connected web apps with Axios.
-
Automated Continuous Freshservice Replication to MySQL
Use CData Sync for automated, continuous, customizable Freshservice replication to MySQL.
-
Rapidly Develop Templated-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 Templated.
-
Load Raisers Edge NXT Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Raisers Edge NXT data to a database.
-
Connect to Coda Data in RazorSQL
Connect to Coda from wizards and query Coda data from the GUI in the RazorSQL database management tool.
-
Use the CData Software JDBC Driver for Tally in MicroStrategy Desktop
Connect to Tally data in MicroStrategy Desktop using the CData Software JDBC Driver for Tally.
-
Create SuiteCRM-Connected Nintex Workflows
Use CData Connect AI to connect to SuiteCRM Data from Nintex Workflow Cloud and build custom workflows using live SuiteCRM data.
-
How to Connect to Live Bitbucket Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Bitbucket data securely in real time.
-
Visualize Oracle HCM Cloud Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Oracle HCM Cloud data.
-
Visualize Quickbase Data in TIBCO Spotfire through ADO.NET
Integrate Quickbase data into dashboards in TIBCO Spotfire.
-
Configure the CData JDBC Driver for Microsoft Teams in a Connection Pool in Tomcat
Connect to Microsoft Teams data from a connection pool in Tomcat.
-
Back Up NASA data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with NASA data data.
-
Automated Continuous ScrapingBee Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ScrapingBee replication to delimited files (CSV/TSV).
-
Build Visualizations of SendInBlue Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SendInBlue data in Birst.
-
Build Dashboards with Sage Cloud Accounting Data in Dundas BI
Create dynamic dashboards and perform analytics based on Sage Cloud Accounting data in Dundas BI.
-
Use ChatGPT to Talk to Your Adobe Commerce 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 Adobe Commerce data for you.
-
How to Connect to Live Sage Intacct Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Sage Intacct data through natural language.
-
How to Visualize Webex Data in Python with pandas
Use pandas and other modules to analyze and visualize live Webex data in Python.
-
Integrate with live Box Data in Jitterbit
Use CData Connect AI to connect to and integrate live Box data in Jitterbit.
-
Automated Continuous Calendly Replication to SQL Server
Use CData Sync for automated, continuous, customizable Calendly replication to SQL Server.
-
Visualize Box Data in Sisense
Create an ElastiCube in Sisense app with access to Box data.
-
A PostgreSQL Interface for Google Spanner Data (MySQL Remoting via JDBC)
Use the Remoting features of the Google Spanner JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect DBeaver to Impala via a JDBC Driver
Manage Impala data with visual tools in DBeaver like the query browser.
-
Integrating SparkPost Data in Talend Cloud Data Management Platform
Connect SparkPost Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Load Strava Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Strava data to a database.
-
Create Salesforce Pardot-Connected Applications in Appsmith
Connect to Salesforce Pardot Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Salesforce Pardot data.
-
Connect to ScrapingBee Data from PowerBuilder via JDBC
This article demonstrates how to access ScrapingBee data from PowerBuilder using the ScrapingBee JDBC Driver.
-
How to Connect to Live Cassandra 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 Cassandra data for you.
-
Automate Paddle Data Replication to Couchbase
Use CData Sync to Customize and automate Paddle data replication to Couchbase.
-
Build Semantic Layer Views for CSV Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for CSV data.
-
Consume Email OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Email feeds that reflect any changes in SAP Lumira.
-
Build Data Flows from Vimeo to SQL Server using SSIS
Easily back up Vimeo data to SQL Server using the SSIS components for Vimeo.
-
Migrating data from eBay to Snowflake using CData SSIS Components.
Easily push eBay data to Snowflake using the CData SSIS Tasks for eBay and Snowflake.
-
How to Connect to Live SharePoint 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 SharePoint data for you.
-
Build Pipelines with Live Google Forms Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Forms from Google Cloud Data Fusion, enabling the integration of live Google Forms data into the building and management of effective data pipelines.
-
How to Connect to Live Sybase 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 Sybase data for you.
-
Integrate Google's Antigravity Agent with Live Excel Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Excel Online data using the Model Context Protocol.
-
Connect and Visualize Live CouchDB Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live CouchDB data into the Databricks platform and create visualization dashboards with real-time CouchDB data.
-
Connect to Reply.io Data in Aqua Data Studio
Access Reply.io data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to use SQLAlchemy ORM to access Paylocity Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Paylocity data.
-
Connect to Rootly Data in RazorSQL
Connect to Rootly from wizards and query Rootly data from the GUI in the RazorSQL database management tool.
-
ETL Airtable in Oracle Data Integrator
This article shows how to transfer Airtable data into a data warehouse using Oracle Data Integrator.
-
Use the CData Software ODBC Driver for Outreach.io in MicroStrategy
Connect to Outreach.io data in MicroStrategy Developer using the CData Software ODBC Driver for Outreach.io.
-
How to Work with Mixpanel Data in ETL Validator JDBC
Connect to Mixpanel from ETL Validator jobs using the CData Software JDBC Driver.
-
Build a Singer.io Tap for FreshBooks With the CData Python Connector
Learn how to easily build a Singer.io Tap for live FreshBooks data using the CData Python Connector.