CData Software - Knowledge Base
Recent Articles
-
Access GitHub Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live GitHub from HeidiSQL.
-
Visualize HBase Data in Tableau
The CData ODBC driver for HBase enables you integrate Apache HBase into Tableau dashboards.
-
DataBind Controls to Onfleet Data in Delphi
DataBind to Onfleet in Delphi with standard data access components and controls.
-
Extract, Transform, and Load Excel Data in Informatica PowerCenter
Create a simple Workflow for Microsoft Excel in Informatica PowerCenter.
-
Rapidly Develop Elasticsearch-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 Elasticsearch.
-
Visualize Live Avro Data in the Power BI Service
Use CData Connect AI to connect to live Apache Avro and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Consume Google Spanner OData Feeds in PowerBuilder
This article demonstrates how to consume Google Spanner as OData feeds from PowerBuilder using the API Server.
-
Access Klaviyo Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Klaviyo from your Oracle system.
-
Import and Visualize Sybase IQ Data in Power View
Create data visualizations based on Sybase IQ in Excel.
-
Easily Integrate Sage Intacct Data in Lazarus Pascal IDE
Learn how to easily integrate live Sage Intacct in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create a Data Access Object for Oracle Eloqua Reporting Data using JDBI
A brief overview of creating a SQL Object API for Oracle Eloqua Reporting in JDBI.
-
Connect to Zoho Creator Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Zoho Creator in the Denodo Virtual DataPort Administrator.
-
Connect Productboard Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Productboard using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Configure the CData JDBC Driver for Facebook in a Connection Pool in Tomcat
Connect to Facebook from a connection pool in Tomcat.
-
Use the CData API Server to Access Amazon S3 Data in Microsoft PowerPivot
Use the CData API Server to connect to live Amazon S3 in the Power Pivot business intelligence tool.
-
Use Dash to Build to Web Apps on Paddle Data
Create Python applications that use pandas and Dash to build Paddle-connected web apps.
-
How to Easily Query Quickbase Data in OpenOffice Base
Connect to Quickbase data in OpenOffice Base using the CData ODBC Driver for Quickbase and generate reports with live data insights.
-
Build Landbot-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Landbot and build web apps with connectivity to live Landbot.
-
Stream Foursquare Data into Apache Kafka Topics
Access and stream Foursquare in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Query, Visualize, and Share live Zoho Inventory Data in Redash
Use CData Connect AI to connect to live Zoho Inventory in Redash for querying, visualizing, and sharing.
-
How to integrate Flowlu with Apache Airflow
Access and process Flowlu in Apache Airflow using the CData JDBC Driver.
-
Integrate Cline with Live Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Exchange from within your IDE.
-
How to import Flowlu Data into Apache Solr
Use the CData Software JDBC Driver for Flowlu in Data Import Handler and create an automated import of Flowlu to Apache Solr Enterprise Search platform.
-
Explore Geographical Relationships in Eventbrite Data with Power Map
Create data visualizations with Eventbrite in Power Map.
-
Integrate Live Sybase Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Sybase and integrate live Sybase into apps built in Microsoft Power Apps.
-
Integrate with Humanity Data in JReport Designer
Create charts and reports based on Humanity in JReport Designer.
-
Access Live Power BI XMLA Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Power BI XMLA from your Google Sheets.
-
Use Dash to Build Web Apps on Cosmos DB Data via CData Connect AI
Build interactive Dash web apps on live Azure Cosmos DB using pandas and the CData Connect AI Python SDK.
-
Bidirectional Access to Jira Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Atlassian Jira in Filemaker Pro for Mac or Windows.
-
Back Up CSV/TSV Files to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for CSV. In this article, we will employ an SSIS workflow to populate a database with CSV/TSV Files data.
-
How to connect PolyBase to Zoho Inventory
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Zoho Inventory.
-
Build MVC Applications with Connectivity to Blackbaud FE NXT Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Blackbaud FE NXT from an ASP.NET MVC application.
-
How to Access Live TigerGraph Data in Power Automate Desktop via ODBC
The CData ODBC Driver for TigerGraph enables you to integrate TigerGraph into workflows built using Microsoft Power Automate Desktop.
-
DataBind Controls to Jira Assets Data in C++Builder
DataBind to Jira Assets in C++Builder with standard components and controls.
-
Bidirectional Access to Miro Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Miro in Filemaker Pro for Mac or Windows.
-
Access Exact Online Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Exact Online from HeidiSQL.
-
Consume SAP HANA OData Feeds in PowerBuilder
This article demonstrates how to consume SAP HANA as OData feeds from PowerBuilder using the API Server.
-
Getting Started with the CData JDBC Driver for Simplesat
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Simplesat.
-
Automated Continuous eBay Analytics Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable eBay Analytics replication to PostgreSQL.
-
Getting Started with the CData Excel Add-In for Dynamics 365
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Dynamics 365.
-
Shopify Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Shopify facts in real time.
-
Integrate Sage Intacct Data in Pentaho Data Integration
Build ETL pipelines based on Sage Intacct in the Pentaho Data Integration tool.
-
How to Visualize xBase Data in Python with pandas
Use pandas and other modules to analyze and visualize live xBase in Python.
-
How to Connect to Xero Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Xero Accounting. Leverage the pyodbc module for ODBC in Python.
-
Process & Analyze Retently Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Retently Data.
-
LINQ to SAS Data Sets 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 SAS Data Sets Data Provider.
-
How to Access Amazon Marketplace Data Using Entity Framework
This article shows how to access Amazon Marketplace using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Discord Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Discord replication to Google BigQuery.
-
Integrate Cline with Live Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Teams from within your IDE.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Teradata
Provide connectivity to Teradata through an SAP BusinessObjects universe.
-
How to Query Live Google Ads Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Ads data in natural language using Python.
-
Access Live DocuSign Data in Coginiti Pro
Connect to and query live DocuSign from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Build an ETL App for Tavily Data in Python with CData
Create ETL applications and real-time data pipelines for Tavily in Python with petl.
-
View Reports on Real-Time Greenplum Data in Power BI Report Server
Use the CData ODBC Driver for Greenplum to visualize Pivotal GreenPlum in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData Python Connector for Drift
Learn to install and license the CData Python Connector
-
Integrate Azure Analysis Services Data into Power Automate Desktop using CData Connect
CData Connect for Azure Analysis Services Data enables you to integrate Azure Analysis Services into workflows built using Microsoft Power Automate Desktop.
-
Integrating GitHub Copilot CLI with Salesforce Data 360 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.
-
How to Build an ETL App for Greenhouse Data in Python with CData Connect AI
Build ETL pipelines that read and write live Greenhouse in Python with petl and the CData Connect AI Python SDK.
-
Natively Connect to Teradata Data in PHP
The CData ODBC driver for Teradata enables you to create PHP applications with connectivity to Teradata. Leverage the native support for ODBC in PHP.
-
Add Aha! Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Aha! with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData Software ODBC Driver for Pipeliner CRM in MicroStrategy Desktop
Connect to Pipeliner CRM in MicroStrategy Desktop using the CData Software ODBC Driver for Pipeliner CRM.
-
DataBind Controls to Hugging Face Data in C++Builder
DataBind to Hugging Face in C++Builder with standard components and controls.
-
Create Power BI Reports on Real-Time Calendly Data
Use the CData ODBC Driver for Calendly to visualize Calendly in Power BI Desktop.
-
Automate SendInBlue Data Replication to Azure Data Lake
Use CData Sync to customize and automate SendInBlue replication to Azure Data Lake.
-
Natively Connect to Wrike Data in PHP
The CData ODBC driver for Wrike enables you to create PHP applications with connectivity to Wrike. Leverage the native support for ODBC in PHP.
-
Process & Analyze HDFS Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live HDFS Data.
-
Publish Opsgenie-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Opsgenie.
-
Publish Crystal Reports on ShipEngine Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ShipEngine.
-
How to Connect to Live Act CRM 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 Act CRM for you.
-
Build Apps with Live Drift Data Using the Low-Code Development Platform of Mendix
Connect Drift with Mendix to build apps using the CData API Driver for JDBC.
-
Replicate Multiple Salesforce CRM Analytics Accounts via the CData Sync CLI
Replicate multiple Salesforce CRM Analytics accounts to one or many databases.
-
How to Connect to Stack Exchange Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Stack Exchange. Leverage the pyodbc module for ODBC in Python.
-
Integrate Cline with Live Lakebase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Lakebase from within your IDE.
-
Connect to Front in SpagoBI
Create reports featuring live Front in SpagoBI Studio. Host Front reports on SpagoBI Server.
-
Explore Geographical Relationships in Mistral AI Data with Power Map
Create data visualizations with Mistral AI in Power Map.
-
Connect to xBase Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for xBase and the SQL Gateway to access xBase from Google Apps Script.
-
LINQ to Salesforce Pardot 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 Salesforce Pardot Data Provider.
-
Visualize Superchat Data in Sisense
Create an ElastiCube in Sisense app with access to Superchat.
-
How to Query Highrise Data in MySQL Workbench
Execute MySQL queries against live Highrise CRM from MySQL Workbench.
-
Automated Continuous API Replication to SQLite
Use CData Sync for automated, continuous, customizable API replication to SQLite.
-
Analyze Live Jira Data in SAS Viya
Use CData Connect AI to connect to Atlassian Jira from SAS Viya and deploy self-service analytics using live Atlassian Jira.
-
Integrate Omnisend with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Omnisend with External Services.
-
Automated Continuous Cloudant Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable IBM Cloudant replication to OneLake in Microsoft Fabric.
-
Visualize Live Testmonitor Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Testmonitor using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Import and Visualize Brex Data in Power View
Create data visualizations based on Brex in Excel.
-
Connect to Adobe Commerce Data in RazorSQL
Connect to Adobe Commerce from wizards and query Adobe Commerce from the GUI in the RazorSQL database management tool.
-
Visualize Live Slack Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Slack using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Bannerbear Data in CloverDX (formerly CloverETL)
Transfer Bannerbear using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous Moosend Replication to Snowflake
Use CData Sync for automated, continuous, customizable Moosend replication to Snowflake.
-
Model Vertica Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Vertica, enabling the direct import of real-time Vertica.
-
Query Hubstaff Data as a MySQL Database in Node.js
Execute MySQL queries against Hubstaff from Node.js.
-
Create Dropbox Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Dropbox from PowerBI.com to create Power BI Dataflows with real-time data.
-
Query Snowflake Data in ColdFusion
Write standard ColdFusion data access code to connect to Snowflake.
-
Integrate Live RSS Feeds into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live RSS Feeds to Blue Prism using the CData ODBC Driver for RSS to create automated workflows for repetitive business tasks.
-
How to Easily Query MariaDB Data in OpenOffice Base
Connect to MariaDB data in OpenOffice Base using the CData ODBC Driver for MariaDB and generate reports with live data insights.
-
Moving Data from Zoho Inventory to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Zoho Inventory data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Contentful Data from a Connection Pool in JBoss
Integrate Contentful into Java servlets: Use the Management Console in JBoss to install the Contentful JDBC Driver.
-
Connect to and Visualize Live GetResponse Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live GetResponse.
-
Visualize Azure Analysis Services Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Azure Analysis Services.
-
Access Live Discord Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Discord into the statistical analysis tools available in SAS JMP. This article shows how to use Discord in the Graph Builder and Query Builder.