CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Adobe Analytics Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to Apache Kafka.
-
Connect to and Visualize Live Amazon S3 in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Amazon S3.
-
Connect to Slack in RapidMiner
Integrate Slack with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Dynamic Epicor Kinetic Grids Using the Infragistics XamDataGrid
Learn how you can connect Epicor Kinetic to Infragistics XamDataGrid to build dynamic grids.
-
Build Dashboards with MYOB AccountRight in Dundas BI
Create dynamic dashboards and perform analytics based on MYOB AccountRight in Dundas BI.
-
Import LinkedIn Ads into the Power BI Service for Visualizations
Use CData Connect AI to connect to LinkedIn Ads and provide access to live LinkedIn Ads for custom reports in the Power BI Service.
-
Connect to AlloyDB from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google AlloyDB using standard SQL.
-
Connect to Acumatica in CloverDX (formerly CloverETL)
Transfer Acumatica ERP using the visual workflow in the CloverDX data integration tool.
-
DataBind Presto to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Presto with the DevExpress Windows Forms and Web controls to provide Presto to a chart.
-
Create Reports with Raisers Edge NXT in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Raisers Edge NXT.
-
Build a Simple VCL Application for REST
How to build a simple VCL Application to view REST in RAD Studio using the CData ODBC Driver for REST.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Shopify within intelligent workflows.
-
How to import Phoenix into Apache Solr
Use the CData Software JDBC Driver for Phoenix in Data Import Handler and create an automated import of Apache Phoenix to Apache Solr Enterprise Search platform.
-
Replicate Multiple Bullhorn CRM Accounts
Replicate multiple Bullhorn CRM accounts to one or many databases.
-
Analyze REST with Power Pivot
This article walks you through the process of using the CData ODBC Driver for REST from Power Pivot. You will use the Table Import Wizard to load REST. You can visually build the import query or use any SQL supported by the driver.
-
How to create Visio diagrams from Xero
Automatically update Xero Accounting with the changes you make to Visio master shapes.
-
Manage Redis in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Redis.
-
Access Live Oracle Service Cloud in Excel 365 Online (Excel for the web)
Connect to Oracle Service Cloud from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create HarperDB Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time HarperDB data access from reports, embedded analytics, and more.
-
DataBind Controls to Workday in Delphi
DataBind to Workday in Delphi with standard data access components and controls.
-
How to connect and process Teradata from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Teradata.
-
Query MySQL from Node.js
Use the OData endpoint of the CData API Server to connect to your MySQL and perform CRUD operations on MySQL from Node.js.
-
How to pipe Marketo to CSV in PowerShell
Use standard PowerShell cmdlets to access Marketo tables.
-
How to Connect Flowise AI Agents to Live Microsoft Planner via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
Deploy the ADO.NET Provider for Google Calendar on an SSRS Report Server
Connect to Google Calendar 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.
-
Integrating Claude Code with Freshdesk via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Freshdesk within assisted coding and automated development workflows.
-
Access Live Odoo in Excel 365 Online (Excel for the web)
Connect to Odoo ERP from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Design Act-On Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Use the CData Software JDBC Driver for Phoenix in MicroStrategy Web
Connect to Apache Phoenix in MicroStrategy Web using the CData Software JDBC Driver for Phoenix.
-
Integrate Azure Synapse with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Azure Synapse with External Services.
-
Provide OData Services of Calendly from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Calendly by developing a WCF Service Application.
-
Use the CData Software ODBC Driver for Invoiced in MicroStrategy Web
Connect to Invoiced in MicroStrategy Web using the CData Software ODBC Driver for Invoiced.
-
Access Live Sybase IQ in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Sybase IQ into the statistical analysis tools available in SAS JMP. This article shows how to use Sybase IQ in the Graph Builder and Query Builder.
-
Access Live WooCommerce Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live WooCommerce data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Visualize Cosmos DB Data in Python with pandas
Use pandas and other modules to analyze and visualize live Azure Cosmos DB in Python.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live MYOB AccountRight using the Model Context Protocol.
-
Automated Continuous ConstantContact Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ConstantContact replication to OneLake in Microsoft Fabric.
-
Build Data Flows from TaxJar to SQL Server using SSIS
Easily back up TaxJar to SQL Server using the SSIS components for TaxJar.
-
Replicate Multiple Oracle Financials Cloud Accounts via the CData Sync CLI
Replicate multiple Oracle Financials Cloud accounts to one or many databases.
-
Import Real-Time PostgreSQL via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use PostgreSQL in ColdFusion.
-
Building Dynamic Web Pages with Wave Financial Using AngularJS
Create single-page applications with live connectivity to Wave Financial using the CData API Server.
-
Import BambooHR into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access BambooHR. In this article, you will use the OData format to import BambooHR into Microsoft Power Query.
-
How to connect PolyBase to Square
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Square.
-
Analyze Zoho Creator in Infragistics Reveal
Use the CData API Server to create an OData API on top of Zoho Creator and visualize live Zoho Creator in Infragistics Reveal.
-
Connect to and Query Outreach.io in QlikView over ODBC
Create data visualizations with Outreach.io in QlikView.
-
How to Query Live OneNote in Claude Desktop
Connect to and query live OneNote in Claude Desktop using the CData MCP Server.
-
Operational Reporting on SAP BusinessObjects BI from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP BusinessObjects BI.
-
Automated Continuous Phoenix Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Apache Phoenix replication to OneLake in Microsoft Fabric.
-
Use the CData Software ODBC Driver for Box in MicroStrategy Desktop
Connect to Box in MicroStrategy Desktop using the CData Software ODBC Driver for Box.
-
Automated Continuous SAP Concur Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP Concur replication to Vertica.
-
Excel Spreadsheet Automation on Reckon Accounts Hosted with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Connect SAP Ariba Procurement to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP Ariba Procurement with IBM WebSphere for seamless data integration and connectivity.
-
How to integrate Metabase with Airtable
Use CData Connect AI to connect to live Airtable and create an interactive dashboard in Metabase from Airtable.
-
xBase Reporting in OBIEE with the xBase JDBC Driver
Deploy the xBase JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Live Oracle Eloqua in AWS Lambda (with IntelliJ IDEA)
Connect to live Oracle Eloqua in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Square as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Square.
-
How to Work with HCL Domino in ETL Validator JDBC
Connect to HCL Domino from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Zoom from Asprova with CData Software ODBC Driver for Zoom
This article shows how to connect faster to Zoom data from Asprova.
-
Query Email in DataGrip
Create a Data Source for Email in DataGrip and use SQL to query live Email.
-
Migrating data from IBM Cloud Object Storage to Google BigQuery using CData SSIS Components.
Easily push IBM Cloud Object Storage to Google BigQuery using the CData SSIS Tasks for IBM Cloud Object Storage and Google BigQuery.
-
Connect to Sage 300 from Asprova with CData Software ODBC Driver for Sage 300
This article shows how to connect faster to Sage 300 data from Asprova.
-
Connect to Real-Time Monday.com Data in Power Apps Using Dataflows to Build Custom Applications
-