CData Software - Knowledge Base
Recent Articles
-
LINQ to Webflow 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 Webflow Data Provider.
-
Query, Visualize, and Share live Azure Analysis Services Data in Redash
Use CData Connect AI to connect to live Azure Analysis Services in Redash for querying, visualizing, and sharing.
-
Analyze Phoenix Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Apache Phoenix and visualize Apache Phoenix in SAP Analytics Cloud.
-
Integrating Antigravity CLI with OpenWeatherMap via CData CLI
Connect OpenWeatherMap to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous FreshBooks Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable FreshBooks replication to PostgreSQL.
-
Automate WordPress Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live WordPress and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Query Live Mode Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Mode data in natural language using Python.
-
Publish Reports with Helpscout Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Helpscout.
-
Migrating data from Klipfolio to Google BigQuery using CData SSIS Components.
Easily push Klipfolio to Google BigQuery using the CData SSIS Tasks for Klipfolio and Google BigQuery.
-
Extract, Transform, and Load Auth0 Data in Informatica PowerCenter
Create a simple Workflow for Auth0 in Informatica PowerCenter.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for FreeAgent
Provide connectivity to FreeAgent through an SAP BusinessObjects universe.
-
How to connect and process Short.io from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Short.io.
-
How to Connect to Live Google Ad Manager Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Google Ad Manager for you.
-
Access Live Oracle Eloqua Data in Coginiti Pro
Connect to and query live Oracle Eloqua from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated OneNote Data Replication to Teradata
Use CData Sync to Customize and automate Microsoft OneNote replication to Teradata.
-
Visualize Live PostgreSQL Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live PostgreSQL.
-
Create Data Visualizations Based On OData Services in Mode
Use CData Connect AI to connect to OData Services from Mode and build visualizations using live
-
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.
-
Integrate Autopilot Data in Pentaho Data Integration
Build ETL pipelines based on Autopilot in the Pentaho Data Integration tool.
-
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.
-
Integrating LangChain with Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Sugar CRM within automated workflows.
-
Create Informatica Mappings From/To an ODBC Data Source for Calendly
Create an ODBC connection to Calendly in Informatica and browse and transfer Calendly.
-
Use the CData Software JDBC Driver for Figshare in MicroStrategy Web
Connect to Figshare in MicroStrategy Web using the CData Software JDBC Driver for Figshare.
-
Integrate MongoDB Data in the Pentaho Report Designer
Publish reports based on MongoDB in the Pentaho BI tool.
-
Connect to QuickBooks Data in Aqua Data Studio
Access QuickBooks Desktop from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Dashboards with RabbitMQ Data in DBxtra
Create dynamic dashboards and perform analytics based on RabbitMQ in DBxtra.
-
Use the CData Software JDBC Driver for Google Calendar in MicroStrategy Desktop
Connect to Google Calendar in MicroStrategy Desktop using the CData Software JDBC Driver for Google Calendar.
-
Integrate Azure Table with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Azure Table with External Services.
-
How to load Google Drive data into Elasticsearch via Logstash
Introducing a simple method to load Google Drive data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Basecamp-Connected Apps in Choreo
Use CData Connect AI to connect to Basecamp Data from Choreo and build custom apps using live Basecamp.
-
How to Create Power BI Visual Reports with Real-Time FreshBooks Data
Use CData Power BI Connectors to visualize FreshBooks in Power BI.
-
Visualize Salesforce Data in Tableau
The CData ODBC driver for Salesforce enables you integrate Salesforce & Force.com into Tableau dashboards.
-
Migrating data from BambooHR to Databricks using CData SSIS Components.
Easily push BambooHR to Databricks using the CData SSIS Tasks for BambooHR and Databricks.
-
Query Rootly Data in DataGrip
Create a Data Source for Rootly in DataGrip and use SQL to query live Rootly.
-
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.
-
ETL ConvertKit in Oracle Data Integrator
This article shows how to transfer ConvertKit into a data warehouse using Oracle Data Integrator.
-
Use ChatGPT to Talk to Your Exact Online 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 Exact Online for you.
-
Connect to Dynamics 365 Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Dynamics 365 and the SQL Gateway to access Microsoft Dynamics 365 from Google Apps Script.
-
Automated Continuous Bugsnag Replication to Vertica
Use CData Sync for automated, continuous, customizable Bugsnag replication to Vertica.
-
Integrate Everhour Data in Pentaho Data Integration
Build ETL pipelines based on Everhour in the Pentaho Data Integration tool.
-
Getting Started with the CData SSIS Components for AlloyDB
Complete guide to installing, licensing, and connecting with the CData SSIS Components for AlloyDB.
-
Migrating data from Drip to Snowflake using CData SSIS Components.
Easily push Drip to Snowflake using the CData SSIS Tasks for Drip and Snowflake.
-
Automate FHIR Data Replication to SAP HANA
Use CData Sync to customize and automate FHIR replication to SAP HANA.
-
Replicate Grafana Data in Heroku for Use in Salesforce Connect
Replicate Grafana to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Live Klaviyo Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Klaviyo in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use Dash to Build to Web Apps on Procore Data
Create Python applications that use pandas and Dash to build Procore-connected web apps.
-
Access Live Twitter Ads Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Twitter Ads from your Excel spreadsheets.
-
Create Reports with SAS xpt Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAS XPORT.
-
Connect to SAP Ariba Source Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAP Ariba Source and the SQL Gateway to access SAP Ariba Source from Google Apps Script.
-
Query SAS Data Sets Data as a MySQL Database in Node.js
Execute MySQL queries against SAS Data Sets from Node.js.
-
Getting Started with the CData JDBC Driver for Act-On
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Act-On.
-
Getting Started with the CData Power BI Connector for Amazon Marketplace
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Amazon Marketplace.
-
Design BIRT Reports on Campaigner Data
Provide current Campaigner to your embedded analytics.
-
Import Reckon Accounts Hosted Data Using Azure Data Factory
Use CData Connect AI to connect to Reckon Accounts Hosted Data from Azure Data Factory and import live Reckon Accounts Hosted.
-
Build MVC Applications with Connectivity to ZeroBounce Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ZeroBounce from an ASP.NET MVC application.
-
Build Agents in Relevance AI with Access to Live BigQuery Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google BigQuery within intelligent agent workflows.
-
Automate HelloSign Data Replication to Azure Data Lake
Use CData Sync to customize and automate HelloSign replication to Azure Data Lake.
-
Deploy the ADO.NET Provider for Vault CRM on an SSRS Report Server
Connect to Veeva Vault & Vault CRM from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Establish a Live Connection with Zoho CRM Data using Tableau Bridge
The CData ODBC Driver for Zoho CRM enables you to integrate live Zoho CRM into Tableau Cloud dashboards using the Tableau Bridge.
-
Automate Clockify Data Replication to Azure Data Lake
Use CData Sync to customize and automate Clockify replication to Azure Data Lake.
-
Integrate Live Klaviyo Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Klaviyo and integrate live Klaviyo into apps built in Microsoft Power Apps.
-
Configure the CData JDBC Driver for Salesforce in a Connection Pool in Tomcat
Connect to Salesforce & Force.com from a connection pool in Tomcat.
-
How to connect PolyBase to Campaigner
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Campaigner.
-
How to Connect to Live SendGrid Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your SendGrid for you.
-
Integrating Claude Code CLI with LionDesk 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.
-
Publish Crystal Reports on Telegram Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Telegram.
-
Create Data Visualizations Based On NetSuite Data in Mode
Use CData Connect AI to connect to NetSuite Data from Mode and build visualizations using live
-
Getting Started with the CData ODBC Driver for REST
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for REST.
-
Automated Continuous QuickBooks Replication to Snowflake
Use CData Sync for automated, continuous, customizable QuickBooks replication to Snowflake.
-
Automate Zoho Projects Data Replication to Azure Data Lake
Use CData Sync to customize and automate Zoho Projects replication to Azure Data Lake.
-
Access Live Klaviyo Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Klaviyo into the statistical analysis tools available in SAS JMP. This article shows how to use Klaviyo in the Graph Builder and Query Builder.
-
Integrate Real-Time Access to SAP Ariba Source in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP Ariba Source in real time.
-
Build Automated Workflows with Live Quickbase Data in Workato
Use CData Connect AI to connect to live Quickbase and build automated workflows in Workato.
-
Import and Visualize Redshift Data in Power View
Create data visualizations based on Amazon Redshift in Excel.
-
Query Google Cloud Storage Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Cloud Storage from Node.js.
-
Connect to Avaza Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Import and Visualize Mouseflow Data in Power View
Create data visualizations based on Mouseflow in Excel.
-
Use Dash to Build Web Apps on Vault CRM Data via CData Connect AI
Build interactive Dash web apps on live Veeva Vault & Vault CRM using pandas and the CData Connect AI Python SDK.
-
Integrating Azure Data Catalog Data in Talend Cloud Data Management Platform
Connect Azure Data Catalog Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Azure Data Catalog.
-
Use the CData Software JDBC Driver for ZohoPeople in MicroStrategy
Connect to ZohoPeople in MicroStrategy Developer using the CData Software JDBC Driver for ZohoPeople.
-
Create Data Visualizations in Cognos BI with XML Data
Access XML Files as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Getting Started with the CData Power BI Connector for HelloSign
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Getting Started with the CData ADO.NET Provider for IBM Informix
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for IBM Informix.
-
Create a Data Access Object for SAP HANA Data using JDBI
A brief overview of creating a SQL Object API for SAP HANA in JDBI.
-
Stream Elasticsearch Data into Apache Kafka Topics
Access and stream Elasticsearch in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to HubDB Data as an External Source in Dremio
Use the CData JDBC Driver to connect to HubDB as an External Source in Dremio.
-
Automated Continuous SendInBlue Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SendInBlue replication to Apache Kafka.
-
Connect to and Query Invoiced Data in QlikView over ODBC
Create data visualizations with Invoiced in QlikView.
-
Build Dashboards with Azure Data Catalog Data in Dundas BI
Create dynamic dashboards and perform analytics based on Azure Data Catalog in Dundas BI.
-
Natively Connect to SAP Fieldglass Data in PHP
The CData ODBC driver for SAP Fieldglass enables you to create PHP applications with connectivity to SAP Fieldglass. Leverage the native support for ODBC in PHP.
-
Publish Crystal Reports on LightSpeedRetail Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date LightSpeedRetail.
-
Query QuickBooks Online Data as a SQL Server Database in Node.js
Execute SQL Server queries against QuickBooks Online from Node.js.
-
Establish a Live Connection with Jira Assets Data using Tableau Bridge
The CData ODBC Driver for Jira Assets enables you to integrate live Jira Assets into Tableau Cloud dashboards using the Tableau Bridge.
-
Import CouchDB Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Apache CouchDB. In this article, you will use the OData format to import Apache CouchDB into Microsoft Power Query.
-
Use JayDeBeApi to access Float Data in Python
Use standard Python scripting and the development environment of your choice to access live Float.
-
Use Manus AI to Talk to Your Outreach.io 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 Outreach.io.
-
Access Live Impala Data in Excel 365 Online (Excel for the web)
Connect to Apache Impala from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous Yelp Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Yelp replication to AlloyDB.
-
Connect to Factorial Data in NetBeans
Connect to Factorial in NetBeans with the data source configuration wizard.
-
How to integrate Metabase with Phoenix Data
Use CData Connect AI to connect to live Apache Phoenix and create an interactive dashboard in Metabase from Apache Phoenix.