CData Software - Knowledge Base
Recent Articles
-
Access SFTP Data from MySQL in PHP
Connect to SFTP through the standard MySQL libraries in PHP.
-
Access Live Couchbase Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Couchbase data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automate LeadDesk Data Replication to Couchbase
Use CData Sync to Customize and automate LeadDesk data replication to Couchbase.
-
How to Query Cosmos DB Data in MySQL Workbench
Execute MySQL queries against live Cosmos DB data from MySQL Workbench.
-
Import and Visualize AlloyDB Data in Power View
Create data visualizations based on AlloyDB data in Excel.
-
ETL Shortcut in Oracle Data Integrator
This article shows how to transfer Shortcut data into a data warehouse using Oracle Data Integrator.
-
Create Power BI Reports on Real-Time Redis Data
Use the CData ODBC Driver for Redis to visualize Redis data in Power BI Desktop.
-
Connect to Greenhouse in SpagoBI
Create reports featuring live Greenhouse data in SpagoBI Studio. Host Greenhouse reports on SpagoBI Server.
-
Add Exa Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Exa with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Goose with Live Bitly Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Bitly data from within the local AI agent.
-
How to integrate SpaceX with Apache Airflow
Access and process SpaceX data in Apache Airflow using the CData JDBC Driver.
-
Integrate with Spark Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Spark data to a JSON file on disk.
-
Integrate Google's Vertex AI Agent with Live Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Splunk data within intelligent workflows.
-
Connect to Postmark Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Postmark and work with Postmark data in your FileMaker applications.
-
How to Query Workday Data in MySQL Workbench
Execute MySQL queries against live Workday data from MySQL Workbench.
-
How to connect and process Datadog data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Datadog data.
-
Replicate Multiple OneNote Accounts via the CData Sync CLI
Replicate multiple OneNote accounts to one or many databases.
-
Add Jira Assets Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Jira Assets with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to connect PolyBase to CouchDB
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live CouchDB data.
-
Create SSAS Tabular Models from Printify Data
How to build a SQL Server Analysis Service Tabular Model from Printify data using CData drivers.
-
Import Real-Time Factorial Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Factorial data in ColdFusion.
-
Bind Live MailChimp Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live MailChimp data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Use CData Connect AI to Access AlloyDB Data in Microsoft Power Pivot
Use CData Connect AI to connect to live AlloyDB data in the Power Pivot business intelligence tool.
-
Connecting GenSpark with Google Sheets Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Google Sheets data without any replication or custom integration required.
-
Use the CData Software JDBC Driver for Azure Data Catalog in MicroStrategy Web
Connect to Azure Data Catalog data in MicroStrategy Web using the CData Software JDBC Driver for Azure Data Catalog.
-
Query Live Supabase Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Supabase data directly from the development environment.
-
Object-Relational Mapping (ORM) with VWO Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to VWO data into a Java-based ORM framework, Hibernate.
-
Connect to ServiceDesk Plus from a Connection Pool in WebLogic
Use the CData JDBC Driver for ServiceDesk Plus to connect to ServiceDesk Plus data from Web applications running on WebLogic.
-
How to Connect to & Open Close Data in Microsoft Excel
This article uses the CData ODBC driver for Close to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Google Ads Data from PowerBuilder via JDBC
This article demonstrates how to access Google Ads data from PowerBuilder using the Google Ads JDBC Driver.
-
Use the CData Software ODBC Driver for JSON in SAS for Real-Time Reporting and Analytics
Connect to real-time JSON services in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for JSON.
-
Create Dynamic Slack Grids Using the Infragistics XamDataGrid
Learn how you can connect Slack to Infragistics XamDataGrid to build dynamic grids.
-
How to connect to TaxJar Data with Squirrel SQL client
Connect to TaxJar data and execute queries in the Squirrel SQL Client.
-
Connect to and Query PhantomBuster Data in QlikView over ODBC
Create data visualizations with PhantomBuster data in QlikView.
-
How to Visualize Timely Data in Python with pandas
Use pandas and other modules to analyze and visualize live Timely data in Python.
-
Connect to HubSpot Data from Crystal Reports
Use CData Connect AI to connect to and report on live HubSpot data from Crystal Reports.
-
Integrate with Live Exact Online Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Exact Online from the MuleSoft Anypoint Platform to integrate live Exact Online data into custom reports and dashboards.
-
Replicate Multiple Exa Accounts
Replicate multiple Exa accounts to one or many databases.
-
Connect to ServiceDesk Plus Data from PowerBuilder via JDBC
This article demonstrates how to access ServiceDesk Plus data from PowerBuilder using the ServiceDesk Plus JDBC Driver.
-
Build Semantic Layer Views for Hugging Face Data in APOS Live Data Gateway
Use the CData Connector for Hugging Face in APOS Live Data Gateway to build Semantic Layer Views for Hugging Face data.
-
Connect to Google Search Results in RapidMiner
Integrate Google Search results with standard components and data source configuration wizards in RapidMiner Studio.
-
A PostgreSQL Interface for MailerSend Data (MySQL Remoting via JDBC)
Use the Remoting features of the MailerSend JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate SuiteCRM Data Replication to Azure Data Lake
Use CData Sync to customize and automate SuiteCRM data replication to Azure Data Lake.
-
Natively Connect to Gmail Data in PHP
The CData ODBC driver for Gmail enables you to create PHP applications with connectivity to Gmail data. Leverage the native support for ODBC in PHP.
-
Replicate Spark Data to Multiple Databases via the CData Sync CLI
Replicate Spark data to disparate databases with a single configuration.
-
Visualize FreshBooks Data in Sisense
Create an ElastiCube in Sisense app with access to FreshBooks data.
-
Connect to JotForm from a Connection Pool in WebLogic
Use the CData JDBC Driver for JotForm to connect to JotForm data from Web applications running on WebLogic.
-
Create Data Visualizations Based On Adobe Commerce Data in Mode
Use CData Connect AI to connect to Adobe Commerce Data from Mode and build visualizations using live Adobe Commerce data.
-
LINQ to Adobe Analytics 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 Adobe Analytics Data Provider.
-
Integrate OpenCode with Live Bright Data Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Bright Data data from within your AI coding agent.
-
Import Real-Time Brex Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Brex data in ColdFusion.
-
How to work with SAP SuccessFactors Data in Apache Spark using SQL
Access and process SAP SuccessFactors Data in Apache Spark using the CData Software JDBC Driver.
-
How to connect PolyBase to Simplesat
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Simplesat data.
-
Integrating Cursor with Strava 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 Asana Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Asana replication to Google BigQuery.
-
Visualize Live Azure Synapse Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Azure Synapse data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Access Google Search Results Using Entity Framework
This article shows how to access Google Search results using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Analyze Zoho Creator Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Zoho Creator from Power Pivot. You will use the Table Import Wizard to load Zoho Creator data. You can visually build the import query or use any SQL supported by the driver.
-
How to Seamlessly Import SingleStore Data into IBM SPSS Modeler
Integrate SingleStore data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrating Antigravity CLI with SendInBlue data via CData CLI
Connect SendInBlue data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Telegram Data in HULFT Integrate
Connect to Telegram as a JDBC data source in HULFT Integrate
-
Analyze SAP Fieldglass Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP Fieldglass from Power Pivot. You will use the Table Import Wizard to load SAP Fieldglass data. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData Tableau Connector for SAP Ariba Source
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP Ariba Source.
-
Integrate Google's Antigravity Agent with Live QuickBooks Time Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live QuickBooks Time data using the Model Context Protocol.
-
Access Live Google Directory Data in TIBCO Data Virtualization
Use the Google Directory Tibco DV Adapter to create a Google Directory data data source in TIBCO Data Virtualization Studio and gain access to live Google Directory data from your TDV Server.
-
Integrating GitHub Copilot with TigerGraph 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.
-
ETL Keap in Oracle Data Integrator
This article shows how to transfer Keap data into a data warehouse using Oracle Data Integrator.
-
Migrating data from Xero to Google BigQuery using CData SSIS Components.
Easily push Xero data to Google BigQuery using the CData SSIS Tasks for Xero and Google BigQuery.
-
Publish Crystal Reports on Vercel Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Vercel data.
-
Automated Beeminder Data Replication to Teradata
Use CData Sync to Customize and automate Beeminder data replication to Teradata.
-
How to Easily Query BenchmarkEmail Data in OpenOffice Base
Connect to BenchmarkEmail data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Working with Sybase IQ Data in LINQPad
Execute LINQ queries to Sybase IQ data in LINQPad.
-
Automated Continuous Pipeline CRM Replication to Snowflake
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to Snowflake.
-
Connect to Salesforce Pardot Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Salesforce Pardot Data and connect to Salesforce Pardot data in Akorbi Digital RunMyProcess.
-
Create SAP Concur-Connected Dashboards in Grafana
Connect to SAP Concur Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP Concur data.
-
Integrating LangChain with Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Act-On data within automated workflows.
-
Create Billsby Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Billsby data access from reports, embedded analytics, and more.
-
Use the CData Software ODBC Driver for Spotify in MicroStrategy
Connect to Spotify data in MicroStrategy Developer using the CData Software ODBC Driver for Spotify.
-
Create PingOne-Connected Dashboards in Grafana
Connect to PingOne Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to PingOne data.
-
Integrate with Sage 300 Data in JReport Designer
Create charts and reports based on Sage 300 data in JReport Designer.
-
Connect to Grafana Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Grafana data.
-
Build Dashboards with Salesforce Data 360 Data in Dundas BI
Create dynamic dashboards and perform analytics based on Salesforce Data 360 data in Dundas BI.
-
LINQ to Exact Online 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 Exact Online Data Provider.
-
Build Google Calendar-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Calendar data and build web apps with connectivity to live Google Calendar data.
-
Build a PostgreSQL Interface for Avalara AvaTax Data using the CData JDBC Driver
Use the Remoting features of the Avalara AvaTax JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Reports from Google Drive Data in Looker Studio
Use CData Connect AI to gain access to live Google Drive data and create custom reports in Looker Studio.
-
Automated Continuous LaunchDarkly Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to Amazon Redshift.
-
Work with Opsgenie Data in FoxPro
Load Opsgenie data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Real-Time SingleStore Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SingleStore and Dataflow to import and use SingleStore data in Power Apps.
-
Connect to Factorial Data in RazorSQL
Connect to Factorial from wizards and query Factorial data from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData Python Connector for Spotify
Learn to install and license the CData Python Connector and configure a connection to live Spotify data.
-
Create Data Visualizations in Cognos BI with Cvent Data
Access Cvent data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Visualize Microsoft Teams Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft Teams data in Python.
-
Connect to Twitter Ads Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Twitter Ads as an External Source in Dremio.
-
Create Reports with SAP Hybris C4C Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Hybris C4C data.
-
Create Datasets from Marketo in Domo Workbench and Build Visualizations of Marketo Data in Domo
Use the CData Software ODBC Driver for Marketo to create datasets from Marketo data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Freshdesk Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Freshdesk replication to IBM DB2.
-
Integrating GitHub Copilot with Auth0 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.
-
Connect to Gmail Data in Google Apps Script via Connect AI
Use CData Connect AI to access Gmail data in Google Apps Script.
-
Create Reports with OData Services in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date OData services.