CData Software - Knowledge Base
Recent Articles
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Splunk to Power BI dashboards. Simply drag and drop Splunk into data visuals on the Power BI canvas.
-
Replicate SAP Concur to Multiple Databases via the CData Sync CLI
Replicate SAP Concur to disparate databases with a single configuration.
-
Build Pipelines with Live Odoo in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Odoo from Google Cloud Data Fusion, enabling the integration of live Odoo ERP into the building and management of effective data pipelines.
-
Connect to SAP HANA in Google Apps Script via Connect AI
Use CData Connect AI to access SAP HANA in Google Apps Script.
-
Connect to REST from Asprova with CData Software ODBC Driver for REST
This article shows how to connect faster to REST data from Asprova.
-
Analyze Live Kintone in SAS Viya
Use CData Connect AI to connect to Kintone from SAS Viya and deploy self-service analytics using live Kintone.
-
Building Dynamic Web Pages with SAS xpt Using AngularJS
Create single-page applications with live connectivity to SAS xpt using the CData API Server.
-
Add PingOne to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for PingOne with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Dynamics 365 from PowerBuilder via JDBC
This article demonstrates how to access Microsoft Dynamics 365 from PowerBuilder using the Dynamics 365 JDBC Driver.
-
How to Connect to Zendesk in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Zendesk. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous HDFS Replication to SingleStore
Use CData Sync for automated, continuous, customizable HDFS replication to SingleStore.
-
How to update SAP SuccessFactors from Excel
This article explains how to transfer data from Excel to SAP SuccessFactors using the Excel Add-In for SAP SuccessFactors.
-
Build Automated Workflows with Live HubSpot in Workato
Use CData Connect AI to connect to live HubSpot and build automated workflows in Workato.
-
A PostgreSQL Interface for Pinterest using the CData ODBC Driver
Use the SQL Gateway and Pinterest ODBC Driver to create a PostgreSQL entry-point for data access.
-
Migrating data from Drip to Google BigQuery using CData SSIS Components.
Easily push Drip to Google BigQuery using the CData SSIS Tasks for Drip and Google BigQuery.
-
Connect to HarperDB in HULFT Integrate
Connect to HarperDB as a JDBC data source in HULFT Integrate
-
Connect to Impala in CloverDX (formerly CloverETL)
Transfer Apache Impala using the visual workflow in the CloverDX data integration tool.
-
How to Access Highrise Using Entity Framework
This article shows how to access Highrise CRM using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Azure Synapse Replication to MySQL
Use CData Sync for automated, continuous, customizable Azure Synapse replication to MySQL.
-
How to Connect to Live Google Ads 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 Google Ads for you.
-
Connect to Paylocity from HeidiSQL
Use CData Connect AI to connect to and query live Paylocity from HeidiSQL.
-
Use the CData Software JDBC Driver for Salesforce Pardot in MicroStrategy
Connect to Salesforce Pardot in MicroStrategy Developer using the CData Software JDBC Driver for Salesforce Pardot.
-
Visualize Live BambooHR in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live BambooHR.
-
Visualize Redshift in Tableau
The CData ODBC driver for Redshift enables you integrate Amazon Redshift into Tableau dashboards.
-
Connect to Azure Analysis Services from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Azure Analysis Services using standard SQL.
-
Integrate Slack with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Slack with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Slack.
-
Import Real-Time SAP Business One via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP Business One in ColdFusion.
-
Use ChatGPT to Talk to Your Oracle Eloqua via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Oracle Eloqua for you.
-
How to Connect Flowise AI Agents to Live Reckon via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
DataBind Controls to Marketo in C++Builder
DataBind to Marketo in C++Builder with standard components and controls.
-
Import GraphQL Using Azure Data Factory
Use CData Connect AI to connect to GraphQL from Azure Data Factory and import live GraphQL.
-
Build Epicor Kinetic-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Epicor Kinetic and build web apps with connectivity to live Epicor Kinetic.
-
Deploy the ADO.NET Provider for Kintone on an SSRS Report Server
Connect to Kintone 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.
-
Query Jira Service Management as a MySQL Database in Node.js
Execute MySQL queries against Atlassian Jira Service Management from Node.js.
-
Publish Zendesk-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Zendesk.
-
How to import QuickBooks Time into Apache Solr
Use the CData Software JDBC Driver for QuickBooks Time in Data Import Handler and create an automated import of QuickBooks Time to Apache Solr Enterprise Search platform.
-
Visualize Zoho Books in Tableau
The CData ODBC driver for Zoho Books enables you integrate Zoho Books into Tableau dashboards.
-
Automate Azure DevOps Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Azure DevOps and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Analyze MySQL in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze MySQL in Microsoft R Open.
-
How to Connect to Live QuickBooks Online from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your QuickBooks Online through natural language.
-
Connect to Google Search Results in ACL Analytics
Connect to Google Search via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Search.
-
Use the CData Software ODBC Driver for NetSuite in MicroStrategy
Connect to NetSuite CRM & ERP in MicroStrategy Developer using the CData Software ODBC Driver for NetSuite.
-
Host the API Server on Azure
Host the CData API Server in Microsoft Windows Azure to create always-on OData entrypoints for your data.
-
Provide OData Services of Raisers Edge NXT from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Raisers Edge NXT by developing a WCF Service Application.
-
Connect to WordPress from HeidiSQL
Use CData Connect AI to connect to and query live WordPress from HeidiSQL.
-
Deploy the ADO.NET Provider for Spark on an SSRS Report Server
Connect to Apache Spark SQL 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 create an RPA flow for Sybase in UiPath Studio
Use the Sybase ODBC Driver to create workflows that access real-time Sybase without any coding.
-
Bidirectional Access to Certinia from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Certinia in Filemaker Pro for Mac or Windows.
-
Access Shippo from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Shippo from HeidiSQL.
-
Access Live Azure Table in AWS Lambda
Connect to live Azure Table Storage in AWS Lambda using the CData JDBC Driver.
-
Use Microsoft Copilot Studio to talk to your Office 365 via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Microsoft Office 365 for you.
-
How to Query Live CouchDB in Claude Desktop
Connect to and query live CouchDB in Claude Desktop using the CData MCP Server.
-
Build MVC Applications with Connectivity to Gmail
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Gmail from an ASP.NET MVC application.
-
Establish a Live Connection with SuiteCRM using Tableau Bridge
The CData ODBC Driver for SuiteCRM enables you to integrate live SuiteCRM into Tableau Cloud dashboards using the Tableau Bridge.
-
How to import Aha into Apache Solr
Use the CData Software JDBC Driver for Aha in Data Import Handler and create an automated import of Aha! to Apache Solr Enterprise Search platform.
-
LINQ to Act CRM
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 Act CRM Data Provider.
-
View Reports on Real-Time Sage 50 UK in Power BI Report Server
Use the CData ODBC Driver for Sage 50 UK to visualize Sage 50 UK in Power BI Desktop and then publish them to Power BI Report Server.
-
Use CData Connect AI to Access Sage Cloud Accounting in Microsoft Power Pivot
Use CData Connect AI to connect to live Sage Business Cloud Accounting in the Power Pivot business intelligence tool.
-
How to create an RPA flow for Workday in UiPath Studio
Use the Workday ODBC Driver to create workflows that access real-time Workday without any coding.
-
How to Access Live Amazon Marketplace in Visual Studio Code via Cline
Run the CData MCP Server for Amazon Marketplace on Windows Subsytem for Linux (WSL) and connect to live Amazon Marketplace from the Cline extension in Visual Studio Code.
-
Connect to Facebook from AWS Glue
Use CData Connect AI to gain access to live Facebook from your AWS Glue jobs.
-
Create Reports with Google Campaign Manager 360 in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Campaign Manager 360.
-
How to connect to SAP Fieldglass with Squirrel SQL client
Connect to SAP Fieldglass and execute queries in the Squirrel SQL Client.
-
Import Real-Time CouchDB via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Apache CouchDB in ColdFusion.
-
Access HubSpot from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live HubSpot from HeidiSQL.
-
Create SSAS Tabular Models from SAP
How to build a SQL Server Analysis Service Tabular Model from SAP ERP/NetWeaver using CData drivers.
-
Automated Continuous Adobe Commerce Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to PostgreSQL.
-
Visualize Live Databricks in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Databricks.
-
Connect to Avalara AvaTax from PowerBuilder via JDBC
This article demonstrates how to access Avalara AvaTax from PowerBuilder using the Avalara AvaTax JDBC Driver.
-
How to create an RPA flow for Klipfolio in UiPath Studio
Use the Klipfolio ODBC Driver to create workflows that access real-time Klipfolio without any coding.
-
How to Connect to Live Epicor Kinetic from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Epicor Kinetic for you.
-
Use Claude to Talk to Your Zoho Books via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Zoho Books for you.
-
Query Microsoft OneDrive in DataGrip
Create a Data Source for Microsoft OneDrive in DataGrip and use SQL to query live Microsoft OneDrive.
-
Use Claude to Talk to Your SAP ByDesign via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your SAP Business ByDesign for you.
-
Connect to SQL Analysis Services from Asprova with CData Software ODBC Driver for SQL Analysis Services
This article shows how to connect faster to SQL Analysis Services data from Asprova.
-
Integrate Live WooCommerce into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to WooCommerce from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live WooCommerce.
-
How to connect to SingleStore from IntelliJ
Integrate connectivity to SingleStore with wizards in IntelliJ.
-
Automated Continuous ServiceNow Replication to Oracle
Use CData Sync for automated, continuous, customizable ServiceNow replication to Oracle.
-
Explore Geographical Relationships in Basecamp with Power Map
Create data visualizations with Basecamp in Power Map.
-
Rapidly Develop BambooHR-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Automated Continuous Power BI XMLA Replication to Vertica
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Vertica.
-
Analyze xBase in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze xBase in Microsoft R Open.
-
Import Real-Time Splunk via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Splunk in ColdFusion.
-
Connect to Couchbase in the Denodo Platform
Use CData driver technologies to create a virtual data source for Couchbase in the Denodo Virtual DataPort Administrator.
-
Access Live Sage 200 in AWS Lambda (with IntelliJ IDEA)
Connect to live Sage 200 in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Microsoft Project Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Project through CData Connect AI using different applications and tools.
-
Analyze Freshdesk in R via JDBC
Use standard R functions and the development environment of your choice to analyze Freshdesk with the CData JDBC Driver for Freshdesk.
-
Using the CData Software ODBC Driver for Bullhorn CRM in PyCharm
Connect to Bullhorn CRM as an ODBC data source in PyCharm using the CData Software ODBC Driver for Bullhorn CRM.
-
Integrate Microsoft Teams in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Teams from Informatica Cloud.
-
How to Connect to Drift in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Drift. Leverage the pyodbc module for ODBC in Python.
-
Publish Crystal Reports on MySQL
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date MySQL.
-
Connect to Tally in Ruby
Connect to Tally ERP in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to connect to Google Spanner in DBVisualizer
Integrate Google Spanner with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Salesloft Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Salesloft replication to AlloyDB.
-
Build Semantic Layer Views for Redshift in APOS Live Data Gateway
Use the CData Connector for Redshift in APOS Live Data Gateway to build Semantic Layer Views for Amazon Redshift.
-
Replicate Trello to Multiple Databases via the CData Sync CLI
Replicate Trello to disparate databases with a single configuration.
-
Query Asana through ODBC in Node.js
Use node-odbc to execute SQL queries against Asana from Node.js.
-
Integrate Workday in the Pentaho Report Designer
Publish reports based on Workday in the Pentaho BI tool.
-
Connect to OData from Asprova with CData Software ODBC Driver for OData
This article shows how to connect faster to OData data from Asprova.
-
Build Agents in Relevance AI with Access to Live Kintone via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Kintone within intelligent agent workflows.