CData Software - Knowledge Base
Recent Articles
-
Connect to Cloudant Data in JRuby
Create a simple JRuby app with access to live IBM Cloudant.
-
Automated Adobe Target Data Replication to Teradata
Use CData Sync to Customize and automate Adobe Target replication to Teradata.
-
Visualize Live ConvertKit Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ConvertKit.
-
Create Informatica Mappings From/To a JDBC Data Source for Browserless
Create Browserless data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Add ClickTime Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ClickTime with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle SCM
Provide connectivity to Oracle SCM through an SAP BusinessObjects universe.
-
Replicate Multiple Tickspot Accounts via the CData Sync CLI
Replicate multiple Tickspot accounts to one or many databases.
-
Automated Continuous Toggl Replication to Databricks
Use CData Sync for automated, continuous, customizable Toggl replication to Databricks.
-
Connect to FreeAgent from Asprova with CData Software ODBC Driver for FreeAgent
This article shows how to connect faster to FreeAgent data from Asprova.
-
How to Connect DBeaver to Blackbaud FE NXT via a JDBC Driver
Manage Blackbaud FE NXT with visual tools in DBeaver like the query browser.
-
Access GetResponse Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access GetResponse from your Oracle system.
-
Easily Integrate Bugsnag Data in Lazarus Pascal IDE
Learn how to easily integrate live Bugsnag in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect to Live Zoho Creator Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Zoho Creator for you.
-
Connect to Acumatica Data in Claris FileMaker Pro
Use the CData ODBC Driver for Acumatica in FileMaker Pro to connect to Acumatica and work with Acumatica ERP in your FileMaker applications.
-
Automated Continuous Exact Online Replication to SingleStore
Use CData Sync for automated, continuous, customizable Exact Online replication to SingleStore.
-
Create Dashboards and Visualize Live SAP Ariba Procurement Data in Geckoboard
Use CData Connect AI to connect to live SAP Ariba Procurement and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Easily Query NASA Data in OpenOffice Base
Connect to NASA data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Moving Data from Simplesat to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Simplesat data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Operational Reporting on Google Contacts Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Contacts.
-
How to connect to Couchbase Data in DBVisualizer
Integrate Couchbase with visual data analysis tools and data connection wizards in DBVisualizer
-
Automate Salesforce Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Salesforce & Force.com and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Use the CData Software ODBC Driver for Procore in MicroStrategy Web
Connect to Procore in MicroStrategy Web using the CData Software ODBC Driver for Procore.
-
Build Power BI XMLA-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Power BI XMLA Data and create custom apps in Mendix.
-
Build Oracle Eloqua Reporting-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Oracle Eloqua Reporting to explore live Oracle Eloqua Reporting Data in Cursor to assist with building Oracle Eloqua Reporting-powered applications.
-
Visualize Paylocity 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 Paylocity into TIBCO Spotfire.
-
How to Query Live Dynamics 365 Business Central Data in Perplexity MacOS Desktop
Connect to and query live Dynamics 365 Business Central Data in Perplexity Desktop using CData MCP Server.
-
Access Live Amazon S3 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 Amazon S3 through MCP integration.
-
Connect to SAP Concur Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SAP Concur from Filemaker Pro on Mac.
-
LINQ to Short.io Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Short.io Data Provider.
-
Integrate Theia IDE with Live Google Ad Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Viewing Unbounce Data in RAD Studio Data Explorer
How to view Unbounce in RAD Studio Data Explorer using the CData ODBC Driver for Unbounce.
-
How to Connect to Live SAP Netweaver Gateway 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 SAP Netweaver Gateway for you.
-
How to connect to Splunk Data from IntelliJ
Integrate connectivity to Splunk with wizards in IntelliJ.
-
Create SSAS Tabular Models from Trello Data
How to build a SQL Server Analysis Service Tabular Model from Trello using CData drivers.
-
Connect to Google Ad Manager Data in Aqua Data Studio
Access Google Ad Manager from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Migrating data from ClickTime to Snowflake using CData SSIS Components.
Easily push ClickTime to Snowflake using the CData SSIS Tasks for ClickTime and Snowflake.
-
Create Dashboards and Visualize Live Odoo Data in Geckoboard
Use CData Connect AI to connect to live Odoo ERP and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Excel Spreadsheet Automation on Impala Data with the QUERY Formula
Pull data from Impala, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Todoist Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Todoist replication to Amazon S3.
-
Access Twitter Ads Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Twitter Ads from HeidiSQL.
-
Enable the Zoho Inventory JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Zoho Inventory.
-
Extend Google Sheets with Adobe Target Data
Make calls to Adobe Target from Google Apps Script via the API Server.
-
Build Xero-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Xero Data from Zoho Analytics and import live Xero Accounting.
-
How to connect and process Facebook Ads from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Facebook Ads.
-
Replicate AfterShip Data in Heroku for Use in Salesforce Connect
Replicate AfterShip to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Excel Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Excel replication to Google BigQuery.
-
A PostgreSQL Interface for Instagram Data (MySQL Remoting via JDBC)
Use the Remoting features of the Instagram JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build HCL Domino Visualizations in Tableau Desktop
Use CData Connect AI to connect to live HCL Domino and build visualizations in Tableau.
-
Visualize AgileCRM Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to AgileCRM.
-
Visualize Live Guru Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Guru.
-
Integrate Retently Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Retently from Informatica Cloud.
-
Rapidly Develop LaunchDarkly-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 LaunchDarkly.
-
Migrating data from Recurly to Snowflake using CData SSIS Components.
Easily push Recurly to Snowflake using the CData SSIS Tasks for Recurly and Snowflake.
-
Access Live Jira Assets Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Jira Assets from your Excel spreadsheets.
-
Create Google Directory-Connected Nintex Workflows
Use CData Connect AI to connect to Google Directory Data from Nintex Workflow Cloud and build custom workflows using live Google Directory.
-
How to load Codat data into Elasticsearch via Logstash
Introducing a simple method to load Codat data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to QuickBooks Time Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live QuickBooks Time from Filemaker Pro on Mac.
-
How to connect to Kafka Data from IntelliJ
Integrate connectivity to Apache Kafka with wizards in IntelliJ.
-
Visualize Slack Data in Sisense
Create an ElastiCube in Sisense app with access to Slack.
-
Import and Visualize Timely Data in Power View
Create data visualizations based on Timely in Excel.
-
Connect to Cosmos DB Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Cosmos DB and the SQL Gateway to access Azure Cosmos DB from Google Apps Script.
-
Getting Started with the CData SSIS Components for FHIR
Complete guide to installing, licensing, and connecting with the CData SSIS Components for FHIR.
-
Integrate Cloudflare with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Cloudflare with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Cloudflare.
-
Connect to SFTP Data from PowerBuilder via JDBC
This article demonstrates how to access SFTP from PowerBuilder using the SFTP JDBC Driver.
-
Getting Started with the CData Excel Add-In for Tavily
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Tavily.
-
How to Query Live SendPulse Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SendPulse data in natural language using Python.
-
Moving Data from Active Directory to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Active Directory data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Zuora Replication to SingleStore
Use CData Sync for automated, continuous, customizable Zuora replication to SingleStore.
-
How to connect to Teamwork Data from Spring Boot
Connect to Teamwork in a Spring Boot Application using the CData API Driver for JDBC
-
Build MVC Applications with Connectivity to Asana Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Asana from an ASP.NET MVC application.
-
Build a Simple VCL Application for Harvest Data
How to build a simple VCL Application to view Harvest in RAD Studio using the CData ODBC Driver for Harvest.
-
Integrate Cursor with Live Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Apache Avro from within the editor.
-
Integrating Gumloop with DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on IBM DB2 within automated workflows.
-
Access Live HCL Domino Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live HCL Domino from your Google Sheets.
-
Publish Act-On-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Act-On.
-
Establish a Live Connection with Odoo Data using Tableau Bridge
The CData ODBC Driver for Odoo enables you to integrate live Odoo ERP into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Sage 200 Data from Crystal Reports
Use CData Connect AI to connect to and report on live Sage 200 from Crystal Reports.
-
Integrating OpenCode Terminal with Hacker News 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.
-
Connect to Email from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Email, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Replicate Multiple Highrise Accounts via the CData Sync CLI
Replicate multiple Highrise accounts to one or many databases.
-
Create Datasets from Instagram in Domo Workbench and Build Visualizations of Instagram Data in Domo
Use the CData Software ODBC Driver for Instagram to create datasets from Instagram in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Figshare Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Figshare into the statistical analysis tools available in SAS JMP. This article shows how to use Figshare in the Graph Builder and Query Builder.
-
Create Reports with SAP Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP ERP/NetWeaver.
-
Automated Continuous JSON Replication to SQLite
Use CData Sync for automated, continuous, customizable JSON replication to SQLite.
-
Integrating Gumloop with Gmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Gmail within automated workflows.
-
Automated Continuous QuickBooks Time Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Google BigQuery.
-
Create Acumatica Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Acumatica from PowerBI.com to create Power BI Dataflows with real-time data.
-
Manage ZeroBounce Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ZeroBounce.
-
Automate Neo4J Data Replication to SAP HANA
Use CData Sync to customize and automate Neo4J replication to SAP HANA.
-
Connect to Snowflake from Asprova with CData Software ODBC Driver for Snowflake
This article shows how to connect faster to Snowflake data from Asprova.
-
Automated Continuous ZohoInvoice Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to Azure SQL Database.
-
How to connect to LightSpeedRetail Data from Spring Boot
Connect to LightSpeedRetail in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Facebook Ads using the Model Context Protocol.
-
Connect to eBay Data in JRuby
Create a simple JRuby app with access to live eBay.
-
Use the CData Software ODBC Driver for Okta in MicroStrategy Web
Connect to Okta in MicroStrategy Web using the CData Software ODBC Driver for Okta.
-
How to create Salesforce Data 360 federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Salesforce Data 360 in MySQL .
-
Connect Wave Financial to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Wave Financial using the CData Python MCP Server.
-
Integrate Retently Data in the Pentaho Report Designer
Publish reports based on Retently in the Pentaho BI tool.
-
Create Dashboards and Visualize Live SAP Ariba Source Data in Geckoboard
Use CData Connect AI to connect to live SAP Ariba Source and create dashboards for real-time monitoring and visualization in Geckoboard.
-
A PostgreSQL Interface for NASA Data (MySQL Remoting via JDBC)
Use the Remoting features of the NASA JDBC Driver to create a PostgreSQL entry-point for data access.