CData Software - Knowledge Base
Recent Articles
-
Create FTP-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to FTP Data from OutSystems and build custom enterprise apps using live FTP Servers.
-
How to load LeadDesk data into Elasticsearch via Logstash
Introducing a simple method to load LeadDesk data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Jira Replication to Vertica
Use CData Sync for automated, continuous, customizable Jira replication to Vertica.
-
Automated Continuous Slack Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Slack replication to delimited files (CSV/TSV).
-
Connect to Shopify Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Shopify and the SQL Gateway to access Shopify from Google Apps Script.
-
Access Live Hacker News Data in Coginiti Pro
Connect to and query live Hacker News from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Enable the Apollo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Apollo.
-
Build Oracle-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Oracle to explore live Oracle Data in Cursor to assist with building Oracle-powered applications.
-
Build MVC Applications with Connectivity to Redshift Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Redshift from an ASP.NET MVC application.
-
Integrate Live FreshBooks Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to FreshBooks from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live FreshBooks.
-
Build Impala-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Impala to explore live Impala Data in GitHub Copilot to assist with building Impala-powered applications.
-
Getting Started with the CData Excel Add-In for SAP Concur
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP Concur.
-
DataBind Charts to ZohoPeople Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ZohoPeople from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
How to Query Live eBay Data in Perplexity MacOS Desktop
Connect to and query live eBay Data in Perplexity Desktop using CData MCP Server.
-
DataBind Controls to Klaviyo Data in C++Builder
DataBind to Klaviyo in C++Builder with standard components and controls.
-
Getting Started with the CData ADO.NET Provider for Nethunt
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
DataBind Controls to ServiceNow Data in C++Builder
DataBind to ServiceNow in C++Builder with standard components and controls.
-
Integrating Antigravity CLI with Figshare via CData CLI
Connect Figshare to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating Kiro CLI with Datadog 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 SSAS Tabular Models from Pipedrive Data
How to build a SQL Server Analysis Service Tabular Model from Pipedrive using CData drivers.
-
Build a PostgreSQL Interface for PolarTeamPro Data using the CData JDBC Driver
Use the Remoting features of the PolarTeamPro JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query RSS Feeds in ColdFusion
Write standard ColdFusion data access code to connect to RSS Feeds.
-
Integrate with live Oracle Service Cloud Data in Jitterbit
Use CData Connect AI to connect to and integrate live Oracle Service Cloud in Jitterbit.
-
Natively Connect to Postmark Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Postmark. Leverage the native support for ODBC in PHP.
-
Extend Google Sheets with Authorize.Net Data
Make calls to Authorize.Net from Google Apps Script via the API Server.
-
Use the CData ODBC Driver for Dropbox from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Dropbox to connect to Dropbox from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Dropbox in Excel.
-
Work with Live Oracle HCM Cloud Data in Power Query
Use CData Connect AI to connect to Oracle HCM Cloud and work with live Oracle HCM Cloud in Microsoft Power Query.
-
Seamlessly Bring SAP Hybris C4C Data into Retool Using CData Connect AI
Integrate SAP Hybris C4C data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
DataBind ZohoDesk Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ZohoDesk to a chart.
-
Connect to Outreach.io Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Outreach.io.
-
Integrating GitHub Copilot CLI with Outreach.io 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.
-
Configuring Incremental Replication in CData Sync
This entry covers how to set up incremental replication for Data Sync.
-
Access Demio Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Demio from your Oracle system.
-
DataBind Unbounce Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Unbounce to a chart.
-
How to create Sybase federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Sybase in MySQL .
-
Extend Google Sheets with Twitter Ads Data
Make calls to Twitter Ads from Google Apps Script via the API Server.
-
Visualize Live Databricks Data in the Power BI Service
Use CData Connect AI to connect to live Databricks and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Open WebUI with Live Raisers Edge NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Raisers Edge NXT from within the chat interface.
-
Automated Continuous Phoenix Replication to Oracle
Use CData Sync for automated, continuous, customizable Phoenix replication to Oracle.
-
Connect to ConstantContact Data in RazorSQL
Connect to ConstantContact from wizards and query ConstantContact from the GUI in the RazorSQL database management tool.
-
How to Work with MariaDB Data in ETL Validator JDBC
Connect to MariaDB from ETL Validator jobs using the CData Software JDBC Driver.
-
Replicate Paylocity Data to Multiple Databases
Replicate Paylocity to disparate databases with a point-and-click configuration.
-
Easily Integrate Smartsheet Data in Lazarus Pascal IDE
Learn how to easily integrate live Smartsheet in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Extend Google Sheets with Access Data
Make calls to Access from Google Apps Script via the API Server.
-
Object-Relational Mapping (ORM) with CapsuleCRM Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to CapsuleCRM into a Java-based ORM framework, Hibernate.
-
How to publish and share EnterpriseDB Data dashboards with Tableau Server
The CData ODBC driver for EnterpriseDB enables you integrate EnterpriseDB into Tableau dashboards.
-
Create Data Visualizations in Cognos BI with SQL Analysis Services Data
Access SQL Analysis Services as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Build an ETL App for AlloyDB Data in Python with CData Connect AI
Build ETL pipelines that read and write live Google AlloyDB in Python with petl and the CData Connect AI Python SDK.
-
Build Authorize.Net-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Authorize.Net to explore live Authorize.Net Data in Gemini Code Assist to assist with building Authorize.Net-powered applications.
-
Integrating OpenCode Terminal with Drift 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.
-
Query Okta Data in DataGrip
Create a Data Source for Okta in DataGrip and use SQL to query live Okta.
-
How to Visualize PayPal Data in Python with pandas
Use pandas and other modules to analyze and visualize live PayPal in Python.
-
Create Dashboards and Visualize Live Amazon Athena Data in Geckoboard
Use CData Connect AI to connect to live Amazon Athena and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build DB2-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to IBM DB2 and build web apps with connectivity to live IBM DB2.
-
How to Connect to Live Tally Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Tally ERP securely in real time.
-
Build Automated Workflows with Live Marketo Data in Workato
Use CData Connect AI to connect to live Marketo and build automated workflows in Workato.
-
Use the CData Software ODBC Driver for ZohoSubscriptions in MicroStrategy Desktop
Connect to ZohoSubscriptions in MicroStrategy Desktop using the CData Software ODBC Driver for ZohoSubscriptions.
-
Connect to IBM Cloud Object Storage Data in DBArtisan
Use wizards in DBArtisan to configure IBM Cloud Object Storage as a data source.
-
How to use SQLAlchemy ORM to access Templated Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Templated.
-
Use the CData ODBC Driver for MySQL in Microsoft Power Query
You can use the CData MySQL ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import MySQL into Microsoft Power Query.
-
Feed Jira Data into FineReport
How to set Atlassian Jira as a JDBC data source in FineReport.
-
Replicate Multiple FormSite Accounts via the CData Sync CLI
Replicate multiple FormSite accounts to one or many databases.
-
Migrating data from Square to Google BigQuery using CData SSIS Components.
Easily push Square to Google BigQuery using the CData SSIS Tasks for Square and Google BigQuery.
-
Automated Continuous MariaDB Replication to Databricks
Use CData Sync for automated, continuous, customizable MariaDB replication to Databricks.
-
Visualize Greenhouse Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Greenhouse.
-
Use Azure AI Foundry to Talk to Your Databricks 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 Databricks for you.
-
Automate Klipfolio Data Replication to SAP HANA
Use CData Sync to customize and automate Klipfolio replication to SAP HANA.
-
Connect Blackbaud FE NXT to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Blackbaud FE NXT using the CData Python MCP Server.
-
How to Query Live ClickUp Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ClickUp data in natural language using Python.
-
Automate Intercom Data Replication to Azure Synapse
Use CData Sync to customize and automate Intercom replication to Azure Synapse.
-
Build Pipelines with Live BigCommerce Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to BigCommerce from Google Cloud Data Fusion, enabling the integration of live BigCommerce into the building and management of effective data pipelines.
-
SFTP Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SFTP facts in real time.
-
Getting Started with the CData ODBC Driver for Vercel
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Vercel.
-
Create Reports with Box Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Box.
-
Build Apps with Live Act CRM Data Using the Low-Code Development Platform of Mendix
Connect Act CRM with Mendix to build apps using the CData JDBC Driver for Act CRM.
-
Getting Started with the CData Python Connector for MarkLogic
Learn to install and license the CData Python Connector
-
Automated Continuous Humanity Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Humanity replication to Azure SQL Database.
-
Connect to Todoist from Asprova with CData Software ODBC Driver for Todoist
This article shows how to connect faster to Todoist data from Asprova.
-
Create PostgreSQL-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to PostgreSQL Data from Klipfolio and build custom visualizations using live PostgreSQL.
-
Import Google Campaign Manager 360 Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Google Campaign Manager 360. In this article, you will use the OData format to import Google Campaign Manager 360 into Microsoft Power Query.
-
Connect to SAP BusinessObjects BI Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP BusinessObjects BI as an External Source in Dremio.
-
Create Informatica Mappings From/To a JDBC Data Source for Contentful
Create Contentful data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Retently Replication to Vertica
Use CData Sync for automated, continuous, customizable Retently replication to Vertica.
-
Connect to Email Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Email as an External Source in Dremio.
-
Access Live SAP Business One Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live SAP Business One through MCP integration.
-
Create Data Visualizations in Cognos BI with Neo4J Data
Access Neo4J as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Use a Microsoft Access Database to Update AlloyDB Data in Real Time
Update AlloyDB data by creating a linked table in Microsoft Access with the CData AlloyDB ODBC Driver.
-
Trigger AlloyDB IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for AlloyDB with standard wizards in Logic Apps.
-
Visualize Elorus Data in TIBCO Spotfire through ADO.NET
Integrate Elorus into dashboards in TIBCO Spotfire.
-
Connect to Mixpanel Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Mixpanel and work with Mixpanel in your FileMaker applications.
-
Excel Spreadsheet Automation on Spotify Data with the QUERY Formula
Pull data from Spotify, automate spreadsheets, and more with the QUERY formula.
-
Integrate Salesforce Marketing Data in the Pentaho Report Designer
Publish reports based on Salesforce Marketing Cloud in the Pentaho BI tool.
-
Analyze Snowflake Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Snowflake and visualize live Snowflake in Infragistics Reveal.
-
How to import Clari Data into Apache Solr
Use the CData Software JDBC Driver for Clari in Data Import Handler and create an automated import of Clari to Apache Solr Enterprise Search platform.
-
Automated Continuous SharePoint Excel Services Replication to MongoDB
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to MongoDB.
-
Use the CData Software JDBC Driver for Okta in MicroStrategy Desktop
Connect to Okta in MicroStrategy Desktop using the CData Software JDBC Driver for Okta.
-
Connect and Query Live Dropbox Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Dropbox into Databricks
-
Easily Integrate Box Data in Lazarus Pascal IDE
Learn how to easily integrate live Box in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Publish Reports with Freshservice Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Freshservice.
-
How to connect to Google Tasks Data in DBVisualizer
Integrate Google Tasks with visual data analysis tools and data connection wizards in DBVisualizer