CData Software - Knowledge Base
Recent Articles
-
Integrate Live Active Directory Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Active Directory to Blue Prism using the CData ODBC Driver for Active Directory to create automated workflows for repetitive business tasks.
-
Connect to NASA Data in RazorSQL
Connect to NASA from wizards and query NASA from the GUI in the RazorSQL database management tool.
-
Connect to Azure Synapse Data in RapidMiner
Integrate Azure Synapse with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData Python Connector for Amazon Marketplace
Learn to install and license the CData Python Connector
-
Integrate with LaunchDarkly Data in JReport Designer
Create charts and reports based on LaunchDarkly in JReport Designer.
-
Write a Simple Go Application to work with Apollo Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Apollo.
-
Visualize DB2 Data in TIBCO Spotfire through OData
Integrate IBM DB2 into dashboards in TIBCO Spotfire.
-
Import and Visualize Greenhouse Data in Power View
Create data visualizations based on Greenhouse in Excel.
-
Connect to Facebook Data in HULFT Integrate
Connect to Facebook as a JDBC data source in HULFT Integrate
-
Use JayDeBeApi to access Teradata Data in Python
Use standard Python scripting and the development environment of your choice to access live Teradata.
-
Access Live Azure Analysis Services Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Azure Analysis Services into the statistical analysis tools available in SAS JMP. This article shows how to use Azure Analysis Services in the Graph Builder and Query Builder.
-
Replicate FHIR Data from PowerShell
Write a quick PowerShell script to query FHIR. Use connectivity to the live data to replicate FHIR to SQL Server.
-
Write a Simple Go Application to work with SharePoint Excel Services Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SharePoint Excel Services.
-
DataBind Controls to Paylocity Data in Delphi
DataBind to Paylocity in Delphi with standard data access components and controls.
-
Automated Continuous AfterShip Replication to MongoDB
Use CData Sync for automated, continuous, customizable AfterShip replication to MongoDB.
-
Replicate SAP Ariba Source Data to Multiple Databases via the CData Sync CLI
Replicate SAP Ariba Source to disparate databases with a single configuration.
-
How to Import Data from Okta into Google Sheets
Import Okta into a Google spreadsheet that is automatically refreshed.
-
How to Access Live Unbounce Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Unbounce enables you to integrate Unbounce into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Google Search Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Search replication to delimited files (CSV/TSV).
-
Connect to Webflow Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Webflow and work with Webflow in your FileMaker applications.
-
Create Power BI Reports on Real-Time ConvertKit Data
Use the CData ODBC Driver for ConvertKit to visualize ConvertKit in Power BI Desktop.
-
How to connect to Amazon DynamoDB Data with Squirrel SQL client
Connect to Amazon DynamoDB and execute queries in the Squirrel SQL Client.
-
Edit and Search Float External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Float to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Float objects that you can access from apps and the dashboard.
-
ETL OnePageCrm in Oracle Data Integrator
This article shows how to transfer OnePageCrm into a data warehouse using Oracle Data Integrator.
-
Connect to Clockify Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Clockify and work with Clockify in your FileMaker application.
-
Connect to Typeform Data from PowerBuilder via ADO.NET
This article demonstrates how to access Typeform from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Rebilly to Power BI dashboards. Simply drag and drop Rebilly into data visuals on the Power BI canvas.
-
Build an OLAP Cube in SSAS from Testmonitor Data
Establish a connection to Testmonitor data from SQL Server Analysis Services, and use the Testmonitor Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Live SAP ByDesign Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP ByDesign from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP Business ByDesign.
-
Analyze Tally Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Tally ERP and visualize Tally ERP in SAP Analytics Cloud.
-
Getting Started with the CData ADO.NET Provider for Pushbullet
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to Build an ETL App for Smartsheet Data in Python with CData
Create ETL applications and real-time data pipelines for Smartsheet in Python with petl.
-
Build an OLAP Cube in SSAS from Google Calendar Data
Establish a connection to Google Calendar data from SQL Server Analysis Services, and use the Google Calendar Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Couchbase Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Couchbase replication to Amazon S3.
-
Use JayDeBeApi to access Azure Synapse Data in Python
Use standard Python scripting and the development environment of your choice to access live Azure Synapse.
-
Analyze Factorial Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Factorial and visualize live Factorial in Infragistics Reveal.
-
How to Connect to Live Google Campaign Manager 360 Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Google Campaign Manager 360 for you.
-
How to import Blackbaud FE NXT Data into Apache Solr
Use the CData Software JDBC Driver for Blackbaud FE NXT in Data Import Handler and create an automated import of Blackbaud FE NXT to Apache Solr Enterprise Search platform.
-
Build a Simple VCL Application for Nethunt Data
How to build a simple VCL Application to view Nethunt in RAD Studio using the CData ODBC Driver for Nethunt.
-
How to connect to SpaceX Data in DBVisualizer
Integrate SpaceX with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to FTP from a Connection Pool in WebLogic
Use the CData JDBC Driver for FTP to connect to FTP Servers from Web applications running on WebLogic.
-
Using the CData Software ODBC Driver for Delighted in PyCharm
Connect to Delighted as an ODBC data source in PyCharm using the CData Software ODBC Driver for Delighted.
-
Rapidly Develop Exa-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 Exa.
-
How to Connect DBeaver to ZohoInvoice via a JDBC Driver
Manage ZohoInvoice with visual tools in DBeaver like the query browser.
-
Working with SAP Business One Data in LINQPad
Execute LINQ queries to SAP Business One in LINQPad.
-
Connect to Splunk Data in Jaspersoft Studio
Execute SQL to remote Splunk in Jaspersoft Studio.
-
Building Dynamic Web Pages with ConvertKit Data Using AngularJS
Create single-page applications with live connectivity to ConvertKit using the CData API Server.
-
Query GitLab Data through ODBC in Node.js
Use node-odbc to execute SQL queries against GitLab from Node.js.
-
How to Access Live Power BI XMLA Data in Visual Studio Code via Cline
Run CData MCP Server for Power BI XMLA on Windows Subsytem for Linux (WSL) and connect to live Power BI XMLA from the Cline extension in Visual Studio Code.
-
Access Live LinkedIn Data in AWS Lambda (with IntelliJ IDEA)
Connect to live LinkedIn in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Publish Crystal Reports on Coinbase Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Coinbase.
-
Visualize Mode Data in Sisense
Create an ElastiCube in Sisense app with access to Mode.
-
Access Live Avaza Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Avaza into the statistical analysis tools available in SAS JMP. This article shows how to use Avaza in the Graph Builder and Query Builder.
-
Creating Google Contacts-Connected Applications in Unqork
You can use CData Connect AI to feed Google Contacts to Unqork and build custom business apps.
-
Use JayDeBeApi to access Jira Assets Data in Python
Use standard Python scripting and the development environment of your choice to access live Jira Assets.
-
Connect to ConvertAPI Data in NetBeans
Connect to ConvertAPI in NetBeans with the data source configuration wizard.
-
Integrating OpenCode Terminal with Apollo 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.
-
Design BIRT Reports on Adobe Commerce Data
Provide current Adobe Commerce to your embedded analytics.
-
Excel Spreadsheet Automation on Raisers Edge NXT Data with the QUERY Formula
Pull data from Raisers Edge NXT, automate spreadsheets, and more with the QUERY formula.
-
Integrating LangGraph with Lakebase Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Lakebase within automated workflows.
-
Automated Continuous SharePoint Excel Services Replication to Databricks
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Databricks.
-
Provide OData Services of AfterShip Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for AfterShip by developing a WCF Service Application.
-
Build a Singer.io Tap for Gmail With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Gmail data using
-
Build an OLAP Cube in SSAS from SAP Business One Data
Establish a connection to SAP Business One data from SQL Server Analysis Services, and use the SAP Business One Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to HCL Domino Data from Crystal Reports
Use CData Connect AI to connect to and report on live HCL Domino from Crystal Reports.
-
Access LeadDesk Data from MySQL in Amazon QuickSight
Connect to LeadDesk and build visualizations of LeadDesk using a MySQL Connection in Amazon QuickSight.
-
Automate SuiteCRM Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SuiteCRM and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Automated Continuous SAP Fieldglass Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to delimited files (CSV/TSV).
-
How to Connect to Live Avalara AvaTax Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Avalara AvaTax without replication.
-
Use the CData Software ODBC Driver for Deel in SAS for Real-Time Reporting and Analytics
Connect to real-time Deel in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Deel.
-
Connect to Rootly Data in Aqua Data Studio
Access Rootly from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build AI/ML Models with Live SendGrid Data using Dataiku
Connect SendGrid Data with Dataiku using the CData JDBC Driver for SendGrid.
-
How to Connect the Power BI Service to Zoom: Complete Guide
Connect to the CData Software Power BI Connector for Zoom from PowerBI.com to provide real-time Zoom across the organization.
-
Integrate Real-Time Access to Simplesat in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Simplesat in real time.
-
How to Seamlessly Import Cohere Data into IBM SPSS Modeler
Integrate Cohere data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Provide OData Services of QuickBooks Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for QuickBooks Desktop by developing a WCF Service Application.
-
Build Mistral AI-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Mistral AI Data in Cursor to assist with building Mistral AI-powered applications.
-
Easily Integrate Facebook Ads Data in Lazarus Pascal IDE
Learn how to easily integrate live Facebook Ads in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Google Analytics Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Analytics and the SQL Gateway to access Google Analytics from Google Apps Script.
-
Connect to Aweber from a Connection Pool in WebLogic
Use the CData JDBC Driver for Aweber to connect to Aweber from Web applications running on WebLogic.
-
A PostgreSQL Interface for JotForm Data using the CData ODBC Driver
Use the SQL Gateway and JotForm ODBC Driver to create a PostgreSQL entry-point for data access.
-
Import Real-Time Aweber Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Aweber in ColdFusion.
-
Access Live CouchDB Data in TIBCO Data Virtualization
Use the CouchDB Tibco DV Adapter to create a Apache CouchDB data source in TIBCO Data Virtualization Studio and gain access to live Apache CouchDB from your TDV Server.
-
Load Workday Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Workday to a database.
-
Trigger Hive IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Hive with standard wizards in Logic Apps.
-
Use the CData Software ODBC Driver for Brex in MicroStrategy
Connect to Brex in MicroStrategy Developer using the CData Software ODBC Driver for Brex.
-
Automated Continuous Google Ad Manager Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to AlloyDB.
-
Use CData Connect AI to Access Sybase Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Sybase in the Power Pivot business intelligence tool.
-
Add AgileCRM Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for AgileCRM with the Informatica Enterprise Data Catalog to classify and organize data.
-
Deploy the ADO.NET Provider for Yelp on an SSRS Report Server
Connect to Yelp 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.
-
Create Informatica Mappings From/To an ODBC Data Source for Keap
Create an ODBC connection to Keap in Informatica and browse and transfer Keap.
-
Getting Started with the CData ODBC Driver for Microsoft Teams
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Microsoft Teams.
-
Build Dashboards with iContact Data in DBxtra
Create dynamic dashboards and perform analytics based on iContact in DBxtra.
-
Access FreeAgent 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 FreeAgent.
-
Build a Singer.io Tap for Okta With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Okta data using
-
Build Semantic Layer Views for SAP SuccessFactors LMS Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP SuccessFactors LMS.
-
Explore Geographical Relationships in TaxJar Data with Power Map
Create data visualizations with TaxJar in Power Map.
-
Migrating data from Webflow to Snowflake using CData SSIS Components.
Easily push Webflow to Snowflake using the CData SSIS Tasks for Webflow and Snowflake.
-
Use Dash to Build to Web Apps on Freshservice Data
Create Python applications that use pandas and Dash to build Freshservice-connected web apps.
-
Connect Qualaroo to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Qualaroo with IBM WebSphere for seamless data integration and connectivity.