CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live Mailgun Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Mailgun data through natural language.
-
Connect to Jira Assets Data in RazorSQL
Connect to Jira Assets from wizards and query Jira Assets data from the GUI in the RazorSQL database management tool.
-
Deploy the ADO.NET Provider for Redshift on an SSRS Report Server
Connect to Redshift data 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.
-
How to Connect to Live WooCommerce 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 WooCommerce data for you.
-
Analyze Perplexity Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Perplexity data with the CData JDBC Driver for Perplexity.
-
How to connect to Stack Exchange Data from IntelliJ
Integrate connectivity to Stack Exchange data with wizards in IntelliJ.
-
How to Easily Query Oracle SCM Data in OpenOffice Base
Connect to Oracle SCM data in OpenOffice Base using the CData ODBC Driver for Oracle SCM and generate reports with live data insights.
-
Integrate Scrapfly with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Scrapfly with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Scrapfly data.
-
Build ServiceNow-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to ServiceNow Data from Zoho Analytics and import live ServiceNow data.
-
Visualize Live Microsoft Entra ID Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft Entra ID data into custom reports in Power BI.
-
Connect to Office 365 Data in RazorSQL
Connect to Office 365 from wizards and query Office 365 data from the GUI in the RazorSQL database management tool.
-
Link Opsgenie with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Opsgenie data in Filemaker Pro for Mac or Windows.
-
Use the CData ODBC Driver for Oracle Sales from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Oracle Sales to connect to Oracle Sales data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Oracle Sales data in Excel.
-
Create Informatica Mappings From/To an ODBC Data Source for Sugar CRM
Create an ODBC connection to Sugar CRM in Informatica and browse and transfer Sugar CRM data.
-
Use the CData Software ODBC Driver for Amazon Marketplace in MicroStrategy
Connect to Amazon Marketplace data in MicroStrategy Developer using the CData Software ODBC Driver for Amazon Marketplace.
-
Create Dynamic Wistia Grids Using the Infragistics XamDataGrid
Learn how you can connect Wistia to Infragistics XamDataGrid to build dynamic grids.
-
Integrating LlamaIndex with Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Avro data in real time.
-
Working with NASA Data in LINQPad
Execute LINQ queries to NASA data in LINQPad.
-
Automated Continuous Sage 200 Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Sage 200 replication to delimited files (CSV/TSV).
-
How to create an RPA flow for Blackbaud FE NXT Data in UiPath Studio
Use the Blackbaud FE NXT ODBC Driver to create workflows that access real-time Blackbaud FE NXT data without any coding.
-
Operational Reporting on Miro Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Miro data.
-
Access Live Azure DevOps Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Azure DevOps data through MCP integration.
-
Automated Continuous Clio Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Clio replication to Amazon Redshift.
-
Build a PostgreSQL Interface for Sybase IQ Data using the CData JDBC Driver
Use the Remoting features of the Sybase IQ JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create a Data Access Object for YouTube Analytics Data using JDBI
A brief overview of creating a SQL Object API for YouTube Analytics data in JDBI.
-
Manage Zoho Projects Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Zoho Projects.
-
Load ZohoSubscriptions Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ZohoSubscriptions data to a database.
-
Connect to BigCommerce Data from HeidiSQL
Use CData Connect AI to connect to and query live BigCommerce data from HeidiSQL.
-
Build Semantic Layer Views for Adobe Experience Manager Data in APOS Live Data Gateway
Use the CData Connector for Adobe Experience Manager in APOS Live Data Gateway to build Semantic Layer Views for Adobe Experience Manager data.
-
Automate Zuora Data Replication to SAP HANA
Use CData Sync to customize and automate Zuora data replication to SAP HANA.
-
Connecting Pipedream with Spark Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Spark data in real time.
-
Connect to Pushbullet Data in Aqua Data Studio
Access Pushbullet data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Odoo Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Odoo data and build visualizations in Tableau.
-
Connect to LightSpeedRetail Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time LightSpeedRetail data using standard SQL.
-
Connect to JSON in SpagoBI
Create reports featuring live JSON services in SpagoBI Studio. Host JSON reports on SpagoBI Server.
-
Access Epicor Kinetic Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Epicor Kinetic data.
-
Replicate SAP HANA Data from PowerShell
Write a quick PowerShell script to query SAP HANA data. Use connectivity to the live data to replicate SAP HANA data to SQL Server.
-
How to connect Amazon QuickSight to Authorize.Net Data
Create a connection to Authorize.Net data in CData Connect AI and insert Authorize.Net data into Amazon QuickSight SPICE to build interactive dashboards.
-
Getting Started with the CData Tableau Connector for Miro
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Working with Parquet Data in LINQPad
Execute LINQ queries to Parquet data in LINQPad.
-
Access Microsoft Exchange Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Microsoft Exchange data.
-
How to Create Power BI Visual Reports with Real-Time PostgreSQL Data
Use CData Power BI Connectors to visualize PostgreSQL data in Power BI.
-
Deploy the ADO.NET Provider for Twitter Ads on an SSRS Report Server
Connect to Twitter Ads data 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.
-
Connecting Mastra with JSON Services 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 JSON services, no replication required.
-
View Reports on Real-Time Egnyte Data in Power BI Report Server
Use the CData ODBC Driver for Egnyte to visualize Egnyte data in Power BI Desktop and then publish them to Power BI Report Server.
-
Operational Reporting on SharePoint Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SharePoint data.
-
Working with PhantomBuster Data in LINQPad
Execute LINQ queries to PhantomBuster data in LINQPad.
-
Integrate Theia IDE with Live NetSuite 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 NetSuite data from within the development environment.
-
Automated Continuous GitLab Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable GitLab replication to Azure SQL Database.
-
Connect to ZohoMarketingHub Data in DBArtisan
Use wizards in DBArtisan to configure ZohoMarketingHub data as a data source.
-
Connect to Microsoft Entra ID Data in Aqua Data Studio
Access Microsoft Entra ID data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Zoho Books Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Zoho Books replication to Apache Cassandra.
-
How to integrate Metabase with Exa Data
Use CData Connect AI to connect to live Exa data and create an interactive dashboard in Metabase from Exa data.
-
Publish Reports with Auth0 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Auth0 data.
-
How to Work with SAP Fieldglass Data in AWS Glue Jobs Using JDBC
Connect to SAP Fieldglass from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create SSAS Tabular Models from ScrapingBee Data
How to build a SQL Server Analysis Service Tabular Model from ScrapingBee data using CData drivers.
-
Replicate Greenplum Data in Heroku for Use in Salesforce Connect
Replicate Greenplum data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Getting Started with the CData Python Connector for Pinterest
Learn to install and license the CData Python Connector and configure a connection to live Pinterest data.
-
Create Data Visualizations in Cognos BI with MailerLite Data
Access MailerLite data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Bind Live Square Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Square data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connect to Azure Data Lake Storage Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Azure Data Lake Storage as an External Source in Dremio.
-
Back Up Zoho CRM data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Zoho CRM. In this article, we will employ an SSIS workflow to populate a database with Zoho CRM data data.
-
Validate MailerLite Data with QuerySurge
Access and validate MailerLite data in QuerySurge using the CData JDBC Driver.
-
Build Visualizations of Tanda Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Tanda data in Birst.
-
Create Data Visualizations in Cognos BI with Dotmailer Data
Access Dotmailer data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
SendGrid Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SendGrid facts in real time.
-
Automated Continuous Pingdom Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Pingdom replication to Azure SQL Database.
-
Create SSAS Tabular Models from HubDB Data
How to build a SQL Server Analysis Service Tabular Model from HubDB data using CData drivers.
-
Publish Rootly-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Rootly data.
-
Replicate Multiple Oracle Sales Accounts via the CData Sync CLI
Replicate multiple Oracle Sales accounts to one or many databases.
-
How to connect to Google Ads Data with Squirrel SQL client
Connect to Google Ads data and execute queries in the Squirrel SQL Client.
-
Automated Continuous XML Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable XML replication to PostgreSQL.
-
Build ZohoDesk-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live ZohoDesk data.
-
Insightly Reporting in OBIEE with the Insightly JDBC Driver
Deploy the Insightly JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to SendPulse Data in DBeaver
Use the CData ODBC Driver to connect to SendPulse data in DBeaver.
-
Integrate FTP Data in Pentaho Data Integration
Build ETL pipelines based on FTP data in the Pentaho Data Integration tool.
-
How to Create Power BI Visual Reports with Real-Time PabblySubscriptions Data
Use CData Power BI Connectors to visualize PabblySubscriptions data in Power BI.
-
Access Tally Data from MySQL in PHP
Connect to Tally through the standard MySQL libraries in PHP.
-
Query TigerGraph Data through ODBC in Node.js
Use node-odbc to execute SQL queries against TigerGraph data from Node.js.
-
DataBind Controls to Mistral AI Data in Delphi
DataBind to Mistral AI data in Delphi with standard data access components and controls.
-
Publish Reports with Nuclia Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Nuclia data.
-
Build Automated Microsoft Entra ID-Connected Workflows in Zapier
Use CData Connect AI to connect to live Microsoft Entra ID data and build automated workflows in Zapier.
-
Build Dashboards with Blackbaud FE NXT Data in Dundas BI
Create dynamic dashboards and perform analytics based on Blackbaud FE NXT data in Dundas BI.
-
Connect and Visualize Live AfterShip Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live AfterShip data into the Databricks platform and create visualization dashboards with real-time AfterShip data.
-
How to Connect to Live Apify Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Apify data for you.
-
Connect to Amazon DynamoDB from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Amazon DynamoDB data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Analyze Supabase Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Supabase from Power Pivot. You will use the Table Import Wizard to load Supabase data. You can visually build the import query or use any SQL supported by the driver.
-
Access BambooHR Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access BambooHR data from your Oracle system.
-
Connect to SAP BusinessObjects BI Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP BusinessObjects BI Data and connect to SAP BusinessObjects BI data in Akorbi Digital RunMyProcess.
-
Replicate Dynamics 365 Data from PowerShell
Write a quick PowerShell script to query Dynamics 365 data. Use connectivity to the live data to replicate Dynamics 365 data to SQL Server.
-
Integrate Goose with Live Oracle Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Oracle data from within the local AI agent.
-
Integrate with Blackbaud FE NXT Data in JReport Designer
Create charts and reports based on Blackbaud FE NXT data in JReport Designer.
-
Visualize Printful Data in Sisense
Create an ElastiCube in Sisense app with access to Printful data.
-
Connect to Auth0 Data in CloverDX (formerly CloverETL)
Transfer Auth0 data using the visual workflow in the CloverDX data integration tool.
-
Model DB2 Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and DB2, enabling the direct import of real-time DB2 data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for LinkedIn
Provide connectivity to LinkedIn data through an SAP BusinessObjects universe.
-
Connect to Copper Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Copper and the SQL Gateway to access Copper data from Google Apps Script.
-
Analyze Avalara AvaTax Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Avalara AvaTax data in Microsoft R Open.
-
Prepare, Blend, and Analyze Oracle Data in Alteryx Designer (ODBC)
Build workflows to access live Oracle data for self-service data analytics.
-
Replicate Multiple Smartsheet Accounts via the CData Sync CLI
Replicate multiple Smartsheet accounts to one or many databases.