CData Software - Knowledge Base
Recent Articles
-
Build MVC Applications with Connectivity to Moosend Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Moosend from an ASP.NET MVC application.
-
Integrate with ClickTime Data in JReport Designer
Create charts and reports based on ClickTime in JReport Designer.
-
Object-Relational Mapping (ORM) with Basecamp Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Basecamp into a Java-based ORM framework, Hibernate.
-
Rapidly Develop Missive-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 Missive.
-
DataBind Controls to OnePageCrm Data in Delphi
DataBind to OnePageCrm in Delphi with standard data access components and controls.
-
Build a Singer.io Tap for LinkedIn Ads With the CData Python Connector
Learn how to easily build a Singer.io Tap for live LinkedIn Ads data using
-
Building Dynamic Web Pages with YouTube Analytics Data Using AngularJS
Create single-page applications with live connectivity to YouTube Analytics using the CData API Server.
-
How to work with Procore Data in Apache Spark using SQL
Access and process Procore Data in Apache Spark using the CData Software JDBC Driver.
-
Replicate Pinterest Data from PowerShell
Write a quick PowerShell script to query Pinterest. Use connectivity to the live data to replicate Pinterest to SQL Server.
-
Replicate WooCommerce Data from PowerShell
Write a quick PowerShell script to query WooCommerce. Use connectivity to the live data to replicate WooCommerce to SQL Server.
-
How to Visualize Azure Data Catalog Data in Python with pandas
Use pandas and other modules to analyze and visualize live Azure Data Catalog in Python.
-
Create SSAS Tabular Models from Ontraport Data
How to build a SQL Server Analysis Service Tabular Model from Ontraport using CData drivers.
-
Use the CData ODBC Driver for Testmonitor in Microsoft Power Query
You can use the CData Testmonitor ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Testmonitor into Microsoft Power Query.
-
LINQ to ZohoExpense 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 ZohoExpense Data Provider.
-
Integrating Kiro CLI with Azure Analysis Services 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 Dashboards with Beeminder Data in Dundas BI
Create dynamic dashboards and perform analytics based on Beeminder in Dundas BI.
-
Visualize Pinecone Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Pinecone.
-
Build Oracle Eloqua Reporting-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Oracle Eloqua Reporting and build web apps with connectivity to live Oracle Eloqua Reporting.
-
How to Build an ETL App for Cassandra Data in Python with CData
Create ETL applications and real-time data pipelines for Apache Cassandra in Python with petl.
-
Use the CData Software JDBC Driver for Excel Online in MicroStrategy
Connect to Microsoft Excel Online in MicroStrategy Developer using the CData Software JDBC Driver for Excel Online.
-
Build a Simple VCL Application for Discord Data
How to build a simple VCL Application to view Discord in RAD Studio using the CData ODBC Driver for Discord.
-
Connect to Gmail Data in RazorSQL
Connect to Gmail from wizards and query Gmail from the GUI in the RazorSQL database management tool.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live DocuSign within intelligent workflows.
-
How to Query Live NetSuite Data in Claude Desktop
Connect to and query live NetSuite Data in Claude Desktop using CData MCP Server.
-
Deploy the ADO.NET Provider for Printful on an SSRS Report Server
Connect to Printful 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.
-
Object-Relational Mapping (ORM) with ZohoSubscriptions Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to ZohoSubscriptions into a Java-based ORM framework, Hibernate.
-
Integrating Tanda Data in Talend Cloud Data Management Platform
Connect Tanda Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Use CData Connect AI to Access SAP Netweaver Gateway Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP Netweaver Gateway in the Power Pivot business intelligence tool.
-
Automate Omnisend Data Replication to Couchbase
Use CData Sync to Customize and automate Omnisend replication to Couchbase.
-
Integrating Codex CLI with Anaplan 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.
-
Create Informatica Mappings From/To a JDBC Data Source for Confluence
Create Confluence data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Replicate Multiple SendPulse Accounts via the CData Sync CLI
Replicate multiple SendPulse accounts to one or many databases.
-
Integrate LibreChat with Live Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Zuora from within the chat interface.
-
Access Live Sage Intacct Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sage Intacct from your Excel spreadsheets.
-
Use ChatGPT to Talk to Your Google Ad Manager 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 Google Ad Manager for you.
-
A PostgreSQL Interface for Salesforce Marketing Data using the CData ODBC Driver
Use the SQL Gateway and Salesforce Marketing ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to work with Everhour Data in Apache Spark using SQL
Access and process Everhour Data in Apache Spark using the CData Software JDBC Driver.
-
Consume Short.io OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Short.io feeds that reflect any changes in SAP Lumira.
-
Integrate Live Microsoft Dataverse Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Microsoft Dataverse (CDS) and integrate live Microsoft Dataverse (CDS) into apps built in Microsoft Power Apps.
-
Integrate Gmail Data in Pentaho Data Integration
Build ETL pipelines based on Gmail in the Pentaho Data Integration tool.
-
Visualize Live Shippo Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Shippo.
-
Reckon Accounts Hosted Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Reckon Accounts Hosted facts in real time.
-
Connect to Cvent Data in Ruby
Connect to Cvent in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Write a Simple Go Application to work with Salesforce Pardot Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Salesforce Pardot.
-
Establish a Live Connection with Planio Data using Tableau Bridge
The CData ODBC Driver for Planio enables you to integrate live Planio into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Dashboards with CockroachDB Data in DBxtra
Create dynamic dashboards and perform analytics based on CockroachDB in DBxtra.
-
Extract, Transform, and Load Snowflake Data in Informatica PowerCenter
Create a simple Workflow for Snowflake in Informatica PowerCenter.
-
Access Live Zoho Projects Data in Excel 365 Online (Excel for the web)
Connect to Zoho Projects from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to connect SharePoint with CircleCI Data through external lists
Provide CircleCI to SharePoint users as an external list.
-
Connect to SAP SuccessFactors Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP SuccessFactors in Google Apps Script.
-
Access Live Eventbrite Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Eventbrite data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use JayDeBeApi to access GitHub Data in Python
Use standard Python scripting and the development environment of your choice to access live GitHub.
-
Use CData Connect AI to Access MailChimp Data in Microsoft Power Pivot
Use CData Connect AI to connect to live MailChimp in the Power Pivot business intelligence tool.
-
Extract, Transform, and Load Greenhouse Data in Informatica PowerCenter
Create a simple Workflow for Greenhouse in Informatica PowerCenter.
-
Access Live Anaplan Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Anaplan into the statistical analysis tools available in SAS JMP. This article shows how to use Anaplan in the Graph Builder and Query Builder.
-
Automated Continuous Zoho CRM Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Zoho CRM replication to PostgreSQL.
-
Connect to Live Google Ad Manager Data in MicroStrategy through CData Connect AI
Create a live connection to Google Ad Manager Data in CData Connect AI and connect to your Google Ad Manager from MicroStrategy.
-
Connect to Act CRM Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Act CRM from Filemaker Pro on Mac.
-
Connect to AlloyDB Data in DBArtisan
Use wizards in DBArtisan to configure Google AlloyDB as a data source.
-
Prepare, Blend, and Analyze JSON Services in Alteryx Designer (ODBC)
Build workflows to access live JSON for self-service data analytics.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SparkPost
Provide connectivity to SparkPost through an SAP BusinessObjects universe.
-
Build AI Agents with Azure Table Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Azure Table Storage through CData Connect AI.
-
Automate Anaplan Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Anaplan from PowerShell? This article demonstrates how to utilize the Anaplan Cmdlets for tasks like connecting to Anaplan, automating operations, downloading data, and more.
-
How to create Visio diagrams from eBay Data
Automatically update eBay with the changes you make to Visio master shapes.
-
Getting Started with the CData ODBC Driver for Scrapfly
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Scrapfly.
-
Integrate Miro Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Miro from Informatica Cloud.
-
Trigger NetSuite IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for NetSuite with standard wizards in Logic Apps.
-
Integrating Dataiku with Bullhorn CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Bullhorn CRM.
-
Automated Continuous Basecamp Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Basecamp replication to OneLake in Microsoft Fabric.
-
Validate Quaderno Data with QuerySurge
Access and validate Quaderno in QuerySurge using the CData JDBC Driver.
-
Access Google Directory Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Directory from HeidiSQL.
-
Replicate Multiple ChargeOver Accounts via the CData Sync CLI
Replicate multiple ChargeOver accounts to one or many databases.
-
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.
-
Use the CData Software JDBC Driver for Bugsnag in MicroStrategy Desktop
Connect to Bugsnag in MicroStrategy Desktop using the CData Software JDBC Driver for Bugsnag.
-
How to Connect to Live Confluence 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 Atlassian Confluence for you.
-
Integrate with BigQuery Data in JReport Designer
Create charts and reports based on Google BigQuery in JReport Designer.
-
Analyze CouchDB Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Apache CouchDB and visualize Apache CouchDB in SAP Analytics Cloud.
-
Connect Attio to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Attio with IBM WebSphere for seamless data integration and connectivity.
-
Access Live Impala Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Apache Impala in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Automated Workflows with Live EnterpriseDB Data in Workato
Use CData Connect AI to connect to live EnterpriseDB and build automated workflows in Workato.
-
Integrate LibreChat with Live Epicor Kinetic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Epicor Kinetic from within the chat interface.
-
Connecting Mastra with LinkedIn 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 LinkedIn, no replication required.
-
Automated Continuous Outreach.io Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Outreach.io replication to IBM DB2.
-
Automate Beeminder Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Beeminder from PowerShell? This article demonstrates how to utilize the Beeminder Cmdlets for tasks like connecting to Beeminder, automating operations, downloading data, and more.
-
Query Live Google Cloud Storage 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 Google Cloud Storage directly from the development environment.
-
Automate SFTP Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SFTP from PowerShell? This article demonstrates how to utilize the SFTP Cmdlets for tasks like connecting to SFTP, automating operations, downloading data, and more.
-
Publish Crystal Reports on Square Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Square.
-
Stream SAP SuccessFactors Data into Apache Kafka Topics
Access and stream SAP SuccessFactors in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Power BI Reports on Real-Time JotForm Data
Use the CData ODBC Driver for JotForm to visualize JotForm in Power BI Desktop.
-
How to create an RPA flow for Harvest Data in UiPath Studio
Use the Harvest ODBC Driver to create workflows that access real-time Harvest without any coding.
-
Use the CData Software JDBC Driver for Workday in MicroStrategy
Connect to Workday in MicroStrategy Developer using the CData Software JDBC Driver for Workday.
-
Automated Continuous Harvest Replication to SQLite
Use CData Sync for automated, continuous, customizable Harvest replication to SQLite.
-
How to integrate RSS with Apache Airflow
Access and process RSS Feeds in Apache Airflow using the CData JDBC Driver.
-
Integrate xBase with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate xBase with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to xBase.
-
Create Power BI Reports on Real-Time Trello Data
Use the CData ODBC Driver for Trello to visualize Trello in Power BI Desktop.
-
Build Charts with ShipStation Data in Clear Analytics
Create dynamic charts and perform analytics based on ShipStation in Clear Analytics.
-
Write a Simple Go Application to work with Hacker News Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Hacker News.
-
Integrating SAS Data Sets Data in Talend Cloud Data Management Platform
Connect SAS Data Sets Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAS Data Sets.
-
Connect to Asana Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Asana.
-
How to Connect to Live Adobe Analytics Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Adobe Analytics securely in real time.