CData Software - Knowledge Base
Recent Articles
-
Analyze XML Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze XML Files with the CData JDBC Driver for XML.
-
Access Live Office 365 Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft Office 365 in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access PagerDuty 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 PagerDuty.
-
View Reports on Real-Time Attio Data in Power BI Report Server
Use the CData ODBC Driver for Attio to visualize Attio in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous SAP ByDesign Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Google Cloud SQL.
-
Use the CData Software ODBC Driver for Superchat in SAS for Real-Time Reporting and Analytics
Connect to real-time Superchat in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Superchat.
-
Import Real-Time ElevenLabs Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ElevenLabs in ColdFusion.
-
Query LightSpeedRetail Data as a MySQL Database in Node.js
Execute MySQL queries against LightSpeedRetail from Node.js.
-
Query, Visualize, and Share live Zoho CRM Data in Redash
Use CData Connect AI to connect to live Zoho CRM in Redash for querying, visualizing, and sharing.
-
Creating Cloudant-Connected Applications in Unqork
You can use CData Connect AI to feed IBM Cloudant to Unqork and build custom business apps.
-
Deploy the ADO.NET Provider for Scrapfly on an SSRS Report Server
Connect to Scrapfly 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.
-
Connect to Salesforce Marketing Data in Ruby
Connect to Salesforce Marketing Cloud in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to CloudConvert Data in RapidMiner
Integrate CloudConvert with standard components and data source configuration wizards in RapidMiner Studio.
-
Automate Elasticsearch Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Elasticsearch and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Add Pinterest Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Pinterest with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData Software JDBC Driver for CouchDB in MicroStrategy Desktop
Connect to Apache CouchDB in MicroStrategy Desktop using the CData Software JDBC Driver for CouchDB.
-
Load Jodoo Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Jodoo to a database.
-
How to import MongoDB Data into Apache Solr
Use the CData Software JDBC Driver for MongoDB in Data Import Handler and create an automated import of MongoDB to Apache Solr Enterprise Search platform.
-
DataBind Controls to Salesloft Data in Delphi
DataBind to Salesloft in Delphi with standard data access components and controls.
-
Validate Supabase Data with QuerySurge
Access and validate Supabase in QuerySurge using the CData JDBC Driver.
-
Getting Started with the CData ADO.NET Provider for HBase
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for HBase.
-
Access Live QuickBooks Time Data in AWS Lambda
Connect to live QuickBooks Time in AWS Lambda using the CData JDBC Driver.
-
Provide OData Services of Browserless Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Browserless by developing a WCF Service Application.
-
Getting Started with the CData Power BI Connector for Oracle HCM Cloud
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Oracle HCM Cloud.
-
Access Live Jira Data in TIBCO Data Virtualization
Use the Jira Tibco DV Adapter to create a Atlassian Jira data source in TIBCO Data Virtualization Studio and gain access to live Atlassian Jira from your TDV Server.
-
Use Biml to Build SSIS Tasks to Replicate Adobe Target Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Adobe Target to SQL Server.
-
Replicate Vault CRM Data from PowerShell
Write a quick PowerShell script to query Veeva Vault & Vault CRM. Use connectivity to the live data to replicate Veeva Vault & Vault CRM to SQL Server.
-
Integrate LibreChat with Live Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Redis from within the chat interface.
-
Connect to Teamgate from Asprova with CData Software ODBC Driver for Teamgate
This article shows how to connect faster to Teamgate data from Asprova.
-
Getting Started with the CData ADO.NET Provider for Salesloft
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Salesloft.
-
Automated Continuous ConvertKit Replication to SQL Server
Use CData Sync for automated, continuous, customizable ConvertKit replication to SQL Server.
-
Manage Anaplan Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Anaplan.
-
Access Live FTP Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live FTP Servers from your Excel spreadsheets.
-
How to Connect to Zoho CRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Zoho CRM. Leverage the pyodbc module for ODBC in Python.
-
Create SSAS Tabular Models from Greenhouse Data
How to build a SQL Server Analysis Service Tabular Model from Greenhouse using CData drivers.
-
Connect to Microsoft Exchange Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Live SAS Data Sets Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAS Data Sets from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Live YouTube Analytics Data in MicroStrategy through CData Connect AI
Create a live connection to YouTube Analytics Data in CData Connect AI and connect to your YouTube Analytics from MicroStrategy.
-
Edit and Search Authorize.Net External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Authorize.Net to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Authorize.Net objects that you can access from apps and the dashboard.
-
Automated Continuous Google Ads Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Ads replication to Oracle.
-
Provide OData Services of SAP Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP ERP/NetWeaver by developing a WCF Service Application.
-
Use the CData Software ODBC Driver for Google Forms in MicroStrategy
Connect to Google Forms in MicroStrategy Developer using the CData Software ODBC Driver for Google Forms.
-
Build Dashboards with Greenhouse Data in DBxtra
Create dynamic dashboards and perform analytics based on Greenhouse in DBxtra.
-
Connect to Snapchat Ads Data in JRuby
Create a simple JRuby app with access to live Snapchat Ads.
-
Query Live SQL Server 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 SQL Server directly from the development environment.
-
Visualize Marketo Data in TIBCO Spotfire through ADO.NET
Integrate Marketo into dashboards in TIBCO Spotfire.
-
Build Visualizations of Airtable Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Airtable in Birst.
-
How to create Bitly federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Bitly in MySQL .
-
Build Dashboards with Azure Synapse Data in Dundas BI
Create dynamic dashboards and perform analytics based on Azure Synapse in Dundas BI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for QuickBooks Online
Provide connectivity to QuickBooks Online through an SAP BusinessObjects universe.
-
Connect PivotalTracker to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live PivotalTracker using the CData Python MCP Server.
-
Publish Reports with Google Analytics Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Analytics.
-
Connect to Sugar CRM Data from PowerBuilder via JDBC
This article demonstrates how to access Sugar CRM from PowerBuilder using the Sugar CRM JDBC Driver.
-
How to work with Apollo Data in Apache Spark using SQL
Access and process Apollo Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for Adobe Analytics in SAS for Real-Time Reporting and Analytics
Connect to real-time Adobe Analytics in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Adobe Analytics.
-
Access Live Zoho Projects Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Zoho Projects into the statistical analysis tools available in SAS JMP. This article shows how to use Zoho Projects in the Graph Builder and Query Builder.
-
Import Real-Time Calendly Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Calendly in ColdFusion.
-
Integrate Excel Data in Pentaho Data Integration
Build ETL pipelines based on Microsoft Excel in the Pentaho Data Integration tool.
-
Use Dash to Build to Web Apps on Facebook Data
Create Python applications that use pandas and Dash to build Facebook-connected web apps.
-
Connect to and Visualize Live Oracle Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Oracle Database.
-
Integrate Teamgate Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Teamgate from Informatica Cloud.
-
Use Dash to Build Web Apps on Amazon S3 Data via CData Connect AI
Build interactive Dash web apps on live Amazon S3 using pandas and the CData Connect AI Python SDK.
-
Publish Facebook Ads-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Facebook Ads.
-
Connect to Mistral AI Data in NetBeans
Connect to Mistral AI in NetBeans with the data source configuration wizard.
-
Create Informatica Mappings From/To an ODBC Data Source for Datadog
Create an ODBC connection to Datadog in Informatica and browse and transfer Datadog.
-
How to integrate Metabase with SAP SuccessFactors Data
Use CData Connect AI to connect to live SAP SuccessFactors and create an interactive dashboard in Metabase from SAP SuccessFactors.
-
Visualize Live SAP ByDesign Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP Business ByDesign.
-
Easily Integrate Google Ads Data in Lazarus Pascal IDE
Learn how to easily integrate live Google Ads in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Explore Geographical Relationships in Pinterest Data with Power Map
Create data visualizations with Pinterest in Power Map.
-
How to use SQLAlchemy ORM to access Facebook Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Facebook.
-
Connect to Discord Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Discord in the Denodo Virtual DataPort Administrator.
-
Explore Geographical Relationships in Sage 200 Data with Power Map
Create data visualizations with Sage 200 in Power Map.
-
Access Live Impala Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Apache Impala from your Excel spreadsheets.
-
Replicate Invoiced Data in Heroku for Use in Salesforce Connect
Replicate Invoiced to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build a Simple VCL Application for Datadog Data
How to build a simple VCL Application to view Datadog in RAD Studio using the CData ODBC Driver for Datadog.
-
How to connect to MariaDB Data from IntelliJ
Integrate connectivity to MariaDB with wizards in IntelliJ.
-
Object-Relational Mapping (ORM) with HubDB 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 HubDB into a Java-based ORM framework, Hibernate.
-
Integrate DB2 with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate DB2 with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to IBM DB2.
-
Building Dynamic Web Pages with Zuora Data Using AngularJS
Create single-page applications with live connectivity to Zuora using the CData API Server.
-
How to connect to Shippo Data in DBVisualizer
Integrate Shippo with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Codat from a Connection Pool in WebLogic
Use the CData JDBC Driver for Codat to connect to Codat from Web applications running on WebLogic.
-
Bridge Freshsales Connectivity with Apache NiFi
Access and process Freshsales in Apache NiFi using the CData JDBC Driver.
-
Build AI Agents with Amazon DynamoDB 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 DynamoDB through CData Connect AI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Opsgenie
Provide connectivity to Opsgenie through an SAP BusinessObjects universe.
-
Replicate Multiple Microsoft Planner Accounts
Replicate multiple Microsoft Planner accounts to one or many databases.
-
How to connect to Klaviyo Data from IntelliJ
Integrate connectivity to Klaviyo with wizards in IntelliJ.
-
Visualize Live SAP SuccessFactors LMS Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP SuccessFactors LMS into custom reports in Power BI.
-
Publish Crystal Reports on QuickBooks Time Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date QuickBooks Time.
-
Access TaxJar 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 TaxJar.
-
Access Live Reckon Accounts Hosted Data in Coginiti Pro
Connect to and query live Reckon Accounts Hosted from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to ConvertAPI Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ConvertAPI in the Denodo Virtual DataPort Administrator.
-
Getting Started with the CData Tableau Connector for Zoho Recruit
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build Dashboards with SpaceX Data in Dundas BI
Create dynamic dashboards and perform analytics based on SpaceX in Dundas BI.
-
Integrate Access Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Access from Informatica Cloud.
-
Analyze Twitter Ads Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Twitter Ads from Power Pivot. You will use the Table Import Wizard to load Twitter Ads. You can visually build the import query or use any SQL supported by the driver.
-
How to connect PolyBase to Amazon S3
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Amazon S3.
-
Getting Started with the CData Tableau Connector for Auth0
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Replicate Google Ads Data to Multiple Databases via the CData Sync CLI
Replicate Google Ads to disparate databases with a single configuration.
-
Use Claude to Talk to Your Acumatica 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 Acumatica ERP for you.
-
How to Connect to Live Square Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Square for you.