CData Software - Knowledge Base
Recent Articles
-
Create Dynamic Stripe Grids Using the Infragistics XamDataGrid
Learn how you can connect Stripe to Infragistics XamDataGrid to build dynamic grids.
-
How to connect to Slack Data from IntelliJ
Integrate connectivity to Slack with wizards in IntelliJ.
-
Connect to Amazon DynamoDB Data in Aqua Data Studio
Access Amazon DynamoDB from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Live Demio Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Demio into the statistical analysis tools available in SAS JMP. This article shows how to use Demio in the Graph Builder and Query Builder.
-
Connecting Moonlit Workflow with Gong 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 Gong in real time.
-
Connect to Datadog Data in Aqua Data Studio
Access Datadog from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Bannerbear Replication to Vertica
Use CData Sync for automated, continuous, customizable Bannerbear replication to Vertica.
-
Visualize Omnisend Data in Sisense
Create an ElastiCube in Sisense app with access to Omnisend.
-
Use the CData API Server to Access Dynamics 365 Business Central Data in Microsoft PowerPivot
Use the CData API Server to connect to live Dynamics 365 Business Central in the Power Pivot business intelligence tool.
-
Connect to AgileCRM Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to AgileCRM and work with AgileCRM in your FileMaker application.
-
Connect to Neo4J Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Neo4J and the Script function in FileMaker Pro to connect to Neo4J and work with Neo4J in your FileMaker application.
-
Consume Google Analytics OData Feeds in PowerBuilder
This article demonstrates how to consume Google Analytics as OData feeds from PowerBuilder using the API Server.
-
Automated Continuous Bullhorn CRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to Amazon Redshift.
-
How to Query Live ZohoSubscriptions Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ZohoSubscriptions data in natural language using Python.
-
Automated Continuous EmailOctopus Replication to MySQL
Use CData Sync for automated, continuous, customizable EmailOctopus replication to MySQL.
-
Use the CData Software ODBC Driver for Zuora in MicroStrategy Desktop
Connect to Zuora in MicroStrategy Desktop using the CData Software ODBC Driver for Zuora.
-
Seamlessly Bring Azure Analysis Services Data into Retool Using CData Connect AI
Integrate Azure Analysis Services data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Excel Spreadsheet Automation on Presto Data with the QUERY Formula
Pull data from Presto, automate spreadsheets, and more with the QUERY formula.
-
Use Biml to Build SSIS Tasks to Replicate JotForm Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate JotForm to SQL Server.
-
How to Connect to Live Oracle Sales 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 Oracle Sales for you.
-
Connect to and Query Pipeline CRM Data in QlikView over ODBC
Create data visualizations with Pipeline CRM in QlikView.
-
Build Pipelines with Live ActiveCampaign Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to ActiveCampaign from Google Cloud Data Fusion, enabling the integration of live ActiveCampaign into the building and management of effective data pipelines.
-
Build Automated Active Directory-Connected Workflows in Zapier
Use CData Connect AI to connect to live Active Directory and build automated workflows in Zapier.
-
Build Box-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Box to explore live Box Data in GitHub Copilot to assist with building Box-powered applications.
-
Build Dropbox-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Dropbox and build Dropbox-connected web apps with Axios.
-
LINQ to ChartMogul 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 ChartMogul Data Provider.
-
How to load Freshdesk data into Elasticsearch via Logstash
Introducing a simple method to load Freshdesk data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Prepare, Blend, and Analyze EnterpriseDB Data in Alteryx Designer (Connect AI)
Build workflows to access live EnterpriseDB for self-service data analytics.
-
Integrating OpenCode Terminal with ShipEngine 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.
-
Migrating data from ChargeOver to Snowflake using CData SSIS Components.
Easily push ChargeOver to Snowflake using the CData SSIS Tasks for ChargeOver and Snowflake.
-
Automated Continuous Drift Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Drift replication to AlloyDB.
-
Automated Continuous Power BI XMLA Replication to SQL Server
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to SQL Server.
-
Visualize SAP Data in TIBCO Spotfire through OData
Integrate SAP ERP/NetWeaver into dashboards in TIBCO Spotfire.
-
Import Real-Time BigQuery Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google BigQuery in ColdFusion.
-
How to use SQLAlchemy ORM to access Adobe Target Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Adobe Target.
-
Query Power BI XMLA Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Power BI XMLA and perform CRUD operations on Power BI XMLA from Node.js.
-
Use the CData Software JDBC Driver for Apify in MicroStrategy Desktop
Connect to Apify in MicroStrategy Desktop using the CData Software JDBC Driver for Apify.
-
Design BIRT Reports on WordPress Data
Provide current WordPress to your embedded analytics.
-
Publish Salesforce Marketing-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Salesforce Marketing Cloud.
-
Query Anaplan Data in ColdFusion
Write standard ColdFusion data access code to connect to Anaplan.
-
Replicate Klipfolio Data in Heroku for Use in Salesforce Connect
Replicate Klipfolio to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Pinecone-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Pinecone.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Microsoft Dynamics 365 within intelligent workflows.
-
Visualize Chargebee Data in TIBCO Spotfire through ADO.NET
Integrate Chargebee into dashboards in TIBCO Spotfire.
-
Access Live Google Drive 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 Google Drive through MCP integration.
-
Connect MarkLogic Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your MarkLogic using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Visualize NASA Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load NASA into TIBCO Spotfire.
-
Connect to Placid Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Placid to connect to Placid and execute queries in PowerBuilder.
-
Integrate Jira Assets Data in the Pentaho Report Designer
Publish reports based on Jira Assets in the Pentaho BI tool.
-
Import Real-Time eBay Analytics Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use eBay Analytics in ColdFusion.
-
How to Connect Flowise AI Agents to Live Cvent Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Cvent without replication.
-
Access Live Clio Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Clio in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous YouTube Analytics Replication to Vertica
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Vertica.
-
Automated Continuous Autopilot Replication to Oracle
Use CData Sync for automated, continuous, customizable Autopilot replication to Oracle.
-
Analyze Oracle Eloqua Data in Looker
Use CData Connect AI to connect to Oracle Eloqua Data from Looker and build custom apps using live Oracle Eloqua.
-
Visualize PayPal Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to PayPal.
-
Build MVC Applications with Connectivity to Google Directory Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Directory from an ASP.NET MVC application.
-
Create Reports from Microsoft Dataverse Data in Looker Studio
Use CData Connect AI to gain access to live Microsoft Dataverse (CDS) and create custom reports in Looker Studio.
-
Connect to Sage 200 Data in JRuby
Create a simple JRuby app with access to live Sage 200.
-
Access Live Figshare Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Figshare in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to connect PolyBase to Freshteam
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Freshteam.
-
Build Apps with Live Zoho CRM Data Using the Low-Code Development Platform of Mendix
Connect Zoho CRM with Mendix to build apps using the CData JDBC Driver for Zoho CRM.
-
Connect WordPress to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect WordPress with IBM WebSphere for seamless data integration and connectivity.
-
Connect to PagerDuty Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for PagerDuty in the Denodo Virtual DataPort Administrator.
-
Replicate Multiple OneNote Accounts
Replicate multiple OneNote accounts to one or many databases.
-
How to Query Google Cloud Storage Data in MySQL Workbench
Execute MySQL queries against live Google Cloud Storage from MySQL Workbench.
-
Connect to Zoho Projects Data in DBeaver
Use the CData ODBC Driver to connect to Zoho Projects in DBeaver.
-
Explore Geographical Relationships in Mode Data with Power Map
Create data visualizations with Mode in Power Map.
-
Feed Miro Data into FineReport
How to set Miro as a JDBC data source in FineReport.
-
How to Access Xero Data Using Entity Framework
This article shows how to access Xero Accounting using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Tickspot from a Connection Pool in WebLogic
Use the CData JDBC Driver for Tickspot to connect to Tickspot from Web applications running on WebLogic.
-
How to connect PolyBase to iContact
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live iContact.
-
Automate Pipeline CRM Data Replication to Azure Synapse
Use CData Sync to customize and automate Pipeline CRM replication to Azure Synapse.
-
Work with Clari Data in FoxPro
Load Clari into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Exa Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Exa replication to delimited files (CSV/TSV).
-
Import Real-Time Sage 300 Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Sage 300 in ColdFusion.
-
Import Real-Time SAS Data Sets Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAS Data Sets in ColdFusion.
-
Working with Asana Data in LINQPad
Execute LINQ queries to Asana in LINQPad.
-
Write a Simple Go Application to work with Miro Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Miro.
-
Use the CData Software ODBC Driver for Qualaroo in MicroStrategy Web
Connect to Qualaroo in MicroStrategy Web using the CData Software ODBC Driver for Qualaroo.
-
Query Live Adobe Commerce 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 Adobe Commerce directly from the development environment.
-
Integrating Oracle Financials Cloud Data in Talend Cloud Data Management Platform
Connect Oracle Financials Cloud Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Oracle Financials Cloud.
-
Create Dynamics CRM Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Dynamics CRM data access from reports, embedded analytics, and more.
-
Connect to Office 365 Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Office 365.
-
Create HBase-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to HBase Data from Klipfolio and build custom visualizations using live Apache HBase.
-
Access Clari Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Clari from your Oracle system.
-
Access Live Coinbase Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Coinbase in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build a Singer.io Tap for BigQuery With the CData Python Connector
Learn how to easily build a Singer.io Tap for live BigQuery data using
-
Build MVC Applications with Connectivity to Oracle Eloqua Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Oracle Eloqua from an ASP.NET MVC application.
-
Use the CData ODBC Driver for Gorgias in Microsoft Power Query
You can use the CData Gorgias ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Gorgias into Microsoft Power Query.
-
Automated Continuous Apify Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Apify replication to AlloyDB.
-
How to connect and process Atlassian Confluence from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Atlassian Confluence.
-
Model, Search, and Visualize Live Microsoft Planner Data in ThoughtSpot
Use CData Connect AI to connect to live Microsoft Planner for modeling, searching, and visualizing.
-
How to Query SharePoint Data in MySQL Workbench
Execute MySQL queries against live Microsoft SharePoint from MySQL Workbench.
-
Explore Geographical Relationships in Perplexity Data with Power Map
Create data visualizations with Perplexity in Power Map.
-
Integrating Antigravity CLI with Azure Cosmos DB via CData CLI
Connect Azure Cosmos DB to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating Boomi Agentstudio with NetSuite Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to NetSuite CRM & ERP, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Analyze DB2 Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze IBM DB2 in Microsoft R Open.
-
Analyze SingleStore Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SingleStore in Microsoft R Open.
-
Establish a Live Connection with QuickBooks Data using Tableau Bridge
The CData ODBC Driver for QuickBooks enables you to integrate live QuickBooks Desktop into Tableau Cloud dashboards using the Tableau Bridge.