CData Software - Knowledge Base
Recent Articles
-
Operational Reporting on Placid Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Placid data.
-
Create Datasets from Amazon DynamoDB in Domo Workbench and Build Visualizations of Amazon DynamoDB Data in Domo
Use the CData Software ODBC Driver for Amazon DynamoDB to create datasets from Amazon DynamoDB data in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Goose with Live GitHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live GitHub data from within the local AI agent.
-
Viewing Oracle Service Cloud Data in RAD Studio Data Explorer
How to view Oracle Service Cloud data in RAD Studio Data Explorer using the CData ODBC Driver for Oracle Service Cloud.
-
Create Todoist Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Todoist data access from reports, embedded analytics, and more.
-
Automated Continuous Aha! Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Aha! replication to AlloyDB.
-
Automate Neo4J Data Replication to Azure Data Lake
Use CData Sync to customize and automate Neo4J data replication to Azure Data Lake.
-
Use the CData Software ODBC Driver for Tally in MicroStrategy Web
Connect to Tally data in MicroStrategy Web using the CData Software ODBC Driver for Tally.
-
Connect to JobNimbus Data in Jaspersoft Studio
Execute SQL to remote JobNimbus data in Jaspersoft Studio.
-
Model Raisers Edge NXT Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Raisers Edge NXT, enabling the direct import of real-time Raisers Edge NXT data.
-
Import Google Calendar Data Using Azure Data Factory
Use CData Connect AI to connect to Google Calendar Data from Azure Data Factory and import live Google Calendar data.
-
Connect to Amplitude Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Amplitude as an External Source in Dremio.
-
Use Dash to Build Web Apps on SQL Analysis Services Data via CData Connect AI
Build interactive Dash web apps on live SQL Analysis Services data using pandas and the CData Connect AI Python SDK.
-
Build Charts with MessageBird Data in Clear Analytics
Create dynamic charts and perform analytics based on MessageBird data in Clear Analytics.
-
Connect to Helpscout Data in DBeaver
Use the CData ODBC Driver to connect to Helpscout data in DBeaver.
-
Integrating Dataiku with ServiceDesk Plus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live ServiceDesk Plus data.
-
Use the CData Software JDBC Driver for Zoho Recruit in MicroStrategy Desktop
Connect to Zoho Recruit data in MicroStrategy Desktop using the CData Software JDBC Driver for Zoho Recruit.
-
Publish Basecamp-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Basecamp data.
-
Connect to Oracle Eloqua Data in JRuby
Create a simple JRuby app with access to live Oracle Eloqua data.
-
Replicate AlloyDB Data to Multiple Databases via the CData Sync CLI
Replicate AlloyDB data to disparate databases with a single configuration.
-
Query QuickBooks Data in ColdFusion
Write standard ColdFusion data access code to connect to QuickBooks data.
-
Connect to Amazon Athena Data in HULFT Integrate
Connect to Amazon Athena as a JDBC data source in HULFT Integrate
-
Query Live IBM Cloud Object Storage 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 IBM Cloud Object Storage data directly from the development environment.
-
Access Live Azure Analysis Services Data in Excel 365 Online (Excel for the web)
Connect to Azure Analysis Services data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access Live Oracle Financials Cloud Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Oracle Financials Cloud data from your Excel spreadsheets.
-
Build Visualizations of Odoo Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Odoo data in Birst.
-
Visualize Live Authorize.Net Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Authorize.Net data into custom reports in Power BI.
-
Create Reports from Elasticsearch Data in Looker Studio
Use CData Connect AI to gain access to live Elasticsearch data and create custom reports in Looker Studio.
-
Integrating Antigravity CLI with Salesforce Marketing data via CData CLI
Connect Salesforce Marketing data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Live Tavily Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Tavily data and integrate live Tavily data into apps built in Microsoft Power Apps.
-
How to Connect to ZarMoney Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ZarMoney data. Leverage the pyodbc module for ODBC in Python.
-
Connect and Query Live AlloyDB Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live AlloyDB data into Databricks and enable direct, live querying and analysis without replication.
-
Build Data Flows from WooCommerce to SQL Server using SSIS
Easily back up WooCommerce data to SQL Server using the SSIS components for WooCommerce.
-
Automated Continuous Highrise Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Highrise replication to Apache Kafka.
-
Getting Started with the CData ADO.NET Provider for Invoiced
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Object-Relational Mapping (ORM) with Coinbase Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Coinbase data into a Java-based ORM framework, Hibernate.
-
Automated Continuous Egnyte Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Egnyte replication to Apache Cassandra.
-
Integrating Dataiku with Google Forms Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Google Forms data.
-
Connect to Cloudant from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Cloudant data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Replicate Twilio Data from PowerShell
Write a quick PowerShell script to query Twilio data. Use connectivity to the live data to replicate Twilio data to SQL Server.
-
How to Build an ETL App for HubDB Data in Python with CData
Create ETL applications and real-time data pipelines for HubDB data in Python with petl.
-
How to integrate Metabase with Sybase IQ Data
Use CData Connect AI to connect to live Sybase IQ data and create an interactive dashboard in Metabase from Sybase IQ data.
-
Integrate Live Procore Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Procore data and integrate live Procore data into apps built in Microsoft Power Apps.
-
Access Live Amplitude Data in AWS Lambda
Connect to live Amplitude data in AWS Lambda using the CData JDBC Driver.
-
Visualize Live Sugar CRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Sugar CRM data.
-
Process & Analyze Procore Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Procore Data.
-
Connect to Quaderno Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Quaderno.
-
Automated Continuous Oracle Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Oracle replication to Azure SQL Database.
-
How to Work with Yelp Data in AWS Glue Jobs Using JDBC
Connect to Yelp from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Google Campaign Manager 360-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Campaign Manager 360 data.
-
Integrate ElevenLabs Data in the Pentaho Report Designer
Publish reports based on ElevenLabs data in the Pentaho BI tool.
-
Use ChatGPT to Talk to Your HubDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your HubDB data for you.
-
Analyze ClickUp Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of ClickUp data and visualize live ClickUp data in Infragistics Reveal.
-
Consume Pinterest OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Pinterest feeds that reflect any changes in SAP Lumira.
-
Validate Wave Financial Data with QuerySurge
Access and validate Wave Financial data in QuerySurge using the CData JDBC Driver.
-
Excel Spreadsheet Automation on Email Data with the QUERY Formula
Pull data from Email, automate spreadsheets, and more with the QUERY formula.
-
Connect to Dynamics 365 Business Central Data from Crystal Reports
Use CData Connect AI to connect to and report on live Dynamics 365 Business Central data from Crystal Reports.
-
Analyze Google Contacts Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Contacts from Power Pivot. You will use the Table Import Wizard to load Google Contacts data. You can visually build the import query or use any SQL supported by the driver.
-
Access Wistia Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Wistia data from your Oracle system.
-
Use the CData ODBC Driver for Twilio from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Twilio to connect to Twilio data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Twilio data in Excel.
-
Connect to PostgreSQL Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live PostgreSQL data from Filemaker Pro on Mac.
-
How to Connect to Cohere Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Cohere data. Leverage the pyodbc module for ODBC in Python.
-
Work with Live Dynamics NAV Data in Power Query
Use CData Connect AI to connect to Dynamics NAV data and work with live Dynamics NAV data in Microsoft Power Query.
-
Build Greenhouse-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Greenhouse data.
-
Automated ZohoMarketingHub Data Replication to Teradata
Use CData Sync to Customize and automate ZohoMarketingHub data replication to Teradata.
-
How to connect and process Pinterest data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Pinterest data.
-
Automated Continuous Sybase Replication to Snowflake
Use CData Sync for automated, continuous, customizable Sybase replication to Snowflake.
-
How to import Stack Exchange Data into Apache Solr
Use the CData Software JDBC Driver for Stack Exchange in Data Import Handler and create an automated import of Stack Exchange data to Apache Solr Enterprise Search platform.
-
Getting Started with the CData ODBC Driver for PayPal
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for PayPal.
-
Rapidly Develop AlloyDB-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 AlloyDB.
-
Create Omnisend-Connected Dashboards in Grafana
Connect to Omnisend Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Omnisend data.
-
Use the CData Software ODBC Driver for Aircall in MicroStrategy
Connect to Aircall data in MicroStrategy Developer using the CData Software ODBC Driver for Aircall.
-
Create Power BI Reports on Real-Time Sugar CRM Data
Use the CData ODBC Driver for Sugar CRM to visualize Sugar CRM data in Power BI Desktop.
-
Process & Analyze Smartsheet Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Smartsheet Data.
-
Integrate Aweber Data in the Pentaho Report Designer
Publish reports based on Aweber data in the Pentaho BI tool.
-
Explore Geographical Relationships in REST Data with Power Map
Create data visualizations with REST data in Power Map.
-
Integrating Antigravity CLI with Datadog data via CData CLI
Connect Datadog data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize Raisers Edge NXT Data in TIBCO Spotfire through ADO.NET
Integrate Raisers Edge NXT data into dashboards in TIBCO Spotfire.
-
Automated Continuous Chargebee Replication to Databricks
Use CData Sync for automated, continuous, customizable Chargebee replication to Databricks.
-
Integrate with Outreach.io Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Outreach.io data to a JSON file on disk.
-
Build Visualizations of Samanage Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Samanage data in Birst.
-
How to connect to Azure DevOps Data with Squirrel SQL client
Connect to Azure DevOps data and execute queries in the Squirrel SQL Client.
-
DataBind Charts to SQL Analysis Services Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SQL Analysis Services data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Write a Simple Go Application to work with Freshsales Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Freshsales data.
-
Build HelloSign-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to HelloSign data and build web apps with connectivity to live HelloSign data.
-
Query Gong Data in ColdFusion
Write standard ColdFusion data access code to connect to Gong data.
-
Stream Microsoft OneDrive Data into Apache Kafka Topics
Access and stream Microsoft OneDrive data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Power BI Reports on Real-Time Hacker News Data
Use the CData ODBC Driver for Hacker News to visualize Hacker News data in Power BI Desktop.
-
Access Beeminder Data from MySQL in PHP
Connect to Beeminder through the standard MySQL libraries in PHP.
-
Validate Zendesk Data with QuerySurge
Access and validate Zendesk data in QuerySurge using the CData JDBC Driver.
-
Create Datasets from Unbounce in Domo Workbench and Build Visualizations of Unbounce Data in Domo
Use the CData Software ODBC Driver for Unbounce to create datasets from Unbounce data in Domo Workbench and then build visualizations in the Domo service.
-
Use the CData Software JDBC Driver for SAP Concur in MicroStrategy
Connect to SAP Concur data in MicroStrategy Developer using the CData Software JDBC Driver for SAP Concur.
-
Anaplan Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Anaplan facts in real time.
-
Connect to Sybase IQ Data in Jaspersoft Studio
Execute SQL to remote Sybase IQ data in Jaspersoft Studio.
-
Publish Crystal Reports on Shopify Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Shopify data.
-
Use CData Connect AI to Access Neo4J Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Neo4J data in the Power Pivot business intelligence tool.
-
Natively Connect to Optimizely Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Optimizely data. Leverage the native support for ODBC in PHP.
-
Connecting GenSpark with Facebook Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Facebook data without any replication or custom integration required.
-
Connect Airtable to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Airtable data using the CData Python MCP Server.
-
Access Live HDFS Data in Coginiti Pro
Connect to and query live HDFS data from the GUI in the Coginiti Pro: SQL Analytics Tool.