CData Software - Knowledge Base
Recent Articles
-
Object-Relational Mapping (ORM) with Salesforce Marketing 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 Salesforce Marketing data into a Java-based ORM framework, Hibernate.
-
Connect to Egnyte Data from AWS Glue
Use CData Connect AI to gain access to live Egnyte data from your AWS Glue jobs.
-
Access Live Phoenix Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Phoenix data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate Live IBM Cloud Object Storage Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live IBM Cloud Object Storage data from within the IDE.
-
How to Connect to Live Instagram 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 Instagram data for you.
-
Connect to Bannerbear Data from AWS Glue
Use CData Connect AI to gain access to live Bannerbear data from your AWS Glue jobs.
-
Replicate MYOB AccountRight Data in Heroku for Use in Salesforce Connect
Replicate MYOB AccountRight data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
A PostgreSQL Interface for Amplitude Data (MySQL Remoting via JDBC)
Use the Remoting features of the Amplitude JDBC Driver to create a PostgreSQL entry-point for data access.
-
Creating Zuora-Connected Applications in Unqork
You can use CData Connect AI to feed Zuora data to Unqork and build custom business apps.
-
Connect to GitLab Data in CloverDX (formerly CloverETL)
Transfer GitLab data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous ServiceNow Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ServiceNow replication to Amazon S3.
-
Automated Continuous Telegram Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Telegram replication to Google Cloud SQL.
-
Build Vertica-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Vertica Data and create custom apps in Bubble.
-
Use Biml to Build SSIS Tasks to Replicate Egnyte Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Egnyte data to SQL Server.
-
Excel Spreadsheet Automation on LaunchDarkly Data with the QUERY Formula
Pull data from LaunchDarkly, automate spreadsheets, and more with the QUERY formula.
-
Building Dynamic Web Pages with CSV Data Using AngularJS
Create single-page applications with live connectivity to CSV using the CData API Server.
-
Getting Started with the CData ODBC Driver for CloudConvert
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for CloudConvert.
-
Work with Live AlloyDB Data in Power Query
Use CData Connect AI to connect to AlloyDB data and work with live AlloyDB data in Microsoft Power Query.
-
Publish Crystal Reports on NASA Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date NASA data.
-
DataBind Controls to Stack Exchange Data in C++Builder
DataBind to Stack Exchange data in C++Builder with standard components and controls.
-
Access Live Confluence Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Confluence data from your Excel spreadsheets.
-
Create Data Visualizations in Tableau with Google Spreadsheets data
You can use the driver to expose your GoogleSheets data as an ODBC data source. We show how to expose this data in Tableau and create a data visualization.
-
Query Dropbox Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Dropbox entities in PHP by modeling them as objects.
-
Integrate Live Microsoft Exchange Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Microsoft Exchange from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Microsoft Exchange data.
-
Deploy the ADO.NET Provider for Cloudant on an SSRS Report Server
Connect to Cloudant data 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.
-
Analyze HubSpot Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze HubSpot data with the CData JDBC Driver for HubSpot.
-
Use the CData ODBC Driver for Asana from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Asana to connect to Asana data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Asana data in Excel.
-
Connect to Float Data in Jaspersoft Studio
Execute SQL to remote Float data in Jaspersoft Studio.
-
Access Live Vault CRM Data in Coginiti Pro
Connect to and query live Vault CRM data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Hubstaff Replication to Vertica
Use CData Sync for automated, continuous, customizable Hubstaff replication to Vertica.
-
Integrating Antigravity CLI with SageHR data via CData CLI
Connect SageHR data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to connect and process CapsuleCRM data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live CapsuleCRM data.
-
Build Semantic Layer Views for Microsoft Planner Data in APOS Live Data Gateway
Use the CData Connector for Microsoft Planner in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Planner data.
-
Use Biml to Build SSIS Tasks to Replicate Printful Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Printful data to SQL Server.
-
Replicate Salesforce Marketing Data to Multiple Databases via the CData Sync CLI
Replicate Salesforce Marketing data to disparate databases with a single configuration.
-
Access Live Salesforce Data 360 Data in AWS Lambda
Connect to live Salesforce Data 360 data in AWS Lambda using the CData JDBC Driver.
-
Analyze Google Translate Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Translate from Power Pivot. You will use the Table Import Wizard to load Google Translate data. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData ODBC Driver for Klaviyo in Microsoft Power Query
You can use the CData Klaviyo ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Klaviyo data into Microsoft Power Query.
-
Integrating Claude Code CLI with Zoho Creator 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.
-
Establish a Live Connection with Freshservice Data using Tableau Bridge
The CData ODBC Driver for Freshservice enables you to integrate live Freshservice data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating GitHub Copilot with ConvertKit 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 Pinterest Data in CloverDX (formerly CloverETL)
Transfer Pinterest data using the visual workflow in the CloverDX data integration tool.
-
Rapidly Develop LinkedIn Ads-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 LinkedIn Ads.
-
Visualize Live SurveyMonkey Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SurveyMonkey data into custom reports in Power BI.
-
Publish Crystal Reports on Amazon Marketplace Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Amazon Marketplace data.
-
Query MarkLogic Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume MarkLogic entities in PHP by modeling them as objects.
-
How to Connect to Apify Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Apify data. Leverage the pyodbc module for ODBC in Python.
-
Natively Connect to Workable Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Workable data. Leverage the native support for ODBC in PHP.
-
How to connect Amazon QuickSight to Google Sheets Data
Create a connection to Google Sheets data in CData Connect AI and insert Google Sheets data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to publish and share Deel Data dashboards with Tableau Server
The CData ODBC driver for Deel enables you integrate Deel data into Tableau dashboards.
-
Integrating LlamaIndex with MySQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on MySQL data in real time.
-
Model Google Ad Manager Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Google Ad Manager, enabling the direct import of real-time Google Ad Manager data.
-
How to Easily Query Simplesat Data in OpenOffice Base
Connect to Simplesat data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Explore Geographical Relationships in Bitbucket Data with Power Map
Create data visualizations with Bitbucket data in Power Map.
-
DataBind Controls to Brex Data in Delphi
DataBind to Brex data in Delphi with standard data access components and controls.
-
Integrate Oracle with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Oracle with External Services.
-
Integrating LlamaIndex with Exa Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Exa data in real time.
-
Analyze Lakebase Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Lakebase data with the CData JDBC Driver for Lakebase.
-
Connect to CockroachDB Data from HeidiSQL
Use CData Connect AI to connect to and query live CockroachDB data from HeidiSQL.
-
Automate Guru Data Replication to SAP HANA
Use CData Sync to customize and automate Guru data replication to SAP HANA.
-
Access Live SAP HANA Data in Coginiti Pro
Connect to and query live SAP HANA data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Semantic Layer Views for Xero Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Xero data.
-
Create Dynamic Smartsheet Grids Using the Infragistics XamDataGrid
Learn how you can connect Smartsheet to Infragistics XamDataGrid to build dynamic grids.
-
Visualize Grafana 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 Grafana data into TIBCO Spotfire.
-
Integrating ZendeskSell Data in Talend Cloud Data Management Platform
Connect ZendeskSell Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Publish Crystal Reports on ZeroBounce Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ZeroBounce data.
-
Build Semantic Layer Views for Datadog Data in APOS Live Data Gateway
Use the CData Connector for Datadog in APOS Live Data Gateway to build Semantic Layer Views for Datadog data.
-
Rapidly Develop Stripe-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 Stripe.
-
Visualize Perigon Data in Sisense
Create an ElastiCube in Sisense app with access to Perigon data.
-
Working with Browserless Data in LINQPad
Execute LINQ queries to Browserless data in LINQPad.
-
Connect to and Visualize Live JobNimbus Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live JobNimbus data.
-
View Reports on Real-Time YouTube Analytics Data in Power BI Report Server
Use the CData ODBC Driver for YouTube Analytics to visualize YouTube Analytics data in Power BI Desktop and then publish them to Power BI Report Server.
-
Validate WooCommerce Data with QuerySurge
Access and validate WooCommerce data in QuerySurge using the CData JDBC Driver.
-
XML Reporting in OBIEE with the XML JDBC Driver
Deploy the XML JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Work with Live Zoho CRM Data in Power Query
Use CData Connect AI to connect to Zoho CRM data and work with live Zoho CRM data in Microsoft Power Query.
-
How to connect SharePoint with Authorize.Net Data through external lists
Provide Authorize.Net data to SharePoint users as an external list.
-
Integrate Google's Antigravity Agent with Live Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Phoenix data using the Model Context Protocol.
-
Easily Integrate PolarTeamPro Data in Lazarus Pascal IDE
Learn how to easily integrate live PolarTeamPro data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous Humanity Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Humanity replication to delimited files (CSV/TSV).
-
Edit and Search External Act-On Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Act-On data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Act-On Data objects that you can access from apps and the dashboard.
-
Create Datasets from Perplexity in Domo Workbench and Build Visualizations of Perplexity Data in Domo
Use the CData Software ODBC Driver for Perplexity to create datasets from Perplexity data in Domo Workbench and then build visualizations in the Domo service.
-
Use the CData Software JDBC Driver for Office 365 in MicroStrategy Web
Connect to Office 365 data in MicroStrategy Web using the CData Software JDBC Driver for Office 365.
-
Integrating Antigravity CLI with Jira data via CData CLI
Connect Jira data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Reports with Mailgun Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Mailgun data.
-
Integrating HubSpot Data in Talend Cloud Data Management Platform
Connect HubSpot Data with Talend Cloud Data Management Platform using the CData JDBC Driver for HubSpot.
-
Integrate SAP Ariba Source with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP Ariba Source with External Services.
-
Establish a Live Connection with Zoho Inventory Data using Tableau Bridge
The CData ODBC Driver for Zoho Inventory enables you to integrate live Zoho Inventory data into Tableau Cloud dashboards using the Tableau Bridge.
-
Query Sybase IQ Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Sybase IQ entities in PHP by modeling them as objects.
-
Connect to EnterpriseDB Data in RapidMiner
Integrate EnterpriseDB data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Real-Time CampaignMonitor Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use CampaignMonitor data in Power Apps.
-
Link Sage 300 with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Sage 300 data in Filemaker Pro for Mac or Windows.
-
Automated Mixpanel Data Replication to Teradata
Use CData Sync to Customize and automate Mixpanel data replication to Teradata.
-
Replicate PayPal Data to Multiple Databases via the CData Sync CLI
Replicate PayPal data to disparate databases with a single configuration.
-
Integrating Antigravity CLI with Zoho Inventory data via CData CLI
Connect Zoho Inventory data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Query Live SurveyMonkey Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live SurveyMonkey data through a conversational interface.
-
Automated Continuous ZohoSubscriptions Replication to MongoDB
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to MongoDB.
-
Build MVC Applications with Connectivity to Parallel Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Parallel from an ASP.NET MVC application.
-
Build Reckon Accounts Hosted-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Reckon Accounts Hosted data and build Reckon Accounts Hosted-connected web apps with Axios.
-
Process & Analyze TaxJar Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live TaxJar Data.
-
Use CData Connect AI to Access IBM Informix Data in Microsoft Power Pivot
Use CData Connect AI to connect to live IBM Informix data in the Power Pivot business intelligence tool.