CData Software - Knowledge Base
Recent Articles
-
Process & Analyze BigCommerce Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live BigCommerce Data.
-
Access Live SQL Server Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SQL Server data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrate Real-Time Access to Google Calendar in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Calendar in real time.
-
Using the CData Software ODBC Driver for Productboard in PyCharm
Connect to Productboard as an ODBC data source in PyCharm using the CData Software ODBC Driver for Productboard.
-
Connect to Salesforce Marketing Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Salesforce Marketing Data and connect to Salesforce Marketing Cloud in Akorbi Digital RunMyProcess.
-
Visualize Apollo 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 Apollo into TIBCO Spotfire.
-
Automated Continuous Act CRM Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Act CRM replication to AlloyDB.
-
Use the CData Software JDBC Driver for Teradata in MicroStrategy
Connect to Teradata in MicroStrategy Developer using the CData Software JDBC Driver for Teradata.
-
Stream Outreach.io Data into Apache Kafka Topics
Access and stream Outreach.io in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Real-Time Sage 200 Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Sage 200 and Dataflow to import and use Sage 200 in Power Apps.
-
Visualize Reply.io Data in TIBCO Spotfire through ADO.NET
Integrate Reply.io into dashboards in TIBCO Spotfire.
-
Migrating data from Google Calendar to Databricks using CData SSIS Components.
Easily push Google Calendar to Databricks using the CData SSIS Tasks for Google Calendar and Databricks.
-
Integrate LibreChat with Live Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Pipedrive from within the chat interface.
-
How to connect to iContact Data from IntelliJ
Integrate connectivity to iContact with wizards in IntelliJ.
-
How to connect to Google Contacts Data from IntelliJ
Integrate connectivity to Google Contacts with wizards in IntelliJ.
-
How to Query Live Sugar CRM Data in Perplexity MacOS Desktop
Connect to and query live Sugar CRM Data in Perplexity Desktop using CData MCP Server.
-
Build Apps with Live Jodoo Data Using the Low-Code Development Platform of Mendix
Connect Jodoo with Mendix to build apps using the CData API Driver for JDBC.
-
How to Connect to & Open Figshare Data in Microsoft Excel
This article uses the CData ODBC driver for Figshare to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Real-Time Adobe Commerce Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Adobe Commerce and Dataflow to import and use Adobe Commerce in Power Apps.
-
Automate XML Data Replication to Azure Data Lake
Use CData Sync to customize and automate XML Files replication to Azure Data Lake.
-
Access Live Datadog Data in AWS Lambda
Connect to live Datadog in AWS Lambda using the CData JDBC Driver.
-
Build Visualizations of JDBC-ODBC Bridge Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of JDBC-ODBC Bridge in Birst.
-
Connect to GetResponse Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for GetResponse in the Denodo Virtual DataPort Administrator.
-
Visualize Autopilot Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Autopilot.
-
How to Access Live Hive Data in Visual Studio Code via Cline
Run CData MCP Server for Hive on Windows Subsytem for Linux (WSL) and connect to live Apache Hive from the Cline extension in Visual Studio Code.
-
Connect to Real-Time Azure Data Lake Storage Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Azure Data Lake Storage and Dataflow to import and use Azure Data Lake Storage in Power Apps.
-
Connect to GitHub Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for GitHub and the SQL Gateway to access GitHub from Google Apps Script.
-
Connect to and Query Aweber Data in QlikView over ODBC
Create data visualizations with Aweber in QlikView.
-
Getting Started with the CData SSIS Components for Twilio
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Twilio.
-
Build ActiveCampaign-Connected Apps in Choreo
Use CData Connect AI to connect to ActiveCampaign Data from Choreo and build custom apps using live ActiveCampaign.
-
Access Quickbase Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Quickbase from HeidiSQL.
-
Use the CData Software JDBC Driver for SendPulse in MicroStrategy Desktop
Connect to SendPulse in MicroStrategy Desktop using the CData Software JDBC Driver for SendPulse.
-
View Reports on Real-Time PhantomBuster Data in Power BI Report Server
Use the CData ODBC Driver for PhantomBuster to visualize PhantomBuster in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData Software JDBC Driver for FormSite in MicroStrategy Web
Connect to FormSite in MicroStrategy Web using the CData Software JDBC Driver for FormSite.
-
Getting Started with the CData Excel Add-In for Todoist
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Todoist.
-
How to Access MailerSend Data Using Entity Framework
This article shows how to access MailerSend using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use Manus AI to Talk to Your Adobe Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Adobe Analytics.
-
How to update Google Campaign Manager 360 from Excel
This article explains how to transfer data from Excel to Google Campaign Manager 360 using the Excel Add-In for Google Campaign Manager 360.
-
Connect to QuickBooks Online Data in ACL Analytics
Connect to QuickBooks Online via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to QuickBooks Online.
-
How to connect to CircleCI Data in DBVisualizer
Integrate CircleCI with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze Microsoft Planner Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft Planner with the CData JDBC Driver for Microsoft Planner.
-
Connect to SAP Ariba Source Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP Ariba Source.
-
Model, Search, and Visualize Live Epicor Kinetic Data in ThoughtSpot
Use CData Connect AI to connect to live Epicor Kinetic for modeling, searching, and visualizing.
-
Connect to Live Procore Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Procore in CData Connect AI and connect to your Procore from PostgreSQL.
-
How to Query Live Stack Exchange Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Stack Exchange data in natural language using Python.
-
Create Certinia Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Certinia data access from reports, embedded analytics, and more.
-
Create Apps from CockroachDB Data in Qlik Sense Cloud
Use CData Connect AI to connect to CockroachDB Data and build apps from live CockroachDB in Qlik Sense Cloud.
-
Create SAP Netweaver Gateway Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP Netweaver Gateway data access from reports, embedded analytics, and more.
-
How to Connect DBeaver to Datadog via a JDBC Driver
Manage Datadog with visual tools in DBeaver like the query browser.
-
Connect to Snapchat Ads Data in DBeaver
Use the CData ODBC Driver to connect to Snapchat Ads in DBeaver.
-
Integrate SFTP with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SFTP with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SFTP.
-
Build Office 365-Connected Apps in Choreo
Use CData Connect AI to connect to Office 365 Data from Choreo and build custom apps using live Microsoft Office 365.
-
Connect to Templated Data in JRuby
Create a simple JRuby app with access to live Templated.
-
How to create an RPA flow for LightSpeedRetail Data in UiPath Studio
Use the LightSpeedRetail ODBC Driver to create workflows that access real-time LightSpeedRetail without any coding.
-
Connect to Confluence in SpagoBI
Create reports featuring live Atlassian Confluence in SpagoBI Studio. Host Confluence reports on SpagoBI Server.
-
Migrating data from AfterShip to Google BigQuery using CData SSIS Components.
Easily push AfterShip to Google BigQuery using the CData SSIS Tasks for AfterShip and Google BigQuery.
-
Connect to Mailgun Data from a Connection Pool in Jetty
The Mailgun JDBC Driver supports connection pooling: This article shows how to connect faster to Mailgun from Web apps in Jetty.
-
Integrate with Google Forms Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Forms to a JSON file on disk.
-
How to create an RPA flow for Samanage Data in UiPath Studio
Use the Samanage ODBC Driver to create workflows that access real-time Samanage without any coding.
-
How to Work with Blackbaud FE NXT Data in ETL Validator JDBC
Connect to Blackbaud FE NXT from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Access Wave Financial Data Using Entity Framework
This article shows how to access Wave Financial using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Real-Time LightSpeedRetail Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use LightSpeedRetail in Power Apps.
-
Automated Continuous Adobe Analytics Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to Amazon S3.
-
Build Dashboards with CircleCI Data in Dundas BI
Create dynamic dashboards and perform analytics based on CircleCI in Dundas BI.
-
How to Design HubSpot Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to HubSpot from mobile and tablet Power Apps.
-
Build Google Sheets-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Sheets and build web apps with connectivity to live Google Sheets.
-
Access ChargeOver Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for ChargeOver.
-
Connect to Shippo Data in RapidMiner
Integrate Shippo with standard components and data source configuration wizards in RapidMiner Studio.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for PostgreSQL
Provide connectivity to PostgreSQL through an SAP BusinessObjects universe.
-
Analyze Act-On Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Act-On and visualize live Act-On in Infragistics Reveal.
-
Connect to and Visualize Live Amplitude Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Amplitude.
-
Edit and Search DB2 External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of IBM DB2 to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create DB2 objects that you can access from apps and the dashboard.
-
Replicate Google Tasks Data to Multiple Databases
Replicate Google Tasks to disparate databases with a point-and-click configuration.
-
Automate Azure Data Catalog Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Azure Data Catalog and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to import Nethunt Data into Apache Solr
Use the CData Software JDBC Driver for Nethunt in Data Import Handler and create an automated import of Nethunt to Apache Solr Enterprise Search platform.
-
Connect to GitLab Data in Ruby
Connect to GitLab in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate with Testmonitor Data in JReport Designer
Create charts and reports based on Testmonitor in JReport Designer.
-
Automated Continuous Klaviyo Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Klaviyo replication to Apache Cassandra.
-
Access Live HBase Data in AWS Lambda
Connect to live Apache HBase in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for LeadDesk in MicroStrategy Desktop
Connect to LeadDesk in MicroStrategy Desktop using the CData Software JDBC Driver for LeadDesk.
-
Excel Spreadsheet Automation on Adobe Experience Manager Data with the QUERY Formula
Pull data from Adobe Experience Manager, automate spreadsheets, and more with the QUERY formula.
-
How to Access Drip Data Using Entity Framework
This article shows how to access Drip using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate Twitter Ads with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Twitter Ads with External Services.
-
Migrating data from Facebook Ads to Snowflake using CData SSIS Components.
Easily push Facebook Ads to Snowflake using the CData SSIS Tasks for Facebook Ads and Snowflake.
-
Visualize Live Oracle Financials Cloud Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Oracle Financials Cloud using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Trello Data from AWS Glue
Use CData Connect AI to gain access to live Trello from your AWS Glue jobs.
-
Create Data Visualizations in Cognos BI with Perplexity Data
Access Perplexity as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Publish Float-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Float.
-
Automated Continuous JSON Replication to Vertica
Use CData Sync for automated, continuous, customizable JSON replication to Vertica.
-
Connect to Mailgun Data in RapidMiner
Integrate Mailgun with standard components and data source configuration wizards in RapidMiner Studio.
-
DataBind ZarMoney Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ZarMoney to a chart.
-
Integrate Live Outreach.io Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Outreach.io to Blue Prism using the CData ODBC Driver for Outreach.io to create automated workflows for repetitive business tasks.
-
Analyze Campaigner Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Campaigner with the CData JDBC Driver for Campaigner.
-
How to work with Raisers Edge NXT Data in Apache Spark using SQL
Access and process Raisers Edge NXT Data in Apache Spark using the CData Software JDBC Driver.
-
Consume Stripe OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Stripe feeds that reflect any changes in SAP Lumira.
-
Connect to Google Ad Manager from Asprova with CData Software ODBC Driver for Google Ad Manager
This article shows how to connect faster to Google Ad Manager data from Asprova.
-
Use Biml to Build SSIS Tasks to Replicate ZohoSubscriptions Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ZohoSubscriptions to SQL Server.
-
Connect to Postmark Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Postmark and the SQL Gateway to access Postmark from Google Apps Script.
-
Work with ZohoPeople Data in FoxPro
Load ZohoPeople into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Dashboards with Zoho CRM Data in DBxtra
Create dynamic dashboards and perform analytics based on Zoho CRM in DBxtra.