CData Software - Knowledge Base
Recent Articles
-
How to Visualize Coinbase Data in Python with pandas
Use pandas and other modules to analyze and visualize live Coinbase in Python.
-
Use the CData Software JDBC Driver for SendPulse in MicroStrategy
Connect to SendPulse in MicroStrategy Developer using the CData Software JDBC Driver for SendPulse.
-
Automated Continuous Couchbase Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Couchbase replication to Amazon S3.
-
LINQ to Hacker News 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 Hacker News Data Provider.
-
Integrate Live Freshsales Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Freshsales to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to import Blackbaud FE NXT Data into Apache Solr
Use the CData Software JDBC Driver for Blackbaud FE NXT in Data Import Handler and create an automated import of Blackbaud FE NXT to Apache Solr Enterprise Search platform.
-
Use the CData Software JDBC Driver for Jumpseller in MicroStrategy
Connect to Jumpseller in MicroStrategy Developer using the CData Software JDBC Driver for Jumpseller.
-
Using the CData Software ODBC Driver for Delighted in PyCharm
Connect to Delighted as an ODBC data source in PyCharm using the CData Software ODBC Driver for Delighted.
-
How to Connect DBeaver to ZohoInvoice via a JDBC Driver
Manage ZohoInvoice with visual tools in DBeaver like the query browser.
-
Connect to Splunk Data in Jaspersoft Studio
Execute SQL to remote Splunk in Jaspersoft Studio.
-
Connect to Live Phoenix Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Phoenix in CData Connect AI and connect to your Apache Phoenix from PostgreSQL.
-
Use Manus AI to Talk to Your Asana 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 Asana.
-
Create Aha! Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Aha! data access from reports, embedded analytics, and more.
-
Choosing the Best Method to Connect Splunk to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Splunk from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Datasets from Cohere in Domo Workbench and Build Visualizations of Cohere Data in Domo
Use the CData Software ODBC Driver for Cohere to create datasets from Cohere in Domo Workbench and then build visualizations in the Domo service.
-
Query GitLab Data through ODBC in Node.js
Use node-odbc to execute SQL queries against GitLab from Node.js.
-
Access Live LinkedIn Data in AWS Lambda (with IntelliJ IDEA)
Connect to live LinkedIn in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Mode Data in Sisense
Create an ElastiCube in Sisense app with access to Mode.
-
Getting Started with the CData SSIS Components for Pingdom
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Pingdom.
-
Access Live Avaza Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Avaza into the statistical analysis tools available in SAS JMP. This article shows how to use Avaza in the Graph Builder and Query Builder.
-
Connect Apify to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Apify using the CData Python MCP Server.
-
Use JayDeBeApi to access Jira Assets Data in Python
Use standard Python scripting and the development environment of your choice to access live Jira Assets.
-
Connect to ConvertAPI Data in NetBeans
Connect to ConvertAPI in NetBeans with the data source configuration wizard.
-
Feed MongoDB Data into FineReport
How to set MongoDB as a JDBC data source in FineReport.
-
Integrating OpenCode Terminal with Apollo 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 SuiteCRM Replication to Oracle
Use CData Sync for automated, continuous, customizable SuiteCRM replication to Oracle.
-
Design BIRT Reports on Adobe Commerce Data
Provide current Adobe Commerce to your embedded analytics.
-
Excel Spreadsheet Automation on Raisers Edge NXT Data with the QUERY Formula
Pull data from Raisers Edge NXT, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous SharePoint Excel Services Replication to Databricks
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Databricks.
-
Build a Singer.io Tap for Gmail With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Gmail data using
-
Build an OLAP Cube in SSAS from SAP Business One Data
Establish a connection to SAP Business One data from SQL Server Analysis Services, and use the SAP Business One Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use ChatGPT to Talk to Your SurveyMonkey 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 SurveyMonkey for you.
-
Access LeadDesk Data from MySQL in Amazon QuickSight
Connect to LeadDesk and build visualizations of LeadDesk using a MySQL Connection in Amazon QuickSight.
-
Connect to Tanda Data in DBeaver
Use the CData ODBC Driver to connect to Tanda in DBeaver.
-
Connect to Rootly Data in Aqua Data Studio
Access Rootly from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect Egnyte to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Egnyte with IBM WebSphere for seamless data integration and connectivity.
-
Build AI/ML Models with Live SendGrid Data using Dataiku
Connect SendGrid Data with Dataiku using the CData JDBC Driver for SendGrid.
-
How to Seamlessly Import Cohere Data into IBM SPSS Modeler
Integrate Cohere data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Provide OData Services of QuickBooks Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for QuickBooks Desktop by developing a WCF Service Application.
-
Automated Continuous VWO Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable VWO replication to Google BigQuery.
-
Easily Integrate Facebook Ads Data in Lazarus Pascal IDE
Learn how to easily integrate live Facebook Ads in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Google Analytics Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Analytics and the SQL Gateway to access Google Analytics from Google Apps Script.
-
Import Real-Time Aweber Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Aweber in ColdFusion.
-
Load Workday Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Workday to a database.
-
Access Live Cosmos DB Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Azure Cosmos DB from your Excel spreadsheets.
-
Use the CData Software ODBC Driver for Brex in MicroStrategy
Connect to Brex in MicroStrategy Developer using the CData Software ODBC Driver for Brex.
-
Automated Continuous Google Ad Manager Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to AlloyDB.
-
Provide OData Services of Dynamics CRM Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft Dynamics CRM by developing a WCF Service Application.
-
Use CData Connect AI to Access Sybase Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Sybase in the Power Pivot business intelligence tool.
-
Create Informatica Mappings From/To an ODBC Data Source for Keap
Create an ODBC connection to Keap in Informatica and browse and transfer Keap.
-
Build Dashboards with iContact Data in DBxtra
Create dynamic dashboards and perform analytics based on iContact in DBxtra.
-
Access FreeAgent 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 FreeAgent.
-
Explore Geographical Relationships in TaxJar Data with Power Map
Create data visualizations with TaxJar in Power Map.
-
Migrating data from Webflow to Snowflake using CData SSIS Components.
Easily push Webflow to Snowflake using the CData SSIS Tasks for Webflow and Snowflake.
-
Import Real-Time Sage 200 Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Sage 200 in ColdFusion.
-
Build Visualizations of eBay Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of eBay in Birst.
-
Access Live BenchmarkEmail Data in AWS Lambda (with IntelliJ IDEA)
Connect to live BenchmarkEmail in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Semantic Layer Views for Google Analytics Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Analytics.
-
Build MVC Applications with Connectivity to HelloSign Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access HelloSign from an ASP.NET MVC application.
-
Build WooCommerce-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for WooCommerce to explore live WooCommerce Data in GitHub Copilot to assist with building WooCommerce-powered applications.
-
Integrate Egnyte with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Egnyte with External Services.
-
Connect to HubSpot Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for HubSpot to connect to HubSpot and execute queries in PowerBuilder.
-
Getting Started with the CData Python Connector for Zoho Recruit
Learn to install and license the CData Python Connector
-
Getting Started with the CData ADO.NET Provider for PivotalTracker
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrating OpenCode Terminal with Twilio 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.
-
A PostgreSQL Interface for ZohoDesk Data using the CData ODBC Driver
Use the SQL Gateway and ZohoDesk ODBC Driver to create a PostgreSQL entry-point for data access.
-
Rapidly Develop Google Analytics-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 Google Analytics.
-
Building Dynamic Web Pages with GraphQL Data Using AngularJS
Create single-page applications with live connectivity to GraphQL using the CData API Server.
-
A PostgreSQL Interface for ZohoInvoice Data (MySQL Remoting via JDBC)
Use the Remoting features of the ZohoInvoice JDBC Driver to create a PostgreSQL entry-point for data access.
-
Edit and Search External Tally Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Tally ERP to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Tally Data objects that you can access from apps and the dashboard.
-
Create Informatica Mappings From/To an ODBC Data Source for SingleStore
Create an ODBC connection to SingleStore in Informatica and browse and transfer SingleStore.
-
Getting Started with the CData Python Connector for SurveyMonkey
Learn to install and license the CData Python Connector
-
Connect to VWO Data from a Connection Pool in JBoss
Integrate VWO into Java servlets: Use the Management Console in JBoss to install the VWO JDBC Driver.
-
Connect FormSite to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect FormSite with IBM WebSphere for seamless data integration and connectivity.
-
Create Dynamic QuickBooks Grids Using the Infragistics XamDataGrid
Learn how you can connect QuickBooks to Infragistics XamDataGrid to build dynamic grids.
-
Operational Reporting on Google Ad Manager Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Ad Manager.
-
How to Query SharePoint Excel Services Data in MySQL Workbench
Execute MySQL queries against live SharePoint Excel Services from MySQL Workbench.
-
How to load Excel data into Elasticsearch via Logstash
Introducing a simple method to load Excel data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live Jira 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 Atlassian Jira through MCP integration.
-
Access Anaplan 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 Anaplan.
-
How to connect to Figshare Data with Squirrel SQL client
Connect to Figshare and execute queries in the Squirrel SQL Client.
-
How to Connect to Live Amazon DynamoDB 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 Amazon DynamoDB for you.
-
Connect to Pinecone in SpagoBI
Create reports featuring live Pinecone in SpagoBI Studio. Host Pinecone reports on SpagoBI Server.
-
Stack Exchange Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Stack Exchange facts in real time.
-
Build an OLAP Cube in SSAS from Autopilot Data
Establish a connection to Autopilot data from SQL Server Analysis Services, and use the Autopilot Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to connect to Pipedrive Data from Spring Boot
Connect to Pipedrive in a Spring Boot Application using the CData JDBC Driver for Pipedrive
-
Automated Continuous SAP HANA XS Advanced Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to OneLake in Microsoft Fabric.
-
Connect to Phoenix Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Phoenix as an External Source in Dremio.
-
Connect to Keap Data from a Connection Pool in Jetty
The Keap JDBC Driver supports connection pooling: This article shows how to connect faster to Keap from Web apps in Jetty.
-
Analyze Google Sheets Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Sheets and visualize live Google Sheets in Infragistics Reveal.
-
Integrate Live Facebook Ads Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Design BIRT Reports on LinkedIn Data
Provide current LinkedIn to your embedded analytics.
-
Easily Integrate VWO Data in Lazarus Pascal IDE
Learn how to easily integrate live VWO in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData Python Connector for Webflow
Learn to install and license the CData Python Connector
-
Connect to Flowlu Data in Aqua Data Studio
Access Flowlu from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Wave Financial
Provide connectivity to Wave Financial through an SAP BusinessObjects universe.
-
Use Dash to Build to Web Apps on OneNote Data
Create Python applications that use pandas and Dash to build OneNote-connected web apps.
-
How to Connect the Power BI Service to Oracle Service Cloud: Complete Guide
Connect to the CData Software Power BI Connector for Oracle Service Cloud from PowerBI.com to provide real-time Oracle Service Cloud across the organization.
-
How to Easily Query CircleCI Data in OpenOffice Base
Connect to CircleCI data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous PabblySubscriptions Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Google Cloud SQL.