CData Software - Knowledge Base
Recent Articles
-
Rapidly Develop CircleCI-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 CircleCI.
-
Automated Continuous Oracle Service Cloud Replication to MySQL
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to MySQL.
-
Visualize SAP SuccessFactors Data in Tableau
The CData ODBC driver for SAP SuccessFactors enables you integrate SAP SuccessFactors into Tableau dashboards.
-
Create Power BI Reports on Real-Time Autopilot Data
Use the CData ODBC Driver for Autopilot to visualize Autopilot in Power BI Desktop.
-
Deploy the ADO.NET Provider for Wrike on an SSRS Report Server
Connect to Wrike 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.
-
Feed Pinterest Data into FineReport
How to set Pinterest as a JDBC data source in FineReport.
-
How to Visualize Printful Data in Python with pandas
Use pandas and other modules to analyze and visualize live Printful in Python.
-
How to Query Bitly Data in MySQL Workbench
Execute MySQL queries against live Bitly from MySQL Workbench.
-
Access SQL Server Data from MySQL in Amazon QuickSight
Connect to SQL Server and build visualizations of Microsoft SQL Server using a MySQL Connection in Amazon QuickSight.
-
Publish Excel Online-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Excel Online.
-
Automate Epicor Kinetic Data Replication to Azure Data Lake
Use CData Sync to customize and automate Epicor Kinetic replication to Azure Data Lake.
-
Getting Started with the CData SSIS Components for Adobe Analytics
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Adobe Analytics.
-
Excel Spreadsheet Automation on Wrike Data with the QUERY Formula
Pull data from Wrike, automate spreadsheets, and more with the QUERY formula.
-
How to use SQLAlchemy ORM to access Oracle SCM Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Oracle SCM.
-
Connect to Gong Data from Crystal Reports
Use CData Connect AI to connect to and report on live Gong from Crystal Reports.
-
How to publish and share Shopify Data dashboards with Tableau Server
The CData ODBC driver for Shopify enables you integrate Shopify into Tableau dashboards.
-
Access Live OneNote Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft OneNote in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Live Workday Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Workday from your Google Sheets.
-
Building Dynamic Web Pages with Azure Table Data Using AngularJS
Create single-page applications with live connectivity to Azure Table using the CData API Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zoho Creator
Provide connectivity to Zoho Creator through an SAP BusinessObjects universe.
-
Build Data Flows from Oracle Sales to SQL Server using SSIS
Easily back up Oracle Sales to SQL Server using the SSIS components for Oracle Sales.
-
DataBind HBase Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for HBase with the DevExpress Windows Forms and Web controls to provide Apache HBase to a chart.
-
Import ShipStation Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access ShipStation. In this article, you will use the OData format to import ShipStation into Microsoft Power Query.
-
How to Seamlessly Import WordPress Data into IBM SPSS Modeler
Integrate WordPress data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to and Query Mixpanel Data in QlikView over ODBC
Create data visualizations with Mixpanel in QlikView.
-
Access Live Amazon S3 Data in TIBCO Data Virtualization
Use the Amazon S3 Tibco DV Adapter to create a Amazon S3 data source in TIBCO Data Virtualization Studio and gain access to live Amazon S3 from your TDV Server.
-
Integrating LlamaIndex with Redshift 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 Redshift in real time.
-
Query Codat Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Codat from Node.js.
-
Automate Azure DevOps Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Azure DevOps from PowerShell? This article demonstrates how to utilize the Azure DevOps Cmdlets for tasks like connecting to Azure DevOps, automating operations, downloading data, and more.
-
Migrating data from Box to Databricks using CData SSIS Components.
Easily push Box to Databricks using the CData SSIS Tasks for Box and Databricks.
-
Automate Office 365 Data Replication to Azure Data Lake
Use CData Sync to customize and automate Microsoft Office 365 replication to Azure Data Lake.
-
Analyze Zoho CRM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Zoho CRM in Microsoft R Open.
-
Build Data Flows from SQL Server to Elasticsearch through SSIS
Easily push SQL Server data to Elasticsearch using the CData SSIS Tasks for Elasticsearch.
-
Automate Google Directory Data Replication to Couchbase
Use CData Sync to Customize and automate Google Directory replication to Couchbase.
-
Connect to Databricks Data in RazorSQL
Connect to Databricks from wizards and query Databricks from the GUI in the RazorSQL database management tool.
-
Enable the HubSpot JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with HubSpot.
-
Connect to Coda Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access eBay Analytics Data from MySQL in PHP
Connect to eBay Analytics through the standard MySQL libraries in PHP.
-
Replicate Oracle HCM Cloud Data from PowerShell
Write a quick PowerShell script to query Oracle HCM Cloud. Use connectivity to the live data to replicate Oracle HCM Cloud to SQL Server.
-
Use the CData API Server to Access MYOB AccountRight Data in Microsoft PowerPivot
Use the CData API Server to connect to live MYOB AccountRight in the Power Pivot business intelligence tool.
-
Connect to Greenplum Data in DBeaver
Use the CData ODBC Driver to connect to Pivotal GreenPlum in DBeaver.
-
Build Visualizations of Klaviyo Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Klaviyo in Birst.
-
Build Apps with Live Active Directory Data Using the Low-Code Development Platform of Mendix
Connect Active Directory with Mendix to build apps using the CData JDBC Driver for Active Directory.
-
Automated SAP Netweaver Gateway Data Replication to Teradata
Use CData Sync to Customize and automate SAP Netweaver Gateway replication to Teradata.
-
How to work with Salesloft Data in Apache Spark using SQL
Access and process Salesloft Data in Apache Spark using the CData Software JDBC Driver.
-
Integrating Codex CLI with Apollo 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 SendInBlue to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SendInBlue using the CData Python MCP Server.
-
Visualize Live Cloudant Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live IBM Cloudant into custom reports in Power BI.
-
Natively Connect to Highrise Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Highrise CRM. Leverage the native support for ODBC in PHP.
-
Provide OData Services of Onfleet Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Onfleet by developing a WCF Service Application.
-
Build a Singer.io Tap for Elorus With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Elorus data using
-
Analyze AfterShip Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze AfterShip with the CData JDBC Driver for AfterShip.
-
Publish Oracle Financials Cloud-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Oracle Financials Cloud.
-
Visualize Mailgun Data in TIBCO Spotfire through ADO.NET
Integrate Mailgun into dashboards in TIBCO Spotfire.
-
Build MVC Applications with Connectivity to Parquet Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Parquet from an ASP.NET MVC application.
-
Integrating Antigravity CLI with SAP Business Warehouse via CData CLI
Connect SAP Business Warehouse to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create a Data Access Object for Aweber Data using JDBI
A brief overview of creating a SQL Object API for Aweber in JDBI.
-
Use the CData Software ODBC Driver for MailerLite in MicroStrategy Web
Connect to MailerLite in MicroStrategy Web using the CData Software ODBC Driver for MailerLite.
-
Access Live Active Directory Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Active Directory from your Google Sheets.
-
Automated Continuous PagerDuty Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable PagerDuty replication to delimited files (CSV/TSV).
-
How to Design Lakebase Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Lakebase from mobile and tablet Power Apps.
-
How to Query Freshteam Data in MySQL Workbench
Execute MySQL queries against live Freshteam from MySQL Workbench.
-
Migrating data from Perplexity to Databricks using CData SSIS Components.
Easily push Perplexity to Databricks using the CData SSIS Tasks for Perplexity and Databricks.
-
How to create Visio diagrams from SharePoint Data
Automatically update Microsoft SharePoint with the changes you make to Visio master shapes.
-
Integrating Antigravity CLI with Apache Hive via CData CLI
Connect Apache Hive to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Trigger Salesforce IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Salesforce with standard wizards in Logic Apps.
-
Square Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Square facts in real time.
-
Integrating Tickspot Data in Talend Cloud Data Management Platform
Connect Tickspot Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to connect to PayPal Data from Spring Boot
Connect to PayPal in a Spring Boot Application using the CData JDBC Driver for PayPal
-
Access Live Snapchat Ads Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Snapchat Ads from your Excel spreadsheets.
-
How to connect to ServiceDesk Plus Data with Squirrel SQL client
Connect to ServiceDesk Plus and execute queries in the Squirrel SQL Client.
-
Connect to Google Campaign Manager 360 Data in Jaspersoft Studio
Execute SQL to remote Google Campaign Manager 360 in Jaspersoft Studio.
-
How to Connect to Live Google Spanner Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Google Spanner for you.
-
A PostgreSQL Interface for Webflow Data (MySQL Remoting via JDBC)
Use the Remoting features of the Webflow JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build an OLAP Cube in SSAS from Hive Data
Establish a connection to Apache Hive data from SQL Server Analysis Services, and use the Hive Data Provider to build OLAP cubes for use in analytics and reporting.
-
Consume Oracle SCM OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Oracle SCM feeds that reflect any changes in SAP Lumira.
-
Automated Continuous Kintone Replication to Oracle
Use CData Sync for automated, continuous, customizable Kintone replication to Oracle.
-
Getting Started with the CData ADO.NET Provider for Oracle Financials Cloud
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Oracle Financials Cloud.
-
Build Charts with Box Data in Clear Analytics
Create dynamic charts and perform analytics based on Box in Clear Analytics.
-
How to Query Live Hive Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Apache Hive data in natural language using Python.
-
Access Salesforce CRM Analytics Data from MySQL in Amazon QuickSight
Connect to Salesforce CRM Analytics and build visualizations of Salesforce CRM Analytics using a MySQL Connection in Amazon QuickSight.
-
Query Billsby Data in DataGrip
Create a Data Source for Billsby in DataGrip and use SQL to query live Billsby.
-
Create Data Visualizations Based On Authorize.Net Data in Mode
Use CData Connect AI to connect to Authorize.Net Data from Mode and build visualizations using live
-
Connect to Facebook Ads Data in Google Apps Script via Connect AI
Use CData Connect AI to access Facebook Ads in Google Apps Script.
-
How to connect PolyBase to Databricks
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Databricks.
-
Build Charts with Parquet Data in Clear Analytics
Create dynamic charts and perform analytics based on Apache Parquet in Clear Analytics.
-
How to integrate Metabase with NetSuite Data
Use CData Connect AI to connect to live NetSuite CRM & ERP and create an interactive dashboard in Metabase from NetSuite CRM & ERP.
-
Connect to Mailjet Data in HULFT Integrate
Connect to Mailjet as a JDBC data source in HULFT Integrate
-
Redshift Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Redshift facts in real time.
-
Access Live Power BI XMLA Data in AWS Lambda
Connect to live Power BI XMLA in AWS Lambda using the CData JDBC Driver.
-
Connect to Adobe Analytics Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Adobe Analytics using standard SQL.
-
Use the CData Software JDBC Driver for Tavily in MicroStrategy Web
Connect to Tavily in MicroStrategy Web using the CData Software JDBC Driver for Tavily.
-
Visualize Confluence Data in Sisense
Create an ElastiCube in Sisense app with access to Atlassian Confluence.
-
Automate GraphQL Data Replication to Couchbase
Use CData Sync to Customize and automate GraphQL replication to Couchbase.
-
How to Access SharePoint Excel Services Data Using Entity Framework
This article shows how to access SharePoint Excel Services using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Stream EmailOctopus Data into Apache Kafka Topics
Access and stream EmailOctopus in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect HubDB Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your HubDB using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect Oracle Financials Cloud to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Oracle Financials Cloud using the CData Python MCP Server.
-
How to Access Live Google Tasks Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Tasks enables you to integrate Google Tasks into workflows built using Microsoft Power Automate Desktop.
-
Trigger Cvent IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Cvent with standard wizards in Logic Apps.