CData Software - Knowledge Base
Recent Articles
-
Replicate Dynamics 365 Business Central Data in Heroku for Use in Salesforce Connect
Replicate Dynamics 365 Business Central data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use Azure AI Foundry to Talk to Your FTP 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 FTP data for you.
-
How to Build an ETL App for Redis Data in Python with CData
Create ETL applications and real-time data pipelines for Redis data in Python with petl.
-
Extract, Transform, and Load Drip Data in Informatica PowerCenter
Create a simple Workflow for Drip data in Informatica PowerCenter.
-
How to import Discourse Data into Apache Solr
Use the CData Software JDBC Driver for Discourse in Data Import Handler and create an automated import of Discourse data to Apache Solr Enterprise Search platform.
-
How to create MariaDB federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for MariaDB data in MySQL .
-
Build Apps with Live Timely Data Using the Low-Code Development Platform of Mendix
Connect Timely data with Mendix to build apps using the CData API Driver for JDBC.
-
How to integrate Metabase with Typeform Data
Use CData Connect AI to connect to live Typeform data and create an interactive dashboard in Metabase from Typeform data.
-
Automate Outreach.io Data Replication to Azure Data Lake
Use CData Sync to customize and automate Outreach.io data replication to Azure Data Lake.
-
How to create an RPA flow for Microsoft Entra ID Data in UiPath Studio
Use the Microsoft Entra ID ODBC Driver to create workflows that access real-time Microsoft Entra ID data without any coding.
-
Connect to Google Cloud Storage Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Google Cloud Storage Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Moving Data from CloudConvert to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live CloudConvert data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Vertica Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Vertica Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Establish a Live Connection with Spotify Data using Tableau Bridge
The CData ODBC Driver for Spotify enables you to integrate live Spotify data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating Cursor with ZohoPeople 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.
-
Explore Geographical Relationships in Templated Data with Power Map
Create data visualizations with Templated data in Power Map.
-
Automated Continuous PagerDuty Replication to Databricks
Use CData Sync for automated, continuous, customizable PagerDuty replication to Databricks.
-
Automated Continuous xBase Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable xBase data replication to OneLake in Microsoft Fabric.
-
Connect to Real-Time Samanage Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Samanage data in Power Apps.
-
Integrate Theia IDE with Live Google Spanner 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 Google Spanner data from within the development environment.
-
Explore Geographical Relationships in Lakebase Data with Power Map
Create data visualizations with Lakebase data in Power Map.
-
Automated Continuous Jira Replication to SQL Server
Use CData Sync for automated, continuous, customizable Jira replication to SQL Server.
-
Build a Simple VCL Application for Tally Data
How to build a simple VCL Application to view Tally data in RAD Studio using the CData ODBC Driver for Tally.
-
Replicate Oracle Service Cloud Data to Multiple Databases
Replicate Oracle Service Cloud data to disparate databases with a point-and-click configuration.
-
Moving Data from SparkPost to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SparkPost data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Discord Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Discord facts in real time.
-
Create Twitter Ads-Connected Business Apps in AppSheet
Connect to Twitter Ads Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Twitter Ads data.
-
Integrating OpenCode with Raisers Edge NXT 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.
-
Create Informatica Mappings From/To an ODBC Data Source for QuickBooks
Create an ODBC connection to QuickBooks in Informatica and browse and transfer QuickBooks data.
-
Access Live Toggl Data in Coginiti Pro
Connect to and query live Toggl data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live ServiceDesk Plus 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 ServiceDesk Plus data through MCP integration.
-
Getting Started with the CData SSIS Components for OpenWeatherMap
Complete guide to installing, licensing, and connecting with the CData SSIS Components for OpenWeatherMap.
-
How to Connect to Live SendGrid Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SendGrid data securely in real time.
-
How to Build an ETL App for Postmark Data in Python with CData
Create ETL applications and real-time data pipelines for Postmark data in Python with petl.
-
Integrate Dify with Live Authorize.Net 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 Authorize.Net data.
-
Access Live Google Analytics Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Analytics data from your Google Sheets.
-
Natively Connect to Certinia Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Certinia data. Leverage the native support for ODBC in PHP.
-
Using the CData Software ODBC Driver for Amazon Marketplace in PyCharm
Connect to Amazon Marketplace as an ODBC data source in PyCharm using the CData Software ODBC Driver for Amazon Marketplace.
-
Build SFTP-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SFTP Data from Zoho Analytics and import live SFTP data.
-
How to Use a Microsoft Access Database to Update SAP Concur Data in Real Time
Update SAP Concur data by creating a linked table in Microsoft Access with the CData SAP Concur ODBC Driver.
-
Connect to Shippo Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Shippo and work with Shippo data in your FileMaker application.
-
Use the CData Software JDBC Driver for Intercom in MicroStrategy Web
Connect to Intercom data in MicroStrategy Web using the CData Software JDBC Driver for Intercom.
-
Query Egnyte Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Egnyte data from Node.js.
-
Replicate Wrike Data to Multiple Databases via the CData Sync CLI
Replicate Wrike data to disparate databases with a single configuration.
-
ETL Dynamics CRM in Oracle Data Integrator
This article shows how to transfer Dynamics CRM data into a data warehouse using Oracle Data Integrator.
-
Seamlessly Bring Smartsheet Data into Retool Using CData Connect AI
Integrate Smartsheet data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Query Coinbase Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Coinbase data from Node.js.
-
Enable the Factorial JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Factorial data.
-
Integrate Live Redis Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Redis from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Redis data.
-
Build a Singer.io Tap for Azure Synapse With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Azure Synapse data using the CData Python Connector.
-
Connect to Wistia Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Wistia and the SQL Gateway to access Wistia data from Google Apps Script.
-
Automated Continuous ShipEngine Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ShipEngine replication to Azure SQL Database.
-
How to Query Live Workday Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Workday data data in natural language using Python.
-
Connect to Jira Assets Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Jira Assets data from Filemaker Pro on Mac.
-
Connect to Bugsnag Data from a Connection Pool in JBoss
Integrate Bugsnag data into Java servlets: Use the Management Console in JBoss to install the Bugsnag JDBC Driver.
-
Connect to Toggl Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Toggl Data and connect to Toggl data in Akorbi Digital RunMyProcess.
-
Build a Singer.io Tap for Teamgate With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Teamgate data using the CData Python Connector.
-
Automated Continuous Quickbase Replication to SQLite
Use CData Sync for automated, continuous, customizable Quickbase replication to SQLite.
-
Connect to Real-Time Adobe Experience Manager Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Adobe Experience Manager and Dataflow to import and use Adobe Experience Manager data in Power Apps.
-
Explore Geographical Relationships in Unbounce Data with Power Map
Create data visualizations with Unbounce data in Power Map.
-
Connect to Google Translate Data in Ruby
Connect to Google Translate data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
YouTube Analytics Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on YouTube Analytics facts in real time.
-
Connect to Hive Data in Claris FileMaker Pro
Use the CData ODBC Driver for Hive in FileMaker Pro to connect to Hive and work with Hive data in your FileMaker applications.
-
Integrate Goose with Live Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Vertica data from within the local AI agent.
-
Interact with Live ZohoDesk Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live ZohoDesk data.
-
Automated Continuous Billsby Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Billsby replication to Amazon Redshift.
-
How to Query Live Attio Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Attio data data in natural language using Python.
-
Operational Reporting on Strava Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Strava data.
-
Query SuiteCRM Data in DataGrip
Create a Data Source for SuiteCRM in DataGrip and use SQL to query live SuiteCRM data.
-
Visualize Reckon Data 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 data into TIBCO Spotfire.
-
Integrating Dataiku with Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Twitter Ads data.
-
How to work with Salesforce Pardot Data in Apache Spark using SQL
Access and process Salesforce Pardot Data in Apache Spark using the CData Software JDBC Driver.
-
Easily Integrate Stripe Data in Lazarus Pascal IDE
Learn how to easily integrate live Stripe data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Visualize Facebook Ads Data in Tableau
The CData ODBC driver for Facebook Ads enables you integrate Facebook Ads data into Tableau dashboards.
-
Connect to HubDB Data from PowerBuilder via JDBC
This article demonstrates how to access HubDB data from PowerBuilder using the HubDB JDBC Driver.
-
Connect to eBay Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for eBay data in the Denodo Virtual DataPort Administrator.
-
Integrating Gumloop with Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Zoom data within automated workflows.
-
Visualize Jodoo Data in Sisense
Create an ElastiCube in Sisense app with access to Jodoo data.
-
Connect to MessageBird Data from a Connection Pool in Jetty
The MessageBird JDBC Driver supports connection pooling: This article shows how to connect faster to MessageBird data from Web apps in Jetty.
-
Automated Continuous Quickbase Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Quickbase replication to Google Cloud SQL.
-
Automate Coinbase Data Replication to SAP HANA
Use CData Sync to customize and automate Coinbase data replication to SAP HANA.
-
Create Reports with Onfleet Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Onfleet data.
-
Replicate Certinia Data to Multiple Databases
Replicate Certinia data to disparate databases with a point-and-click configuration.
-
How to connect Amazon QuickSight to Hive Data
Create a connection to Hive data in CData Connect AI and insert Hive data into Amazon QuickSight SPICE to build interactive dashboards.
-
Add MYOB AccountRight Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for MYOB AccountRight with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connecting GenSpark with SingleStore Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SingleStore data without any replication or custom integration required.
-
MarkLogic Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on MarkLogic facts in real time.
-
How to Connect the Power BI Service to SAP Concur: Complete Guide
Connect to the CData Software Power BI Connector for SAP Concur from PowerBI.com to provide real-time SAP Concur data across the organization.
-
Getting Started with the CData JDBC Driver for Hubstaff
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Hubstaff.
-
Use CData Connect AI to Access Perplexity Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Perplexity data in the Power Pivot business intelligence tool.
-
Moving Data from Workable to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Workable data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to connect to Wrike Data with Squirrel SQL client
Connect to Wrike data and execute queries in the Squirrel SQL Client.
-
Build Semantic Layer Views for MongoDB Data in APOS Live Data Gateway
Use the CData Connector for MongoDB in APOS Live Data Gateway to build Semantic Layer Views for MongoDB data.
-
Interact with Live Blackbaud FE NXT Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Blackbaud FE NXT data.
-
How to connect PolyBase to FreeAgent
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live FreeAgent data.
-
How to Work with Perplexity Data in ETL Validator JDBC
Connect to Perplexity from ETL Validator jobs using the CData Software JDBC Driver.
-
Automate Amazon Marketplace Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Amazon Marketplace data from PowerShell? This article demonstrates how to utilize the Amazon Marketplace Cmdlets for tasks like connecting to Amazon Marketplace data, automating operations, downloading data, and more.
-
Build Charts with Bitbucket Data in Clear Analytics
Create dynamic charts and perform analytics based on Bitbucket data in Clear Analytics.
-
Use CData Connect AI to Access Twilio Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Twilio data in the Power Pivot business intelligence tool.
-
Automate Salesloft Data Replication to SAP HANA
Use CData Sync to customize and automate Salesloft data replication to SAP HANA.