CData Software - Knowledge Base
Recent Articles
-
How to Connect the Power BI Service to Browserless: Complete Guide
Connect to the CData Software Power BI Connector for Browserless from PowerBI.com to provide real-time Browserless across the organization.
-
Integrate Asana Data into Power Automate Desktop using CData Connect
CData Connect for Asana Data enables you to integrate Asana into workflows built using Microsoft Power Automate Desktop.
-
Visualize Freshservice Data in TIBCO Spotfire through ADO.NET
Integrate Freshservice into dashboards in TIBCO Spotfire.
-
How to Connect to Live Google Ads 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 Ads for you.
-
Analyze Marketo Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Marketo and visualize live Marketo in Infragistics Reveal.
-
Integrating LlamaIndex with Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Amazon S3 in real time.
-
Validate Azure Analysis Services Data with QuerySurge
Access and validate Azure Analysis Services in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Zoho Inventory Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to OneLake in Microsoft Fabric.
-
Connect to Google Sheets Data from AWS Glue
Use CData Connect AI to gain access to live Google Sheets from your AWS Glue jobs.
-
Create Power BI Reports on Real-Time Google Directory Data
Use the CData ODBC Driver for Google Directory to visualize Google Directory in Power BI Desktop.
-
Connect to Hive from Asprova with CData Software ODBC Driver for Hive
This article shows how to connect faster to Hive data from Asprova.
-
Use Dash to Build Web Apps on QuickBooks Time Data via CData Connect AI
Build interactive Dash web apps on live QuickBooks Time using pandas and the CData Connect AI Python SDK.
-
Integrating GitHub Copilot CLI with Snowflake 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.
-
Create Data Visualizations in Cognos BI with Email Data
Access Email as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Publish Reports with Sugar CRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sugar CRM.
-
How to use SQLAlchemy ORM to access ZohoInvoice Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ZohoInvoice.
-
Access Grafana Data from MySQL in Amazon QuickSight
Connect to Grafana and build visualizations of Grafana using a MySQL Connection in Amazon QuickSight.
-
Build Charts with Odoo Data in Clear Analytics
Create dynamic charts and perform analytics based on Odoo ERP in Clear Analytics.
-
Analyze Mouseflow Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Mouseflow with the CData JDBC Driver for Mouseflow.
-
Integrate Goose with Live NetSuite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live NetSuite CRM & ERP from within the local AI agent.
-
Build MVC Applications with Connectivity to Dynamics NAV Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Dynamics NAV from an ASP.NET MVC application.
-
Access Redshift Data from MySQL in Amazon QuickSight
Connect to Redshift and build visualizations of Amazon Redshift using a MySQL Connection in Amazon QuickSight.
-
Connect to IBM Cloud Object Storage Data from a Connection Pool in JBoss
Integrate IBM Cloud Object Storage into Java servlets: Use the Management Console in JBoss to install the IBM Cloud Object Storage JDBC Driver.
-
Access Live IBM Informix Data in TIBCO Data Virtualization
Use the IBM Informix Tibco DV Adapter to create a IBM Informix data source in TIBCO Data Virtualization Studio and gain access to live IBM Informix from your TDV Server.
-
Query Kafka Data in ColdFusion
Write standard ColdFusion data access code to connect to Apache Kafka.
-
Integrating Claude Code with Reckon Accounts Hosted Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Reckon Accounts Hosted within assisted coding and automated development workflows.
-
Integrate Printify with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Printify with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Printify.
-
Getting Started with the CData Python Connector for Todoist
Learn to install and license the CData Python Connector
-
Automated Continuous ConstantContact Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ConstantContact replication to Amazon Redshift.
-
Create a Data Access Object for Close Data using JDBI
A brief overview of creating a SQL Object API for Close in JDBI.
-
Visualize ConvertAPI Data in TIBCO Spotfire through ADO.NET
Integrate ConvertAPI into dashboards in TIBCO Spotfire.
-
Build a Simple VCL Application for Google Tasks Data
How to build a simple VCL Application to view Google Tasks in RAD Studio using the CData ODBC Driver for Google Tasks.
-
Feed Kintone Data into FineReport
How to set Kintone as a JDBC data source in FineReport.
-
Design BIRT Reports on Redshift Data
Provide current Amazon Redshift to your embedded analytics.
-
Integrate with Shippo Data in JReport Designer
Create charts and reports based on Shippo in JReport Designer.
-
Automated Continuous DB2 Replication to Databricks
Use CData Sync for automated, continuous, customizable DB2 replication to Databricks.
-
Integrating Office 365 Data in Talend Cloud Data Management Platform
Connect Office 365 Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Office 365.
-
Create Cosmos DB Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Cosmos DB from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData Software JDBC Driver for Stripe in MicroStrategy Desktop
Connect to Stripe in MicroStrategy Desktop using the CData Software JDBC Driver for Stripe.
-
Analyze Email Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Email with the CData JDBC Driver for Email.
-
Connect to Real-Time Amazon DynamoDB Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Amazon DynamoDB and Dataflow to import and use Amazon DynamoDB in Power Apps.
-
Excel Spreadsheet Automation on Grafana Data with the QUERY Formula
Pull data from Grafana, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous LaunchDarkly Replication to SQLite
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to SQLite.
-
Integrate with Typeform Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Typeform to a JSON file on disk.
-
Automated Continuous XML Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable XML replication to Apache Cassandra.
-
Load Beeminder Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Beeminder to a database.
-
Integrating Zoho CRM Data in Talend Cloud Data Management Platform
Connect Zoho CRM Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Zoho CRM.
-
Feed Neo4J Data into FineReport
How to set Neo4J as a JDBC data source in FineReport.
-
Perform Batch Operations with CouchDB Data in Apache NiFi
Connect to Apache CouchDB and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to Connect OneNote Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live OneNote data in real time using natural language.
-
Visualize Live HelloSign Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live HelloSign using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Dashboards with ServiceNow Data in Dundas BI
Create dynamic dashboards and perform analytics based on ServiceNow in Dundas BI.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for PolarTeamPro
Provide connectivity to PolarTeamPro through an SAP BusinessObjects universe.
-
How to use SQLAlchemy ORM to access Instagram Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Instagram.
-
Integrate Scrapfly Data in the Pentaho Report Designer
Publish reports based on Scrapfly in the Pentaho BI tool.
-
Use Agno to Talk to Your Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Google Sheets for you.
-
Natively Connect to ZohoMarketingHub Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ZohoMarketingHub. Leverage the native support for ODBC in PHP.
-
Use the CData ODBC Driver for Mouseflow in Microsoft Power Query
You can use the CData Mouseflow ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Mouseflow into Microsoft Power Query.
-
Use JayDeBeApi to access ZohoSubscriptions Data in Python
Use standard Python scripting and the development environment of your choice to access live ZohoSubscriptions.
-
Analyze Adobe Analytics Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Adobe Analytics from Power Pivot. You will use the Table Import Wizard to load Adobe Analytics. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Invoiced with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Invoiced with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Invoiced.
-
Analyze EmailOctopus Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for EmailOctopus from Power Pivot. You will use the Table Import Wizard to load EmailOctopus. You can visually build the import query or use any SQL supported by the driver.
-
Access Live Impala Data in TIBCO Data Virtualization
Use the Impala Tibco DV Adapter to create a Apache Impala data source in TIBCO Data Virtualization Studio and gain access to live Apache Impala from your TDV Server.
-
A PostgreSQL Interface for Outreach.io Data (MySQL Remoting via JDBC)
Use the Remoting features of the Outreach.io JDBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Clio Data from PowerShell
Write a quick PowerShell script to query Clio. Use connectivity to the live data to replicate Clio to SQL Server.
-
A PostgreSQL Interface for Invoiced Data using the CData ODBC Driver
Use the SQL Gateway and Invoiced ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize JotForm Data in TIBCO Spotfire through ADO.NET
Integrate JotForm into dashboards in TIBCO Spotfire.
-
Integrate Live Oracle Service Cloud Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Oracle Service Cloud to Blue Prism using the CData ODBC Driver for Oracle Service Cloud to create automated workflows for repetitive business tasks.
-
Extend Google Sheets with TaxJar Data
Make calls to TaxJar from Google Apps Script via the API Server.
-
Integrate Amazon Marketplace Data in Pentaho Data Integration
Build ETL pipelines based on Amazon Marketplace in the Pentaho Data Integration tool.
-
Use Dash to Build Web Apps on Microsoft Entra ID Data via CData Connect AI
Build interactive Dash web apps on live Microsoft Entra ID using pandas and the CData Connect AI Python SDK.
-
How to import HelloSign Data into Apache Solr
Use the CData Software JDBC Driver for HelloSign in Data Import Handler and create an automated import of HelloSign to Apache Solr Enterprise Search platform.
-
Visualize Live SAP ByDesign Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP Business ByDesign into custom reports in Power BI.
-
Connect to Avalara AvaTax Data in DBeaver
Use the CData ODBC Driver to connect to Avalara AvaTax in DBeaver.
-
Create SSAS Tabular Models from Pingdom Data
How to build a SQL Server Analysis Service Tabular Model from Pingdom using CData drivers.
-
Access Pushbullet Data from MySQL in Amazon QuickSight
Connect to Pushbullet and build visualizations of Pushbullet using a MySQL Connection in Amazon QuickSight.
-
Connect SuiteCRM Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SuiteCRM using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to and Query Samanage Data in QlikView over ODBC
Create data visualizations with Samanage in QlikView.
-
How to Build an ETL App for DB2 Data in Python with CData Connect AI
Build ETL pipelines that read and write live IBM DB2 in Python with petl and the CData Connect AI Python SDK.
-
Build Semantic Layer Views for FTP Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for FTP Servers.
-
Connect to Freshteam Data from PowerBuilder via ADO.NET
This article demonstrates how to access Freshteam from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrating Avaza Data in Talend Cloud Data Management Platform
Connect Avaza Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Use Manus AI to Talk to Your Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Box.
-
Automated Continuous Microsoft Teams Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to OneLake in Microsoft Fabric.
-
Build MVC Applications with Connectivity to Customer.io Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Customer.io from an ASP.NET MVC application.
-
How to Connect to & Open Eventbrite Data in Microsoft Excel
This article uses the CData ODBC driver for Eventbrite to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to AgileCRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for AgileCRM.
-
Automated Continuous Spark Replication to MySQL
Use CData Sync for automated, continuous, customizable Spark replication to MySQL.
-
Create Reports with Chargebee Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Chargebee.
-
Create Trello-Connected Applications in Appsmith
Connect to Trello Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Trello.
-
Create Data Visualizations in Cognos BI with Outreach.io Data
Access Outreach.io as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData Software ODBC Driver for PDFMonkey in MicroStrategy
Connect to PDFMonkey in MicroStrategy Developer using the CData Software ODBC Driver for PDFMonkey.
-
Create Reports from Acumatica Data in Looker Studio
Use CData Connect AI to gain access to live Acumatica ERP and create custom reports in Looker Studio.
-
Integrate Pinecone Data in the Pentaho Report Designer
Publish reports based on Pinecone in the Pentaho BI tool.
-
Access Live IBM Informix Data in Excel 365 Online (Excel for the web)
Connect to IBM Informix from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to connect PolyBase to Dotmailer
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Dotmailer.
-
How to Work with Dynamics NAV Data in AWS Glue Jobs Using JDBC
Connect to Dynamics NAV from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Getting Started with the CData ADO.NET Provider for NetSuite
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for NetSuite.
-
How to import Google Spanner Data into Apache Solr
Use the CData Software JDBC Driver for Google Spanner in Data Import Handler and create an automated import of Google Spanner to Apache Solr Enterprise Search platform.
-
Build Semantic Layer Views for Slack Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Slack.