CData Software - Knowledge Base
Recent Articles
-
Connect to Everhour Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Everhour and work with Everhour in your FileMaker applications.
-
Automated Continuous BenchmarkEmail Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to Apache Kafka.
-
Analyze Salesforce CRM Analytics Data in Cognos Analytics
Use CData Connect AI to connect to Salesforce CRM Analytics Data from Cognos Analytics and analyze live Salesforce CRM Analytics.
-
Build Salesforce-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Salesforce & Force.com.
-
Visualize SAP BusinessObjects BI Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP BusinessObjects BI.
-
Design BIRT Reports on SendInBlue Data
Provide current SendInBlue to your embedded analytics.
-
Import and Visualize Microsoft Exchange Data in Power View
Create data visualizations based on Microsoft Exchange in Excel.
-
How to connect to Foursquare Data from IntelliJ
Integrate connectivity to Foursquare with wizards in IntelliJ.
-
Connect to Bullhorn CRM Data from HeidiSQL
Use CData Connect AI to connect to and query live Bullhorn CRM from HeidiSQL.
-
Visualize SAP Business One Data in Tableau
The CData ODBC driver for SAP Business One enables you integrate SAP Business One into Tableau dashboards.
-
Integrate with SAP Concur Data in JReport Designer
Create charts and reports based on SAP Concur in JReport Designer.
-
Connect FHIR to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live FHIR using the CData Python MCP Server.
-
Migrating data from ConstantContact to Google BigQuery using CData SSIS Components.
Easily push ConstantContact to Google BigQuery using the CData SSIS Tasks for ConstantContact and Google BigQuery.
-
Automated Continuous Couchbase Replication to Oracle
Use CData Sync for automated, continuous, customizable Couchbase replication to Oracle.
-
Getting Started with the CData ODBC Driver for Pinecone
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Pinecone.
-
Validate Landbot Data with QuerySurge
Access and validate Landbot in QuerySurge using the CData JDBC Driver.
-
Query Gmail Data in DataGrip
Create a Data Source for Gmail in DataGrip and use SQL to query live Gmail.
-
Build PayPal-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for PayPal to explore live PayPal Data in Claude Code to assist with building PayPal-powered applications.
-
A PostgreSQL Interface for MarkLogic Data using the CData ODBC Driver
Use the SQL Gateway and MarkLogic ODBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Presto Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Presto with the DevExpress Windows Forms and Web controls to provide Presto to a chart.
-
Publish Amazon S3-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Amazon S3.
-
Use the CData Software ODBC Driver for QuickBooks Time in SAS for Real-Time Reporting and Analytics
Connect to real-time QuickBooks Time in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for QuickBooks Time.
-
Integrate MailerSend Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MailerSend from Informatica Cloud.
-
Query, Visualize, and Share live Lakebase Data in Redash
Use CData Connect AI to connect to live Lakebase in Redash for querying, visualizing, and sharing.
-
How to create an RPA flow for SingleStore Data in UiPath Studio
Use the SingleStore ODBC Driver to create workflows that access real-time SingleStore without any coding.
-
Automated Continuous Active Directory Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Active Directory replication to PostgreSQL.
-
Create Dynamic Zoho Projects Grids Using the Infragistics XamDataGrid
Learn how you can connect Zoho Projects to Infragistics XamDataGrid to build dynamic grids.
-
How to Connect to Live Google Search Results 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 Google Search for you.
-
Replicate Bannerbear Data in Heroku for Use in Salesforce Connect
Replicate Bannerbear to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Visualize FreshBooks Data in Python with pandas
Use pandas and other modules to analyze and visualize live FreshBooks in Python.
-
Analyze Coda Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Coda with the CData JDBC Driver for Coda.
-
Publish Reports with FTP Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date FTP Servers.
-
Getting Started with the CData Python Connector for ConvertKit
Learn to install and license the CData Python Connector
-
Integrate NetSuite with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate NetSuite with External Services.
-
How to Import Data from Trello into Google Sheets
Import Trello into a Google spreadsheet that is automatically refreshed.
-
Connect to Amazon Marketplace Data in DBArtisan
Use wizards in DBArtisan to configure Amazon Marketplace as a data source.
-
Connect to OData Services in DBArtisan
Use wizards in DBArtisan to configure OData as a data source.
-
Access Live NASA Data in AWS Lambda (with IntelliJ IDEA)
Connect to live NASA in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Codat Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Codat replication to Amazon S3.
-
Connect to Calendly Data in Aqua Data Studio
Access Calendly from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to RabbitMQ Data in HULFT Integrate
Connect to RabbitMQ as a JDBC data source in HULFT Integrate
-
How to connect and process Microsoft Entra ID from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft Entra ID.
-
Connect MongoDB to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live MongoDB using the CData Python MCP Server.
-
Connect to Asana Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Asana in the Denodo Virtual DataPort Administrator.
-
Integrate Dropbox Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Dropbox and integrate live Dropbox into your Power Automate tasks.
-
Load JDBC-ODBC Bridge Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load JDBC-ODBC Bridge to a database.
-
Getting Started with the CData ODBC Driver for Freshservice
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Freshservice.
-
A PostgreSQL Interface for AdRoll Data using the CData ODBC Driver
Use the SQL Gateway and AdRoll ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build MYOB AccountRight Visualizations in Tableau Cloud
Use CData Connect AI to connect to live MYOB AccountRight and build visualizations in Tableau Cloud.
-
How to Connect the Power BI Service to NetSuite: Complete Guide
Connect to the CData Software Power BI Connector for NetSuite from PowerBI.com to provide real-time NetSuite CRM & ERP across the organization.
-
Automated Continuous Google Analytics Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Analytics replication to Apache Kafka.
-
Working with Demio Data in LINQPad
Execute LINQ queries to Demio in LINQPad.
-
How to Connect to & Open Splunk Data in Microsoft Excel
This article uses the CData ODBC driver for Splunk to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Enable the ClickTime JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ClickTime.
-
Use Biml to Build SSIS Tasks to Replicate Coda Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Coda to SQL Server.
-
Connect to LinkedIn Ads Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Live Twitter Ads Data in Coginiti Pro
Connect to and query live Twitter Ads from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Foursquare Data in JRuby
Create a simple JRuby app with access to live Foursquare.
-
Integrate PayPal Data in Pentaho Data Integration
Build ETL pipelines based on PayPal in the Pentaho Data Integration tool.
-
How to publish and share Campaigner Data dashboards with Tableau Server
The CData ODBC driver for Campaigner enables you integrate Campaigner into Tableau dashboards.
-
Build a Singer.io Tap for Superchat With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Superchat data using
-
Publish Reports with Access Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Access.
-
Integrate Live Oracle Financials Cloud Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Oracle Financials Cloud from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Oracle Financials Cloud.
-
Visualize Live Onfleet Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Onfleet.
-
Automated Continuous Confluence Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Confluence replication to Azure SQL Database.
-
How to connect PolyBase to ShipEngine
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ShipEngine.
-
Access Live Azure Table Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Azure Table Storage from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Couchbase in SpagoBI
Create reports featuring live Couchbase in SpagoBI Studio. Host Couchbase reports on SpagoBI Server.
-
Building Dynamic Web Pages with Quickbase Data Using AngularJS
Create single-page applications with live connectivity to Quickbase using the CData API Server.
-
Use Agno to Talk to Your Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Pivotal GreenPlum for you.
-
Access Presto 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 Presto.
-
Creating Microsoft Planner-Connected Applications in Unqork
You can use CData Connect AI to feed Microsoft Planner to Unqork and build custom business apps.
-
Back Up PivotalTracker to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with PivotalTracker data.
-
Consume Microsoft Planner OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft Planner as OData feeds from PowerBuilder using the API Server.
-
Connect to PayPal Data in RazorSQL
Connect to PayPal from wizards and query PayPal from the GUI in the RazorSQL database management tool.
-
Connect to SendInBlue Data in NetBeans
Connect to SendInBlue in NetBeans with the data source configuration wizard.
-
Automated Continuous SendPulse Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SendPulse replication to Apache Cassandra.
-
DataBind Charts to Xero Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Xero Accounting 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 to Live Presto Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Presto securely in real time.
-
Access Drip Data from MySQL in Amazon QuickSight
Connect to Drip and build visualizations of Drip using a MySQL Connection in Amazon QuickSight.
-
Seamlessly Bring Trello Data into Retool Using CData Connect AI
Integrate Trello data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Import Salesforce Pardot Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Salesforce Pardot Data and provide access to live Salesforce Pardot for custom reports in the Power BI Service.
-
How to create Reply.io federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Reply.io in MySQL .
-
Query Google Ad Manager Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Ad Manager from Node.js.
-
Connect to Google Translate Data from PowerBuilder via JDBC
This article demonstrates how to access Google Translate from PowerBuilder using the Google Translate JDBC Driver.
-
Query AgileCRM Data in ColdFusion
Write standard ColdFusion data access code to connect to AgileCRM.
-
Use the CData API Server to Access Salesforce Pardot Data in Microsoft PowerPivot
Use the CData API Server to connect to live Salesforce Pardot in the Power Pivot business intelligence tool.
-
How to integrate Chargebee with Apache Airflow
Access and process Chargebee in Apache Airflow using the CData JDBC Driver.
-
Connect to Microsoft Teams from Asprova with CData Software ODBC Driver for Microsoft Teams
This article shows how to connect faster to Microsoft Teams data from Asprova.
-
Add Close Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Close with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect DBeaver to Perplexity via a JDBC Driver
Manage Perplexity with visual tools in DBeaver like the query browser.
-
Wrike Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Wrike facts in real time.
-
Build an OLAP Cube in SSAS from Oracle Financials Cloud Data
Establish a connection to Oracle Financials Cloud data from SQL Server Analysis Services, and use the Oracle Financials Cloud Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Dashboards with SAP Business Warehouse Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP Business Warehouse in Dundas BI.
-
How to Query Google Ad Manager Data in MySQL Workbench
Execute MySQL queries against live Google Ad Manager from MySQL Workbench.
-
Deploy the ADO.NET Provider for Onfleet on an SSRS Report Server
Connect to Onfleet 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.
-
Automated Continuous TaxJar Replication to SQLite
Use CData Sync for automated, continuous, customizable TaxJar replication to SQLite.
-
How to integrate Metabase with Amazon Athena Data
Use CData Connect AI to connect to live Amazon Athena and create an interactive dashboard in Metabase from Amazon Athena.
-
Use Databricks Agent Bricks to Talk to Your Stripe Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Stripe for you.
-
Analyze Microsoft Dataverse Data in Looker
Use CData Connect AI to connect to Microsoft Dataverse Data from Looker and build custom apps using live Microsoft Dataverse (CDS).