CData Software - Knowledge Base
Recent Articles
-
Visualize Live Odoo Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Odoo ERP using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live HDFS Data in TIBCO Data Virtualization
Use the HDFS Tibco DV Adapter to create a Apache HDFS data source in TIBCO Data Virtualization Studio and gain access to live Apache HDFS from your TDV Server.
-
Import Google Contacts Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Google Contacts. In this article, you will use the OData format to import Google Contacts into Microsoft Power Query.
-
Create Informatica Mappings From/To an ODBC Data Source for Cohere
Create an ODBC connection to Cohere in Informatica and browse and transfer Cohere.
-
Create Informatica Mappings From/To an ODBC Data Source for Scrapfly
Create an ODBC connection to Scrapfly in Informatica and browse and transfer Scrapfly.
-
Connect to Live Redis Data in MicroStrategy through CData Connect AI
Create a live connection to Redis Data in CData Connect AI and connect to your Redis from MicroStrategy.
-
How to Build an ETL App for Outreach.io Data in Python with CData
Create ETL applications and real-time data pipelines for Outreach.io in Python with petl.
-
Integrate with Postmark Data in JReport Designer
Create charts and reports based on Postmark in JReport Designer.
-
Connect to Real-Time Discourse Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Discourse in Power Apps.
-
Bidirectional Access to EmailOctopus Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate EmailOctopus in Filemaker Pro for Mac or Windows.
-
DataBind SendGrid Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SendGrid with the DevExpress Windows Forms and Web controls to provide SendGrid to a chart.
-
Visualize Aweber Data in Sisense
Create an ElastiCube in Sisense app with access to Aweber.
-
LINQ to Active Directory Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Active Directory Data Provider.
-
Integrate with Live Cassandra Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Cassandra from the MuleSoft Anypoint Platform to integrate live Apache Cassandra into custom reports and dashboards.
-
How to Seamlessly Import eBay Analytics Data into IBM SPSS Modeler
Integrate eBay Analytics data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create SharePoint-Connected Dashboards in Grafana
Connect to SharePoint Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Microsoft SharePoint.
-
Automated Continuous Datadog Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Datadog replication to delimited files (CSV/TSV).
-
Use JayDeBeApi to access ZohoMarketingHub Data in Python
Use standard Python scripting and the development environment of your choice to access live ZohoMarketingHub.
-
Automated Continuous SageHR Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SageHR replication to delimited files (CSV/TSV).
-
Operational Reporting on ZohoDesk Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ZohoDesk.
-
Deploy the ADO.NET Provider for Zuora on an SSRS Report Server
Connect to Zuora 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 work with Delighted Data in Apache Spark using SQL
Access and process Delighted Data in Apache Spark using the CData Software JDBC Driver.
-
Integrating Claude Code CLI with LeadDesk Data 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.
-
Automated Continuous Autopilot Replication to MySQL
Use CData Sync for automated, continuous, customizable Autopilot replication to MySQL.
-
Feed Freshdesk Data into FineReport
How to set Freshdesk as a JDBC data source in FineReport.
-
Automate Odoo Data Replication to SAP HANA
Use CData Sync to customize and automate Odoo ERP replication to SAP HANA.
-
Build Google Campaign Manager 360-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Campaign Manager 360 and build web apps with connectivity to live Google Campaign Manager 360.
-
Integrating Kiro CLI with Google Forms Data 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.
-
Automated Continuous Omnisend Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Omnisend replication to OneLake in Microsoft Fabric.
-
Connect to Act CRM Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Act CRM using standard SQL.
-
Automated Continuous Freshteam Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Freshteam replication to Amazon Redshift.
-
Create Data Visualizations in Cognos BI with Placid Data
Access Placid as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Google Tasks Data from MySQL in Amazon QuickSight
Connect to Google Tasks and build visualizations of Google Tasks using a MySQL Connection in Amazon QuickSight.
-
Integrating LangGraph with Google Cloud Storage Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Google Cloud Storage within automated workflows.
-
Getting Started with the CData ADO.NET Provider for Productboard
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build Visualizations of Dynamics 365 Business Central Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Dynamics 365 Business Central in Birst.
-
Connect to LeadDesk Data in Ruby
Connect to LeadDesk in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData ADO.NET Provider for Toggl
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Query LinkedIn Ads Data as a SQL Server Database in Node.js
Execute SQL Server queries against LinkedIn Ads from Node.js.
-
Back Up Azure Table Storage to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Azure Table. In this article, we will employ an SSIS workflow to populate a database with Azure Table Storage data.
-
Build MVC Applications with Connectivity to Bannerbear Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Bannerbear from an ASP.NET MVC application.
-
Back Up Exact Online to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Exact Online. In this article, we will employ an SSIS workflow to populate a database with Exact Online data.
-
ETL CouchDB in Oracle Data Integrator
This article shows how to transfer Apache CouchDB into a data warehouse using Oracle Data Integrator.
-
How to connect and process CampaignMonitor from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live CampaignMonitor.
-
Connect to Live Amazon S3 Data in MicroStrategy through CData Connect AI
Create a live connection to Amazon S3 Data in CData Connect AI and connect to your Amazon S3 from MicroStrategy.
-
A PostgreSQL Interface for Microsoft Ads Data (MySQL Remoting via JDBC)
Use the Remoting features of the Microsoft Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Provide OData Services of Webflow Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Webflow by developing a WCF Service Application.
-
Automated Continuous Coinbase Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Coinbase replication to Apache Kafka.
-
How to work with Grafana Data in Apache Spark using SQL
Access and process Grafana Data in Apache Spark using the CData Software JDBC Driver.
-
Analyze SAP Ariba Source Data in Cognos Analytics
Use CData Connect AI to connect to SAP Ariba Source Data from Cognos Analytics and analyze live SAP Ariba Source.
-
Getting Started with the CData Python Connector for Zuora
Learn to install and license the CData Python Connector
-
Prepare, Blend, and Analyze Vercel Data in Alteryx Designer (ODBC)
Build workflows to access live Vercel for self-service data analytics.
-
How to Connect DBeaver to Microsoft Entra ID via a JDBC Driver
Manage Microsoft Entra ID with visual tools in DBeaver like the query browser.
-
Automated Continuous Cloudant Replication to SingleStore
Use CData Sync for automated, continuous, customizable Cloudant replication to SingleStore.
-
Automate Snapchat Ads Data Replication to Azure Data Lake
Use CData Sync to customize and automate Snapchat Ads replication to Azure Data Lake.
-
Build Apps with Live Discourse Data Using the Low-Code Development Platform of Mendix
Connect Discourse with Mendix to build apps using the CData API Driver for JDBC.
-
Use the CData API Server to Access Twitter Ads Data in Microsoft PowerPivot
Use the CData API Server to connect to live Twitter Ads in the Power Pivot business intelligence tool.
-
Build an OLAP Cube in SSAS from Coda Data
Establish a connection to Coda data from SQL Server Analysis Services, and use the Coda Data Provider to build OLAP cubes for use in analytics and reporting.
-
Query Gmail Data as a SQL Server Database in Node.js
Execute SQL Server queries against Gmail from Node.js.
-
Build Odoo-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Odoo to explore live Odoo Data in Claude Code to assist with building Odoo-powered applications.
-
Publish Crystal Reports on CapsuleCRM Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date CapsuleCRM.
-
Connect to Sage Cloud Accounting Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Sage Business Cloud Accounting.
-
Automated Continuous FreeAgent Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable FreeAgent replication to Google BigQuery.
-
How to Connect to FormSite Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to FormSite. Leverage the pyodbc module for ODBC in Python.
-
Query WordPress Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume WordPress entities in PHP by modeling them as objects.
-
Automated Continuous Stack Exchange Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Google BigQuery.
-
Getting Started with the CData ADO.NET Provider for Sage 300
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Sage 300.
-
Connect to Zoom Data in RazorSQL
Connect to Zoom from wizards and query Zoom from the GUI in the RazorSQL database management tool.
-
Analyze xBase Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for xBase from Power Pivot. You will use the Table Import Wizard to load xBase. You can visually build the import query or use any SQL supported by the driver.
-
Use JayDeBeApi to access Webflow Data in Python
Use standard Python scripting and the development environment of your choice to access live Webflow.
-
Integrating Codex CLI with SendPulse 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.
-
Connect to ZeroBounce Data from a Connection Pool in JBoss
Integrate ZeroBounce into Java servlets: Use the Management Console in JBoss to install the ZeroBounce JDBC Driver.
-
Explore Geographical Relationships in PingOne Data with Power Map
Create data visualizations with PingOne in Power Map.
-
Create Gumroad Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Gumroad from PowerBI.com to create Power BI Dataflows with real-time data.
-
QuickBooks Online Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on QuickBooks Online facts in real time.
-
Load ZohoMarketingHub Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ZohoMarketingHub to a database.
-
Access YouTube Analytics Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access YouTube Analytics from your Oracle system.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ZohoDesk
Provide connectivity to ZohoDesk through an SAP BusinessObjects universe.
-
Visualize Reckon Accounts Hosted Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Reckon Accounts Hosted.
-
Integrate with Zoho Books Data in JReport Designer
Create charts and reports based on Zoho Books in JReport Designer.
-
Build Semantic Layer Views for Clio Data in APOS Live Data Gateway
Use the CData Connector for Clio in APOS Live Data Gateway to build Semantic Layer Views for Clio.
-
Build REST-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for REST to explore live REST Data in Cursor to assist with building REST-powered applications.
-
Feed PingOne Data into FineReport
How to set PingOne as a JDBC data source in FineReport.
-
Visualize Mailjet Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Mailjet.
-
Connect to Neo4J in SpagoBI
Create reports featuring live Neo4J in SpagoBI Studio. Host Neo4J reports on SpagoBI Server.
-
Connect Paymo Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Paymo using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Visualize SAP Hybris C4C Data in TIBCO Spotfire through ADO.NET
Integrate SAP Hybris C4C into dashboards in TIBCO Spotfire.
-
Create SSAS Tabular Models from JSON Services
How to build a SQL Server Analysis Service Tabular Model from JSON using CData drivers.
-
Prepare, Blend, and Analyze Coda Data in Alteryx Designer (ODBC)
Build workflows to access live Coda for self-service data analytics.
-
Build a PostgreSQL Interface for Oracle Financials Cloud Data using the CData JDBC Driver
Use the Remoting features of the Oracle Financials Cloud JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Avro
Provide connectivity to Apache Avro through an SAP BusinessObjects universe.
-
How to Visualize AgileCRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live AgileCRM in Python.
-
How to Import Data from SuiteCRM into Google Sheets
Import SuiteCRM into a Google spreadsheet that is automatically refreshed.
-
Query Microsoft Exchange Data in ColdFusion
Write standard ColdFusion data access code to connect to Microsoft Exchange.
-
Integrate Live ZendeskSell Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ZendeskSell to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build Dashboards with SingleStore Data in DBxtra
Create dynamic dashboards and perform analytics based on SingleStore in DBxtra.
-
Integrating Codex CLI with Apache Cassandra 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.
-
Automated Continuous GetResponse Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable GetResponse replication to Azure SQL Database.
-
Build MVC Applications with Connectivity to Bugsnag Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Bugsnag from an ASP.NET MVC application.
-
How to Seamlessly Import Unbounce Data into IBM SPSS Modeler
Integrate Unbounce data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.