CData Software - Knowledge Base
Recent Articles
-
Integrate Theia IDE with Live NetSuite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Automate Omnisend Data Replication to SAP HANA
Use CData Sync to customize and automate Omnisend replication to SAP HANA.
-
How to Work with SAP Fieldglass Data in AWS Glue Jobs Using JDBC
Connect to SAP Fieldglass from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build a Singer.io Tap for Nuclia With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Nuclia data using
-
Getting Started with the CData JDBC Driver for ZohoSubscriptions
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ZohoSubscriptions.
-
Import Real-Time Scrapfly Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Scrapfly in ColdFusion.
-
Automated Continuous Sugar CRM Replication to Databricks
Use CData Sync for automated, continuous, customizable Sugar CRM replication to Databricks.
-
Connect to SurveyMonkey Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SurveyMonkey from Filemaker Pro on Mac.
-
Create Airtable-Connected Business Apps in AppSheet
Connect to Airtable Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Airtable.
-
Load Zoho Creator Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Zoho Creator to a database.
-
Build LinkedIn-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for LinkedIn to explore live LinkedIn Data in Cursor to assist with building LinkedIn-powered applications.
-
Connect to Redshift from a Connection Pool in WebLogic
Use the CData JDBC Driver for Redshift to connect to Amazon Redshift from Web applications running on WebLogic.
-
Visualize LinkedIn Data in TIBCO Spotfire through ADO.NET
Integrate LinkedIn into dashboards in TIBCO Spotfire.
-
How to Easily Query Dynamics 365 Data in OpenOffice Base
Connect to Dynamics 365 data in OpenOffice Base using the CData ODBC Driver for Dynamics 365 and generate reports with live data insights.
-
Create Data Visualizations in Cognos BI with Dotmailer Data
Access Dotmailer as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Reports with Opsgenie Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Opsgenie.
-
Using CData ODBC drivers from SharePoint Excel Services
This article demonstrates how to use the CData ODBC drivers to connect to an external data source from Excel spreadsheets in SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards in their Excel spreadsheets using data from sources like Salesforce, QuickBooks, Dynamics CRM and many more.
-
Publish Rootly-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Rootly.
-
Getting Started with the CData SSIS Components for AgileCRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for AgileCRM.
-
Access Live Stripe Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Stripe in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData Software ODBC Driver for xBase in MicroStrategy Web
Connect to xBase in MicroStrategy Web using the CData Software ODBC Driver for xBase.
-
PhantomBuster Reporting in OBIEE with the PhantomBuster JDBC Driver
Deploy the PhantomBuster JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Smartsheet-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Smartsheet.
-
How to Design Salesloft Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Salesloft from mobile and tablet Power Apps.
-
How to connect SharePoint with Spark Data through external lists
Provide Apache Spark SQL to SharePoint users as an external list.
-
Visualize Eventbrite Data in Sisense
Create an ElastiCube in Sisense app with access to Eventbrite.
-
Build ActiveCampaign-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for ActiveCampaign to explore live ActiveCampaign Data in Claude Code to assist with building ActiveCampaign-powered applications.
-
Prepare, Blend, and Analyze Salesforce Pardot Data in Alteryx Designer (Connect AI)
Build workflows to access live Salesforce Pardot for self-service data analytics.
-
Natively Connect to Greenhouse Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Greenhouse. Leverage the native support for ODBC in PHP.
-
How to create Sage Cloud Accounting federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Sage Business Cloud Accounting in MySQL .
-
How to Query Live Greenplum Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Pivotal GreenPlum data in natural language using Python.
-
Publish PingOne-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live PingOne.
-
Publish Crystal Reports on Gorgias Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Gorgias.
-
Connecting Moonlit Workflow with Slack Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Slack in real time.
-
How to publish and share EmailOctopus Data dashboards with Tableau Server
The CData ODBC driver for EmailOctopus enables you integrate EmailOctopus into Tableau dashboards.
-
Replicate Avalara AvaTax Data to Multiple Databases
Replicate Avalara AvaTax to disparate databases with a point-and-click configuration.
-
Explore Geographical Relationships in ClickTime Data with Power Map
Create data visualizations with ClickTime in Power Map.
-
Getting Started with the CData Power BI Connector for Bright Data
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Analyze Live Dynamics CRM Data in SAS Viya
Use CData Connect AI to connect to Microsoft Dynamics CRM from SAS Viya and deploy self-service analytics using live Microsoft Dynamics CRM.
-
Replicate Multiple Float Accounts via the CData Sync CLI
Replicate multiple Float accounts to one or many databases.
-
Integrating LlamaIndex with ShipStation Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on ShipStation in real time.
-
Import OneNote Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to OneNote Data and provide access to live Microsoft OneNote for custom reports in the Power BI Service.
-
Automated Continuous Mailgun Replication to Databricks
Use CData Sync for automated, continuous, customizable Mailgun replication to Databricks.
-
Use Azure AI Foundry to Talk to Your Asana 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 Asana for you.
-
Back Up Onfleet 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 Onfleet data.
-
How to Design Odoo Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Odoo from mobile and tablet Power Apps.
-
Query Hubstaff Data in ColdFusion
Write standard ColdFusion data access code to connect to Hubstaff.
-
Query ActiveCampaign Data in ColdFusion
Write standard ColdFusion data access code to connect to ActiveCampaign.
-
Connect to Amazon DynamoDB Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Amazon DynamoDB and the Script function in FileMaker Pro to connect to Amazon DynamoDB and work with Amazon DynamoDB in your FileMaker application.
-
How to integrate Metabase with OneNote Data
Use CData Connect AI to connect to live Microsoft OneNote and create an interactive dashboard in Metabase from Microsoft OneNote.
-
Connect to PivotalTracker Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for PivotalTracker in the Denodo Virtual DataPort Administrator.
-
Automated Continuous GitHub Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable GitHub replication to Google Cloud SQL.
-
Connect to Azure DevOps Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Azure DevOps in the Denodo Virtual DataPort Administrator.
-
Stream MailerSend Data into Apache Kafka Topics
Access and stream MailerSend in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to create an RPA flow for Scrapfly Data in UiPath Studio
Use the Scrapfly ODBC Driver to create workflows that access real-time Scrapfly without any coding.
-
Build Voice Agents in ElevenLabs with access to Live Amazon DynamoDB Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Amazon DynamoDB.
-
Natively Connect to Sage Cloud Accounting Data in PHP
The CData ODBC driver for Sage Cloud Accounting enables you to create PHP applications with connectivity to Sage Business Cloud Accounting. Leverage the native support for ODBC in PHP.
-
Build Data Flows from SQL Server to Splunk through SSIS
Easily push SQL Server data to Splunk using the CData SSIS Tasks for Splunk.
-
Extend Google Sheets with RSS Feeds
Make calls to RSS from Google Apps Script via the API Server.
-
Use Databricks Agent Bricks to Talk to Your ActiveCampaign Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your ActiveCampaign for you.
-
Analyze Raisers Edge NXT Data in Looker
Use CData Connect AI to connect to Raisers Edge NXT Data from Looker and build custom apps using live Raisers Edge NXT.
-
Query Freshservice Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Freshservice from Node.js.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP Hybris C4C using the Model Context Protocol.
-
View Reports on Real-Time Couchbase Data in Power BI Report Server
Use the CData ODBC Driver for Couchbase to visualize Couchbase in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData Software JDBC Driver for OData in MicroStrategy Web
Connect to OData in MicroStrategy Web using the CData Software JDBC Driver for OData.
-
Connect to OnePageCrm Data in CloverDX (formerly CloverETL)
Transfer OnePageCrm using the visual workflow in the CloverDX data integration tool.
-
Connect to Cosmos DB Data in Claris FileMaker Pro
Use the CData ODBC Driver for Cosmos DB in FileMaker Pro to connect to Cosmos DB and work with Azure Cosmos DB in your FileMaker applications.
-
Connect to ZohoSubscriptions Data in CloverDX (formerly CloverETL)
Transfer ZohoSubscriptions using the visual workflow in the CloverDX data integration tool.
-
Connect to ADP Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with ADP Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Connect to Phoenix Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Apache Phoenix. Leverage the pyodbc module for ODBC in Python.
-
Migrating data from SendInBlue to Google BigQuery using CData SSIS Components.
Easily push SendInBlue to Google BigQuery using the CData SSIS Tasks for SendInBlue and Google BigQuery.
-
Natively Connect to Parallel Data in PHP
The CData ODBC driver for Parallel enables you to create PHP applications with connectivity to Parallel. Leverage the native support for ODBC in PHP.
-
Build SparkPost-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SparkPost and build web apps with connectivity to live SparkPost.
-
Connect to Salesforce Marketing Data in HULFT Integrate
Connect to Salesforce Marketing as a JDBC data source in HULFT Integrate
-
How to Create Power BI Visual Reports with Real-Time LeadDesk Data
Use CData Power BI Connectors to visualize LeadDesk in Power BI.
-
Replicate LeadDesk Data from PowerShell
Write a quick PowerShell script to query LeadDesk. Use connectivity to the live data to replicate LeadDesk to SQL Server.
-
Automated Continuous DocuSign Replication to Oracle
Use CData Sync for automated, continuous, customizable DocuSign replication to Oracle.
-
Create Reports with Lakebase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Lakebase.
-
Visualize Live PhantomBuster Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live PhantomBuster using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Data Visualizations in Cognos BI with MariaDB Data
Access MariaDB as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to ShipEngine Data in JRuby
Create a simple JRuby app with access to live ShipEngine.
-
Integrating GitHub Copilot CLI with Reckon Accounts Hosted 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 Apollo Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Apollo and work with Apollo in your FileMaker applications.
-
Build Dashboards with VWO Data in DBxtra
Create dynamic dashboards and perform analytics based on VWO in DBxtra.
-
Connect to Microsoft Teams Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to connect Amazon QuickSight to Google Analytics Data
Create a connection to Google Analytics in CData Connect AI and insert Google Analytics into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Power BI Reports on Real-Time HelloSign Data
Use the CData ODBC Driver for HelloSign to visualize HelloSign in Power BI Desktop.
-
How to Build an ETL App for ZohoInvoice Data in Python with CData
Create ETL applications and real-time data pipelines for ZohoInvoice in Python with petl.
-
Use the CData API Server to Access ServiceNow Data in Microsoft PowerPivot
Use the CData API Server to connect to live ServiceNow in the Power Pivot business intelligence tool.
-
Create Power BI Reports on Real-Time Accelo Data
Use the CData ODBC Driver for Accelo to visualize Accelo in Power BI Desktop.
-
Add Egnyte Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Egnyte with the Informatica Enterprise Data Catalog to classify and organize data.
-
Migrating data from CouchDB to Snowflake using CData SSIS Components.
Easily push Apache CouchDB to Snowflake using the CData SSIS Tasks for CouchDB and Snowflake.
-
Choosing the Best Method to Connect IBM Cloud Object Storage to SQL Server: 5 Options Explained
Discover multiple ways to connect and use IBM Cloud Object Storage from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating Kiro CLI with Facebook 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.
-
Publish Splunk-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Splunk.
-
How to connect to Reckon Data from Spring Boot
Connect to Reckon in a Spring Boot Application using the CData JDBC Driver for Reckon
-
Viewing Gmail Data in RAD Studio Data Explorer
How to view Gmail in RAD Studio Data Explorer using the CData ODBC Driver for Gmail.
-
Automated Continuous Mode Replication to Vertica
Use CData Sync for automated, continuous, customizable Mode replication to Vertica.
-
Access Nethunt Data from MySQL in PHP
Connect to Nethunt through the standard MySQL libraries in PHP.
-
Access Live Salesloft Data in AWS Lambda
Connect to live Salesloft in AWS Lambda using the CData JDBC Driver.