CData Software - Knowledge Base
Recent Articles
-
How to use SQLAlchemy ORM to access Facebook Ads Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Facebook Ads data.
-
Access Live Oracle Sales Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Oracle Sales data from your Excel spreadsheets.
-
Import Real-Time Amazon DynamoDB Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Amazon DynamoDB data in ColdFusion.
-
LeadDesk Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on LeadDesk facts in real time.
-
Use the CData Software JDBC Driver for Google Drive in MicroStrategy Desktop
Connect to Google Drive data in MicroStrategy Desktop using the CData Software JDBC Driver for Google Drive.
-
Use Manus AI to Talk to Your Moosend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Moosend data.
-
Connect EnterpriseDB to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live EnterpriseDB data using the CData Python MCP Server.
-
How to Connect to Live Facebook 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 Facebook data for you.
-
Connect to Toggl Data in RapidMiner
Integrate Toggl data with standard components and data source configuration wizards in RapidMiner Studio.
-
Visualize Codat Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Codat data.
-
A PostgreSQL Interface for Authorize.Net Data using the CData ODBC Driver
Use the SQL Gateway and Authorize.Net ODBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze LinkedIn Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze LinkedIn data in Microsoft R Open.
-
Viewing Spotify Data in RAD Studio Data Explorer
How to view Spotify data in RAD Studio Data Explorer using the CData ODBC Driver for Spotify.
-
Automated Continuous Excel Online Replication to Oracle
Use CData Sync for automated, continuous, customizable Excel Online replication to Oracle.
-
Access Reckon Accounts Hosted Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Reckon Accounts Hosted data.
-
Analyze Epicor Kinetic Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Epicor Kinetic data in Microsoft R Open.
-
Connect to and Visualize Live Klipfolio Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Klipfolio data.
-
Visualize Live Optimizely Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Optimizely data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Easily Integrate AdRoll Data in Lazarus Pascal IDE
Learn how to easily integrate live AdRoll data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Azure Table Data from Crystal Reports
Use CData Connect AI to connect to and report on live Azure Table data from Crystal Reports.
-
Connect to Act-On Data in Jaspersoft Studio
Execute SQL to remote Act-On data in Jaspersoft Studio.
-
How to Build an ETL App for Gumroad Data in Python with CData
Create ETL applications and real-time data pipelines for Gumroad data in Python with petl.
-
Query Bitbucket Data as a MySQL Database in Node.js
Execute MySQL queries against Bitbucket data from Node.js.
-
Analyze LinkedIn Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of LinkedIn data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Work with LDAP Objects in FoxPro
Load LDAP objects into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Informatica Mappings From/To an ODBC Data Source for Basecamp
Create an ODBC connection to Basecamp in Informatica and browse and transfer Basecamp data.
-
Analyze SAP Netweaver Gateway Data in Looker
Use CData Connect AI to connect to SAP Netweaver Gateway Data from Looker and build custom apps using live SAP Netweaver Gateway data.
-
Automate Mixpanel Data Replication to Azure Data Lake
Use CData Sync to customize and automate Mixpanel data replication to Azure Data Lake.
-
Integrate Live Egnyte Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Egnyte from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Egnyte data.
-
How to Connect to Live SendGrid 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 SendGrid data for you.
-
Use the CData Software ODBC Driver for Vimeo in MicroStrategy Web
Connect to Vimeo data in MicroStrategy Web using the CData Software ODBC Driver for Vimeo.
-
Create Informatica Mappings From/To an ODBC Data Source for Dynamics 365
Create an ODBC connection to Dynamics 365 in Informatica and browse and transfer Dynamics 365 data.
-
Getting Started with the CData ODBC Driver for Mouseflow
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Mouseflow.
-
Configure the CData JDBC Driver for Mixpanel in a Connection Pool in Tomcat
Connect to Mixpanel data from a connection pool in Tomcat.
-
Prepare, Blend, and Analyze SAS Data Sets Data in Alteryx Designer (Connect AI)
Build workflows to access live SAS Data Sets data for self-service data analytics.
-
Replicate Salesforce Marketing Data to Multiple Databases
Replicate Salesforce Marketing data to disparate databases with a point-and-click configuration.
-
Integrate Open WebUI with Live Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Vertica data from within the chat interface.
-
Connect to DocuSign Data in JRuby
Create a simple JRuby app with access to live DocuSign data.
-
Use Grok to Talk to Your SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your SAP Hybris C4C data for you.
-
How to connect PolyBase to Tanda
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Tanda data.
-
Create a Data Access Object for QuickBooks Time Data using JDBI
A brief overview of creating a SQL Object API for QuickBooks Time data in JDBI.
-
How to Access Live ConvertKit Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ConvertKit enables you to integrate ConvertKit data into workflows built using Microsoft Power Automate Desktop.
-
Query Bullhorn CRM Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Bullhorn CRM entities in PHP by modeling them as objects.
-
Connecting Mastra with BenchmarkEmail 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 BenchmarkEmail data, no replication required.
-
Connect to SAS Data Sets 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 SAS Data Sets data.
-
Natively Connect to ADP Data in PHP
The CData ODBC driver for ADP enables you to create PHP applications with connectivity to ADP data. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData Excel Add-In for Google Calendar
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Calendar.
-
Consume Sage 300 OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Sage 300 feeds that reflect any changes in SAP Lumira.
-
Connect to Accelo Data in Jaspersoft Studio
Execute SQL to remote Accelo data in Jaspersoft Studio.
-
Build Charts with FHIR Data in Clear Analytics
Create dynamic charts and perform analytics based on FHIR data in Clear Analytics.
-
Access Google Spanner Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Google Spanner data.
-
Query Square Data as a MySQL Database in Node.js
Execute MySQL queries against Square data from Node.js.
-
Using the CData Software ODBC Driver for Perigon in PyCharm
Connect to Perigon as an ODBC data source in PyCharm using the CData Software ODBC Driver for Perigon.
-
Integrating Boomi Agentstudio with DB2 Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to DB2 data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build a Simple VCL Application for Paymo Data
How to build a simple VCL Application to view Paymo data in RAD Studio using the CData ODBC Driver for Paymo.
-
Build Data Flows from SQL Server to MarkLogic through SSIS
Easily push SQL Server data to MarkLogic using the CData SSIS Tasks for MarkLogic.
-
DataBind Avaza Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Avaza data to a chart.
-
Automated Continuous Amazon Athena Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Apache Kafka.
-
Integrate Sentry with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Sentry with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Sentry data.
-
Replicate Authorize.Net Data to Multiple Databases via the CData Sync CLI
Replicate Authorize.Net data to disparate databases with a single configuration.
-
Integrate LibreChat with Live Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Jira Assets data from within the chat interface.
-
Visualize Live Jira Assets Data in the Power BI Service
Use CData Connect AI to connect to live Jira Assets data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Wrike Data in Tableau
The CData ODBC driver for Wrike enables you integrate Wrike data into Tableau dashboards.
-
Query HubSpot Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume HubSpot entities in PHP by modeling them as objects.
-
Use the CData ODBC Driver for CouchDB from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for CouchDB to connect to CouchDB data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring CouchDB data in Excel.
-
Query Live DocuSign Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live DocuSign data through a conversational interface.
-
Integrating Antigravity CLI with Snapchat Ads data via CData CLI
Connect Snapchat Ads data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Cline with Live Reckon Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Reckon data from within your IDE.
-
DataBind GitLab Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide GitLab data to a chart.
-
Access Live Quickbase Data in Excel 365 Online (Excel for the web)
Connect to Quickbase data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use Biml to Build SSIS Tasks to Replicate iContact Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate iContact data to SQL Server.
-
How to connect to Sendwithus Data from IntelliJ
Integrate connectivity to Sendwithus data with wizards in IntelliJ.
-
How to Connect to Live Facebook Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Facebook data securely in real time.
-
CData Sync - Change Tracking in Dynamics 365 Entities for CDC Replication
How to enable automatic change tracking in Dynamics 365 entities for change-data-capture replication with CData Sync
-
Work with SAP Hybris C4C Data in FoxPro
Load SAP Hybris C4C data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Mode Data in JRuby
Create a simple JRuby app with access to live Mode data.
-
Automated Continuous PagerDuty Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable PagerDuty replication to Azure SQL Database.
-
Use the CData Software JDBC Driver for Teamwork in MicroStrategy Web
Connect to Teamwork data in MicroStrategy Web using the CData Software JDBC Driver for Teamwork.
-
Build Dashboards with Clari Data in DBxtra
Create dynamic dashboards and perform analytics based on Clari data in DBxtra.
-
Adobe Analytics Reporting in OBIEE with the Adobe Analytics JDBC Driver
Deploy the Adobe Analytics JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Calendly in SpagoBI
Create reports featuring live Calendly data in SpagoBI Studio. Host Calendly reports on SpagoBI Server.
-
Connect to Quickbase from a Connection Pool in WebLogic
Use the CData JDBC Driver for Quickbase to connect to Quickbase data from Web applications running on WebLogic.
-
Connecting to Azure Cosmos DB with MongoDB Drivers
Set up an Azure Cosmos DB account using the MongoDB API and connect using any CData Software Driver for MongoDB.
-
View Reports on Real-Time Quaderno Data in Power BI Report Server
Use the CData ODBC Driver for Quaderno to visualize Quaderno data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to work with Webflow Data in Apache Spark using SQL
Access and process Webflow Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous Office 365 Replication to SQL Server
Use CData Sync for automated, continuous, customizable Office 365 replication to SQL Server.
-
Back Up Yelp 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 Yelp data data.
-
Create SAP Hybris C4C-Connected Nintex Workflows
Use CData Connect AI to connect to SAP Hybris C4C Data from Nintex Workflow Cloud and build custom workflows using live SAP Hybris C4C data.
-
Access Optimizely Data from MySQL in Amazon QuickSight
Connect to Optimizely and build visualizations of Optimizely data using a MySQL Connection in Amazon QuickSight.
-
Connecting GenSpark with SAP HANA Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP HANA data without any replication or custom integration required.
-
Publish Freshteam-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Freshteam data.
-
Integrating GitHub Copilot with Dynamics CRM 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.
-
Connect and Visualize Live BigCommerce Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live BigCommerce data into the Databricks platform and create visualization dashboards with real-time BigCommerce data.
-
Validate Rebilly Data with QuerySurge
Access and validate Rebilly data in QuerySurge using the CData JDBC Driver.
-
Configure the CData JDBC Driver for Mode in a Connection Pool in Tomcat
Connect to Mode data from a connection pool in Tomcat.
-
DataBind Beeminder Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Beeminder data to a chart.
-
Use ChatGPT to Talk to Your Timely 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 Timely data for you.
-
Replicate Cloudant Data to Multiple Databases
Replicate Cloudant data to disparate databases with a point-and-click configuration.
-
Replicate Multiple Avro Accounts via the CData Sync CLI
Replicate multiple Avro accounts to one or many databases.
-
Automated Continuous HCL Domino Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable HCL Domino replication to Azure SQL Database.