CData Software - Knowledge Base
Recent Articles
-
Connect to OneNote Data as an External Source in Dremio
Use the CData JDBC Driver to connect to OneNote as an External Source in Dremio.
-
Automated Continuous PolarTeamPro Replication to Vertica
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to Vertica.
-
How to import Google Directory Data into Apache Solr
Use the CData Software JDBC Driver for Google Directory in Data Import Handler and create an automated import of Google Directory to Apache Solr Enterprise Search platform.
-
DataBind Charts to TaxJar Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to TaxJar from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Using the CData Software ODBC Driver for Keap in PyCharm
Connect to Keap as an ODBC data source in PyCharm using the CData Software ODBC Driver for Keap.
-
Configure the CData JDBC Driver for XML in a Connection Pool in Tomcat
Connect to XML Files from a connection pool in Tomcat.
-
Natively Connect to CSV Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to CSV/TSV Files. Leverage the native support for ODBC in PHP.
-
Automated Continuous Amazon DynamoDB Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to AlloyDB.
-
Write a Simple Go Application to work with Oracle Service Cloud Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Oracle Service Cloud.
-
Integrate Live AlloyDB Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google AlloyDB and integrate live Google AlloyDB into apps built in Microsoft Power Apps.
-
How to connect PolyBase to HelloSign
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live HelloSign.
-
How to Work with Azure Data Catalog Data in AWS Glue Jobs Using JDBC
Connect to Azure Data Catalog from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Import Data from HubDB into Google Sheets
Import HubDB into a Google spreadsheet that is automatically refreshed.
-
Enable the Klaviyo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Klaviyo.
-
Getting Started with the CData Tableau Connector for Avro
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Avro.
-
Connect to Excel Online Data in RapidMiner
Integrate Microsoft Excel Online with standard components and data source configuration wizards in RapidMiner Studio.
-
Manage FreeAgent Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for FreeAgent.
-
Prepare, Blend, and Analyze Adobe Commerce Data in Alteryx Designer (Connect AI)
Build workflows to access live Adobe Commerce for self-service data analytics.
-
Access Live Zoom Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Zoom through MCP integration.
-
Design BIRT Reports on Paddle Data
Provide current Paddle to your embedded analytics.
-
Access Live Dropbox Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Dropbox from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to publish and share Supabase Data dashboards with Tableau Server
The CData ODBC driver for Supabase enables you integrate Supabase into Tableau dashboards.
-
Migrating data from HubDB to Google BigQuery using CData SSIS Components.
Easily push HubDB to Google BigQuery using the CData SSIS Tasks for HubDB and Google BigQuery.
-
How to Connect to Placid Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Placid. Leverage the pyodbc module for ODBC in Python.
-
Natively Connect to Google Calendar Data in PHP
The CData ODBC driver for Google Calendar enables you to create PHP applications with connectivity to Google Calendar. Leverage the native support for ODBC in PHP.
-
Connect to Hubstaff Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Hubstaff as an External Source in Dremio.
-
Build MVC Applications with Connectivity to SAP BusinessObjects BI Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP BusinessObjects BI from an ASP.NET MVC application.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Zoho Inventory actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Operational Reporting on Pipeliner CRM Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Pipeliner CRM.
-
A PostgreSQL Interface for Rebilly Data (MySQL Remoting via JDBC)
Use the Remoting features of the Rebilly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Establish a Live Connection with SharePoint Excel Services Data using Tableau Bridge
The CData ODBC Driver for SharePoint Excel Services enables you to integrate live SharePoint Excel Services into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Everhour Data from MySQL in PHP
Connect to Everhour through the standard MySQL libraries in PHP.
-
Import FTP Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to FTP Data and provide access to live FTP Servers for custom reports in the Power BI Service.
-
Access Live Xero 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 Xero Accounting through MCP integration.
-
How to Work with Reckon Accounts Hosted Data in AWS Glue Jobs Using JDBC
Connect to Reckon Accounts Hosted from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Google Calendar Data in Ruby
Connect to Google Calendar in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build an OLAP Cube in SSAS from Zoom Data
Establish a connection to Zoom data from SQL Server Analysis Services, and use the Zoom Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData ODBC Driver for Exa from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Exa to connect to Exa from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Exa in Excel.
-
Visualize HCL Domino Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load HCL Domino into TIBCO Spotfire.
-
Automated Continuous Bullhorn CRM Replication to Vertica
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to Vertica.
-
Connect to SAP BusinessObjects BI Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP BusinessObjects BI from Crystal Reports.
-
Work with Codat Data in FoxPro
Load Codat into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Connect the Power BI Service to Pinecone: Complete Guide
Connect to the CData Software Power BI Connector for Pinecone from PowerBI.com to provide real-time Pinecone across the organization.
-
How to Query Live Vimeo Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Vimeo data in natural language using Python.
-
Integrate with live Office 365 Data in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft Office 365 in Jitterbit.
-
Import and Visualize Phoenix Data in Power View
Create data visualizations based on Apache Phoenix in Excel.
-
DataBind Oracle Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Oracle with the DevExpress Windows Forms and Web controls to provide Oracle Database to a chart.
-
Access Sendwithus Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sendwithus from your Oracle system.
-
Query Grafana Data as a MySQL Database in Node.js
Execute MySQL queries against Grafana from Node.js.
-
Build a Simple VCL Application for Mode Data
How to build a simple VCL Application to view Mode in RAD Studio using the CData ODBC Driver for Mode.
-
Create Reports with Perplexity Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Perplexity.
-
Connect to OData Services Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for OData and the Script function in FileMaker Pro to connect to OData and work with OData in your FileMaker application.
-
Design BIRT Reports on PolarTeamPro Data
Provide current PolarTeamPro to your embedded analytics.
-
Analyze Suadeo Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Suadeo and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Dashboards with GraphQL Data in DBxtra
Create dynamic dashboards and perform analytics based on GraphQL in DBxtra.
-
Connect to Live CouchDB Data in MicroStrategy through CData Connect AI
Create a live connection to CouchDB Data in CData Connect AI and connect to your Apache CouchDB from MicroStrategy.
-
Configure the CData JDBC Driver for HelloSign in a Connection Pool in Tomcat
Connect to HelloSign from a connection pool in Tomcat.
-
Build Couchbase Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Couchbase and build visualizations in Tableau Cloud.
-
DataBind Charts to Avalara AvaTax Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Avalara AvaTax from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
How to Easily Query Everhour Data in OpenOffice Base
Connect to Everhour data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous Amazon S3 Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Amazon S3 replication to Apache Kafka.
-
Access Live Opsgenie Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Opsgenie in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access CampaignMonitor Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access CampaignMonitor from your Oracle system.
-
Getting Started with the CData Excel Add-In for Adobe Experience Manager
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Adobe Experience Manager.
-
Connect to Azure Data Lake Storage Data in HULFT Integrate
Connect to Azure Data Lake Storage as a JDBC data source in HULFT Integrate
-
Add LeadDesk Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for LeadDesk with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Real-Time CSV Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for CSV and Dataflow to import and use CSV/TSV Files in Power Apps.
-
How to Visualize Mailgun Data in Python with pandas
Use pandas and other modules to analyze and visualize live Mailgun in Python.
-
Build Data Flows from Box to SQL Server using SSIS
Easily back up Box to SQL Server using the SSIS components for Box.
-
Publish Crystal Reports on MongoDB Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date MongoDB.
-
Use Agno to Talk to Your ShipStation 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 ShipStation for you.
-
Automated Continuous SAP SuccessFactors Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to Vertica.
-
Work with OneNote Data in FoxPro
Load Microsoft OneNote into a FoxPro database. This article includes full code and a walk-through of the process.
-
Import Real-Time Apollo Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Apollo in ColdFusion.
-
Provide OData Services of Everhour Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Everhour by developing a WCF Service Application.
-
Connect to XML Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for XML Files.
-
Getting Started with the CData Python Connector for Vimeo
Learn to install and license the CData Python Connector
-
A PostgreSQL Interface for Act-On Data using the CData ODBC Driver
Use the SQL Gateway and Act-On ODBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Confluence Data in Looker
Use CData Connect AI to connect to Confluence Data from Looker and build custom apps using live Atlassian Confluence.
-
Automated Continuous Azure Synapse Replication to MongoDB
Use CData Sync for automated, continuous, customizable Azure Synapse replication to MongoDB.
-
Integrate with Live SAP SuccessFactors Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAP SuccessFactors from the MuleSoft Anypoint Platform to integrate live SAP SuccessFactors into custom reports and dashboards.
-
Build Elasticsearch Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Elasticsearch and build visualizations in Tableau.
-
Process & Analyze Browserless Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Browserless Data.
-
Access Live Redis 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 Redis through MCP integration.
-
How to connect to BigQuery Data with Squirrel SQL client
Connect to Google BigQuery and execute queries in the Squirrel SQL Client.
-
Automated Continuous Figshare Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Figshare replication to Apache Cassandra.
-
Visualize Zoho Creator Data in TIBCO Spotfire through OData
Integrate Zoho Creator into dashboards in TIBCO Spotfire.
-
Access Live Mistral AI Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Mistral AI in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Cline with Live Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Jira Assets from within your IDE.
-
Automated Continuous Oracle Eloqua Reporting Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to AlloyDB.
-
Connect and Visualize Live Redis Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Redis into the Databricks platform and create visualization dashboards with real-time Redis.
-
Getting Started with the CData ODBC Driver for ZarMoney
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ZarMoney.
-
Create SAS Data Sets-Connected Business Apps in AppSheet
Connect to SAS Data Sets Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAS Data Sets.
-
Build Presto-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Presto.
-
Getting Started with the CData SSIS Components for Zoho Creator
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Zoho Creator.
-
Connect to Rebilly Data in RapidMiner
Integrate Rebilly with standard components and data source configuration wizards in RapidMiner Studio.
-
Consume Google Cloud Storage OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Cloud Storage feeds that reflect any changes in SAP Lumira.
-
Connect to Short.io from a Connection Pool in WebLogic
Use the CData JDBC Driver for Short.io to connect to Short.io from Web applications running on WebLogic.
-
Import CockroachDB Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to CockroachDB Data and provide access to live CockroachDB for custom reports in the Power BI Service.
-
Connect to LeadDesk Data in RazorSQL
Connect to LeadDesk from wizards and query LeadDesk from the GUI in the RazorSQL database management tool.