CData Software - Knowledge Base
Recent Articles
-
How to Seamlessly Import Flowlu Data into IBM SPSS Modeler
Integrate Flowlu data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automate Wistia Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Wistia data from PowerShell? This article demonstrates how to utilize the Wistia Cmdlets for tasks like connecting to Wistia data, automating operations, downloading data, and more.
-
Query Samanage Data as a SQL Server Database in Node.js
Execute SQL Server queries against Samanage data from Node.js.
-
Query Klipfolio Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Klipfolio data from Node.js.
-
ZohoMarketingHub Reporting in OBIEE with the ZohoMarketingHub JDBC Driver
Deploy the ZohoMarketingHub JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Bitbucket Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Bitbucket replication to Amazon S3.
-
Extract, Transform, and Load Redis Data in Informatica PowerCenter
Create a simple Workflow for Redis data in Informatica PowerCenter.
-
How to use SQLAlchemy ORM to access Twilio Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Twilio data.
-
Use the CData ODBC Driver for Helpscout in Microsoft Power Query
You can use the CData Helpscout ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Helpscout data into Microsoft Power Query.
-
Integrate with Sage 300 Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Sage 300 data to a JSON file on disk.
-
Getting Started with the CData Connect AI Python SDK for LinkedIn Ads
Install the CData Connect AI Python SDK to read live LinkedIn Ads data with standard DB-API 2.0 Python code.
-
Build Notion-Connected Apps in Choreo
Use CData Connect AI to connect to Notion Data from Choreo and build custom apps using live Notion data.
-
Analyze Reckon Accounts Hosted Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Reckon Accounts Hosted data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Automated Workflows with Live TaxJar Data in Workato
Use CData Connect AI to connect to live TaxJar data and build automated workflows in Workato.
-
Query SAP BusinessObjects BI Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP BusinessObjects BI data from Node.js.
-
Replicate Scrapfly Data to Multiple Databases
Replicate Scrapfly data to disparate databases with a point-and-click configuration.
-
Create Egnyte-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Egnyte Data from Klipfolio and build custom visualizations using live Egnyte data.
-
LINQ to Excel 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 Excel Data Provider.
-
Connect to Live Cloudflare Data in MicroStrategy through CData Connect AI
Create a live connection to Cloudflare Data in CData Connect AI and connect to your Cloudflare data from MicroStrategy.
-
Visualize Live OpenWeatherMap Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live OpenWeatherMap data.
-
Connect to Google Translate from Asprova with CData Software ODBC Driver for Google Translate
This article shows how to connect faster to Google Translate data from Asprova.
-
Query Live Sage Cloud Accounting Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Sage Cloud Accounting data directly from the development environment.
-
Analyze Live SAP Business One Data in SAS Viya
Use CData Connect AI to connect to SAP Business One data from SAS Viya and deploy self-service analytics using live SAP Business One data.
-
Rapidly Develop ConvertAPI-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 ConvertAPI.
-
Visualize Live Impala Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Impala data into custom reports in Power BI.
-
Analyze Landbot Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Landbot data in Microsoft R Open.
-
Use the CData ODBC Driver for Google Directory in Microsoft Power Query
You can use the CData Google Directory ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Directory data into Microsoft Power Query.
-
Getting Started with the CData SSIS Components for ActiveCampaign
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ActiveCampaign.
-
Query Nuclia Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Nuclia data from Node.js.
-
Work with Dotmailer Data in FoxPro
Load Dotmailer data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate ChartMogul Data in Pentaho Data Integration
Build ETL pipelines based on ChartMogul data in the Pentaho Data Integration tool.
-
Connect to and Visualize Live Foursquare Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Foursquare data.
-
Connect to Live ZohoPeople Data in PostGresSQL Interface through CData Connect AI
Create a live connection to ZohoPeople in CData Connect AI and connect to your ZohoPeople data from PostgreSQL.
-
Automated Continuous Contentful Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Contentful replication to Google Cloud SQL.
-
Connect to and Visualize Live Shortcut Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Shortcut data.
-
Connect to Splunk Data from PowerBuilder via ADO.NET
This article demonstrates how to access Splunk data from Appeon PowerBuilder using the CData ADO.NET Provider for Splunk.
-
Use the CData ODBC Driver for Acumatica in Microsoft Power Query
You can use the CData Acumatica ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Acumatica data into Microsoft Power Query.
-
Create Power BI Reports on Real-Time FHIR Data
Use the CData ODBC Driver for FHIR to visualize FHIR data in Power BI Desktop.
-
Access Zoho Books Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zoho Books data from your Oracle system.
-
Integrate Trae with Live ZohoMarketingHub Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live ZohoMarketingHub data from within the AI-powered IDE.
-
Use the CData Software JDBC Driver for Acumatica in MicroStrategy Web
Connect to Acumatica data in MicroStrategy Web using the CData Software JDBC Driver for Acumatica.
-
How to integrate ElevenLabs with Apache Airflow
Access and process ElevenLabs data in Apache Airflow using the CData JDBC Driver.
-
Moving Data from Act CRM to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Act CRM data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Apps with Live Factorial Data Using the Low-Code Development Platform of Mendix
Connect Factorial data with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate Demio with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Demio with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Demio data.
-
Automated Continuous Supabase Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Supabase replication to PostgreSQL.
-
Getting Started with the CData Tableau Connector for Retently
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrate with Supabase Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Supabase data in SnapLogic.
-
Create a Data Access Object for Apify Data using JDBI
A brief overview of creating a SQL Object API for Apify data in JDBI.
-
Connect to Reply.io Data in DBeaver
Use the CData ODBC Driver to connect to Reply.io data in DBeaver.
-
Rapidly Develop SendPulse-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 SendPulse.
-
Access Live GitHub Data in Excel 365 Online (Excel for the web)
Connect to GitHub data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate Live Zoho CRM Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Zoho CRM from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zoho CRM data.
-
Design BIRT Reports on Access Data
Provide current Access data to your embedded analytics.
-
Connect Azure Synapse to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Azure Synapse with IBM WebSphere for seamless data integration and connectivity.
-
DataBind Controls to Testmonitor Data in Delphi
DataBind to Testmonitor data in Delphi with standard data access components and controls.
-
Elasticsearch Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Elasticsearch data through CData Connect AI using different applications and tools.
-
How to connect SharePoint with Reckon Data through external lists
Provide Reckon data to SharePoint users as an external list.
-
Use JayDeBeApi to access SuiteCRM Data in Python
Use standard Python scripting and the development environment of your choice to access live SuiteCRM data.
-
Enable the Marketo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Marketo data.
-
Use ChatGPT to Talk to Your Zuora 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 Zuora data for you.
-
Integrate Google's Vertex AI Agent with Live Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Google Analytics data within intelligent workflows.
-
Write a Simple Go Application to work with Float Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Float data.
-
Natively Connect to Dynamics 365 Business Central Data in PHP
The CData ODBC driver for Dynamics 365 Business Central enables you to create PHP applications with connectivity to Dynamics 365 Business Central data. Leverage the native support for ODBC in PHP.
-
Integrate Theia IDE with Live Excel Online 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 Excel Online data from within the development environment.
-
Work with Live ShipEngine Data in Power Query
Use CData Connect AI to connect to ShipEngine data and work with live ShipEngine data in Microsoft Power Query.
-
Use Agno to Talk to Your Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Confluence data for you.
-
Integrate Real-Time Access to Adobe Target in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Adobe Target data in real time.
-
Access Live Sage Intacct Data in AWS Lambda
Connect to live Sage Intacct data in AWS Lambda using the CData JDBC Driver.
-
Build Semantic Layer Views for ClickUp Data in APOS Live Data Gateway
Use the CData Connector for ClickUp in APOS Live Data Gateway to build Semantic Layer Views for ClickUp data.
-
Connect to Guru Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Guru and work with Guru data in your FileMaker applications.
-
Use Biml to Build SSIS Tasks to Replicate SAP SuccessFactors LMS Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP SuccessFactors LMS data to SQL Server.
-
Use Claude to Talk to Your SendPulse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your SendPulse data for you.
-
How to Build an ETL App for Bright Data Data in Python with CData Connect AI
Extract and transform live Bright Data data in Python with petl and the CData Connect AI Python SDK.
-
Build Oracle SCM-Connected Apps in Choreo
Use CData Connect AI to connect to Oracle SCM Data from Choreo and build custom apps using live Oracle SCM data.
-
How to Visualize Asana Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Asana data in Python.
-
Use the CData Software ODBC Driver for LaunchDarkly in MicroStrategy Desktop
Connect to LaunchDarkly data in MicroStrategy Desktop using the CData Software ODBC Driver for LaunchDarkly.
-
Access Live Azure Table 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 Azure Table data through MCP integration.
-
Build Semantic Layer Views for YouTube Analytics Data in APOS Live Data Gateway
Use the CData Connector for YouTube Analytics in APOS Live Data Gateway to build Semantic Layer Views for YouTube Analytics data.
-
Use the CData Software JDBC Driver for Google Ad Manager in MicroStrategy
Connect to Google Ad Manager data in MicroStrategy Developer using the CData Software JDBC Driver for Google Ad Manager.
-
Connect to Outlook Data in NetBeans
Connect to Outlook data in NetBeans with the data source configuration wizard.
-
Automated Continuous Recurly Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Recurly replication to PostgreSQL.
-
Replicate ZeroBounce Data to Multiple Databases via the CData Sync CLI
Replicate ZeroBounce data to disparate databases with a single configuration.
-
How to Work with Strava Data in ETL Validator JDBC
Connect to Strava from ETL Validator jobs using the CData Software JDBC Driver.
-
Migrating data from SAP Ariba Source to Databricks using CData SSIS Components.
Easily push SAP Ariba Source data to Databricks using the CData SSIS Tasks for SAP Ariba Source and Databricks.
-
Integrate with Live Zoho CRM Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Zoho CRM from the MuleSoft Anypoint Platform to integrate live Zoho CRM data into custom reports and dashboards.
-
Automated Aircall Data Replication to Teradata
Use CData Sync to Customize and automate Aircall data replication to Teradata.
-
Migrating data from Helpscout to Snowflake using CData SSIS Components.
Easily push Helpscout data to Snowflake using the CData SSIS Tasks for Helpscout and Snowflake.
-
Build MVC Applications with Connectivity to CloudConvert Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access CloudConvert from an ASP.NET MVC application.
-
Visualize Power BI XMLA Data in Tableau
The CData ODBC driver for Power BI XMLA enables you integrate Power BI XMLA data into Tableau dashboards.
-
How to connect to Quickbase Data from IntelliJ
Integrate connectivity to Quickbase data with wizards in IntelliJ.
-
Connect to and Visualize Live Onfleet Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Onfleet data.
-
Publish Crystal Reports on ShipStation Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ShipStation data.
-
Use the CData Software ODBC Driver for Perplexity in SAS for Real-Time Reporting and Analytics
Connect to real-time Perplexity data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Perplexity.
-
Use Azure AI Foundry to Talk to Your Pinterest 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 Pinterest data for you.
-
Connect to Adobe Commerce Data from a Connection Pool in JBoss
Integrate Adobe Commerce data into Java servlets: Use the Management Console in JBoss to install the Adobe Commerce JDBC Driver.
-
Prepare, Blend, and Analyze Procore Data in Alteryx Designer (ODBC)
Build workflows to access live Procore data for self-service data analytics.
-
Build Dashboards with Shippo Data in Dundas BI
Create dynamic dashboards and perform analytics based on Shippo data in Dundas BI.
-
Integrating OpenCode with Testmonitor 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 Avro-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Avro data.