CData Software - Knowledge Base
Recent Articles
-
Integrating Dataiku with LDAP Objects via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live LDAP objects.
-
How to Connect to Live Sage Intacct Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Sage Intacct data without replication.
-
Manage Bullhorn CRM Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Bullhorn CRM.
-
Build Data Flows from SQL Server to Oracle Sales through SSIS
Easily push SQL Server data to Oracle Sales using the CData SSIS Tasks for Oracle Sales.
-
Access Live Oracle SCM Data in Coginiti Pro
Connect to and query live Oracle SCM data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Design BIRT Reports on OnePageCrm Data
Provide current OnePageCrm data to your embedded analytics.
-
Connect to TaxJar Data as an External Source in Dremio
Use the CData JDBC Driver to connect to TaxJar as an External Source in Dremio.
-
Build an OLAP Cube in SSAS from Slack Data
Establish a connection to Slack data data from SQL Server Analysis Services, and use the Slack Data Provider to build OLAP cubes for use in analytics and reporting.
-
Cosmos DB Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Cosmos DB facts in real time.
-
Use CData Connect AI to Access Dropbox Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Dropbox data in the Power Pivot business intelligence tool.
-
Access Live Outreach.io Data in Excel 365 Online (Excel for the web)
Connect to Outreach.io data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Getting Started with the CData Power BI Connector for Discourse
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Integrate with live SparkPost Data in Jitterbit
Use CData Connect AI to connect to and integrate live SparkPost data in Jitterbit.
-
Replicate Pipeliner CRM Data from PowerShell
Write a quick PowerShell script to query Pipeliner CRM data. Use connectivity to the live data to replicate Pipeliner CRM data to SQL Server.
-
How to Connect to Live GitLab Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live GitLab data without replication.
-
Create CircleCI Dataflows on PowerBI.com
Connect to the CData Power BI Connector for CircleCI from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect to Live Printify Data 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 Printify data for you.
-
How to work with PagerDuty Data in Apache Spark using SQL
Access and process PagerDuty Data in Apache Spark using the CData Software JDBC Driver.
-
Automate Intercom Data Replication to Azure Data Lake
Use CData Sync to customize and automate Intercom data replication to Azure Data Lake.
-
Automated Continuous AlloyDB Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable AlloyDB replication to delimited files (CSV/TSV).
-
Connect to Parallel Data in DBeaver
Use the CData ODBC Driver to connect to Parallel data in DBeaver.
-
Create Data Visualizations in Cognos BI with Eventbrite Data
Access Eventbrite data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Deel Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Deel data.
-
Connect to Scrapfly Data from a Connection Pool in Jetty
The Scrapfly JDBC Driver supports connection pooling: This article shows how to connect faster to Scrapfly data from Web apps in Jetty.
-
Excel Spreadsheet Automation on Pipedrive Data with the QUERY Formula
Pull data from Pipedrive, automate spreadsheets, and more with the QUERY formula.
-
Rapidly Develop Azure Data Lake Storage-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Azure Data Lake Storage.
-
Replicate Trello Data to Multiple Databases
Replicate Trello data to disparate databases with a point-and-click configuration.
-
Import Shippo Data Using Azure Data Factory
Use CData Connect AI to connect to Shippo Data from Azure Data Factory and import live Shippo data.
-
Working with Basecamp Data in LINQPad
Execute LINQ queries to Basecamp data in LINQPad.
-
Getting Started with the CData Excel Add-In for Lakebase
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Lakebase.
-
Publish Crystal Reports on Deel Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Deel data.
-
How to connect to SAP SuccessFactors LMS Data in DBVisualizer
Integrate SAP SuccessFactors LMS data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Vertica Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Vertica data and build visualizations in Tableau.
-
How to connect to Paylocity Data from IntelliJ
Integrate connectivity to Paylocity data with wizards in IntelliJ.
-
Build MVC Applications with Connectivity to SpaceX Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SpaceX from an ASP.NET MVC application.
-
Redis Reporting in OBIEE with the Redis JDBC Driver
Deploy the Redis JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Moving Data from Amazon Marketplace to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Amazon Marketplace data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Link ConvertKit with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ConvertKit data in Filemaker Pro for Mac or Windows.
-
How to publish and share Pingdom Data dashboards with Tableau Server
The CData ODBC driver for Pingdom enables you integrate Pingdom data into Tableau dashboards.
-
Replicate Strava Data from PowerShell
Write a quick PowerShell script to query Strava data. Use connectivity to the live data to replicate Strava data to SQL Server.
-
Connect to CloudConvert 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 CloudConvert and work with CloudConvert data in your FileMaker application.
-
Validate Avalara AvaTax Data with QuerySurge
Access and validate Avalara AvaTax data in QuerySurge using the CData JDBC Driver.
-
Visualize Live Oracle Sales Data in the Power BI Service
Use CData Connect AI to connect to live Oracle Sales data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create SSAS Tabular Models from Outlook Data
How to build a SQL Server Analysis Service Tabular Model from Outlook data using CData drivers.
-
Connect to and Visualize Live SAP Hybris C4C Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP Hybris C4C data.
-
How to Connect to Live Act CRM 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 Act CRM data for you.
-
Work with Hacker News Data in FoxPro
Load Hacker News data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Monday.com Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Monday.com data and build visualizations in Tableau.
-
Access Mistral AI Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Mistral AI data from your Oracle system.
-
Load Elasticsearch Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Elasticsearch data to a database.
-
Automated Continuous ScrapingBee Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ScrapingBee replication to Google BigQuery.
-
Analyze Okta Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Okta data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Access Live MessageBird Data in AWS Lambda
Connect to live MessageBird data in AWS Lambda using the CData JDBC Driver.
-
Import and Visualize Stack Exchange Data in Power View
Create data visualizations based on Stack Exchange data in Excel.
-
Provide OData Services of Trello Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Trello data by developing a WCF Service Application.
-
Build AI Agents with IBM Informix 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 IBM Informix data through CData Connect AI.
-
Connect xBase to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live xBase data using the CData Python MCP Server.
-
Import Real-Time Reckon Accounts Hosted Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Reckon Accounts Hosted data in ColdFusion.
-
Build AI/ML Models with Live Workday Data using Dataiku
Connect Workday Data with Dataiku using the CData JDBC Driver for Workday.
-
Analyze Azure Data Lake Storage Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Azure Data Lake Storage data and visualize Azure Data Lake Storage data in SAP Analytics Cloud.
-
Use the CData Software ODBC Driver for Twitter Ads in MicroStrategy
Connect to Twitter Ads data in MicroStrategy Developer using the CData Software ODBC Driver for Twitter Ads.
-
How to Connect to Live Amazon S3 Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Amazon S3 data for you.
-
Work with Live Certinia Data in Power Query
Use CData Connect AI to connect to Certinia data and work with live Certinia data in Microsoft Power Query.
-
Connect to Simplesat Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Simplesat and work with Simplesat data in your FileMaker applications.
-
Automated Continuous LinkedIn Ads Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to PostgreSQL.
-
How to create NASA federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for NASA data in MySQL .
-
Build Automated Trello-Connected Workflows in Zapier
Use CData Connect AI to connect to live Trello data and build automated workflows in Zapier.
-
Build Webflow-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Webflow data and build web apps with connectivity to live Webflow data.
-
How to Connect to Live QuickBooks Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your QuickBooks data for you.
-
ETL SageHR in Oracle Data Integrator
This article shows how to transfer SageHR data into a data warehouse using Oracle Data Integrator.
-
Use the CData Software ODBC Driver for Microsoft Teams in SAS for Real-Time Reporting and Analytics
Connect to real-time Microsoft Teams data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Microsoft Teams.
-
Working with Superchat Data in LINQPad
Execute LINQ queries to Superchat data in LINQPad.
-
Build Charts with Redis Data in Clear Analytics
Create dynamic charts and perform analytics based on Redis data in Clear Analytics.
-
How to create Azure Data Catalog federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Azure Data Catalog data in MySQL .
-
Connect to Azure Synapse Data from PowerBuilder via ADO.NET
This article demonstrates how to access Azure Synapse data from Appeon PowerBuilder using the CData ADO.NET Provider for Azure Synapse.
-
Replicate ChartMogul Data in Heroku for Use in Salesforce Connect
Replicate ChartMogul data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Beeminder Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Beeminder replication to Apache Cassandra.
-
Build Float-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Float data.
-
Model SAP Business One Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP Business One, enabling the direct import of real-time SAP Business One data.
-
Query Acumatica Data as a SQL Server Database in Node.js
Execute SQL Server queries against Acumatica data from Node.js.
-
Write a Simple Go Application to work with Auth0 Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Auth0 data.
-
How to Connect to Live Google Cloud Storage Data 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 Google Cloud Storage data for you.
-
Getting Started with the CData Excel Add-In for Avro
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Avro.
-
How to Connect Google Search Results to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Google Search data in real time using natural language.
-
Build Charts with BigQuery Data in Clear Analytics
Create dynamic charts and perform analytics based on BigQuery data in Clear Analytics.
-
Create SSAS Tabular Models from ClickUp Data
How to build a SQL Server Analysis Service Tabular Model from ClickUp data using CData drivers.
-
Visualize Live Unbounce Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Unbounce data.
-
Create API-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to API Data from OutSystems and build custom enterprise apps using live API data.
-
Connect to BigQuery Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for BigQuery to connect to BigQuery data and execute queries in PowerBuilder.
-
Build Paylocity-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Paylocity Data and create custom apps in Bubble.
-
Analyze Quickbase Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Quickbase data with the CData JDBC Driver for Quickbase.
-
Access AlloyDB Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access AlloyDB data from your Oracle system.
-
AgileCRM Reporting in OBIEE with the AgileCRM JDBC Driver
Deploy the AgileCRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous SQL Server Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SQL Server replication to Amazon Redshift.
-
Integrating Lakebase Data in Talend Cloud Data Management Platform
Connect Lakebase Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Lakebase.
-
Connect to Live Microsoft Exchange Data in MicroStrategy through CData Connect AI
Create a live connection to Microsoft Exchange Data in CData Connect AI and connect to your Microsoft Exchange data from MicroStrategy.
-
Automated Continuous Short.io Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Short.io replication to Apache Kafka.
-
Access Live Odoo Data in Coginiti Pro
Connect to and query live Odoo data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Replicate Pinecone Data from PowerShell
Write a quick PowerShell script to query Pinecone data. Use connectivity to the live data to replicate Pinecone data to SQL Server.
-
Build Dashboards with Clio Data in DBxtra
Create dynamic dashboards and perform analytics based on Clio data in DBxtra.