CData Software - Knowledge Base
Recent Articles
-
Build Agents in Relevance AI with Access to Live Airtable via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Airtable within intelligent agent workflows.
-
Design BIRT Reports on Twilio
Provide current Twilio to your embedded analytics.
-
Replicate WordPress from PowerShell
Write a quick PowerShell script to query WordPress. Use connectivity to the live data to replicate WordPress to SQL Server.
-
Deploy the ADO.NET Provider for Certinia on an SSRS Report Server
Connect to Certinia 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.
-
Build a PostgreSQL Interface for Stripe using the CData JDBC Driver
Use the Remoting features of the Stripe JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Access Live Salesforce Marketing in Power Automate Desktop via ODBC
The CData ODBC Driver for Salesforce Marketing enables you to integrate Salesforce Marketing Cloud into workflows built using Microsoft Power Automate Desktop.
-
Access Live LinkedIn Ads in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live LinkedIn Ads from your Excel spreadsheets.
-
Create Power BI Reports on Real-Time Airtable
Use the CData ODBC Driver for Airtable to visualize Airtable in Power BI Desktop.
-
Automate Azure Active Directory Replication to Azure Data Lake
Use CData Sync to customize and automate Azure Active Directory replication to Azure Data Lake.
-
Integrate MailChimp with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate MailChimp with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to MailChimp.
-
Connect to Bing Ads in Google Apps Script via SQL Gateway
Use the ODBC Driver for Bing Ads and the SQL Gateway to access Bing Ads from Google Apps Script.
-
View Reports on Real-Time Impala in Power BI Report Server
Use the CData ODBC Driver for Impala to visualize Apache Impala in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Bing Ads in Aqua Data Studio
Access Bing Ads from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Getting Started with the CData Excel Add-In for SurveyMonkey
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SurveyMonkey.
-
Integrate Cursor with Live Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Exact Online from within the editor.
-
Access Live Bullhorn CRM 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 Bullhorn CRM through MCP integration.
-
Connect to Printful in Aqua Data Studio
Access Printful from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Oracle Eloqua Reporting Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Oracle Eloqua Reporting data access from reports, embedded analytics, and more.
-
Connect to Zoho CRM as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Zoho CRM.
-
Automated Continuous Printful Replication to SQL Server
Use CData Sync for automated, continuous, customizable Printful replication to SQL Server.
-
How to Connect to Live SAP ByDesign 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 SAP Business ByDesign for you.
-
Automated Continuous Invoiced Replication to Oracle
Use CData Sync for automated, continuous, customizable Invoiced replication to Oracle.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Twitter
Provide connectivity to Twitter through an SAP BusinessObjects universe.
-
Integrate with Live MYOB AccountRight in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to MYOB AccountRight from the MuleSoft Anypoint Platform to integrate live MYOB AccountRight into custom reports and dashboards.
-
Build Dashboards with Impala in DBxtra
Create dynamic dashboards and perform analytics based on Apache Impala in DBxtra.
-
Create a Data Access Object for Dropbox using JDBI
A brief overview of creating a SQL Object API for Dropbox in JDBI.
-
Create Impala-Connected Business Apps in AppSheet
Connect to Impala via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Apache Impala.
-
Automated Continuous Zoho CRM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Zoho CRM replication to Apache Cassandra.
-
Visualize Invoiced from Tableau
Use the Tableau Desktop business intelligence tool to connect to Invoiced.
-
Integrate Acumatica with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Acumatica with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Acumatica ERP.
-
Integrate with ShipStation using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ShipStation to a JSON file on disk.
-
How to connect to DB2 with Squirrel SQL client
Connect to IBM DB2 and execute queries in the Squirrel SQL Client.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed ADP to Power BI dashboards. Simply drag and drop ADP into data visuals on the Power BI canvas.
-
Stream Oracle SCM into Apache Kafka Topics
Access and stream Oracle SCM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Act CRM from PowerBuilder via JDBC
This article demonstrates how to access Act CRM from PowerBuilder using the Act CRM JDBC Driver.
-
Build Visualizations of Amazon Athena in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Amazon Athena in Birst.
-
Visualize Reckon in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Reckon into TIBCO Spotfire.
-
Automated SurveyMonkey Replication to Teradata
Use CData Sync to Customize and automate SurveyMonkey replication to Teradata.
-
Create Outreach.io Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Outreach.io data access from reports, embedded analytics, and more.
-
Access Live Azure Active Directory in AWS Lambda (with IntelliJ IDEA)
Connect to live Azure Active Directory in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to connect to BambooHR with Squirrel SQL client
Connect to BambooHR and execute queries in the Squirrel SQL Client.
-
Use the CData Software ODBC Driver for Zuora in MicroStrategy Desktop
Connect to Zuora in MicroStrategy Desktop using the CData Software ODBC Driver for Zuora.
-
Build a Singer.io Tap for ClickUp With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ClickUp data using
-
Automated Continuous Unbounce Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Unbounce replication to Amazon S3.
-
Seamlessly Bring Google Sheets into Retool Using CData Connect AI
Integrate Google Sheets data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Bridge Google Drive Connectivity with Apache NiFi
Access and process Google Drive in Apache NiFi using the CData JDBC Driver.
-
How to pipe Google Sheets to CSV in PowerShell
Use standard PowerShell cmdlets to access Google Sheets tables.
-
How to Query Live Microsoft Project Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft Project data in natural language using Python.
-
Prepare, Blend, and Analyze Oracle Financials Cloud in Alteryx Designer (ODBC)
Build workflows to access live Oracle Financials Cloud for self-service data analytics.
-
Connect to SAS xpt in Ruby
Connect to SAS XPORT in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Zoho Projects in DBArtisan
Use wizards in DBArtisan to configure Zoho Projects as a data source.
-
Connect to Zoho Inventory in CloverDX (formerly CloverETL)
Transfer Zoho Inventory using the visual workflow in the CloverDX data integration tool.
-
Visualize Sybase in TIBCO Spotfire through OData
Integrate Sybase into dashboards in TIBCO Spotfire.
-
Natively Connect to ServiceNow in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ServiceNow. Leverage the native support for ODBC in PHP.
-
Import eBay into the Power BI Service for Visualizations
Use CData Connect AI to connect to eBay and provide access to live eBay for custom reports in the Power BI Service.
-
Use the CData Software JDBC Driver for Trello in MicroStrategy
Connect to Trello in MicroStrategy Developer using the CData Software JDBC Driver for Trello.
-
Analyze ServiceNow with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ServiceNow from Power Pivot. You will use the Table Import Wizard to load ServiceNow. You can visually build the import query or use any SQL supported by the driver.
-
Analyze Live Excel Online in SAS Viya
Use CData Connect AI to connect to Microsoft Excel Online from SAS Viya and deploy self-service analytics using live Microsoft Excel Online.
-
How to Connect to Live Facebook Ads from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Facebook Ads for you.
-
Automated Continuous Adobe Analytics Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to OneLake in Microsoft Fabric.
-
Build Outreach.io-Connected Apps in Choreo
Use CData Connect AI to connect to Outreach.io from Choreo and build custom apps using live Outreach.io.
-
Work with Snapchat Ads in FoxPro
Load Snapchat Ads into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect to Live Splunk from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Splunk for you.
-
How to Query Live SAP Business One in Perplexity MacOS Desktop
Connect to and query live SAP Business One in Perplexity Desktop using CData Code Assist MCP.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Square using the Model Context Protocol.
-
Automated Continuous LinkedIn Replication to IBM DB2
Use CData Sync for automated, continuous, customizable LinkedIn replication to IBM DB2.
-
Connect to Blackbaud FE NXT as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Blackbaud FE NXT.
-
Replicate Databricks from PowerShell
Write a quick PowerShell script to query Databricks. Use connectivity to the live data to replicate Databricks to SQL Server.
-
Trigger Couchbase IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Build Dashboards with Sybase in DBxtra
Create dynamic dashboards and perform analytics based on Sybase in DBxtra.
-
Connect to and Query Airtable in QlikView over ODBC
Create data visualizations with Airtable in QlikView.
-
Back Up EnterpriseDB to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for EnterpriseDB. In this article, we will employ an SSIS workflow to populate a database with EnterpriseDB data.
-
Create Reports with Zendesk in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zendesk.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live FHIR using the Model Context Protocol.
-
Automated Continuous Sage Intacct Replication to MongoDB
Use CData Sync for automated, continuous, customizable Sage Intacct replication to MongoDB.
-
Using the CData Software ODBC Driver for YouTube Analytics in PyCharm
Connect to YouTube Analytics as an ODBC data source in PyCharm using the CData Software ODBC Driver for YouTube Analytics.
-
Getting Started with the CData Excel Add-In for MailChimp
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for MailChimp.
-
Load Shippo to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Shippo to a database.
-
Create Dashboards and Visualize Live SendGrid in Geckoboard
Use CData Connect AI to connect to live SendGrid and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Import Data from SAP ByDesign into Google Sheets
Import SAP Business ByDesign into a Google spreadsheet that is automatically refreshed.
-
Model Vault CRM Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Vault CRM, enabling the direct import of real-time Veeva Vault & Vault CRM.
-
Connect to EventBrite in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build Parquet-Powered Applications in Cursor with CData Code Assist MCP
-