CData Software - Knowledge Base
Recent Articles
-
Integrating Gumloop with Salesforce CRM Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Salesforce CRM Analytics within automated workflows.
-
Use the CData Software ODBC Driver for SurveyMonkey in MicroStrategy Web
Connect to SurveyMonkey in MicroStrategy Web using the CData Software ODBC Driver for SurveyMonkey.
-
Create Informatica Mappings From/To a JDBC Data Source for Sage 300
Create Sage 300 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Import Real-Time Lakebase Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Lakebase in ColdFusion.
-
Build a Simple VCL Application for Apollo Data
How to build a simple VCL Application to view Apollo in RAD Studio using the CData ODBC Driver for Apollo.
-
Getting Started with the CData Tableau Connector for Excel Online
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Excel Online.
-
Access Live ScrapingBee Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ScrapingBee in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Live Zoho Projects Data in Coginiti Pro
Connect to and query live Zoho Projects from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Load Tickspot Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Tickspot to a database.
-
Access Live Bright Data Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Bright Data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Query FHIR Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume FHIR entities in PHP by modeling them as objects.
-
How to create an RPA flow for SAP BusinessObjects BI Data in UiPath Studio
Use the SAP BusinessObjects BI ODBC Driver to create workflows that access real-time SAP BusinessObjects BI without any coding.
-
Build Dashboards with SageHR Data in Dundas BI
Create dynamic dashboards and perform analytics based on SageHR in Dundas BI.
-
Connect to SAP Hybris C4C Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAP Hybris C4C and the SQL Gateway to access SAP Hybris C4C from Google Apps Script.
-
Connect to Nethunt Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Nethunt as an External Source in Dremio.
-
Automate ShipStation Data Replication to SAP HANA
Use CData Sync to customize and automate ShipStation replication to SAP HANA.
-
How to connect to Everhour Data from IntelliJ
Integrate connectivity to Everhour with wizards in IntelliJ.
-
DataBind Controls to Klipfolio Data in C++Builder
DataBind to Klipfolio in C++Builder with standard components and controls.
-
Access Live SendGrid Data in Excel 365 Online (Excel for the web)
Connect to SendGrid from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for PabblySubscriptions
Provide connectivity to PabblySubscriptions through an SAP BusinessObjects universe.
-
Query Blackbaud FE NXT Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Blackbaud FE NXT entities in PHP by modeling them as objects.
-
Import Airtable Data Using Azure Data Factory
Use CData Connect AI to connect to Airtable Data from Azure Data Factory and import live Airtable.
-
How to connect to Amazon Athena Data from IntelliJ
Integrate connectivity to Amazon Athena with wizards in IntelliJ.
-
Integrate Cline with Live Dynamics 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Dynamics 365 from within your IDE.
-
Build Google Calendar-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Google Calendar Data from Zoho Analytics and import live Google Calendar.
-
Automated Continuous VWO Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable VWO replication to Google Cloud SQL.
-
Use the CData API Server to Access Wave Financial Data in Microsoft PowerPivot
Use the CData API Server to connect to live Wave Financial in the Power Pivot business intelligence tool.
-
Use JayDeBeApi to access Facebook Data in Python
Use standard Python scripting and the development environment of your choice to access live Facebook.
-
Analyze Reckon Accounts Hosted Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Reckon Accounts Hosted with the CData JDBC Driver for Reckon Accounts Hosted.
-
Query Live Microsoft Exchange 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 Microsoft Exchange directly from the development environment.
-
How to Use a Microsoft Access Database to Update Facebook Ads Data in Real Time
Update Facebook Ads data by creating a linked table in Microsoft Access with the CData Facebook Ads ODBC Driver.
-
How to Connect Flowise AI Agents to Live SAP SuccessFactors LMS Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live SAP SuccessFactors LMS without replication.
-
Integrate with Instantly Data in JReport Designer
Create charts and reports based on Instantly in JReport Designer.
-
Use the CData API Server to Access PingOne Data in Microsoft PowerPivot
Use the CData API Server to connect to live PingOne in the Power Pivot business intelligence tool.
-
How to connect and process Close from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Close.
-
Viewing YouTube Analytics Data in RAD Studio Data Explorer
How to view YouTube Analytics in RAD Studio Data Explorer using the CData ODBC Driver for YouTube Analytics.
-
Connect to ZohoDesk Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ZohoDesk in the Denodo Virtual DataPort Administrator.
-
Connect to Impala Data in Google Apps Script via Connect AI
Use CData Connect AI to access Apache Impala in Google Apps Script.
-
How to Work with ZendeskSell Data in AWS Glue Jobs Using JDBC
Connect to ZendeskSell from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automate Stack Exchange Data Replication to SAP HANA
Use CData Sync to customize and automate Stack Exchange replication to SAP HANA.
-
Validate Nethunt Data with QuerySurge
Access and validate Nethunt in QuerySurge using the CData JDBC Driver.
-
DataBind Charts to Tavily Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Tavily 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.
-
Getting Started with the CData ODBC Driver for Missive
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Missive.
-
Automated Phoenix Data Replication to Teradata
Use CData Sync to Customize and automate Apache Phoenix replication to Teradata.
-
Connect Drip to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Drip with IBM WebSphere for seamless data integration and connectivity.
-
Build Pipelines with Live HubSpot Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to HubSpot from Google Cloud Data Fusion, enabling the integration of live HubSpot into the building and management of effective data pipelines.
-
Create Informatica Mappings From/To an ODBC Data Source for HelloSign
Create an ODBC connection to HelloSign in Informatica and browse and transfer HelloSign.
-
Moving Data from Zoom to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Zoom data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to BambooHR Data from PowerBuilder via ADO.NET
This article demonstrates how to access BambooHR from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Publish Reports with Outlook Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Outlook.
-
Connect to Rootly Data from a Connection Pool in Jetty
The Rootly JDBC Driver supports connection pooling: This article shows how to connect faster to Rootly from Web apps in Jetty.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Salesforce CRM Analytics
Provide connectivity to Salesforce CRM Analytics through an SAP BusinessObjects universe.
-
Getting Started with the CData Excel Add-In for FTP
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for FTP.
-
Automated Continuous JSON Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable JSON replication to delimited files (CSV/TSV).
-
Use Claude to Talk to Your Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Azure Analysis Services for you.
-
Bridge SAS Data Sets Connectivity with Apache NiFi
Access and process SAS Data Sets in Apache NiFi using the CData JDBC Driver.
-
Migrating data from Shortcut to Google BigQuery using CData SSIS Components.
Easily push Shortcut to Google BigQuery using the CData SSIS Tasks for Shortcut and Google BigQuery.
-
Validate Instantly Data with QuerySurge
Access and validate Instantly in QuerySurge using the CData JDBC Driver.
-
How to publish and share Exact Online Data dashboards with Tableau Server
The CData ODBC driver for Exact Online enables you integrate Exact Online into Tableau dashboards.
-
Add Nuclia Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Nuclia with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Live MailChimp Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live MailChimp from your Excel spreadsheets.
-
Bidirectional Access to SAP Netweaver Gateway Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SAP Netweaver Gateway in Filemaker Pro for Mac or Windows.
-
Visualize Live Slack Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Slack into custom reports in Power BI.
-
Create Informatica Mappings From/To a JDBC Data Source for Pingdom
Create Pingdom data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Publish Reports with Wave Financial Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Wave Financial.
-
Integrate Phoenix Data into Power Automate Desktop using CData Connect
CData Connect for Phoenix Data enables you to integrate Apache Phoenix into workflows built using Microsoft Power Automate Desktop.
-
Using the CData Software ODBC Driver for Zuora in PyCharm
Connect to Zuora as an ODBC data source in PyCharm using the CData Software ODBC Driver for Zuora.
-
Integrating Antigravity CLI with Rebilly via CData CLI
Connect Rebilly to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create a Data Access Object for Quaderno Data using JDBI
A brief overview of creating a SQL Object API for Quaderno in JDBI.
-
Explore Geographical Relationships in Excel Online Data with Power Map
Create data visualizations with Microsoft Excel Online in Power Map.
-
Replicate Microsoft Exchange Data to Multiple Databases via the CData Sync CLI
Replicate Microsoft Exchange to disparate databases with a single configuration.
-
Analyze Zuora Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Zuora in Microsoft R Open.
-
How to Easily Query Vercel Data in OpenOffice Base
Connect to Vercel data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build MongoDB Visualizations in Tableau Cloud
Use CData Connect AI to connect to live MongoDB and build visualizations in Tableau Cloud.
-
Visualize GraphQL Data in Tableau
The CData ODBC driver for GraphQL enables you integrate GraphQL into Tableau dashboards.
-
How to connect to Missive Data from Spring Boot
Connect to Missive in a Spring Boot Application using the CData API Driver for JDBC
-
Create a Data Access Object for Miro Data using JDBI
A brief overview of creating a SQL Object API for Miro in JDBI.
-
Create SSAS Tabular Models from Google Calendar Data
How to build a SQL Server Analysis Service Tabular Model from Google Calendar using CData drivers.
-
Connect to Pinterest Data in HULFT Integrate
Connect to Pinterest as a JDBC data source in HULFT Integrate
-
Connect to Apify Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Apify.
-
Validate Discourse Data with QuerySurge
Access and validate Discourse in QuerySurge using the CData JDBC Driver.
-
Connect to Lakebase Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Lakebase as an External Source in Dremio.
-
Build Dashboards with Quickbase Data in Dundas BI
Create dynamic dashboards and perform analytics based on Quickbase in Dundas BI.
-
How to integrate Cassandra with Apache Airflow
Access and process Apache Cassandra in Apache Airflow using the CData JDBC Driver.
-
Analyze Azure Synapse Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Azure Synapse and visualize live Azure Synapse in Infragistics Reveal.
-
Edit and Search External Active Directory Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Active Directory to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Active Directory Data objects that you can access from apps and the dashboard.
-
Connect to and Visualize Live Procore Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Procore.
-
Import Real-Time SAP Netweaver Gateway Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP Netweaver Gateway in ColdFusion.
-
Easily Integrate HCL Domino Data in Lazarus Pascal IDE
Learn how to easily integrate live HCL Domino in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to connect PolyBase to Intercom
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Intercom.
-
Use JayDeBeApi to access ZohoPeople Data in Python
Use standard Python scripting and the development environment of your choice to access live ZohoPeople.
-
Build AI Agents with Amazon Athena Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Amazon Athena through CData Connect AI.
-
Visualize Live Templated Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Templated using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to SQL Server from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft SQL Server, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use the CData SSIS Components to Insert New or Update Existing Microsoft Exchange Records from SQL Server
Easily push SQL Server data to Microsoft Exchange using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Microsoft Exchange or update existing records with data from a SQL Server database.
-
Integrate Live Sybase IQ Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Sybase IQ to Blue Prism using the CData ODBC Driver for Sybase IQ to create automated workflows for repetitive business tasks.
-
Connect to LinkedIn Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for LinkedIn to connect to LinkedIn and execute queries in PowerBuilder.
-
Visualize OData Services from Tableau
Use the Tableau Desktop business intelligence tool to connect to OData.
-
Load Discourse Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Discourse to a database.
-
Build LightSpeedRetail-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to LightSpeedRetail and build web apps with connectivity to live LightSpeedRetail.