CData Software - Knowledge Base
Recent Articles
-
Create Google Analytics-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Google Analytics Data from OutSystems and build custom enterprise apps using live Google Analytics data.
-
Automate Ontraport Data Replication to SAP HANA
Use CData Sync to customize and automate Ontraport data replication to SAP HANA.
-
Create Dynamic Reckon Accounts Hosted Grids Using the Infragistics XamDataGrid
Learn how you can connect Reckon Accounts Hosted to Infragistics XamDataGrid to build dynamic grids.
-
Back Up GetResponse 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 GetResponse data data.
-
Connect to Suadeo Data in Aqua Data Studio
Access Suadeo data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Visualize Live Pinterest Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Pinterest data.
-
Create ActiveCampaign-Connected Business Apps in AppSheet
Connect to ActiveCampaign Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to ActiveCampaign data.
-
Back Up Dynamics CRM data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Dynamics CRM. In this article, we will employ an SSIS workflow to populate a database with Dynamics CRM data data.
-
Deploy the ADO.NET Provider for NASA on an SSRS Report Server
Connect to NASA 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.
-
Automated Continuous ZohoMarketingHub Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to IBM DB2.
-
Replicate Multiple Pingdom Accounts
Replicate multiple Pingdom accounts to one or many databases.
-
Integrate Google's Antigravity Agent with Live JSON Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live JSON services using the Model Context Protocol.
-
How to Connect to Live Zendesk Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Zendesk data securely in real time.
-
Connect to Paddle Data from a Connection Pool in JBoss
Integrate Paddle data into Java servlets: Use the Management Console in JBoss to install the Paddle JDBC Driver.
-
Aweber Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Aweber facts in real time.
-
Replicate Spotify Data in Heroku for Use in Salesforce Connect
Replicate Spotify data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Microsoft Entra ID Replication to Vertica
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to Vertica.
-
Establish a Live Connection with SAP BusinessObjects BI Data using Tableau Bridge
The CData ODBC Driver for SAP BusinessObjects BI enables you to integrate live SAP BusinessObjects BI data into Tableau Cloud dashboards using the Tableau Bridge.
-
Getting Started with the CData Excel Add-In for Harvest
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Harvest.
-
How to connect PolyBase to Bullhorn CRM
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Bullhorn CRM data.
-
Create Dynamic Invoiced Grids Using the Infragistics XamDataGrid
Learn how you can connect Invoiced to Infragistics XamDataGrid to build dynamic grids.
-
Moving Data from Bitly to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Bitly data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use CData Connect AI to Access Google Ads Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Ads data in the Power Pivot business intelligence tool.
-
Build Workday-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Workday data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for MongoDB
Provide connectivity to MongoDB data through an SAP BusinessObjects universe.
-
Import and Visualize Customer.io Data in Power View
Create data visualizations based on Customer.io data in Excel.
-
Excel Spreadsheet Automation on Cassandra Data with the QUERY Formula
Pull data from Cassandra, automate spreadsheets, and more with the QUERY formula.
-
Load SQL Analysis Services Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SQL Analysis Services data to a database.
-
Connecting Mastra with FTP 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 FTP data, no replication required.
-
Automated Continuous Zoho Creator Replication to MySQL
Use CData Sync for automated, continuous, customizable Zoho Creator replication to MySQL.
-
Build a Singer.io Tap for Sage Cloud Accounting With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Sage Cloud Accounting data using the CData Python Connector.
-
Automated Continuous DocuSign Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable DocuSign replication to Amazon Redshift.
-
Access Live Slack Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Slack data from your Google Sheets.
-
Access NASA Data from MySQL in PHP
Connect to NASA through the standard MySQL libraries in PHP.
-
Create Oracle HCM Cloud-Connected Nintex Workflows
Use CData Connect AI to connect to Oracle HCM Cloud Data from Nintex Workflow Cloud and build custom workflows using live Oracle HCM Cloud data.
-
How to Work with Bugsnag Data in ETL Validator JDBC
Connect to Bugsnag from ETL Validator jobs using the CData Software JDBC Driver.
-
Build a PostgreSQL Interface for ServiceNow Data using the CData JDBC Driver
Use the Remoting features of the ServiceNow JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Azure Synapse Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Azure Synapse data from Node.js.
-
How to Visualize ServiceNow Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live ServiceNow data in Python.
-
Connect to ServiceDesk Plus Data in Google Apps Script via Connect AI
Use CData Connect AI to access ServiceDesk Plus data in Google Apps Script.
-
Build Semantic Layer Views for Placid Data in APOS Live Data Gateway
Use the CData Connector for Placid in APOS Live Data Gateway to build Semantic Layer Views for Placid data.
-
Access Live Splunk Data in TIBCO Data Virtualization
Use the Splunk Tibco DV Adapter to create a Splunk data data source in TIBCO Data Virtualization Studio and gain access to live Splunk data from your TDV Server.
-
Visualize CloudConvert Data in TIBCO Spotfire through ADO.NET
Integrate CloudConvert data into dashboards in TIBCO Spotfire.
-
Access Live WordPress Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live WordPress data through MCP integration.
-
How to Build an ETL App for BambooHR Data in Python with CData
Create ETL applications and real-time data pipelines for BambooHR data in Python with petl.
-
Connect to Zoho Inventory Data in RazorSQL
Connect to Zoho Inventory from wizards and query Zoho Inventory data from the GUI in the RazorSQL database management tool.
-
Access Live QuickBooks Time Data in Coginiti Pro
Connect to and query live QuickBooks Time data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to SurveyMonkey from a Connection Pool in WebLogic
Use the CData JDBC Driver for SurveyMonkey to connect to SurveyMonkey data from Web applications running on WebLogic.
-
Automated Continuous Coinbase Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Coinbase replication to Google Cloud SQL.
-
Automated Continuous ZohoPeople Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ZohoPeople replication to Amazon S3.
-
Build MailerLite-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live MailerLite data and build MailerLite-connected web apps with Axios.
-
Integrating Kiro with Basecamp 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 OpenWeatherMap Data with Squirrel SQL client
Connect to OpenWeatherMap data and execute queries in the Squirrel SQL Client.
-
Build Charts with Adobe Commerce Data in Clear Analytics
Create dynamic charts and perform analytics based on Adobe Commerce data in Clear Analytics.
-
How to Visualize Splunk Data in Python with pandas
Use pandas and other modules to analyze and visualize live Splunk data in Python.
-
Connect to OData from a Connection Pool in WebLogic
Use the CData JDBC Driver for OData to connect to OData services from Web applications running on WebLogic.
-
Integrate Live Shippo Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Shippo from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Shippo data.
-
Build Apps with Live Google Analytics Data Using the Low-Code Development Platform of Mendix
Connect Google Analytics data with Mendix to build apps using the CData JDBC Driver for Google Analytics.
-
Visualize Live HubDB Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live HubDB data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze GitHub Data in Looker
Use CData Connect AI to connect to GitHub Data from Looker and build custom apps using live GitHub data.
-
Replicate AgileCRM Data in Heroku for Use in Salesforce Connect
Replicate AgileCRM data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
A PostgreSQL Interface for Google Directory Data using the CData ODBC Driver
Use the SQL Gateway and Google Directory ODBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Crystal Reports on SendPulse Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SendPulse data.
-
How to Access Live Amazon Athena Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Amazon Athena enables you to integrate Amazon Athena data into workflows built using Microsoft Power Automate Desktop.
-
How to Create Power BI Visual Reports with Real-Time Gmail Data
Use CData Power BI Connectors to visualize Gmail data in Power BI.
-
Automated Continuous CapsuleCRM Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Azure SQL Database.
-
How to connect to Zoho Projects Data in DBVisualizer
Integrate Zoho Projects data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Work with Browserless Data in AWS Glue Jobs Using JDBC
Connect to Browserless from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to DocuSign from a Connection Pool in WebLogic
Use the CData JDBC Driver for DocuSign to connect to DocuSign data from Web applications running on WebLogic.
-
Connecting Pipedream with Box Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Box data in real time.
-
Design BIRT Reports on Teamwork Data
Provide current Teamwork data to your embedded analytics.
-
Create Twitter Ads-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Twitter Ads Data from OutSystems and build custom enterprise apps using live Twitter Ads data.
-
Easily Integrate Google Drive Data in Lazarus Pascal IDE
Learn how to easily integrate live Google Drive data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Visualize Live Sage 200 Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Sage 200 data.
-
Connect to Oracle Sales Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Oracle Sales as an External Source in Dremio.
-
Automated Continuous PagerDuty Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable PagerDuty replication to Google Cloud SQL.
-
Stream Short.io Data into Apache Kafka Topics
Access and stream Short.io data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
LINQ to Mailjet Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Mailjet Data Provider.
-
Natively Connect to Amazon Athena Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Amazon Athena data. Leverage the native support for ODBC in PHP.
-
Connect to Google Ads Data in RapidMiner
Integrate Google Ads data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to ADP in SpagoBI
Create reports featuring live ADP data in SpagoBI Studio. Host ADP reports on SpagoBI Server.
-
Connect to Facebook Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Facebook data.
-
Access ZohoExpense Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ZohoExpense data from your Oracle system.
-
Enable the Humanity JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Humanity data.
-
Replicate Gumroad Data to Multiple Databases via the CData Sync CLI
Replicate Gumroad data to disparate databases with a single configuration.
-
Connect to Helpscout Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Helpscout as an External Source in Dremio.
-
Publish Crystal Reports on SurveyMonkey Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SurveyMonkey data.
-
How to Connect Apify 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 Apify data in real time using natural language.
-
Integrate with Factorial Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Factorial data to a JSON file on disk.
-
How to Connect to Mouseflow Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Mouseflow data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Cohere Data in RapidMiner
Integrate Cohere data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Claude Code CLI with Splunk 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.
-
Import Cosmos DB Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Cosmos DB Data and provide access to live Cosmos DB data for custom reports in the Power BI Service.
-
Work with Telegram Data in FoxPro
Load Telegram data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData ADO.NET Provider for Bullhorn CRM
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Bullhorn CRM.
-
Connect to Databricks Data in NetBeans
Connect to Databricks data in NetBeans with the data source configuration wizard.
-
How to create an RPA flow for GitLab Data in UiPath Studio
Use the GitLab ODBC Driver to create workflows that access real-time GitLab data without any coding.
-
Connect to ActiveCampaign Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live ActiveCampaign data.
-
Build Epicor Kinetic-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Epicor Kinetic data.
-
Connect to Reckon Accounts Hosted Data from AWS Glue
Use CData Connect AI to gain access to live Reckon Accounts Hosted data from your AWS Glue jobs.