CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Instagram Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Instagram replication to PostgreSQL.
-
Provide OData Services of Adobe Target Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Adobe Target by developing a WCF Service Application.
-
Getting Started with the CData ODBC Driver for Salesforce CRM Analytics
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Salesforce CRM Analytics.
-
Getting Started with the CData JDBC Driver for Active Directory
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Active Directory.
-
How to Seamlessly Import Cloudflare Data into IBM SPSS Modeler
Integrate Cloudflare data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Viewing Cvent Data in RAD Studio Data Explorer
How to view Cvent in RAD Studio Data Explorer using the CData ODBC Driver for Cvent.
-
Edit and Search EnterpriseDB External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of EnterpriseDB to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create EnterpriseDB objects that you can access from apps and the dashboard.
-
How to create an RPA flow for SAS xpt Data in UiPath Studio
Use the SAS xpt ODBC Driver to create workflows that access real-time SAS XPORT without any coding.
-
Integrating Amazon DynamoDB Data in Talend Cloud Data Management Platform
Connect Amazon DynamoDB Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Amazon DynamoDB.
-
Enable the Short.io JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Short.io.
-
How to Connect DBeaver to Bright Data via a JDBC Driver
Manage Bright Data with visual tools in DBeaver like the query browser.
-
Getting Started with the CData Connect AI Python SDK for OneNote
Install the CData Connect AI Python SDK to read and write live Microsoft OneNote with standard DB-API 2.0 Python code.
-
Use the CData API Server to Access Kafka Data in Microsoft PowerPivot
Use the CData API Server to connect to live Apache Kafka in the Power Pivot business intelligence tool.
-
Provide OData Services of Recurly Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Recurly by developing a WCF Service Application.
-
How to Visualize QuickBooks Time Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live QuickBooks Time in Python.
-
Access Live Apollo Data in Coginiti Pro
Connect to and query live Apollo from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Semantic Layer Views for Onfleet Data in APOS Live Data Gateway
Use the CData Connector for Onfleet in APOS Live Data Gateway to build Semantic Layer Views for Onfleet.
-
How to Connect to Live SAS xpt Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAS XPORT securely in real time.
-
Automated Continuous SendPulse Replication to SQL Server
Use CData Sync for automated, continuous, customizable SendPulse replication to SQL Server.
-
Connect to Wave Financial Data from a Connection Pool in JBoss
Integrate Wave Financial into Java servlets: Use the Management Console in JBoss to install the Wave Financial JDBC Driver.
-
Migrating data from Float to Google BigQuery using CData SSIS Components.
Easily push Float to Google BigQuery using the CData SSIS Tasks for Float and Google BigQuery.
-
Integrate with Excel Online Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft Excel Online to a JSON file on disk.
-
Analyze Adobe Commerce Data in Looker
Use CData Connect AI to connect to Adobe Commerce Data from Looker and build custom apps using live Adobe Commerce.
-
Use the CData Software ODBC Driver for Mouseflow in MicroStrategy
Connect to Mouseflow in MicroStrategy Developer using the CData Software ODBC Driver for Mouseflow.
-
Create Dynamic Snapchat Ads Grids Using the Infragistics XamDataGrid
Learn how you can connect Snapchat Ads to Infragistics XamDataGrid to build dynamic grids.
-
Excel Spreadsheet Automation on Azure Table Data with the QUERY Formula
Pull data from Azure Table, automate spreadsheets, and more with the QUERY formula.
-
Access NetSuite Sales Orders in Dynamics CRM
Improve your sales team’s visibility into the needs of your business and customers by accessing your NetSuite sales orders from Dynamics CRM.
-
Process & Analyze IBM Cloud Object Storage Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live IBM Cloud Object Storage Data.
-
Import Real-Time FTP Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use FTP Servers in ColdFusion.
-
Connect to Active Directory Data in Ruby
Connect to Active Directory in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed PayPal to Power BI dashboards. Simply drag and drop PayPal into data visuals on the Power BI canvas.
-
Visualize Deel Data in Sisense
Create an ElastiCube in Sisense app with access to Deel.
-
Integrate Live Front Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Front to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Query Live OneNote Data in Claude Desktop
Connect to and query live OneNote Data in Claude Desktop using CData MCP Server.
-
Connect to Vimeo Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Vimeo in the Denodo Virtual DataPort Administrator.
-
Integrate Salesforce Pardot with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Salesforce Pardot with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Salesforce Pardot.
-
Connect to Real-Time Browserless Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Browserless in Power Apps.
-
How to Connect the Power BI Service to Shortcut: Complete Guide
Connect to the CData Software Power BI Connector for Shortcut from PowerBI.com to provide real-time Shortcut across the organization.
-
Use the CData Software JDBC Driver for Apify in MicroStrategy Web
Connect to Apify in MicroStrategy Web using the CData Software JDBC Driver for Apify.
-
How to Import Data from GraphQL into Google Sheets
Import GraphQL into a Google spreadsheet that is automatically refreshed.
-
Easily Integrate Azure Table Data in Lazarus Pascal IDE
Learn how to easily integrate live Azure Table Storage in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automate Printify Data Replication to SAP HANA
Use CData Sync to customize and automate Printify replication to SAP HANA.
-
Bidirectional Access to OData Services from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate OData in Filemaker Pro for Mac or Windows.
-
View Reports on Real-Time Recurly Data in Power BI Report Server
Use the CData ODBC Driver for Recurly to visualize Recurly in Power BI Desktop and then publish them to Power BI Report Server.
-
Bidirectional Access to Attio Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Attio in Filemaker Pro for Mac or Windows.
-
Automated Continuous SendGrid Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SendGrid replication to Amazon Redshift.
-
Getting Started with the CData Python Connector for Strava
Learn to install and license the CData Python Connector
-
Automated Continuous Google Ads Replication to SingleStore
Use CData Sync for automated, continuous, customizable Google Ads replication to SingleStore.
-
Getting Started with the CData ADO.NET Provider for SAP Ariba Procurement
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SAP Ariba Procurement.
-
Use the CData Software ODBC Driver for RabbitMQ in MicroStrategy Desktop
Connect to RabbitMQ in MicroStrategy Desktop using the CData Software ODBC Driver for RabbitMQ.
-
Build Semantic Layer Views for MarkLogic Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for MarkLogic.
-
Visualize Kintone Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Kintone.
-
Import Real-Time Mailgun Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Mailgun in ColdFusion.
-
Recurly Reporting in OBIEE with the Recurly JDBC Driver
Deploy the Recurly JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
DataBind Controls to PingOne Data in C++Builder
DataBind to PingOne in C++Builder with standard components and controls.
-
How to Seamlessly Import SharePoint Excel Services Data into IBM SPSS Modeler
Integrate SharePoint Excel Services data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Work with NASA Data in FoxPro
Load NASA into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Real-Time Coinbase Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Coinbase in Power Apps.
-
Visualize Snowflake Data in Sisense
Create an ElastiCube in Sisense app with access to Snowflake.
-
How to Connect to & Open Teamgate Data in Microsoft Excel
This article uses the CData ODBC driver for Teamgate to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build AI Agents with Outreach.io 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 Outreach.io through CData Connect AI.
-
How to Build an ETL App for SQL Analysis Services Data in Python with CData Connect AI
Build ETL pipelines that read and write live SQL Analysis Services in Python with petl and the CData Connect AI Python SDK.
-
Connect to Toggl Data in CloverDX (formerly CloverETL)
Transfer Toggl using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous Microsoft Teams Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to Apache Kafka.
-
Feed Outreach.io Data into FineReport
How to set Outreach.io as a JDBC data source in FineReport.
-
Create Informatica Mappings From/To an ODBC Data Source for Paymo
Create an ODBC connection to Paymo in Informatica and browse and transfer Paymo.
-
Connect to YouTube Analytics Data from HeidiSQL
Use CData Connect AI to connect to and query live YouTube Analytics from HeidiSQL.
-
Access Microsoft Teams 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 Microsoft Teams.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Tally ERP to Power BI dashboards. Simply drag and drop Tally ERP into data visuals on the Power BI canvas.
-
Telegram Reporting in OBIEE with the Telegram JDBC Driver
Deploy the Telegram JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Google Directory Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Google Directory to connect to Google Directory and execute queries in PowerBuilder.
-
Establish a Live Connection with SAP ByDesign Data using Tableau Bridge
The CData ODBC Driver for SAP ByDesign enables you to integrate live SAP Business ByDesign into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Coinbase Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Coinbase.
-
How to connect to OnePageCrm Data from IntelliJ
Integrate connectivity to OnePageCrm with wizards in IntelliJ.
-
How to Connect to Live Zoho Projects 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 Zoho Projects for you.
-
Automate Tasks in Power Automate Using the CData API Server
Automate SAP Business One actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Write a Simple Go Application to work with Landbot Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Landbot.
-
Connect to Facebook from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Facebook, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to create an RPA flow for Amazon S3 Data in UiPath Studio
Use the Amazon S3 ODBC Driver to create workflows that access real-time Amazon S3 without any coding.
-
Access SendInBlue Data from MySQL in Amazon QuickSight
Connect to SendInBlue and build visualizations of SendInBlue using a MySQL Connection in Amazon QuickSight.
-
Connect to SAP HANA XS Advanced Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP HANA XS Advanced to connect to SAP HANA XS Advanced and execute queries in PowerBuilder.
-
Build a PostgreSQL Interface for Rebilly Data using the CData JDBC Driver
Use the Remoting features of the Rebilly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import Real-Time Google Sheets Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Sheets in ColdFusion.
-
Integrate Asana Data in the Pentaho Report Designer
Publish reports based on Asana in the Pentaho BI tool.
-
Design BIRT Reports on Exact Online Data
Provide current Exact Online to your embedded analytics.
-
Automated Continuous Klaviyo Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Klaviyo replication to AlloyDB.
-
Natively Connect to Coinbase Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Coinbase. Leverage the native support for ODBC in PHP.
-
Validate Short.io Data with QuerySurge
Access and validate Short.io in QuerySurge using the CData JDBC Driver.
-
Connect to LionDesk Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for LionDesk and the SQL Gateway to access LionDesk from Google Apps Script.
-
Prepare, Blend, and Analyze Perigon Data in Alteryx Designer (ODBC)
Build workflows to access live Perigon for self-service data analytics.
-
How to Visualize Certinia Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Certinia in Python.
-
Use the CData Software ODBC Driver for Rebilly in MicroStrategy
Connect to Rebilly in MicroStrategy Developer using the CData Software ODBC Driver for Rebilly.
-
Connect to and Query TigerGraph Data in QlikView over ODBC
Create data visualizations with TigerGraph in QlikView.
-
Build a Singer.io Tap for ServiceDesk Plus With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ServiceDesk Plus data using
-
DataBind Charts to Calendly Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Calendly 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.
-
How to Connect the Power BI Service to Amazon Athena: Complete Guide
Connect to the CData Software Power BI Connector for Amazon Athena from PowerBI.com to provide real-time Amazon Athena across the organization.
-
Use JayDeBeApi to access Google Translate Data in Python
Use standard Python scripting and the development environment of your choice to access live Google Translate.
-
Query Phoenix Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Phoenix entities in PHP by modeling them as objects.
-
Connect Epicor Kinetic Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Epicor Kinetic using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect PolarTeamPro to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect PolarTeamPro with IBM WebSphere for seamless data integration and connectivity.