CData Software - Knowledge Base
Recent Articles
-
Visualize Printful Data in Sisense
Create an ElastiCube in Sisense app with access to Printful.
-
Build Vercel-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Vercel and build web apps with connectivity to live Vercel.
-
Automated Continuous EnterpriseDB Replication to MySQL
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to MySQL.
-
How to Query Live Sybase Data in Claude Desktop
Connect to and query live Sybase Data in Claude Desktop using CData MCP Server.
-
Build Visualizations of PhantomBuster Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of PhantomBuster in Birst.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for LinkedIn
Provide connectivity to LinkedIn through an SAP BusinessObjects universe.
-
Automate SendPulse Data Replication to Azure Data Lake
Use CData Sync to customize and automate SendPulse replication to Azure Data Lake.
-
DataBind Controls to Drip Data in C++Builder
DataBind to Drip in C++Builder with standard components and controls.
-
Visualize Live SAS Data Sets Data in the Power BI Service
Use CData Connect AI to connect to live SAS Data Sets and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Prepare, Blend, and Analyze Oracle Data in Alteryx Designer (ODBC)
Build workflows to access live Oracle Database for self-service data analytics.
-
Replicate Multiple Smartsheet Accounts via the CData Sync CLI
Replicate multiple Smartsheet accounts to one or many databases.
-
Connecting Mastra with Amazon S3 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 Amazon S3, no replication required.
-
Build SharePoint Excel Services-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SharePoint Excel Services to explore live SharePoint Excel Services Data in Gemini Code Assist to assist with building SharePoint Excel Services-powered applications.
-
Integrate Real-Time Access to SendGrid in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SendGrid in real time.
-
Use the CData Software JDBC Driver for Excel Online in MicroStrategy Desktop
Connect to Microsoft Excel Online in MicroStrategy Desktop using the CData Software JDBC Driver for Excel Online.
-
Connect to RSS Feeds in RazorSQL
Connect to RSS from wizards and query RSS Feeds from the GUI in the RazorSQL database management tool.
-
DataBind Charts to eBay Analytics Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to eBay Analytics 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.
-
Create CockroachDB-Connected Nintex Workflows
Use CData Connect AI to connect to CockroachDB Data from Nintex Workflow Cloud and build custom workflows using live CockroachDB.
-
Natively Connect to Google Ads Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Ads. Leverage the native support for ODBC in PHP.
-
Build MVC Applications with Connectivity to Attio Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Attio from an ASP.NET MVC application.
-
Create Power BI Reports on Real-Time YouTube Analytics Data
Use the CData ODBC Driver for YouTube Analytics to visualize YouTube Analytics in Power BI Desktop.
-
Provide OData Services of Templated Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Templated by developing a WCF Service Application.
-
How to Work with Reckon Data in ETL Validator JDBC
Connect to Reckon from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Open WebUI with Live SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SendGrid from within the chat interface.
-
Build Visualizations of PDFMonkey Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of PDFMonkey in Birst.
-
Integrate Theia IDE with Live Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Use the CData Software ODBC Driver for Tanda in SAS for Real-Time Reporting and Analytics
Connect to real-time Tanda in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Tanda.
-
Automated Continuous Supabase Replication to Vertica
Use CData Sync for automated, continuous, customizable Supabase replication to Vertica.
-
Publish Crystal Reports on Airtable Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Airtable.
-
Connect to Real-Time Float Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Float in Power Apps.
-
Manage IBM Informix Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for IBM Informix.
-
How to connect Amazon QuickSight to Dynamics 365 Business Central Data
Create a connection to Dynamics 365 Business Central in CData Connect AI and insert Dynamics 365 Business Central into Amazon QuickSight SPICE to build interactive dashboards.
-
How to connect and process Trello from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Trello.
-
Create a Data Access Object for Epicor Kinetic Data using JDBI
A brief overview of creating a SQL Object API for Epicor Kinetic in JDBI.
-
Integrating Boomi Agentstudio with Microsoft OneDrive Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft OneDrive, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Work with Live Oracle Service Cloud Data in Power Query
Use CData Connect AI to connect to Oracle Service Cloud and work with live Oracle Service Cloud in Microsoft Power Query.
-
Create Sentry Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Sentry from PowerBI.com to create Power BI Dataflows with real-time data.
-
Publish Crystal Reports on Snapchat Ads Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Snapchat Ads.
-
Query HubSpot Data as a SQL Server Database in Node.js
Execute SQL Server queries against HubSpot from Node.js.
-
LINQ to EnterpriseDB Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the EnterpriseDB Data Provider.
-
Query SuiteCRM Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SuiteCRM and perform CRUD operations on SuiteCRM from Node.js.
-
Access Live Zoom Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Zoom from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Dashboards with Pingdom Data in DBxtra
Create dynamic dashboards and perform analytics based on Pingdom in DBxtra.
-
Getting Started with the CData Excel Add-In for IBM Cloud Object Storage
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for IBM Cloud Object Storage.
-
Automated Continuous Optimizely Replication to MySQL
Use CData Sync for automated, continuous, customizable Optimizely replication to MySQL.
-
Integrating Antigravity CLI with Front via CData CLI
Connect Front to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Explore Geographical Relationships in Redis Data with Power Map
Create data visualizations with Redis in Power Map.
-
Connect WordPress Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your WordPress using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData ODBC Driver for Snapchat Ads
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Snapchat Ads.
-
Access Live YouTube Analytics Data in Excel 365 Online (Excel for the web)
Connect to YouTube Analytics from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Back Up ServiceNow to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for ServiceNow. In this article, we will employ an SSIS workflow to populate a database with ServiceNow data.
-
Analyze Harvest Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Harvest from Power Pivot. You will use the Table Import Wizard to load Harvest. You can visually build the import query or use any SQL supported by the driver.
-
Import Real-Time Close Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Close in ColdFusion.
-
Access SAP Data from MySQL in PHP
Connect to SAP through the standard MySQL libraries in PHP.
-
Integrating Claude Code CLI with Teradata 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 BigQuery to Databricks using CData SSIS Components.
Easily push Google BigQuery to Databricks using the CData SSIS Tasks for BigQuery and Databricks.
-
Connect to Outlook Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Outlook as an External Source in Dremio.
-
How to use SQLAlchemy ORM to access SAP Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP ERP/NetWeaver.
-
Connect to Postmark Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Postmark to connect to Postmark and execute queries in PowerBuilder.
-
Replicate Multiple HDFS Accounts via the CData Sync CLI
Replicate multiple HDFS accounts to one or many databases.
-
Use Dash to Build to Web Apps on Typeform Data
Create Python applications that use pandas and Dash to build Typeform-connected web apps.
-
Getting Started with the CData Tableau Connector for SAP Business Warehouse
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP Business Warehouse.
-
Connect to MailerLite Data in JRuby
Create a simple JRuby app with access to live MailerLite.
-
Automated Continuous Pipeliner CRM Replication to SQL Server
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to SQL Server.
-
DataBind ZohoSubscriptions Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ZohoSubscriptions to a chart.
-
Connect to Pipeliner CRM Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Pipeliner CRM in the Denodo Virtual DataPort Administrator.
-
How to Work with Twilio Data in ETL Validator JDBC
Connect to Twilio from ETL Validator jobs using the CData Software JDBC Driver.
-
Build PayPal-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live PayPal and build PayPal-connected web apps with Axios.
-
How to Connect DBeaver to Salesforce Data 360 via a JDBC Driver
Manage Salesforce Data 360 with visual tools in DBeaver like the query browser.
-
Use Manus AI to Talk to Your Workday 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 Workday.
-
Automated Continuous EnterpriseDB Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to PostgreSQL.
-
How to connect to Zoho Inventory Data with Squirrel SQL client
Connect to Zoho Inventory and execute queries in the Squirrel SQL Client.
-
Access Live Scrapfly Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Scrapfly data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Replicate Opsgenie Data in Heroku for Use in Salesforce Connect
Replicate Opsgenie to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Reports from MariaDB Data in Looker Studio
Use CData Connect AI to gain access to live MariaDB and create custom reports in Looker Studio.
-
Analyze Databricks Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Databricks and visualize Databricks in SAP Analytics Cloud.
-
Automate Phoenix Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Apache Phoenix and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Create Reports with Salesforce CRM Analytics Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Salesforce CRM Analytics.
-
Connect to Real-Time Tavily Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Tavily in Power Apps.
-
Build an OLAP Cube in SSAS from Cvent Data
Establish a connection to Cvent data from SQL Server Analysis Services, and use the Cvent Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Microsoft Dataverse-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Microsoft Dataverse Data from OutSystems and build custom enterprise apps using live Microsoft Dataverse (CDS).
-
Connect to Monday.com Data in CloverDX (formerly CloverETL)
Transfer Monday.com using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous Zoho Books Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Zoho Books replication to Azure SQL Database.
-
Automated Continuous Exa Replication to SQL Server
Use CData Sync for automated, continuous, customizable Exa replication to SQL Server.
-
How to publish and share Zoho Books Data dashboards with Tableau Server
The CData ODBC driver for Zoho Books enables you integrate Zoho Books into Tableau dashboards.
-
Connect to Zoho Recruit in SpagoBI
Create reports featuring live Zoho Recruit in SpagoBI Studio. Host Zoho Recruit reports on SpagoBI Server.
-
How to Visualize Samanage Data in Python with pandas
Use pandas and other modules to analyze and visualize live Samanage in Python.
-
Connect to SAP Ariba Procurement Data in RapidMiner
Integrate SAP Ariba Procurement with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Amazon DynamoDB from Asprova with CData Software ODBC Driver for Amazon DynamoDB
This article shows how to connect faster to Amazon DynamoDB data from Asprova.
-
Build AI/ML Models with Live PhantomBuster Data using Dataiku
Connect PhantomBuster Data with Dataiku using the CData API Driver for JDBC.
-
Connect to Live Cloudant Data in MicroStrategy through CData Connect AI
Create a live connection to Cloudant Data in CData Connect AI and connect to your IBM Cloudant from MicroStrategy.
-
Connect to CSV Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for CSV/TSV Files in Airbyte.
-
Analyze Live WooCommerce Data in SAS Viya
Use CData Connect AI to connect to WooCommerce from SAS Viya and deploy self-service analytics using live WooCommerce.
-
How to Easily Query BambooHR Data in OpenOffice Base
Connect to BambooHR data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Rapidly Develop Productboard-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 Productboard.
-
Integrate with Bitbucket Data in JReport Designer
Create charts and reports based on Bitbucket in JReport Designer.
-
Connect to ConvertAPI Data in Ruby
Connect to ConvertAPI in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access Live Dotmailer Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Dotmailer in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
ETL Superchat in Oracle Data Integrator
This article shows how to transfer Superchat into a data warehouse using Oracle Data Integrator.
-
How to Visualize Okta Data in Python with pandas
Use pandas and other modules to analyze and visualize live Okta in Python.