CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live SAP SuccessFactors LMS 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 SAP SuccessFactors LMS data for you.
-
How to Build an ETL App for Twilio Data in Python with CData
Create ETL applications and real-time data pipelines for Twilio data in Python with petl.
-
Trigger Zendesk IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Zendesk with standard wizards in Logic Apps.
-
Automated Continuous Salesforce CRM Analytics Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to Google BigQuery.
-
Manage Todoist Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Todoist.
-
Connect CampaignMonitor to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect CampaignMonitor with IBM WebSphere for seamless data integration and connectivity.
-
Back Up AgileCRM 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 AgileCRM data data.
-
Connect to Bright Data Data in Aqua Data Studio
Access Bright Data data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to SAP BusinessObjects BI Data from AWS Glue
Use CData Connect AI to gain access to live SAP BusinessObjects BI data from your AWS Glue jobs.
-
How to connect PolyBase to NetSuite
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live NetSuite data.
-
Provide OData Services of Odoo Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Odoo data by developing a WCF Service Application.
-
Automated Continuous Sendwithus Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Sendwithus replication to Amazon S3.
-
Integrate Live Intercom Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Intercom data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Replicate HubSpot Data to Multiple Databases
Replicate HubSpot data to disparate databases with a point-and-click configuration.
-
Create SSAS Tabular Models from Sage Intacct Data
How to build a SQL Server Analysis Service Tabular Model from Sage Intacct data using CData drivers.
-
Connect to and Visualize Live Quickbase Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Quickbase data.
-
Automated Continuous Stripe Replication to Snowflake
Use CData Sync for automated, continuous, customizable Stripe replication to Snowflake.
-
Access Live SAP Fieldglass Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live SAP Fieldglass data through MCP integration.
-
Connect to SAP Concur Data in DBeaver
Use the CData ODBC Driver to connect to SAP Concur data in DBeaver.
-
Automated Continuous Kintone Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Kintone replication to Apache Kafka.
-
Establish a Live Connection with Cloudant Data using Tableau Bridge
The CData ODBC Driver for Cloudant enables you to integrate live Cloudant data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Act-On Data in the Pentaho Report Designer
Publish reports based on Act-On data in the Pentaho BI tool.
-
Natively Connect to EnterpriseDB Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to EnterpriseDB data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Outlook Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Outlook replication to IBM DB2.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Missive
Provide connectivity to Missive data through an SAP BusinessObjects universe.
-
Getting Started with the CData ODBC Driver for Templated
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Templated.
-
How to Connect to Live Oracle HCM Cloud 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 Oracle HCM Cloud data for you.
-
Connecting GenSpark with Smartsheet Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Smartsheet data without any replication or custom integration required.
-
How to Create Power BI Visual Reports with Real-Time JSON Services
Use CData Power BI Connectors to visualize JSON services in Power BI.
-
Use the CData Software ODBC Driver for Excel in MicroStrategy
Connect to Excel data in MicroStrategy Developer using the CData Software ODBC Driver for Excel.
-
Build Presto-Connected Apps in Choreo
Use CData Connect AI to connect to Presto Data from Choreo and build custom apps using live Presto data.
-
Integrate Theia IDE with Live Supabase 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 Supabase data from within the development environment.
-
Analyze Google Cloud Storage Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Cloud Storage data and visualize live Google Cloud Storage data in Infragistics Reveal.
-
Connect to SAP SuccessFactors Data in NetBeans
Connect to SAP SuccessFactors data in NetBeans with the data source configuration wizard.
-
Access Google Translate Data from MySQL in PHP
Connect to Google Translate through the standard MySQL libraries in PHP.
-
Connect to SAP Business Warehouse Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP Business Warehouse data from HeidiSQL.
-
Connect to CampaignMonitor Data as an External Source in Dremio
Use the CData JDBC Driver to connect to CampaignMonitor as an External Source in Dremio.
-
Access Live Kintone Data in TIBCO Data Virtualization
Use the Kintone Tibco DV Adapter to create a Kintone data data source in TIBCO Data Virtualization Studio and gain access to live Kintone data from your TDV Server.
-
Integrate Google's Vertex AI Agent with Live Apify 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 Apify data within intelligent workflows.
-
Create Dynamic Discord Grids Using the Infragistics XamDataGrid
Learn how you can connect Discord to Infragistics XamDataGrid to build dynamic grids.
-
Replicate SAP Fieldglass Data from PowerShell
Write a quick PowerShell script to query SAP Fieldglass data. Use connectivity to the live data to replicate SAP Fieldglass data to SQL Server.
-
Connect to PagerDuty Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for PagerDuty and the SQL Gateway to access PagerDuty data from Google Apps Script.
-
Integrating Cursor with HDFS 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.
-
Integrate Open WebUI with Live SFTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SFTP data from within the chat interface.
-
Connect Quickbase Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Quickbase data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
A PostgreSQL Interface for Webex Data using the CData ODBC Driver
Use the SQL Gateway and Webex ODBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind SurveyMonkey Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SurveyMonkey with the DevExpress Windows Forms and Web controls to provide SurveyMonkey data to a chart.
-
Access Azure Synapse Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Azure Synapse data from your Oracle system.
-
DataBind Controls to ZohoMarketingHub Data in C++Builder
DataBind to ZohoMarketingHub data in C++Builder with standard components and controls.
-
Getting Started with the CData Excel Add-In for OneNote
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for OneNote.
-
Automated Continuous Aweber Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Aweber replication to Apache Cassandra.
-
How to import Brex Data into Apache Solr
Use the CData Software JDBC Driver for Brex in Data Import Handler and create an automated import of Brex data to Apache Solr Enterprise Search platform.
-
Getting Started with the CData SSIS Components for HelloSign
Complete guide to installing, licensing, and connecting with the CData SSIS Components for HelloSign.
-
Integrate Live GetResponse Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to GetResponse from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live GetResponse data.
-
How to Create Power BI Visual Reports with Real-Time MariaDB Data
Use CData Power BI Connectors to visualize MariaDB data in Power BI.
-
Import and Visualize Exact Online Data in Power View
Create data visualizations based on Exact Online data in Excel.
-
Use Databricks Agent Bricks to Talk to Your SAP Ariba Source Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP Ariba Source data for you.
-
Build an OLAP Cube in SSAS from Foursquare Data
Establish a connection to Foursquare data data from SQL Server Analysis Services, and use the Foursquare Data Provider to build OLAP cubes for use in analytics and reporting.
-
Replicate Xero Data from PowerShell
Write a quick PowerShell script to query Xero data. Use connectivity to the live data to replicate Xero data to SQL Server.
-
Connect to and Query ZeroBounce Data in QlikView over ODBC
Create data visualizations with ZeroBounce data in QlikView.
-
Connect to Aircall Data in Aqua Data Studio
Access Aircall data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use JayDeBeApi to access Sage Cloud Accounting Data in Python
Use standard Python scripting and the development environment of your choice to access live Sage Cloud Accounting data.
-
Integrate Act CRM Data in the Pentaho Report Designer
Publish reports based on Act CRM data in the Pentaho BI tool.
-
Automated Continuous Salesforce Pardot Replication to Snowflake
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Snowflake.
-
Integrate Trae with Live Vault CRM Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Vault CRM data from within the AI-powered IDE.
-
Automated Continuous ElevenLabs Replication to SingleStore
Use CData Sync for automated, continuous, customizable ElevenLabs replication to SingleStore.
-
Connect to SAP SuccessFactors LMS from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP SuccessFactors LMS data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Presto Data in Jaspersoft Studio
Execute SQL to remote Presto data in Jaspersoft Studio.
-
Access Oracle SCM Data from MySQL in Amazon QuickSight
Connect to Oracle SCM and build visualizations of Oracle SCM data using a MySQL Connection in Amazon QuickSight.
-
Chargebee Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Chargebee facts in real time.
-
Connect to Odoo Data from AWS Glue
Use CData Connect AI to gain access to live Odoo data from your AWS Glue jobs.
-
Getting Started with the CData ODBC Driver for Office 365
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Office 365.
-
Automated Continuous Ontraport Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Ontraport replication to PostgreSQL.
-
Use the CData Software ODBC Driver for Gmail in MicroStrategy Desktop
Connect to Gmail data in MicroStrategy Desktop using the CData Software ODBC Driver for Gmail.
-
Automated Continuous ServiceDesk Plus Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ServiceDesk Plus replication to Azure SQL Database.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Sage 300
Provide connectivity to Sage 300 data through an SAP BusinessObjects universe.
-
Integrating GitHub Copilot with SAP Business Warehouse 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.
-
Integrate Dify with Live ShipStation Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live ShipStation data.
-
Connecting GenSpark with TaxJar Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to TaxJar data without any replication or custom integration required.
-
Connect to Kafka Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Kafka data.
-
Build SAP HANA-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SAP HANA Data from Zoho Analytics and import live SAP HANA data.
-
Create GitLab-Connected Dashboards in Grafana
Connect to GitLab Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to GitLab data.
-
Use ChatGPT to Talk to Your Microsoft Exchange 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 Microsoft Exchange data for you.
-
Deploy the ADO.NET Provider for SageHR on an SSRS Report Server
Connect to SageHR data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Use the CData Software ODBC Driver for Vault CRM in SAS for Real-Time Reporting and Analytics
Connect to real-time Vault CRM data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Vault CRM.
-
Use Agno to Talk to Your Coda 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 Coda data for you.
-
DataBind Controls to Sage 300 Data in C++Builder
DataBind to Sage 300 data in C++Builder with standard components and controls.
-
How to integrate CapsuleCRM with Apache Airflow
Access and process CapsuleCRM data in Apache Airflow using the CData JDBC Driver.
-
Connect to Presto Data in Ruby
Connect to Presto data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connecting Agentforce with Airtable 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 Airtable data for you.
-
How to connect to Exa Data in DBVisualizer
Integrate Exa data with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze Salesforce CRM Analytics Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Salesforce CRM Analytics data and visualize live Salesforce CRM Analytics data in Infragistics Reveal.
-
Object-Relational Mapping (ORM) with Epicor Kinetic Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Epicor Kinetic data into a Java-based ORM framework, Hibernate.
-
How to integrate Metabase with Power BI XMLA Data
Use CData Connect AI to connect to live Power BI XMLA data and create an interactive dashboard in Metabase from Power BI XMLA data.
-
Automated Continuous DB2 for i Replication to IBM DB2
Use CData Sync for automated, continuous, customizable DB2 for i replication to IBM DB2.
-
Write a Simple Go Application to work with Sage Cloud Accounting Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Sage Cloud Accounting data.
-
Use the CData SSIS Components to Insert New or Update Existing Salesloft Records from SQL Server
Easily push SQL Server data to Salesloft using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Salesloft or update existing records with data from a SQL Server database.
-
Visualize Live Testmonitor Data in the Power BI Service
Use CData Connect AI to connect to live Testmonitor data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Printify Replication to SingleStore
Use CData Sync for automated, continuous, customizable Printify replication to SingleStore.
-
Bridge SAP HANA Connectivity with Apache NiFi
Access and process SAP HANA data in Apache NiFi using the CData JDBC Driver.