CData Software - Knowledge Base
Recent Articles
-
Migrating data from Azure Analysis Services to Databricks using CData SSIS Components.
Easily push Azure Analysis Services data to Databricks using the CData SSIS Tasks for Azure Analysis Services and Databricks.
-
Integrate with Splunk Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Splunk data in SnapLogic.
-
How to connect PolyBase to Dotmailer
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Dotmailer data.
-
How to Query Live SAP Netweaver Gateway Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP Netweaver Gateway data data in natural language using Python.
-
Analyze BigCommerce Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze BigCommerce data in Microsoft R Open.
-
Automate CouchDB Data Replication to Azure Data Lake
Use CData Sync to customize and automate CouchDB data replication to Azure Data Lake.
-
Work with OData Services in FoxPro
Load OData services into a FoxPro database. This article includes full code and a walk-through of the process.
-
Host the API Server on Heroku
Host the CData API Servers in Heroku Cloud Application Platform.
-
Query, Visualize, and Share live Campaigner Data in Redash
Use CData Connect AI to connect to live Campaigner data in Redash for querying, visualizing, and sharing.
-
Build Dashboards with Outreach.io Data in DBxtra
Create dynamic dashboards and perform analytics based on Outreach.io data in DBxtra.
-
Integrating Kiro with Google Contacts 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.
-
Automate MariaDB Data Replication to Azure Synapse
Use CData Sync to customize and automate MariaDB data replication to Azure Synapse.
-
Build MVC Applications with Connectivity to Klipfolio Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Klipfolio from an ASP.NET MVC application.
-
How to Easily Query Access Data in OpenOffice Base
Connect to Access data in OpenOffice Base using the CData ODBC Driver for Access and generate reports with live data insights.
-
Connect to Omnisend from Asprova with CData Software ODBC Driver for Omnisend
This article shows how to connect faster to Omnisend data from Asprova.
-
Viewing Gong Data in RAD Studio Data Explorer
How to view Gong data in RAD Studio Data Explorer using the CData ODBC Driver for Gong.
-
Analyze Toggl Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Toggl from Power Pivot. You will use the Table Import Wizard to load Toggl data. You can visually build the import query or use any SQL supported by the driver.
-
How to create an RPA flow for LaunchDarkly Data in UiPath Studio
Use the LaunchDarkly ODBC Driver to create workflows that access real-time LaunchDarkly data without any coding.
-
Build Exa-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Exa data without replication.
-
Build Amazon Marketplace-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Amazon Marketplace Data from Zoho Analytics and import live Amazon Marketplace data.
-
Build Semantic Layer Views for Reckon Accounts Hosted Data in APOS Live Data Gateway
Use the CData Connector for Reckon Accounts Hosted in APOS Live Data Gateway to build Semantic Layer Views for Reckon Accounts Hosted data.
-
Connect to Aha! Data in HULFT Integrate
Connect to Aha! as a JDBC data source in HULFT Integrate
-
Validate Google Tasks Data with QuerySurge
Access and validate Google Tasks data in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Parquet Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Parquet replication to Amazon Redshift.
-
Create HubDB Dataflows on PowerBI.com
Connect to the CData Power BI Connector for HubDB from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to connect to Snapchat Ads Data from Spring Boot
Connect to Snapchat Ads in a Spring Boot Application using the CData JDBC Driver for Snapchat Ads
-
Automated Continuous Contentful Replication to Databricks
Use CData Sync for automated, continuous, customizable Contentful replication to Databricks.
-
Query ADP Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume ADP entities in PHP by modeling them as objects.
-
How to create Basecamp federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Basecamp data in MySQL .
-
How to Connect BigCommerce 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 BigCommerce data in real time using natural language.
-
Model Printify Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Printify, enabling the direct import of real-time Printify data.
-
Natively Connect to Placid Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Placid data. Leverage the native support for ODBC in PHP.
-
Access Live ConvertAPI Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ConvertAPI data into the statistical analysis tools available in SAS JMP. This article shows how to use ConvertAPI data in the Graph Builder and Query Builder.
-
Integrating Boomi Agentstudio with PostgreSQL Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to PostgreSQL data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Voice Agents in ElevenLabs with access to Live Supabase Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Supabase data.
-
Connect to Spark Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Spark and the SQL Gateway to access Spark data from Google Apps Script.
-
A PostgreSQL Interface for ShipEngine Data (MySQL Remoting via JDBC)
Use the Remoting features of the ShipEngine JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect SharePoint with SAP Netweaver Gateway Data through external lists
Provide SAP Netweaver Gateway data to SharePoint users as an external list.
-
Integrating Kiro with ConvertKit 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.
-
Access Email 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 Email data.
-
Integrate with Live Sage 300 Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Sage 300 from the MuleSoft Anypoint Platform to integrate live Sage 300 data into custom reports and dashboards.
-
Getting Started with the CData ODBC Driver for eBay
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for eBay.
-
Automated Dynamics NAV Data Replication to Teradata
Use CData Sync to Customize and automate Dynamics NAV data replication to Teradata.
-
Integrate Theia IDE with Live SAP Fieldglass 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 SAP Fieldglass data from within the development environment.
-
Build SendGrid Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SendGrid data and build visualizations in Tableau Cloud.
-
Connect to IBM Informix Data in Aqua Data Studio
Access IBM Informix data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Live SpaceX Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SpaceX data into the statistical analysis tools available in SAS JMP. This article shows how to use SpaceX data in the Graph Builder and Query Builder.
-
How to Query Live Mode Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Mode data data in natural language using Python.
-
Integrate Goose with Live Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Jira Assets data from within the local AI agent.
-
Automated Continuous Active Directory Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Active Directory replication to IBM DB2.
-
Integrate ConvertKit with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ConvertKit with External Services.
-
Build Shippo-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Shippo Data from Zoho Analytics and import live Shippo data.
-
Connect to ElevenLabs Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ElevenLabs data.
-
Load Salesforce CRM Analytics Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Salesforce CRM Analytics data to a database.
-
Connect to and Visualize Live Pushbullet Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Pushbullet data.
-
Connect to Zendesk Data in Jaspersoft Studio
Execute SQL to remote Zendesk data in Jaspersoft Studio.
-
Access Amazon Marketplace Data from MySQL in PHP
Connect to Amazon Marketplace through the standard MySQL libraries in PHP.
-
Build a Simple VCL Application for Clockify Data
How to build a simple VCL Application to view Clockify data in RAD Studio using the CData ODBC Driver for Clockify.
-
Connect to Jodoo Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Jodoo.
-
Connect to SFTP Data in JRuby
Create a simple JRuby app with access to live SFTP data.
-
Access Live Oracle Eloqua Data in Coginiti Pro
Connect to and query live Oracle Eloqua data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect Flowise AI Agents to Live Salesforce Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Salesforce data without replication.
-
Create Trello Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Trello data access from reports, embedded analytics, and more.
-
Visualize Live PostgreSQL Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live PostgreSQL data.
-
Visualize Teradata Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Teradata data.
-
Write a Simple Go Application to work with Jumpseller Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Jumpseller data.
-
Link Guru with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Guru data in Filemaker Pro for Mac or Windows.
-
Rapidly Develop Oracle Financials Cloud-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Oracle Financials Cloud.
-
Getting Started with the CData ODBC Driver for SAP ByDesign
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP ByDesign.
-
Process & Analyze Freshsales Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Freshsales Data.
-
Integrating Kiro with Monday.com 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.
-
Build MVC Applications with Connectivity to Invoiced Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Invoiced from an ASP.NET MVC application.
-
Create SSAS Tabular Models from Workable Data
How to build a SQL Server Analysis Service Tabular Model from Workable data using CData drivers.
-
Connect to Oracle HCM Cloud Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Oracle HCM Cloud data.
-
Integrating Codex with Planio 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.
-
Migrating data from TaxJar to Snowflake using CData SSIS Components.
Easily push TaxJar data to Snowflake using the CData SSIS Tasks for TaxJar and Snowflake.
-
Import Adobe Target Data Using Azure Data Factory
Use CData Connect AI to connect to Adobe Target Data from Azure Data Factory and import live Adobe Target data.
-
Create Mailgun Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Mailgun from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to QuickBooks Data in Aqua Data Studio
Access QuickBooks data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to RSS Feeds in Ruby
Connect to RSS feeds in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Data Visualizations in Cognos BI with Databricks Data
Access Databricks data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to connect Amazon QuickSight to Testmonitor Data
Create a connection to Testmonitor data in CData Connect AI and insert Testmonitor data into Amazon QuickSight SPICE to build interactive dashboards.
-
Build SAP Netweaver Gateway-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAP Netweaver Gateway Data and create custom apps in Bubble.
-
DataBind Controls to Freshteam Data in Delphi
DataBind to Freshteam data in Delphi with standard data access components and controls.
-
Use the CData Software JDBC Driver for Google Calendar in MicroStrategy Desktop
Connect to Google Calendar data in MicroStrategy Desktop using the CData Software JDBC Driver for Google Calendar.
-
Create SSAS Tabular Models from BenchmarkEmail Data
How to build a SQL Server Analysis Service Tabular Model from BenchmarkEmail data using CData drivers.
-
Connect to WooCommerce from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from WooCommerce data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Connect to Live SurveyMonkey Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SurveyMonkey data without replication.
-
Build Paymo-Connected Apps in Choreo
Use CData Connect AI to connect to Paymo Data from Choreo and build custom apps using live Paymo data.
-
Integrate SAP Concur with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP Concur with External Services.
-
Discovering SaaS, Big Data, and NoSQL Metadata with JDBC
Use the CData JDBC Drivers to see the metadata for all of your SaaS, Big Data, RDBMS, and NoSQL data sources.
-
A PostgreSQL Interface for RabbitMQ Data using the CData ODBC Driver
Use the SQL Gateway and RabbitMQ ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating LangChain with Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Oracle Eloqua data within automated workflows.
-
Automated Continuous Sendwithus Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Sendwithus data replication to OneLake in Microsoft Fabric.
-
Build Dashboards with Zoom Data in DBxtra
Create dynamic dashboards and perform analytics based on Zoom data in DBxtra.
-
Getting Started with the CData Connect AI Python SDK for Google Cloud Storage
Install the CData Connect AI Python SDK to read live Google Cloud Storage data with standard DB-API 2.0 Python code.
-
How to connect to Google Drive Data in DBVisualizer
Integrate Google Drive data with visual data analysis tools and data connection wizards in DBVisualizer
-
Use Biml to Build SSIS Tasks to Replicate Impala Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Impala data to SQL Server.
-
Publish Reports with Anaplan Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Anaplan data.
-
How to connect to Planio Data from IntelliJ
Integrate connectivity to Planio data with wizards in IntelliJ.