CData Software - Knowledge Base
Recent Articles
-
Connect to SAP Hybris C4C Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP Hybris C4C using standard SQL.
-
Automated Continuous PagerDuty Replication to SQLite
Use CData Sync for automated, continuous, customizable PagerDuty replication to SQLite.
-
How to Access Live Pingdom Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Pingdom enables you to integrate Pingdom into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData ODBC Driver for Gmail
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Gmail.
-
Analyze Oracle Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Oracle Database and visualize live Oracle Database in Infragistics Reveal.
-
Connect to OData Services in Ruby
Connect to OData in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData Software ODBC Driver for Adobe Experience Manager in MicroStrategy
Connect to Adobe Experience Manager in MicroStrategy Developer using the CData Software ODBC Driver for Adobe Experience Manager.
-
Integrating Dataiku with Dynamics 365 Business Central Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Dynamics 365 Business Central.
-
DataBind Charts to SAP ByDesign Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP Business ByDesign 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.
-
Use the CData Software ODBC Driver for Google Calendar in MicroStrategy
Connect to Google Calendar in MicroStrategy Developer using the CData Software ODBC Driver for Google Calendar.
-
Create Data Visualizations Based On WordPress Data in Mode
Use CData Connect AI to connect to WordPress Data from Mode and build visualizations using live
-
Connect to and Query Bitbucket Data in QlikView over ODBC
Create data visualizations with Bitbucket in QlikView.
-
View Reports on Real-Time HubSpot Data in Power BI Report Server
Use the CData ODBC Driver for HubSpot to visualize HubSpot in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Codex CLI with Google Directory 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 LinkedIn Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date LinkedIn.
-
Operational Reporting on Asana Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Asana.
-
Automated Continuous Facebook Ads Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Facebook Ads replication to Apache Kafka.
-
A PostgreSQL Interface for Dynamics CRM Data (MySQL Remoting via JDBC)
Use the Remoting features of the Dynamics CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for ZohoInvoice in MicroStrategy Desktop
Connect to ZohoInvoice in MicroStrategy Desktop using the CData Software JDBC Driver for ZohoInvoice.
-
Access Live Copper Data in Coginiti Pro
Connect to and query live Copper from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Publish Adobe Analytics-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Adobe Analytics.
-
Integrating LlamaIndex with HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on HCL Domino in real time.
-
Build Data Flows from SQL Server to YouTube Analytics through SSIS
Easily push SQL Server data to YouTube Analytics using the CData SSIS Tasks for YouTube Analytics.
-
Moving Data from Nethunt to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Nethunt data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating Antigravity CLI with Google Sheets via CData CLI
Connect Google Sheets to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Sugar CRM Data in Jaspersoft Studio
Execute SQL to remote Sugar CRM in Jaspersoft Studio.
-
Getting Started with the CData Power BI Connector for PagerDuty
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build GraphQL-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live GraphQL.
-
Visualize Google Calendar Data in Sisense
Create an ElastiCube in Sisense app with access to Google Calendar.
-
Connect Mixpanel Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Mixpanel using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Dynamic IBM Informix Grids Using the Infragistics XamDataGrid
Learn how you can connect IBM Informix to Infragistics XamDataGrid to build dynamic grids.
-
Stream Bullhorn CRM Data into Apache Kafka Topics
Access and stream Bullhorn CRM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Work with Jira Assets Data in FoxPro
Load Jira Assets into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize Drip Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Drip.
-
A PostgreSQL Interface for Trello Data using the CData ODBC Driver
Use the SQL Gateway and Trello ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Easily Query Vault CRM Data in OpenOffice Base
Connect to Vault CRM data in OpenOffice Base using the CData ODBC Driver for Vault CRM and generate reports with live data insights.
-
Use Biml to Build SSIS Tasks to Replicate Zoho CRM Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zoho CRM to SQL Server.
-
How to Work with Exact Online Data in ETL Validator JDBC
Connect to Exact Online from ETL Validator jobs using the CData Software JDBC Driver.
-
DataBind Charts to Basecamp Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Basecamp 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 Acumatica Data in Perplexity MacOS Desktop
Connect to and query live Acumatica Data in Perplexity Desktop using CData MCP Server.
-
Build a PostgreSQL Interface for Landbot Data using the CData JDBC Driver
Use the Remoting features of the Landbot JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to import Active Directory Data into Apache Solr
Use the CData Software JDBC Driver for Active Directory in Data Import Handler and create an automated import of Active Directory to Apache Solr Enterprise Search platform.
-
Automated Continuous Teamgate Replication to Databricks
Use CData Sync for automated, continuous, customizable Teamgate replication to Databricks.
-
Create SSAS Tabular Models from SAP HANA Data
How to build a SQL Server Analysis Service Tabular Model from SAP HANA using CData drivers.
-
Access Insightly 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 Insightly.
-
Build Exact Online-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Exact Online Data from Zoho Analytics and import live Exact Online.
-
Integrate with PostgreSQL Data in JReport Designer
Create charts and reports based on PostgreSQL in JReport Designer.
-
Import Real-Time CouchDB Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Apache CouchDB in ColdFusion.
-
Connect to Templated Data from PowerBuilder via ADO.NET
This article demonstrates how to access Templated from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use Manus AI to Talk to Your Odoo 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 Odoo ERP.
-
Access Live Paylocity 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 Paylocity through MCP integration.
-
Replicate Google Ad Manager Data from PowerShell
Write a quick PowerShell script to query Google Ad Manager. Use connectivity to the live data to replicate Google Ad Manager to SQL Server.
-
Automated Continuous SendGrid Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SendGrid replication to PostgreSQL.
-
Validate ZohoPeople Data with QuerySurge
Access and validate ZohoPeople in QuerySurge using the CData JDBC Driver.
-
Deploy the ADO.NET Provider for Microsoft Planner on an SSRS Report Server
Connect to Microsoft Planner 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.
-
How to connect SharePoint with Quickbase Data through external lists
Provide Quickbase to SharePoint users as an external list.
-
Automated Continuous Delighted Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Delighted replication to IBM DB2.
-
How to load Adobe Target data into Elasticsearch via Logstash
Introducing a simple method to load Adobe Target data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Dashboards with SAP HANA Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP HANA in Dundas BI.
-
Build Data Flows from Azure Table to SQL Server using SSIS
Easily back up Azure Table Storage to SQL Server using the SSIS components for Azure Table.
-
Connect to Amazon Marketplace Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Amazon Marketplace and the Script function in FileMaker Pro to connect to Amazon Marketplace and work with Amazon Marketplace in your FileMaker application.
-
Build Agents in Relevance AI with Access to Live Lakebase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Lakebase within intelligent agent workflows.
-
Visualize Sage Cloud Accounting Data in TIBCO Spotfire through ADO.NET
Integrate Sage Business Cloud Accounting into dashboards in TIBCO Spotfire.
-
How to connect to Anaplan Data with Squirrel SQL client
Connect to Anaplan and execute queries in the Squirrel SQL Client.
-
Access Live Tavily Data in AWS Lambda
Connect to live Tavily in AWS Lambda using the CData JDBC Driver.
-
Connect to Egnyte from Asprova with CData Software ODBC Driver for Egnyte
This article shows how to connect faster to Egnyte data from Asprova.
-
Access Live Deel Data in Coginiti Pro
Connect to and query live Deel from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Drift Replication to Databricks
Use CData Sync for automated, continuous, customizable Drift replication to Databricks.
-
How to publish and share Azure DevOps Data dashboards with Tableau Server
The CData ODBC driver for Azure DevOps enables you integrate Azure DevOps into Tableau dashboards.
-
Import Real-Time Excel Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Excel in ColdFusion.
-
Deploy CData SSIS Components on Azure Data Factory
Deploy an SSIS Package with CData components to the Azure Data Factory Cloud
-
Analyze Oracle SCM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Oracle SCM from Power Pivot. You will use the Table Import Wizard to load Oracle SCM. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Salesforce Pardot Data from AWS Glue
Use CData Connect AI to gain access to live Salesforce Pardot from your AWS Glue jobs.
-
Working with LinkedIn Ads Data in LINQPad
Execute LINQ queries to LinkedIn Ads in LINQPad.
-
Connect to Microsoft Dataverse Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft Dataverse (CDS) in DBeaver.
-
Visualize Hacker News Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Hacker News.
-
How to connect to Jodoo Data with Squirrel SQL client
Connect to Jodoo and execute queries in the Squirrel SQL Client.
-
Natively Connect to Mailgun Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Mailgun. Leverage the native support for ODBC in PHP.
-
Access Live SAP SuccessFactors Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP SuccessFactors from your Excel spreadsheets.
-
Query Bugsnag Data as a MySQL Database in Node.js
Execute MySQL queries against Bugsnag from Node.js.
-
Integrate Spark Data in Pentaho Data Integration
Build ETL pipelines based on Apache Spark SQL in the Pentaho Data Integration tool.
-
Integrate with Twilio Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Twilio in SnapLogic.
-
Automated Continuous Tanda Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Tanda replication to IBM DB2.
-
Integrate Egnyte Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Egnyte from Informatica Cloud.
-
Use the CData ODBC Driver for Coinbase in Microsoft Power Query
You can use the CData Coinbase ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Coinbase into Microsoft Power Query.
-
Load Opsgenie Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Opsgenie to a database.
-
Build Data Flows from Zoho CRM to SQL Server using SSIS
Easily back up Zoho CRM to SQL Server using the SSIS components for Zoho CRM.
-
How to connect to Tickspot Data from IntelliJ
Integrate connectivity to Tickspot with wizards in IntelliJ.
-
DataBind Controls to Autopilot Data in Delphi
DataBind to Autopilot in Delphi with standard data access components and controls.
-
Query, Visualize, and Share live CockroachDB Data in Redash
Use CData Connect AI to connect to live CockroachDB in Redash for querying, visualizing, and sharing.
-
Connect to Rebilly Data in Ruby
Connect to Rebilly in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize Live Redshift Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Amazon Redshift into custom reports in Power BI.
-
Build Dashboards with SAP HANA XS Advanced Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP HANA XS Advanced in Dundas BI.
-
Query, Visualize, and Share live Google Ads Data in Redash
Use CData Connect AI to connect to live Google Ads in Redash for querying, visualizing, and sharing.
-
Connect to Pipeliner CRM Data from PowerBuilder via JDBC
This article demonstrates how to access Pipeliner CRM from PowerBuilder using the Pipeliner CRM JDBC Driver.
-
Access Live SAS Data Sets Data in AWS Lambda
Connect to live SAS Data Sets in AWS Lambda using the CData JDBC Driver.
-
Visualize Live Pipedrive Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Pipedrive into custom reports in Power BI.
-
Automated Continuous Dynamics 365 Business Central Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Amazon S3.
-
Integrate with Snapchat Ads Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Snapchat Ads in SnapLogic.
-
Connect to Google Search Results in NetBeans
Connect to Google Search in NetBeans with the data source configuration wizard.