CData Software - Knowledge Base
Recent Articles
-
Create Sage 200 Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Sage 200 data access from reports, embedded analytics, and more.
-
Automated Continuous Bright Data Replication to Databricks
Use CData Sync for automated, continuous, customizable Bright Data replication to Databricks.
-
Connect to and Query Stack Exchange Data in QlikView over ODBC
Create data visualizations with Stack Exchange data in QlikView.
-
Replicate Recurly Data in Heroku for Use in Salesforce Connect
Replicate Recurly data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Consume Reckon OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Reckon feeds that reflect any changes in SAP Lumira.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Trello
Provide connectivity to Trello data through an SAP BusinessObjects universe.
-
Connect to Lakebase Data from PowerBuilder via JDBC
This article demonstrates how to access Lakebase data from PowerBuilder using the Lakebase JDBC Driver.
-
Use the CData Software JDBC Driver for Superchat in MicroStrategy Desktop
Connect to Superchat data in MicroStrategy Desktop using the CData Software JDBC Driver for Superchat.
-
How to Connect the Power BI Service to Beeminder: Complete Guide
Connect to the CData Software Power BI Connector for Beeminder from PowerBI.com to provide real-time Beeminder data across the organization.
-
Connect to QuickBooks Time Data in DBeaver
Use the CData ODBC Driver to connect to QuickBooks Time data in DBeaver.
-
Connect to Google Ads Data from Crystal Reports
Use CData Connect AI to connect to and report on live Google Ads data from Crystal Reports.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Shippo
Provide connectivity to Shippo data through an SAP BusinessObjects universe.
-
DataBind Controls to Wrike Data in C++Builder
DataBind to Wrike data in C++Builder with standard components and controls.
-
Create Power BI Reports on Real-Time Placid Data
Use the CData ODBC Driver for Placid to visualize Placid data in Power BI Desktop.
-
Automate Figshare Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Figshare data from PowerShell? This article demonstrates how to utilize the Figshare Cmdlets for tasks like connecting to Figshare data, automating operations, downloading data, and more.
-
Connect to Opsgenie Data in JRuby
Create a simple JRuby app with access to live Opsgenie data.
-
Query, Visualize, and Share live DocuSign Data in Redash
Use CData Connect AI to connect to live DocuSign data in Redash for querying, visualizing, and sharing.
-
Object-Relational Mapping (ORM) with SAP Netweaver Gateway 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 SAP Netweaver Gateway data into a Java-based ORM framework, Hibernate.
-
Automated Continuous RSS Feeds Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable RSS feeds replication to OneLake in Microsoft Fabric.
-
Access Live Redshift 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 Redshift data through MCP integration.
-
Integrating Boomi Agentstudio with NetSuite SuiteAnalytics Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to NetSuite SuiteAnalytics data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrate Paylocity Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Paylocity data from Informatica Cloud.
-
Integrate Devin with Live ZohoExpense Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live ZohoExpense data.
-
Integrating Kiro with Apollo 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.
-
Integrate Google's Vertex AI Agent with Live SendGrid 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 SendGrid data within intelligent workflows.
-
Create Data Visualizations in Cognos BI with Zoho CRM Data
Access Zoho CRM data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to connect to Oracle Service Cloud Data from Spring Boot
Connect to Oracle Service Cloud in a Spring Boot Application using the CData JDBC Driver for Oracle Service Cloud
-
How to use SQLAlchemy ORM to access Salesforce Data 360 Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Salesforce Data 360 data.
-
Bridge PhantomBuster Connectivity with Apache NiFi
Access and process PhantomBuster data in Apache NiFi using the CData JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Zoho Books Data
Use CData Power BI Connectors to visualize Zoho Books data in Power BI.
-
Query SAP Hybris C4C Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAP Hybris C4C data from Node.js.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP Netweaver Gateway
Provide connectivity to SAP Netweaver Gateway data through an SAP BusinessObjects universe.
-
Use the CData SSIS Components to Insert New or Update Existing Microsoft Dataverse Records from SQL Server
Easily push SQL Server data to Microsoft Dataverse using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Microsoft Dataverse or update existing records with data from a SQL Server database.
-
Automated Continuous ChartMogul Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ChartMogul replication to delimited files (CSV/TSV).
-
How to create Freshservice federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Freshservice data in MySQL .
-
Connect to Clari Data in CloverDX (formerly CloverETL)
Transfer Clari data using the visual workflow in the CloverDX data integration tool.
-
Connect to SAS xpt Data in ACL Analytics
Connect to SAS xpt data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAS xpt data.
-
Replicate API Data to Multiple Databases
Replicate API data to disparate databases with a point-and-click configuration.
-
Bind Live SuiteCRM Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SuiteCRM data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Getting Started with the CData Tableau Connector for Mailjet
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Query Egnyte Data as a SQL Server Database in Node.js
Execute SQL Server queries against Egnyte data from Node.js.
-
Use the CData Software ODBC Driver for Placid in MicroStrategy
Connect to Placid data in MicroStrategy Developer using the CData Software ODBC Driver for Placid.
-
Working with Act CRM Data in LINQPad
Execute LINQ queries to Act CRM data in LINQPad.
-
Integrate Anaplan Data into Power Automate Desktop using CData Connect
CData Connect for Anaplan Data enables you to integrate Anaplan data into workflows built using Microsoft Power Automate Desktop.
-
How to publish and share SharePoint Data dashboards with Tableau Server
The CData ODBC driver for SharePoint enables you integrate SharePoint data into Tableau dashboards.
-
DataBind Controls to ClickUp Data in Delphi
DataBind to ClickUp data in Delphi with standard data access components and controls.
-
Build AI/ML Models with Live Twitter Ads Data using Dataiku
Connect Twitter Ads Data with Dataiku using the CData JDBC Driver for Twitter Ads.
-
Automated Continuous Oracle Sales Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Oracle Sales replication to AlloyDB.
-
How to Query Zoho Creator Data in MySQL Workbench
Execute MySQL queries against live Zoho Creator data from MySQL Workbench.
-
Integrate Freshservice Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Freshservice data and integrate live Freshservice data into your Power Automate tasks.
-
Connect to DocuSign Data in Google Apps Script via Connect AI
Use CData Connect AI to access DocuSign data in Google Apps Script.
-
Establish a Live Connection with MYOB AccountRight Data using Tableau Bridge
The CData ODBC Driver for MYOB AccountRight enables you to integrate live MYOB AccountRight data into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Microsoft Planner Data in TIBCO Spotfire through ADO.NET
Integrate Microsoft Planner data into dashboards in TIBCO Spotfire.
-
Model, Search, and Visualize Live Amazon Athena Data in ThoughtSpot
Use CData Connect AI to connect to live Amazon Athena data for modeling, searching, and visualizing.
-
Integrate Real-Time Access to Jira in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Jira data in real time.
-
How to Connect to & Open Todoist Data in Microsoft Excel
This article uses the CData ODBC driver for Todoist to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use Databricks Agent Bricks to Talk to Your MongoDB Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your MongoDB data for you.
-
Connect to HDFS Data from PowerBuilder via JDBC
This article demonstrates how to access HDFS data from PowerBuilder using the HDFS JDBC Driver.
-
Integrate with live Paylocity Data in Jitterbit
Use CData Connect AI to connect to and integrate live Paylocity data in Jitterbit.
-
Connect to Shippo from Asprova with CData Software ODBC Driver for Shippo
This article shows how to connect faster to Shippo data from Asprova.
-
How to Connect TaxJar Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live TaxJar data in real time using natural language.
-
Prepare, Blend, and Analyze Supabase Data in Alteryx Designer (Connect AI)
Build workflows to access live Supabase data for self-service data analytics.
-
Automated Continuous Shippo Replication to Snowflake
Use CData Sync for automated, continuous, customizable Shippo replication to Snowflake.
-
Connect to Microsoft OneDrive Data in DBArtisan
Use wizards in DBArtisan to configure Microsoft OneDrive data as a data source.
-
ETL Salesloft in Oracle Data Integrator
This article shows how to transfer Salesloft data into a data warehouse using Oracle Data Integrator.
-
Integrate LibreChat with Live SAP SuccessFactors Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SAP SuccessFactors data from within the chat interface.
-
Connect to Monday.com Data in Jaspersoft Studio
Execute SQL to remote Monday.com data in Jaspersoft Studio.
-
Integrate Live Kintone Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Kintone data from within the IDE.
-
Automated Continuous Coinbase Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Coinbase replication to AlloyDB.
-
How to connect SharePoint with Avalara AvaTax Data through external lists
Provide Avalara AvaTax data to SharePoint users as an external list.
-
Connect to Discourse Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Discourse data in the Denodo Virtual DataPort Administrator.
-
Using the CData Software ODBC Driver for Wistia in PyCharm
Connect to Wistia as an ODBC data source in PyCharm using the CData Software ODBC Driver for Wistia.
-
Query Dotmailer Data in DataGrip
Create a Data Source for Dotmailer in DataGrip and use SQL to query live Dotmailer data.
-
Integrate with Rebilly Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Rebilly data to a JSON file on disk.
-
How to Access Calendly Data Using Entity Framework
This article shows how to access Calendly data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Sage 200 Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Sage 200 data in Airbyte.
-
Extract, Transform, and Load Jodoo Data in Informatica PowerCenter
Create a simple Workflow for Jodoo data in Informatica PowerCenter.
-
Use the CData Software JDBC Driver for Brex in MicroStrategy Desktop
Connect to Brex data in MicroStrategy Desktop using the CData Software JDBC Driver for Brex.
-
Build Dashboards with Office 365 Data in DBxtra
Create dynamic dashboards and perform analytics based on Office 365 data in DBxtra.
-
Integrating Codex with Wrike 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.
-
Automated Continuous CampaignMonitor Replication to SingleStore
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to SingleStore.
-
Automate Freshservice Data Replication to SAP HANA
Use CData Sync to customize and automate Freshservice data replication to SAP HANA.
-
Integrate Exa Data into Power Automate Desktop using CData Connect
CData Connect for Exa Data enables you to integrate Exa data into workflows built using Microsoft Power Automate Desktop.
-
Access Live Samanage Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Samanage data from your Excel spreadsheets.
-
Integrate Dify with Live Adobe Commerce Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Adobe Commerce data.
-
A PostgreSQL Interface for CouchDB Data (MySQL Remoting via JDBC)
Use the Remoting features of the CouchDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Viewing HBase Data in RAD Studio Data Explorer
How to view HBase data in RAD Studio Data Explorer using the CData ODBC Driver for HBase.
-
Integrate Theia IDE with Live Aweber 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 Aweber data from within the development environment.
-
Easily Integrate Salesforce Pardot Data in Lazarus Pascal IDE
Learn how to easily integrate live Salesforce Pardot data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Real-Time Access to Kintone in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Kintone data in real time.
-
Access Vault CRM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Vault CRM data from HeidiSQL.
-
Access Live Cvent Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Cvent data from your Google Sheets.
-
Choosing the Best Method to Connect FormSite to SQL Server: 5 Options Explained
Discover multiple ways to connect and use FormSite data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Cline with Live Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Oracle Financials Cloud data from within your IDE.
-
Build Semantic Layer Views for FormSite Data in APOS Live Data Gateway
Use the CData Connector for FormSite in APOS Live Data Gateway to build Semantic Layer Views for FormSite data.
-
Choosing the Best Method to Connect Stack Exchange to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Stack Exchange data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect to Egnyte Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Egnyte data. Leverage the pyodbc module for ODBC in Python.
-
Build Dashboards with JotForm Data in Dundas BI
Create dynamic dashboards and perform analytics based on JotForm data in Dundas BI.
-
Manage Highrise Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Highrise.
-
LINQ to Google Sheets 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 Google Sheets Data Provider.