CData Software - Knowledge Base
Recent Articles
-
Perform Batch Operations with Salesloft Data in Apache NiFi
Connect to Salesloft and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Clio Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Clio in the Denodo Virtual DataPort Administrator.
-
Access Live BigQuery Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Google BigQuery through MCP integration.
-
Visualize Certinia 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 Certinia into TIBCO Spotfire.
-
Build Charts with Figshare Data in Clear Analytics
Create dynamic charts and perform analytics based on Figshare in Clear Analytics.
-
Connect to Procore Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Procore.
-
Import Real-Time Retently Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Retently in ColdFusion.
-
How to Connect to Live eBay Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your eBay for you.
-
Import Real-Time Adobe Target Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Adobe Target in ColdFusion.
-
Bind Live Cloudant Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Cloudant data
-
Integrate Live Facebook Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Facebook to Blue Prism using the CData ODBC Driver for Facebook to create automated workflows for repetitive business tasks.
-
Connect to and Visualize Live Google Directory Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Directory.
-
Visualize WordPress Data in Tableau
The CData ODBC driver for WordPress enables you integrate WordPress into Tableau dashboards.
-
Automated Continuous Greenplum Replication to MySQL
Use CData Sync for automated, continuous, customizable Greenplum replication to MySQL.
-
Visualize Zoho Creator 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 Zoho Creator into TIBCO Spotfire.
-
How to Connect to Reckon Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Reckon. Leverage the pyodbc module for ODBC in Python.
-
Import Vault CRM Data Using Azure Data Factory
Use CData Connect AI to connect to Vault CRM Data from Azure Data Factory and import live Veeva Vault & Vault CRM.
-
Connect to Live Freshdesk Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Freshdesk in CData Connect AI and connect to your Freshdesk from PostgreSQL.
-
Connect to Microsoft Entra ID Data in DBArtisan
Use wizards in DBArtisan to configure Microsoft Entra ID as a data source.
-
Getting Started with the CData JDBC Driver for Mixpanel
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Mixpanel.
-
Access Live Stripe Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Stripe through MCP integration.
-
Query Zendesk Data in ColdFusion
Write standard ColdFusion data access code to connect to Zendesk.
-
Access Live Grafana Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Grafana into the statistical analysis tools available in SAS JMP. This article shows how to use Grafana in the Graph Builder and Query Builder.
-
Replicate Multiple ZohoPeople Accounts via the CData Sync CLI
Replicate multiple ZohoPeople accounts to one or many databases.
-
Configure the CData JDBC Driver for Xero in a Connection Pool in Tomcat
Connect to Xero Accounting from a connection pool in Tomcat.
-
Access Live Productboard Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Productboard into the statistical analysis tools available in SAS JMP. This article shows how to use Productboard in the Graph Builder and Query Builder.
-
Import and Visualize Cloudant Data in Power View
Create data visualizations based on IBM Cloudant in Excel.
-
Connect to and Query Outlook Data in QlikView over ODBC
Create data visualizations with Outlook in QlikView.
-
How to Query Live CloudConvert Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live CloudConvert data in natural language using Python.
-
How to Query Salesforce Marketing Data in MySQL Workbench
Execute MySQL queries against live Salesforce Marketing Cloud from MySQL Workbench.
-
Automated Continuous Opsgenie Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Opsgenie replication to OneLake in Microsoft Fabric.
-
Connect to Amazon Athena Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Amazon Athena and the SQL Gateway to access Amazon Athena from Google Apps Script.
-
Build Charts with SAP Business One Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP Business One in Clear Analytics.
-
Connect to Salesforce Marketing from Asprova with CData Software ODBC Driver for Salesforce Marketing
This article shows how to connect faster to Salesforce Marketing data from Asprova.
-
Use JayDeBeApi to access Nuclia Data in Python
Use standard Python scripting and the development environment of your choice to access live Nuclia.
-
Integrate Pipedrive Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Pipedrive from Informatica Cloud.
-
Deploy the ADO.NET Provider for Browserless on an SSRS Report Server
Connect to Browserless 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.
-
Choosing the Best Method to Connect Guru to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Guru from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Choosing the Best Method to Connect Webflow to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Webflow from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
DataBind Controls to SharePoint Excel Services Data in Delphi
DataBind to SharePoint Excel Services in Delphi with standard data access components and controls.
-
DataBind Lakebase Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Lakebase with the DevExpress Windows Forms and Web controls to provide Lakebase to a chart.
-
DataBind Freshdesk Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Freshdesk with the DevExpress Windows Forms and Web controls to provide Freshdesk to a chart.
-
Access Live MYOB AccountRight Data in Coginiti Pro
Connect to and query live MYOB AccountRight from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Browserless Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Browserless using standard SQL.
-
How to connect PolyBase to Google Campaign Manager 360
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Campaign Manager 360.
-
How to Import Data from Google Contacts into Google Sheets
Import Google Contacts into a Google spreadsheet that is automatically refreshed.
-
How to Connect to Shopify Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Shopify. Leverage the pyodbc module for ODBC in Python.
-
Consume SAS xpt OData Feeds in PowerBuilder
This article demonstrates how to consume SAS XPORT as OData feeds from PowerBuilder using the API Server.
-
Use Dash to Build to Web Apps on Zoho Inventory Data
Create Python applications that use pandas and Dash to build Zoho Inventory-connected web apps.
-
Connect to Quickbase Data in Ruby
Connect to Quickbase in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to create an RPA flow for VWO Data in UiPath Studio
Use the VWO ODBC Driver to create workflows that access real-time VWO without any coding.
-
DataBind Controls to Cloudant Data in C++Builder
DataBind to IBM Cloudant in C++Builder with standard components and controls.
-
Add Greenplum Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Greenplum with the Informatica Enterprise Data Catalog to classify and organize data.
-
Migrating data from QuickBooks Time to Databricks using CData SSIS Components.
Easily push QuickBooks Time to Databricks using the CData SSIS Tasks for QuickBooks Time and Databricks.
-
Automate Reckon Accounts Hosted Data Replication to Azure Data Lake
Use CData Sync to customize and automate Reckon Accounts Hosted replication to Azure Data Lake.
-
Building Dynamic Web Pages with Bitbucket Data Using AngularJS
Create single-page applications with live connectivity to Bitbucket using the CData API Server.
-
Integrate with Office 365 Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft Office 365 to a JSON file on disk.
-
Validate Unbounce Data with QuerySurge
Access and validate Unbounce in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Elasticsearch Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Elasticsearch replication to Amazon S3.
-
Rapidly Develop SharePoint Excel Services-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 SharePoint Excel Services.
-
Build a PostgreSQL Interface for Clio Data using the CData JDBC Driver
Use the Remoting features of the Clio JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Avro-Connected Nintex Workflows
Use CData Connect AI to connect to Avro Data from Nintex Workflow Cloud and build custom workflows using live Apache Avro.
-
A PostgreSQL Interface for SAP SuccessFactors Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP SuccessFactors JDBC Driver to create a PostgreSQL entry-point for data access.
-
Creating IBM Cloud Object Storage-Connected Applications in Unqork
You can use CData Connect AI to feed IBM Cloud Object Storage to Unqork and build custom business apps.
-
Connect Reckon Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Reckon using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Real-Time Access to Pingdom in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Pingdom in real time.
-
Integrate Rootly Data in Pentaho Data Integration
Build ETL pipelines based on Rootly in the Pentaho Data Integration tool.
-
How to update Amazon Athena from Excel
This article explains how to transfer data from Excel to Amazon Athena using the Excel Add-In for Amazon Athena.
-
Connect Active Directory Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Active Directory using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Reports with Adobe Experience Manager Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Adobe Experience Manager.
-
Integrate SingleStore with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SingleStore with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SingleStore.
-
How to Access Live Gong Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Gong enables you to integrate Gong into workflows built using Microsoft Power Automate Desktop.
-
Easily Integrate IBM Informix Data in Lazarus Pascal IDE
Learn how to easily integrate live IBM Informix in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to update Salesforce CRM Analytics from Excel
This article explains how to transfer data from Excel to Salesforce CRM Analytics using the Excel Add-In for Salesforce CRM Analytics.
-
Create SSAS Tabular Models from Power BI XMLA Data
How to build a SQL Server Analysis Service Tabular Model from Power BI XMLA using CData drivers.
-
Integrate with live SAP SuccessFactors LMS Data in Jitterbit
Use CData Connect AI to connect to and integrate live SAP SuccessFactors LMS in Jitterbit.
-
Connect to OData Services in Jaspersoft Studio
Execute SQL to remote OData in Jaspersoft Studio.
-
How to Build an ETL App for Databricks Data in Python with CData
Create ETL applications and real-time data pipelines for Databricks in Python with petl.
-
Integrate ActiveCampaign Data in Pentaho Data Integration
Build ETL pipelines based on ActiveCampaign in the Pentaho Data Integration tool.
-
Natively Connect to Testmonitor Data in PHP
The CData ODBC driver for Testmonitor enables you to create PHP applications with connectivity to Testmonitor. Leverage the native support for ODBC in PHP.
-
How to Connect to Live SAP Netweaver Gateway Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your SAP Netweaver Gateway through natural language.
-
How to Visualize Front Data in Python with pandas
Use pandas and other modules to analyze and visualize live Front in Python.
-
Connect to Google Directory Data in RazorSQL
Connect to Google Directory from wizards and query Google Directory from the GUI in the RazorSQL database management tool.
-
How to Connect SAS Data Sets Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live SAS Data Sets data in real time using natural language.
-
How to work with Gumroad Data in Apache Spark using SQL
Access and process Gumroad Data in Apache Spark using the CData Software JDBC Driver.
-
How to Access Live Acumatica Data in Visual Studio Code via Cline
Run CData MCP Server for Acumatica on Windows Subsytem for Linux (WSL) and connect to live Acumatica ERP from the Cline extension in Visual Studio Code.
-
Connect to Zoho CRM Data in Claris FileMaker Pro
Use the CData ODBC Driver for Zoho CRM in FileMaker Pro to connect to Zoho CRM and work with Zoho CRM in your FileMaker applications.
-
Connect to Bugsnag Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
DataBind Controls to Odoo Data in C++Builder
DataBind to Odoo ERP in C++Builder with standard components and controls.
-
Connect to LDAP Objects from PowerBuilder via ADO.NET
This article demonstrates how to access LDAP from Appeon PowerBuilder using the CData ADO.NET Provider for LDAP.
-
Connect to TigerGraph Data in Claris FileMaker Pro
Use the CData ODBC Driver for TigerGraph in FileMaker Pro to connect to TigerGraph and work with TigerGraph in your FileMaker applications.
-
How to connect Amazon QuickSight to Salesforce Marketing Data
Create a connection to Salesforce Marketing Cloud in CData Connect AI and insert Salesforce Marketing Cloud into Amazon QuickSight SPICE to build interactive dashboards.
-
How to work with Hubstaff Data in Apache Spark using SQL
Access and process Hubstaff Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live Avro Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Apache Avro into the statistical analysis tools available in SAS JMP. This article shows how to use Apache Avro in the Graph Builder and Query Builder.
-
Access Live FreshBooks Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a FreshBooks data source in TIBCO Data Virtualization Studio and gain access to live FreshBooks from your TDV Server.
-
Build Data Flows from REST to SQL Server using SSIS
Easily back up REST to SQL Server using the SSIS components for REST.
-
Connect to ClickUp Data in RazorSQL
Connect to ClickUp from wizards and query ClickUp from the GUI in the RazorSQL database management tool.
-
Query Guru Data in ColdFusion
Write standard ColdFusion data access code to connect to Guru.
-
Replicate Google Forms Data in Heroku for Use in Salesforce Connect
Replicate Google Forms to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
ETL Tavily in Oracle Data Integrator
This article shows how to transfer Tavily into a data warehouse using Oracle Data Integrator.