CData Software - Knowledge Base
Recent Articles
-
Use the CData JDBC Drivers to Create New Data Sources in DbVisualizer
Connect to the CData JDBC Driver for QuickBooks through the DbVisualizer database management tool.
-
Rapidly Develop Microsoft OneDrive-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 Microsoft OneDrive.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Salesforce CRM Analytics to Power BI dashboards. Simply drag and drop Salesforce CRM Analytics into data visuals on the Power BI canvas.
-
Use the CData Software ODBC Driver for ConvertKit in SAS for Real-Time Reporting and Analytics
Connect to real-time ConvertKit in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ConvertKit.
-
Connect to FormSite Data in JRuby
Create a simple JRuby app with access to live FormSite.
-
How to connect to Sage Cloud Accounting Data from Spring Boot
Connect to Sage Cloud Accounting in a Spring Boot Application using the CData JDBC Driver for Sage Cloud Accounting
-
Create Dashboards and Visualize Live SAP SuccessFactors Data in Geckoboard
Use CData Connect AI to connect to live SAP SuccessFactors and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate Live Stripe Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Automated Continuous ZarMoney Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ZarMoney replication to Amazon Redshift.
-
Working with SAS xpt Data in LINQPad
Execute LINQ queries to SAS XPORT in LINQPad.
-
Moving Data from Paylocity to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Paylocity data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Validate Jira Data with QuerySurge
Access and validate Atlassian Jira in QuerySurge using the CData JDBC Driver.
-
Connect to and Query Google Directory Data in QlikView over ODBC
Create data visualizations with Google Directory in QlikView.
-
Use the CData Software JDBC Driver for SQL Analysis Services in MicroStrategy Web
Connect to SQL Analysis Services in MicroStrategy Web using the CData Software JDBC Driver for SQL Analysis Services.
-
Automated Continuous HubSpot Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable HubSpot replication to Azure SQL Database.
-
Create Bullhorn CRM-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Bullhorn CRM Data from OutSystems and build custom enterprise apps using live Bullhorn CRM.
-
Load Oracle Sales Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Oracle Sales to a database.
-
Build Data Flows from Vault CRM to SQL Server using SSIS
Easily back up Veeva Vault & Vault CRM to SQL Server using the SSIS components for Vault CRM.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Attio
Provide connectivity to Attio through an SAP BusinessObjects universe.
-
Access Live Exact Online Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Exact Online from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Access Live Foursquare Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Foursquare enables you to integrate Foursquare into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous eBay Analytics Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable eBay Analytics replication to delimited files (CSV/TSV).
-
How to Connect Flowise AI Agents to Live Phoenix 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 Apache Phoenix without replication.
-
Build a Singer.io Tap for Cassandra With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Cassandra data using
-
How to connect and process Azure Analysis Services from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Azure Analysis Services.
-
Query Moosend Data as a MySQL Database in Node.js
Execute MySQL queries against Moosend from Node.js.
-
Query Bugsnag Data in DataGrip
Create a Data Source for Bugsnag in DataGrip and use SQL to query live Bugsnag.
-
How to Access Live Sugar CRM Data in Visual Studio Code via Cline
Run CData MCP Server for Sugar CRM on Windows Subsytem for Linux (WSL) and connect to live Sugar CRM from the Cline extension in Visual Studio Code.
-
Build Data Flows from CloudConvert to SQL Server using SSIS
Easily back up CloudConvert to SQL Server using the SSIS components for CloudConvert.
-
How to connect Amazon QuickSight to BigQuery Data
Create a connection to Google BigQuery in CData Connect AI and insert Google BigQuery into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Auth0 Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Auth0 from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live JSON Services in AWS Lambda
Connect to live JSON in AWS Lambda using the CData JDBC Driver.
-
Query, Visualize, and Share live NetSuite SuiteAnalytics Data in Redash
Use CData Connect AI to connect to live NetSuite SuiteAnalytics in Redash for querying, visualizing, and sharing.
-
Query Elorus Data in ColdFusion
Write standard ColdFusion data access code to connect to Elorus.
-
Validate Dotmailer Data with QuerySurge
Access and validate Dotmailer in QuerySurge using the CData JDBC Driver.
-
Use Dash to Build to Web Apps on ZohoMarketingHub Data
Create Python applications that use pandas and Dash to build ZohoMarketingHub-connected web apps.
-
Access Jira Assets Data from MySQL in PHP
Connect to Jira Assets through the standard MySQL libraries in PHP.
-
Connect to MarkLogic Data in Google Apps Script via Connect AI
Use CData Connect AI to access MarkLogic in Google Apps Script.
-
Visualize Live Google Cloud Storage Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Google Cloud Storage into custom reports in Power BI.
-
Connect to LinkedIn Data in HULFT Integrate
Connect to LinkedIn as a JDBC data source in HULFT Integrate
-
Analyze Live Phoenix Data in SAS Viya
Use CData Connect AI to connect to Apache Phoenix from SAS Viya and deploy self-service analytics using live Apache Phoenix.
-
Connect to LaunchDarkly from a Connection Pool in WebLogic
Use the CData JDBC Driver for LaunchDarkly to connect to LaunchDarkly from Web applications running on WebLogic.
-
How to connect to Active Directory Data from IntelliJ
Integrate connectivity to Active Directory with wizards in IntelliJ.
-
Replicate Multiple ZohoSubscriptions Accounts
Replicate multiple ZohoSubscriptions accounts to one or many databases.
-
Migrating data from Zoho Inventory to Google BigQuery using CData SSIS Components.
Easily push Zoho Inventory to Google BigQuery using the CData SSIS Tasks for Zoho Inventory and Google BigQuery.
-
Integrate with Auth0 Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Auth0 to a JSON file on disk.
-
Visualize Live Elasticsearch Data in the Power BI Service
Use CData Connect AI to connect to live Elasticsearch and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze ADP Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ADP with the CData JDBC Driver for ADP.
-
Integrating Antigravity CLI with SAP BusinessObjects BI via CData CLI
Connect SAP BusinessObjects BI to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Amazon S3 Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Amazon S3 and build visualizations in Tableau.
-
Integrate Shortcut Data in the Pentaho Report Designer
Publish reports based on Shortcut in the Pentaho BI tool.
-
Add ConvertAPI Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ConvertAPI with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Tickspot Data from PowerBuilder via ADO.NET
This article demonstrates how to access Tickspot from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build a Simple VCL Application for Microsoft OneDrive Data
How to build a simple VCL Application to view Microsoft OneDrive in RAD Studio using the CData ODBC Driver for Microsoft OneDrive.
-
Natively Connect to Beeminder Data in PHP
The CData ODBC driver for Beeminder enables you to create PHP applications with connectivity to Beeminder. Leverage the native support for ODBC in PHP.
-
Access Live Instagram Data in AWS Lambda
Connect to live Instagram in AWS Lambda using the CData JDBC Driver.
-
Integrate with HBase Data in JReport Designer
Create charts and reports based on Apache HBase in JReport Designer.
-
Visualize SageHR Data in Tableau
The CData ODBC driver for SageHR enables you integrate SageHR into Tableau dashboards.
-
Integrating Antigravity CLI with Discourse via CData CLI
Connect Discourse to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Use Databricks Agent Bricks to Talk to Your Oracle Sales Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Oracle Sales for you.
-
Connect to and Visualize Live Adobe Experience Manager Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Adobe Experience Manager.
-
Build Semantic Layer Views for Amazon S3 Data in APOS Live Data Gateway
Use the CData Connector for Amazon S3 in APOS Live Data Gateway to build Semantic Layer Views for Amazon S3.
-
Automated Continuous Sage 200 Replication to MongoDB
Use CData Sync for automated, continuous, customizable Sage 200 replication to MongoDB.
-
Explore Geographical Relationships in Printful Data with Power Map
Create data visualizations with Printful in Power Map.
-
Easily Integrate Teamwork Data in Lazarus Pascal IDE
Learn how to easily integrate live Teamwork in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Hive Data in Aqua Data Studio
Access Apache Hive from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Process & Analyze Tally Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Tally Data.
-
Build Tavily-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Tavily and build web apps with connectivity to live Tavily.
-
Access LDAP Objects from MySQL in Amazon QuickSight
Connect to LDAP and build visualizations of LDAP using a MySQL Connection in Amazon QuickSight.
-
Use the CData Software JDBC Driver for AgileCRM in MicroStrategy Web
Connect to AgileCRM in MicroStrategy Web using the CData Software JDBC Driver for AgileCRM.
-
DataBind Charts to OData Services
Use the standard ADO.NET procedures for databinding to provide bidirectional access to OData 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.
-
Access Live SFTP Data in Coginiti Pro
Connect to and query live SFTP from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Salesforce CRM Analytics Data in JRuby
Create a simple JRuby app with access to live Salesforce CRM Analytics.
-
Getting Started with the CData ODBC Driver for Delighted
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Delighted.
-
How to connect to Azure DevOps Data from Spring Boot
Connect to Azure DevOps in a Spring Boot Application using the CData JDBC Driver for Azure DevOps
-
Use Microsoft Copilot Studio to talk to your Twilio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Twilio for you.
-
DataBind Controls to SparkPost Data in Delphi
DataBind to SparkPost in Delphi with standard data access components and controls.
-
Visualize Act CRM Data in TIBCO Spotfire through OData
Integrate Act CRM into dashboards in TIBCO Spotfire.
-
Publish Crystal Reports on Outlook Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Outlook.
-
Automated Continuous Ontraport Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Ontraport replication to IBM DB2.
-
Integrating Antigravity CLI with Apache CouchDB via CData CLI
Connect Apache CouchDB to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Rapidly Develop Datadog-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 Datadog.
-
How to connect PolyBase to Azure Table
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Azure Table Storage.
-
How to Work with Google Analytics Data in AWS Glue Jobs Using JDBC
Connect to Google Analytics from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Egnyte Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Egnyte replication to PostgreSQL.
-
Perform Batch Operations with Excel Data in Apache NiFi
Connect to Microsoft Excel and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to use SQLAlchemy ORM to access FormSite Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of FormSite.
-
Import and Visualize Bitly Data in Power View
Create data visualizations based on Bitly in Excel.
-
Replicate SAP Ariba Procurement Data to Multiple Databases
Replicate SAP Ariba Procurement to disparate databases with a point-and-click configuration.
-
Use the CData API Server to Access SAP ByDesign Data in Microsoft PowerPivot
Use the CData API Server to connect to live SAP Business ByDesign in the Power Pivot business intelligence tool.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Databricks actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
How to Connect DBeaver to Slack via a JDBC Driver
Manage Slack with visual tools in DBeaver like the query browser.
-
Use the CData Software JDBC Driver for Freshdesk in MicroStrategy Web
Connect to Freshdesk in MicroStrategy Web using the CData Software JDBC Driver for Freshdesk.
-
Build a PostgreSQL Interface for Suadeo Data using the CData JDBC Driver
Use the Remoting features of the Suadeo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to ChartMogul Data in HULFT Integrate
Connect to ChartMogul as a JDBC data source in HULFT Integrate
-
Natively Connect to Zoom Data in PHP
The CData ODBC driver for Zoom enables you to create PHP applications with connectivity to Zoom. Leverage the native support for ODBC in PHP.
-
Automated JSON Services Replication to Teradata
Use CData Sync to Customize and automate JSON replication to Teradata.
-
How to Connect DBeaver to Stripe via a JDBC Driver
Manage Stripe with visual tools in DBeaver like the query browser.
-
How to Query Live Salesforce Marketing Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Salesforce Marketing Cloud data in natural language using Python.
-
A PostgreSQL Interface for HubSpot Data using the CData ODBC Driver
Use the SQL Gateway and HubSpot ODBC Driver to create a PostgreSQL entry-point for data access.