CData Software - Knowledge Base
Recent Articles
-
Access Live Salesloft in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Salesloft into the statistical analysis tools available in SAS JMP. This article shows how to use Salesloft in the Graph Builder and Query Builder.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ADP
Provide connectivity to ADP through an SAP BusinessObjects universe.
-
Connect to SingleStore in SpagoBI
Create reports featuring live SingleStore in SpagoBI Studio. Host SingleStore reports on SpagoBI Server.
-
Create EnterpriseDB Dataflows on PowerBI.com
Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
-
Edit and Search External Azure Data Lake Storage Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Azure Data Lake Storage to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Azure Data Lake Storage objects that you can access from apps and the dashboard.
-
Enable the OData JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with OData.
-
Connecting Mastra with Databricks 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 data across hundreds of enterprise sources no replication required.
-
Access Live Oracle Sales Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Oracle Sales data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Visualize Microsoft Exchange in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Microsoft Exchange into TIBCO Spotfire.
-
How to Connect to Live Impala 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 Apache Impala for you.
-
Use Dash to Build to Web Apps on Workday
Create Python applications that use pandas and Dash to build Workday-connected web apps.
-
How to Access Microsoft Dataverse Using Entity Framework
This article shows how to access Microsoft Dataverse (CDS) using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Zoho CRM Reporting in OBIEE with the Zoho CRM JDBC Driver
Deploy the Zoho CRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to integrate Metabase with API
Use CData Connect AI to connect to live API and create an interactive dashboard in Metabase from API.
-
Create Jira Service Management-Connected Nintex Workflows
Use CData Connect AI to connect to Jira Service Management from Nintex Workflow Cloud and build custom workflows using live Atlassian Jira Service Management.
-
Use the CData Software ODBC Driver for OneNote in MicroStrategy Desktop
Connect to Microsoft OneNote in MicroStrategy Desktop using the CData Software ODBC Driver for OneNote.
-
Query RSS Feeds from Node.js
Use the OData endpoint of the CData API Server to connect to your RSS Feeds and perform CRUD operations on RSS from Node.js.
-
Use Biml to Build SSIS Tasks to Replicate JSON Services to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate JSON to SQL Server.
-
Connect/Disconnect the QuickBooks Online Products
In this entry you will learn to use the CData Excel Add-In for QuickBooks Online or the CData Sync Application for QuickBooks Online to connect to or disconnect from your QuickBooks Online data.
-
Connect to Exact Online in HULFT Integrate
Connect to Exact Online as a JDBC data source in HULFT Integrate
-
How to Query Live Asana Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Asana data in natural language using Python.
-
How to Build an ETL App for Amazon DynamoDB in Python with CData
Create ETL applications and real-time data pipelines for Amazon DynamoDB in Python with petl.
-
Integrate Microsoft Planner in Pentaho Data Integration
Build ETL pipelines based on Microsoft Planner in the Pentaho Data Integration tool.
-
A PostgreSQL Interface for Office 365 (MySQL Remoting via JDBC)
Use the Remoting features of the Office 365 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData API Server to Access WordPress in Microsoft PowerPivot
Use the CData API Server to connect to live WordPress in the Power Pivot business intelligence tool.
-
Design BIRT Reports on ShipStation
Provide current ShipStation to your embedded analytics.
-
How to Visualize ServiceNow Data in Python with pandas
Use pandas and other modules to analyze and visualize live ServiceNow in Python.
-
Build Data Flows from SQL Server to Google Spanner through SSIS
Easily push SQL Server data to Google Spanner using the CData SSIS Tasks for Google Spanner.
-
Import Real-Time Google Campaign Manager 360 via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Campaign Manager 360 in ColdFusion.
-
Access Live Google Data Catalog Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Google Data Catalog data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Access Live SAS xpt in AWS Lambda (with IntelliJ IDEA)
Connect to live SAS XPORT in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Oracle Service Cloud
Provide connectivity to Oracle Service Cloud through an SAP BusinessObjects universe.
-
Build ADP-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to ADP from Zoho Analytics and import live ADP.
-
Xero Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Xero facts in real time.
-
Automated Continuous Unbounce Replication to SQLite
Use CData Sync for automated, continuous, customizable Unbounce replication to SQLite.
-
Integrate Cursor with Live Reckon Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Reckon from within the editor.
-
Connect to eBay Analytics as an External Source in Dremio
Use the CData JDBC Driver to connect to eBay Analytics as an External Source in Dremio.
-
Automated Continuous Act CRM Replication to Snowflake
Use CData Sync for automated, continuous, customizable Act CRM replication to Snowflake.
-
How to create Visio diagrams from Acumatica
Automatically update Acumatica ERP with the changes you make to Visio master shapes.
-
Integrate with GitHub in JReport Designer
Create charts and reports based on GitHub in JReport Designer.
-
How to Query Live Cloudant in Claude Desktop
Connect to and query live Cloudant in Claude Desktop using CData Code Assist MCP.
-
Integrate with Microsoft Planner using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft Planner to a JSON file on disk.
-
Natively Connect to Adobe Experience Manager in PHP
The CData ODBC driver for Adobe Experience Manager enables you to create PHP applications with connectivity to Adobe Experience Manager. Leverage the native support for ODBC in PHP.
-
How to Connect DBeaver to Oracle via a JDBC Driver
Manage Oracle Database with visual tools in DBeaver like the query browser.
-
Extract, Transform, and Load Sugar CRM in Informatica PowerCenter
Create a simple Workflow for Sugar CRM in Informatica PowerCenter.
-
Working with Dynamics NAV in LINQPad
Execute LINQ queries to Microsoft Dynamics NAV in LINQPad.
-
Automated Continuous Microsoft Project Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Microsoft Project replication to Google Cloud SQL.
-
Access Zoho Inventory from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Zoho Inventory from HeidiSQL.
-
Integrate Oracle Sales into Power Automate Desktop using CData Connect
CData Connect for Oracle Sales enables you to integrate Oracle Sales into workflows built using Microsoft Power Automate Desktop.
-
How to Access Live Couchbase in Power Automate Desktop via ODBC
The CData ODBC Driver for Couchbase enables you to integrate Couchbase into workflows built using Microsoft Power Automate Desktop.
-
Build Act-On-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Act-On from Zoho Analytics and import live Act-On.
-
Build a Singer.io Tap for Parquet With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Parquet data using
-
Microsoft OneDrive Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Microsoft OneDrive facts in real time.
-
Build Dashboards with Jira Assets in Dundas BI
Create dynamic dashboards and perform analytics based on Jira Assets in Dundas BI.
-
Connect Kintone to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Kintone using the CData Python MCP Server.
-
Extend Google Sheets with YouTube Analytics
Make calls to the API Server from Google Apps Script.
-
Automated Continuous IBM Informix Replication to Vertica
Use CData Sync for automated, continuous, customizable IBM Informix replication to Vertica.
-
Migrating data from Azure Active Directory to Snowflake using CData SSIS Components.
Easily push Azure Active Directory to Snowflake using the CData SSIS Tasks for Azure Active Directory and Snowflake.
-
Connect to Email in DBArtisan
Use wizards in DBArtisan to configure Email as a data source.
-
Connect to Act CRM from HeidiSQL
Use CData Connect AI to connect to and query live Act CRM from HeidiSQL.
-
Automated Continuous Phoenix Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Phoenix replication to Azure SQL Database.
-
How to connect to Sage Intacct in DBVisualizer
Integrate Sage Intacct with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect to Google Ads in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Ads. Leverage the pyodbc module for ODBC in Python.
-
Design BIRT Reports on Vault CRM
Provide current Veeva Vault & Vault CRM to your embedded analytics.
-
Enable the SAP Fieldglass JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP Fieldglass.
-
Use Manus AI to Talk to Your Microsoft Exchange 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 Microsoft Exchange.
-
Explore Geographical Relationships in Marketo with Power Map
Create data visualizations with Marketo in Power Map.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live GraphQL within intelligent workflows.
-
Create Power BI Reports on Real-Time Act CRM
Use the CData ODBC Driver for Act CRM to visualize Act CRM in Power BI Desktop.
-
Create Datasets from Airtable in Domo Workbench and Build Visualizations of Airtable in Domo
Use the CData Software ODBC Driver for Airtable to create datasets from Airtable in Domo Workbench and then build visualizations in the Domo service.
-
Use Azure AI Foundry to Talk to Your Marketo via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Marketo for you.
-
Create Reports with Office 365 in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Office 365.
-
Create Dynamic GitHub Grids Using the Infragistics XamDataGrid
Learn how you can connect GitHub to Infragistics XamDataGrid to build dynamic grids.
-
Building Dynamic Web Pages with Aha! Using AngularJS
Create single-page applications with live connectivity to Aha! using the CData API Server.
-
How to work with SingleStore in Apache Spark using SQL
Access and process SingleStore in Apache Spark using the CData Software JDBC Driver.
-
Analyze MailChimp in Infragistics Reveal
Use CData Connect AI to create on OData API on top of MailChimp and visualize live MailChimp in Infragistics Reveal.
-
Use JayDeBeApi to access JotForm in Python
Use standard Python scripting and the development environment of your choice to access live JotForm.
-
Build Dashboards with Teradata in Dundas BI
Create dynamic dashboards and perform analytics based on Teradata in Dundas BI.
-
Build Azure Data Lake Storage-Powered Applications in GitHub Copilot with CData Code Assist MCP
-