CData Software - Knowledge Base
Recent Articles
-
Create a Data Access Object for Guru Data using JDBI
A brief overview of creating a SQL Object API for Guru in JDBI.
-
Replicate Multiple ChargeOver Accounts via the CData Sync CLI
Replicate multiple ChargeOver accounts to one or many databases.
-
Connect to Basecamp Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Basecamp and the SQL Gateway to access Basecamp from Google Apps Script.
-
Import Redis Data Using Azure Data Factory
Use CData Connect AI to connect to Redis Data from Azure Data Factory and import live Redis.
-
Use the CData Software JDBC Driver for Bugsnag in MicroStrategy Desktop
Connect to Bugsnag in MicroStrategy Desktop using the CData Software JDBC Driver for Bugsnag.
-
Load Nethunt Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Nethunt to a database.
-
How to Connect to Live Confluence 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 Atlassian Confluence for you.
-
Connect to and Visualize Live Adobe Target Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Adobe Target.
-
Analyze Email Data in Looker
Use CData Connect AI to connect to Email Data from Looker and build custom apps using live Email.
-
Migrating data from Suadeo to Snowflake using CData SSIS Components.
Easily push Suadeo to Snowflake using the CData SSIS Tasks for Suadeo and Snowflake.
-
Build Semantic Layer Views for Tavily Data in APOS Live Data Gateway
Use the CData Connector for Tavily in APOS Live Data Gateway to build Semantic Layer Views for Tavily.
-
Analyze CouchDB Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Apache CouchDB and visualize Apache CouchDB in SAP Analytics Cloud.
-
Connect Attio to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Attio with IBM WebSphere for seamless data integration and connectivity.
-
Access Live Impala Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Apache Impala in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Enable the Kafka JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Apache Kafka.
-
Create Xero-Connected Nintex Workflows
Use CData Connect AI to connect to Xero Data from Nintex Workflow Cloud and build custom workflows using live Xero Accounting.
-
Integrate LibreChat with Live Epicor Kinetic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Epicor Kinetic from within the chat interface.
-
Connecting Mastra with LinkedIn Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time LinkedIn, no replication required.
-
Automated Continuous Outreach.io Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Outreach.io replication to IBM DB2.
-
Automate Beeminder Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Beeminder from PowerShell? This article demonstrates how to utilize the Beeminder Cmdlets for tasks like connecting to Beeminder, automating operations, downloading data, and more.
-
How to Visualize Close Data in Python with pandas
Use pandas and other modules to analyze and visualize live Close in Python.
-
Automate SFTP Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SFTP from PowerShell? This article demonstrates how to utilize the SFTP Cmdlets for tasks like connecting to SFTP, automating operations, downloading data, and more.
-
Publish Crystal Reports on Square Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Square.
-
Stream SAP SuccessFactors Data into Apache Kafka Topics
Access and stream SAP SuccessFactors in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Power BI Reports on Real-Time JotForm Data
Use the CData ODBC Driver for JotForm to visualize JotForm in Power BI Desktop.
-
How to create an RPA flow for Harvest Data in UiPath Studio
Use the Harvest ODBC Driver to create workflows that access real-time Harvest without any coding.
-
Automated Continuous Harvest Replication to SQLite
Use CData Sync for automated, continuous, customizable Harvest replication to SQLite.
-
How to Connect DBeaver to CloudConvert via a JDBC Driver
Manage CloudConvert with visual tools in DBeaver like the query browser.
-
How to integrate RSS with Apache Airflow
Access and process RSS Feeds in Apache Airflow using the CData JDBC Driver.
-
Integrate xBase with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate xBase with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to xBase.
-
Build Charts with ShipStation Data in Clear Analytics
Create dynamic charts and perform analytics based on ShipStation in Clear Analytics.
-
Write a Simple Go Application to work with Hacker News Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Hacker News.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Paymo
Provide connectivity to Paymo through an SAP BusinessObjects universe.
-
Connect to Asana Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Asana.
-
How to Connect to Live Adobe Analytics Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Adobe Analytics securely in real time.
-
Connect to Shippo from a Connection Pool in WebLogic
Use the CData JDBC Driver for Shippo to connect to Shippo from Web applications running on WebLogic.
-
Getting Started with the CData Excel Add-In for SAP BusinessObjects BI
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP BusinessObjects BI.
-
Connect to Greenplum Data in Jaspersoft Studio
Execute SQL to remote Pivotal GreenPlum in Jaspersoft Studio.
-
Build SAP SuccessFactors-Connected Apps in Choreo
Use CData Connect AI to connect to SAP SuccessFactors Data from Choreo and build custom apps using live SAP SuccessFactors.
-
Automated Continuous Cosmos DB Replication to SingleStore
Use CData Sync for automated, continuous, customizable Cosmos DB replication to SingleStore.
-
Use the CData Software JDBC Driver for Sage Intacct in MicroStrategy Desktop
Connect to Sage Intacct in MicroStrategy Desktop using the CData Software JDBC Driver for Sage Intacct.
-
Use the CData Software JDBC Driver for MailerLite in MicroStrategy Web
Connect to MailerLite in MicroStrategy Web using the CData Software JDBC Driver for MailerLite.
-
Use the CData SSIS Components to Insert New or Update Existing SAS Data Sets Records from SQL Server
Easily push SQL Server data to SAS Data Sets using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SAS Data Sets or update existing records with data from a SQL Server database.
-
OpenWeatherMap Reporting in OBIEE with the OpenWeatherMap JDBC Driver
Deploy the OpenWeatherMap JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize Discourse Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Discourse.
-
Build a PostgreSQL Interface for Google Translate Data using the CData JDBC Driver
Use the Remoting features of the Google Translate JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous OnePageCrm Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable OnePageCrm replication to Apache Cassandra.
-
Prepare, Blend, and Analyze Mocean Data in Alteryx Designer (ODBC)
Build workflows to access live Mocean for self-service data analytics.
-
Use Dash to Build to Web Apps on Phoenix Data
Create Python applications that use pandas and Dash to build Phoenix-connected web apps.
-
How to connect to Wave Financial Data in DBVisualizer
Integrate Wave Financial with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze Live SharePoint Data in SAS Viya
Use CData Connect AI to connect to Microsoft SharePoint from SAS Viya and deploy self-service analytics using live Microsoft SharePoint.
-
Build Charts with Pipedrive Data in Clear Analytics
Create dynamic charts and perform analytics based on Pipedrive in Clear Analytics.
-
Analyze Tavily Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Tavily with the CData JDBC Driver for Tavily.
-
Connect to SAP Business Warehouse Data in RazorSQL
Connect to SAP Business Warehouse from wizards and query SAP Business Warehouse from the GUI in the RazorSQL database management tool.
-
Automated Continuous Twilio Replication to MySQL
Use CData Sync for automated, continuous, customizable Twilio replication to MySQL.
-
Visualize Hive Data in TIBCO Spotfire through OData
Integrate Apache Hive into dashboards in TIBCO Spotfire.
-
Automated Continuous SendPulse Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SendPulse replication to Google BigQuery.
-
Use the CData Software ODBC Driver for VWO in SAS for Real-Time Reporting and Analytics
Connect to real-time VWO in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for VWO.
-
Getting Started with the CData Tableau Connector for Apollo
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to connect SharePoint with Twitter Ads Data through external lists
Provide Twitter Ads to SharePoint users as an external list.
-
Write a Simple Go Application to work with Productboard Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Productboard.
-
Google Ads Reporting in OBIEE with the Google Ads JDBC Driver
Deploy the Google Ads JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Pingdom Data in RapidMiner
Integrate Pingdom with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Redshift Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Amazon Redshift in the Denodo Virtual DataPort Administrator.
-
Build AI/ML Models with Live Salesforce Pardot Data using Dataiku
Connect Salesforce Pardot Data with Dataiku using the CData JDBC Driver for Salesforce Pardot.
-
Use the CData Software JDBC Driver for Factorial in MicroStrategy
Connect to Factorial in MicroStrategy Developer using the CData Software JDBC Driver for Factorial.
-
Access Beeminder Data from MySQL in Amazon QuickSight
Connect to Beeminder and build visualizations of Beeminder using a MySQL Connection in Amazon QuickSight.
-
Build Xero Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Xero Accounting and build visualizations in Tableau Cloud.
-
Automate Sybase IQ Data Replication to Azure Synapse
Use CData Sync to customize and automate Sybase IQ replication to Azure Synapse.
-
Integrating Antigravity CLI with Couchbase via CData CLI
Connect Couchbase to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Stream Dynamics NAV Data into Apache Kafka Topics
Access and stream Microsoft Dynamics NAV in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Analyze SAP Ariba Procurement Data in Cognos Analytics
Use CData Connect AI to connect to SAP Ariba Procurement Data from Cognos Analytics and analyze live SAP Ariba Procurement.
-
Import Real-Time BenchmarkEmail Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use BenchmarkEmail in ColdFusion.
-
How to Easily Query HubDB Data in OpenOffice Base
Connect to HubDB data in OpenOffice Base using the CData ODBC Driver for HubDB and generate reports with live data insights.
-
Integrating Kiro CLI with ZohoDesk 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.
-
How to import Float Data into Apache Solr
Use the CData Software JDBC Driver for Float in Data Import Handler and create an automated import of Float to Apache Solr Enterprise Search platform.
-
View Reports on Real-Time Reckon Data in Power BI Report Server
Use the CData ODBC Driver for Reckon to visualize Reckon in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Browserless from a Connection Pool in WebLogic
Use the CData JDBC Driver for Browserless to connect to Browserless from Web applications running on WebLogic.
-
Connect to Oracle Data in RapidMiner
Integrate Oracle Database with standard components and data source configuration wizards in RapidMiner Studio.
-
Creating Blackbaud FE NXT-Connected Applications in Unqork
You can use CData Connect AI to feed Blackbaud FE NXT to Unqork and build custom business apps.
-
Jira Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Jira facts in real time.
-
Build Sage 200-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Sage 200 to explore live Sage 200 Data in Cursor to assist with building Sage 200-powered applications.
-
Integrating Antigravity CLI with FreeAgent via CData CLI
Connect FreeAgent to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous CapsuleCRM Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Apache Kafka.
-
Getting Started with the CData JDBC Driver for Xero
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Xero.
-
Process & Analyze WooCommerce Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live WooCommerce Data.
-
Import Salesforce Data 360 Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Salesforce Data 360. In this article, you will use the OData format to import Salesforce Data 360 into Microsoft Power Query.
-
Access Live Strava Data in Coginiti Pro
Connect to and query live Strava from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Access Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Access from your Oracle system.
-
How to integrate Excel with Apache Airflow
Access and process Microsoft Excel in Apache Airflow using the CData JDBC Driver.
-
Model, Search, and Visualize Live Facebook Data in ThoughtSpot
Use CData Connect AI to connect to live Facebook for modeling, searching, and visualizing.
-
Work with SuiteCRM Data in FoxPro
Load SuiteCRM into a FoxPro database. This article includes full code and a walk-through of the process.
-
DataBind Charts to Odoo Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Odoo ERP 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.
-
Connect to Live eBay Data in MicroStrategy through CData Connect AI
Create a live connection to eBay Data in CData Connect AI and connect to your eBay from MicroStrategy.
-
Deploy the ADO.NET Provider for SingleStore on an SSRS Report Server
Connect to SingleStore 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 Dynamics NAV Replication to SQLite
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to SQLite.
-
Working with Shippo Data in LINQPad
Execute LINQ queries to Shippo in LINQPad.
-
Build AI Agents with OData 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 OData through CData Connect AI.
-
Connect to Attio Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use the CData Software ODBC Driver for Acumatica in MicroStrategy Desktop
Connect to Acumatica ERP in MicroStrategy Desktop using the CData Software ODBC Driver for Acumatica.