CData Software - Knowledge Base
Recent Articles
-
Create Reports with Pipeliner CRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pipeliner CRM.
-
Build Hive-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Hive Data and create custom apps in Bubble.
-
Build a PostgreSQL Interface for DocuSign Data using the CData JDBC Driver
Use the Remoting features of the DocuSign JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Workday Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Workday with the DevExpress Windows Forms and Web controls to provide Workday to a chart.
-
Build Pipelines with Live Couchbase Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Couchbase from Google Cloud Data Fusion, enabling the integration of live Couchbase into the building and management of effective data pipelines.
-
Create Dynamic Tally Grids Using the Infragistics XamDataGrid
Learn how you can connect Tally to Infragistics XamDataGrid to build dynamic grids.
-
How to Access Mocean Data Using Entity Framework
This article shows how to access Mocean using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to connect to ClickTime Data with Squirrel SQL client
Connect to ClickTime and execute queries in the Squirrel SQL Client.
-
Build AI Agents with Greenhouse 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 Greenhouse through CData Connect AI.
-
Automated Continuous Zoho Projects Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Amazon Redshift.
-
Automate Email Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Email from PowerShell? This article demonstrates how to utilize the Email Cmdlets for tasks like connecting to Email, automating operations, downloading data, and more.
-
Integrate with Front Data in JReport Designer
Create charts and reports based on Front in JReport Designer.
-
Connecting Moonlit Workflow with Databricks Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Databricks in real time.
-
Automate Chargebee Data Replication to Azure Data Lake
Use CData Sync to customize and automate Chargebee replication to Azure Data Lake.
-
Visualize Live Salesforce Marketing Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Salesforce Marketing Cloud.
-
Query SAP Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SAP ERP/NetWeaver and perform CRUD operations on SAP from Node.js.
-
Viewing Vault CRM Data in RAD Studio Data Explorer
How to view Veeva Vault & Vault CRM in RAD Studio Data Explorer using the CData ODBC Driver for Vault CRM.
-
Automated Continuous Keap Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Keap replication to IBM DB2.
-
Build Data Flows from SQL Server to Marketo through SSIS
Easily push SQL Server data to Marketo using the CData SSIS Tasks for Marketo.
-
How to connect and process SAP ERP/NetWeaver from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP ERP/NetWeaver.
-
Automate ConstantContact Data Replication to Azure Synapse
Use CData Sync to customize and automate ConstantContact replication to Azure Synapse.
-
Integrating Cursor CLI with Microsoft Entra ID 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.
-
Use the CData Software ODBC Driver for Xero in MicroStrategy
Connect to Xero Accounting in MicroStrategy Developer using the CData Software ODBC Driver for Xero.
-
Connect to AdRoll Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for AdRoll in the Denodo Virtual DataPort Administrator.
-
Query Insightly Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Insightly from Node.js.
-
Automated Paymo Data Replication to Teradata
Use CData Sync to Customize and automate Paymo replication to Teradata.
-
Connect to Zoho Creator Data in Aqua Data Studio
Access Zoho Creator from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Import Real-Time Quaderno Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Quaderno in ColdFusion.
-
Automated Continuous Billsby Replication to Oracle
Use CData Sync for automated, continuous, customizable Billsby replication to Oracle.
-
Build Bullhorn CRM Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Bullhorn CRM and build visualizations in Tableau.
-
DataBind Controls to Pinterest Data in Delphi
DataBind to Pinterest in Delphi with standard data access components and controls.
-
Connect to Oracle Financials Cloud Data in RazorSQL
Connect to Oracle Financials Cloud from wizards and query Oracle Financials Cloud from the GUI in the RazorSQL database management tool.
-
Write a Simple Go Application to work with MariaDB Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to MariaDB.
-
Use Microsoft Copilot Studio to talk to your Google Directory Data 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 Google Directory for you.
-
How to import Avaza Data into Apache Solr
Use the CData Software JDBC Driver for Avaza in Data Import Handler and create an automated import of Avaza to Apache Solr Enterprise Search platform.
-
How to Connect DBeaver to Sentry via a JDBC Driver
Manage Sentry with visual tools in DBeaver like the query browser.
-
Connect to Phoenix from a Connection Pool in WebLogic
Use the CData JDBC Driver for Phoenix to connect to Apache Phoenix from Web applications running on WebLogic.
-
Excel Spreadsheet Automation on Twitter Ads Data with the QUERY Formula
Pull data from Twitter Ads, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous ZohoInvoice Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to Google Cloud SQL.
-
Connect to Pipedrive Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Pipedrive in Airbyte.
-
Connect Mistral AI to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Mistral AI using the CData Python MCP Server.
-
Use the CData ODBC Driver for Snowflake in Microsoft Power Query
You can use the CData Snowflake ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Snowflake into Microsoft Power Query.
-
Seamlessly Bring Dropbox Data into Retool Using CData Connect AI
Integrate Dropbox data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Access Live Jira Assets Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Jira Assets enables you to integrate Jira Assets into workflows built using Microsoft Power Automate Desktop.
-
Build Semantic Layer Views for Vimeo Data in APOS Live Data Gateway
Use the CData Connector for Vimeo in APOS Live Data Gateway to build Semantic Layer Views for Vimeo.
-
Use the CData Software ODBC Driver for SAP Fieldglass in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP Fieldglass in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP Fieldglass.
-
Connect to Zoho Inventory Data in NetBeans
Connect to Zoho Inventory in NetBeans with the data source configuration wizard.
-
Build Apps with Live Google Tasks Data Using the Low-Code Development Platform of Mendix
Connect Google Tasks with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to SAP Fieldglass from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP Fieldglass, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Access Live Quickbase Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Quickbase data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Query Shortcut Data in DataGrip
Create a Data Source for Shortcut in DataGrip and use SQL to query live Shortcut.
-
Extract, Transform, and Load Outreach.io Data in Informatica PowerCenter
Create a simple Workflow for Outreach.io in Informatica PowerCenter.
-
Create Dashboards and Visualize Live Salesforce Pardot Data in Geckoboard
Use CData Connect AI to connect to live Salesforce Pardot and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build NetSuite-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for NetSuite to explore live NetSuite Data in Gemini Code Assist to assist with building NetSuite-powered applications.
-
Excel Spreadsheet Automation on PDFMonkey Data with the QUERY Formula
Pull data from PDFMonkey, automate spreadsheets, and more with the QUERY formula.
-
Model, Search, and Visualize Live Vault CRM Data in ThoughtSpot
Use CData Connect AI to connect to live Veeva Vault & Vault CRM for modeling, searching, and visualizing.
-
Use the CData SSIS Components to Insert New or Update Existing Dynamics NAV Records from SQL Server
Easily push SQL Server data to Dynamics NAV using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Dynamics NAV or update existing records with data from a SQL Server database.
-
Build Apps with Live EnterpriseDB Data Using the Low-Code Development Platform of Mendix
Connect EnterpriseDB with Mendix to build apps using the CData JDBC Driver for EnterpriseDB.
-
Connect to PayPal Data from HeidiSQL
Use CData Connect AI to connect to and query live PayPal from HeidiSQL.
-
Automate Spark Data Replication to SAP HANA
Use CData Sync to customize and automate Apache Spark SQL replication to SAP HANA.
-
How to Connect the Power BI Service to CircleCI: Complete Guide
Connect to the CData Software Power BI Connector for CircleCI from PowerBI.com to provide real-time CircleCI across the organization.
-
How to Work with Discourse Data in ETL Validator JDBC
Connect to Discourse from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Query Phoenix Data in MySQL Workbench
Execute MySQL queries against live Apache Phoenix from MySQL Workbench.
-
DataBind Controls to Facebook Ads Data in Delphi
DataBind to Facebook Ads in Delphi with standard data access components and controls.
-
Deploy the ADO.NET Provider for Productboard on an SSRS Report Server
Connect to Productboard 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.
-
Connect to Procore Data from PowerBuilder via JDBC
This article demonstrates how to access Procore from PowerBuilder using the Procore JDBC Driver.
-
Integrate Humanity with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Humanity with External Services.
-
Use Claude to Talk to Your SAP ByDesign Data 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.
-
Getting Started with the CData Power BI Connector for QuickBooks
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for QuickBooks.
-
Build Automated Avalara AvaTax-Connected Workflows in Zapier
Use CData Connect AI to connect to live Avalara AvaTax and build automated workflows in Zapier.
-
Automate Helpscout Data Replication to SAP HANA
Use CData Sync to customize and automate Helpscout replication to SAP HANA.
-
Establish a Live Connection with Presto Data using Tableau Bridge
The CData ODBC Driver for Presto enables you to integrate live Presto into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to OpenWeatherMap Data in NetBeans
Connect to OpenWeatherMap in NetBeans with the data source configuration wizard.
-
Connect to Live Sage 200 Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Sage 200 in CData Connect AI and connect to your Sage 200 from PostgreSQL.
-
Visualize Live Pushbullet Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Pushbullet.
-
Build Azure DevOps-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Azure DevOps Data and create custom apps in Mendix.
-
Build Stripe Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Stripe and build visualizations in Tableau Cloud.
-
Access Live Humanity Data in Coginiti Pro
Connect to and query live Humanity from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Query Impala Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Impala entities in PHP by modeling them as objects.
-
Build PayPal-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live PayPal.
-
Automated Continuous Printful Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Printful replication to Google Cloud SQL.
-
How to Access Live Short.io Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Short.io enables you to integrate Short.io into workflows built using Microsoft Power Automate Desktop.
-
Viewing Oracle SCM Data in RAD Studio Data Explorer
How to view Oracle SCM in RAD Studio Data Explorer using the CData ODBC Driver for Oracle SCM.
-
Automated Continuous Azure DevOps Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Google BigQuery.
-
Connect to Reckon Accounts Hosted Data in CloverDX (formerly CloverETL)
Transfer Reckon Accounts Hosted using the visual workflow in the CloverDX data integration tool.
-
Build Dashboards with MarkLogic Data in DBxtra
Create dynamic dashboards and perform analytics based on MarkLogic in DBxtra.
-
Object-Relational Mapping (ORM) with Bannerbear 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 Bannerbear into a Java-based ORM framework, Hibernate.
-
How to Connect to Live SingleStore Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your SingleStore for you.
-
Integrating OpenCode Terminal with Calendly 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.
-
How to Connect to & Open Email Data in Microsoft Excel
This article uses the CData ODBC driver for Email to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Feed PostgreSQL Data into FineReport
How to set PostgreSQL as a JDBC data source in FineReport.
-
Integrate with Trello Data in JReport Designer
Create charts and reports based on Trello in JReport Designer.
-
Connect to Rootly Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Rootly as an External Source in Dremio.
-
Automate Klaviyo Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Klaviyo from PowerShell? This article demonstrates how to utilize the Klaviyo Cmdlets for tasks like connecting to Klaviyo, automating operations, downloading data, and more.
-
Connect to MongoDB from a Connection Pool in WebLogic
Use the CData JDBC Driver for MongoDB to connect to MongoDB from Web applications running on WebLogic.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Presto
Provide connectivity to Presto through an SAP BusinessObjects universe.
-
DataBind LDAP Objects to the DevExpress Data Grid
Use the CData ADO.NET Provider for LDAP with the DevExpress Windows Forms and Web controls to provide LDAP to a chart.
-
How to Work with Google Search Results in ETL Validator JDBC
Connect to Google Search from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect the Power BI Service to Perigon: Complete Guide
Connect to the CData Software Power BI Connector for Perigon from PowerBI.com to provide real-time Perigon across the organization.
-
How to connect PolyBase to REST
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live REST.