CData Software - Knowledge Base
Recent Articles
-
Use Manus AI to Talk to Your HBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Apache HBase.
-
Import Microsoft Planner Data Using Azure Data Factory
Use CData Connect AI to connect to Microsoft Planner Data from Azure Data Factory and import live Microsoft Planner.
-
How to Connect to Live IBM Cloud Object Storage Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live IBM Cloud Object Storage securely in real time.
-
Integrating Codex CLI with Oracle Database 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 SAS xpt Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAS XPORT using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Natively Connect to Bitly Data in PHP
The CData ODBC driver for Bitly enables you to create PHP applications with connectivity to Bitly. Leverage the native support for ODBC in PHP.
-
Automated Continuous Google Spanner Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Spanner replication to PostgreSQL.
-
Automated Paylocity Data Replication to Teradata
Use CData Sync to Customize and automate Paylocity replication to Teradata.
-
PagerDuty Reporting in OBIEE with the PagerDuty JDBC Driver
Deploy the PagerDuty JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize Live CloudConvert Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live CloudConvert using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automate ConvertKit Data Replication to Couchbase
Use CData Sync to Customize and automate ConvertKit replication to Couchbase.
-
Build Visualizations of Sendwithus Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Sendwithus in Birst.
-
How to publish and share Bitly Data dashboards with Tableau Server
The CData ODBC driver for Bitly enables you integrate Bitly into Tableau dashboards.
-
How to publish and share Zoho Projects Data dashboards with Tableau Server
The CData ODBC driver for Zoho Projects enables you integrate Zoho Projects into Tableau dashboards.
-
Use the CData Software JDBC Driver for Adobe Commerce in MicroStrategy Desktop
Connect to Adobe Commerce in MicroStrategy Desktop using the CData Software JDBC Driver for Adobe Commerce.
-
Import HubSpot Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access HubSpot. In this article, you will use the OData format to import HubSpot into Microsoft Power Query.
-
Automated Continuous XML Replication to SQLite
Use CData Sync for automated, continuous, customizable XML replication to SQLite.
-
MailerSend Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on MailerSend facts in real time.
-
Integrate Cursor with Live SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Microsoft SQL Server from within the editor.
-
Bind Live SAP Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP data
-
Build Agents in Relevance AI with Access to Live Excel Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft Excel Online within intelligent agent workflows.
-
Build ServiceNow Visualizations in Tableau Desktop
Use CData Connect AI to connect to live ServiceNow and build visualizations in Tableau.
-
Replicate Multiple eBay Accounts via the CData Sync CLI
Replicate multiple eBay accounts to one or many databases.
-
Visualize Hive Data in Sisense
Create an ElastiCube in Sisense app with access to Apache Hive.
-
Building Dynamic Web Pages with WooCommerce Data Using AngularJS
Create single-page applications with live connectivity to WooCommerce using the CData API Server.
-
How to connect Amazon QuickSight to Amazon S3 Data
Create a connection to Amazon S3 in CData Connect AI and insert Amazon S3 into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Oracle SCM Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Oracle SCM Data and connect to Oracle SCM in Akorbi Digital RunMyProcess.
-
Create Datasets from OData in Domo Workbench and Build Visualizations of OData Services in Domo
Use the CData Software ODBC Driver for OData to create datasets from OData in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Apollo Data from AWS Glue
Use CData Connect AI to gain access to live Apollo from your AWS Glue jobs.
-
Write a Simple Go Application to work with Freshdesk Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Freshdesk.
-
Connect to Google Ad Manager Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Ad Manager Data and connect to Google Ad Manager in Akorbi Digital RunMyProcess.
-
Building Dynamic Web Pages with Zoho CRM Data Using AngularJS
Create single-page applications with live connectivity to Zoho CRM using the CData API Server.
-
Integrate Access with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Access with External Services.
-
How to connect PolyBase to Coinbase
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Coinbase.
-
Use JayDeBeApi to access Trello Data in Python
Use standard Python scripting and the development environment of your choice to access live Trello.
-
Integrating Gumloop with Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Redis within automated workflows.
-
Analyze Live LinkedIn Data in SAS Viya
Use CData Connect AI to connect to LinkedIn from SAS Viya and deploy self-service analytics using live LinkedIn.
-
Import Google Search Results Using Azure Data Factory
Use CData Connect AI to connect to Google Search Results from Azure Data Factory and import live Google Search.
-
Integrate CloudConvert with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate CloudConvert with External Services.
-
Query, Visualize, and Share live Xero Data in Redash
Use CData Connect AI to connect to live Xero Accounting in Redash for querying, visualizing, and sharing.
-
Connect to MailerSend in SpagoBI
Create reports featuring live MailerSend in SpagoBI Studio. Host MailerSend reports on SpagoBI Server.
-
Use Dash to Build to Web Apps on Flowlu Data
Create Python applications that use pandas and Dash to build Flowlu-connected web apps.
-
Create Data Visualizations in Cognos BI with MessageBird Data
Access MessageBird as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Dashboards with Vault CRM Data in Dundas BI
Create dynamic dashboards and perform analytics based on Veeva Vault & Vault CRM in Dundas BI.
-
Back Up Atlassian Jira to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Jira. In this article, we will employ an SSIS workflow to populate a database with Atlassian Jira data.
-
Integrating Kiro CLI with Demio 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 connect and process ZohoInvoice from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ZohoInvoice.
-
Integrate Azure Synapse with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Azure Synapse with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Azure Synapse.
-
Create Avaza Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Avaza from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect to & Open ClickTime Data in Microsoft Excel
This article uses the CData ODBC driver for ClickTime to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Connect to & Open Quickbase Data in Microsoft Excel
This article uses the CData ODBC driver for Quickbase to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Analyze Apollo Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Apollo from Power Pivot. You will use the Table Import Wizard to load Apollo. You can visually build the import query or use any SQL supported by the driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP Concur
Provide connectivity to SAP Concur through an SAP BusinessObjects universe.
-
Publish Crystal Reports on Keap Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Keap.
-
Choosing the Best Method to Connect Xero to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Xero Accounting from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Google Translate Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Google Translate as an External Source in Dremio.
-
Integrate Cursor with Live Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Smartsheet from within the editor.
-
Query Greenhouse Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Greenhouse and perform CRUD operations on Greenhouse from Node.js.
-
Getting Started with the CData SSIS Components for Hubstaff
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Hubstaff.
-
Integrate Teradata with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Teradata with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Teradata.
-
Working with Everhour Data in LINQPad
Execute LINQ queries to Everhour in LINQPad.
-
Connect to Real-Time Delighted Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Delighted in Power Apps.
-
Connect to Redshift Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Back Up Retently 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 Retently data.
-
Back Up Printify 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 Printify data.
-
Working with Pipeline CRM Data in LINQPad
Execute LINQ queries to Pipeline CRM in LINQPad.
-
How to Easily Query Basecamp Data in OpenOffice Base
Connect to Basecamp data in OpenOffice Base using the CData ODBC Driver for Basecamp and generate reports with live data insights.
-
Automate HBase Data Replication to Couchbase
Use CData Sync to Customize and automate Apache HBase replication to Couchbase.
-
How to Work with Chargebee Data in ETL Validator JDBC
Connect to Chargebee from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Live Azure Data Lake Storage Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Azure Data Lake Storage in CData Connect AI and connect to your Azure Data Lake Storage from PostgreSQL.
-
Bridge Greenhouse Connectivity with Apache NiFi
Access and process Greenhouse in Apache NiFi using the CData JDBC Driver.
-
How to Build an ETL App for RabbitMQ Data in Python with CData
Create ETL applications and real-time data pipelines for RabbitMQ in Python with petl.
-
Automated Continuous OnePageCrm Replication to MySQL
Use CData Sync for automated, continuous, customizable OnePageCrm replication to MySQL.
-
Manage Instagram Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Instagram.
-
Getting Started with the CData SSIS Components for FreshBooks
Complete guide to installing, licensing, and connecting with the CData SSIS Components for FreshBooks.
-
Connect to Amplitude in SpagoBI
Create reports featuring live Amplitude in SpagoBI Studio. Host Amplitude reports on SpagoBI Server.
-
Getting Started with the CData Excel Add-In for Email
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Email.
-
Connect to ScrapingBee Data from PowerBuilder via ADO.NET
This article demonstrates how to access ScrapingBee from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
DataBind Charts to FreeAgent Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to FreeAgent 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.
-
Analyze Greenhouse Data in Looker
Use CData Connect AI to connect to Greenhouse Data from Looker and build custom apps using live Greenhouse.
-
Automated Continuous PolarTeamPro Replication to Amazon S3
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to Amazon S3.
-
Query Basecamp Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Basecamp from Node.js.
-
Connect to SAS xpt Data from PowerBuilder via JDBC
This article demonstrates how to access SAS XPORT from PowerBuilder using the SAS xpt JDBC Driver.
-
How to connect to Confluence Data in DBVisualizer
Integrate Atlassian Confluence with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Box-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Box to explore live Box Data in Cursor to assist with building Box-powered applications.
-
Integrating Kiro CLI with Microsoft Planner 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.
-
Integrate Live SAP SuccessFactors Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP SuccessFactors to Blue Prism using the CData ODBC Driver for SAP SuccessFactors to create automated workflows for repetitive business tasks.
-
Edit and Search SAP Concur External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SAP Concur to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SAP Concur objects that you can access from apps and the dashboard.
-
Integrating GitHub Copilot CLI with Google Sheets 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 Salesforce CRM Analytics Data in RazorSQL
Connect to Salesforce CRM Analytics from wizards and query Salesforce CRM Analytics from the GUI in the RazorSQL database management tool.
-
Use the CData Software ODBC Driver for SAP Ariba Procurement in MicroStrategy Desktop
Connect to SAP Ariba Procurement in MicroStrategy Desktop using the CData Software ODBC Driver for SAP Ariba Procurement.
-
Analyze Adobe Commerce Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Adobe Commerce from Power Pivot. You will use the Table Import Wizard to load Adobe Commerce. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData Software JDBC Driver for Pipeline CRM in MicroStrategy Web
Connect to Pipeline CRM in MicroStrategy Web using the CData Software JDBC Driver for Pipeline CRM.
-
Build Agents in Relevance AI with Access to Live Active Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Active Directory within intelligent agent workflows.
-
Build AI Agents with Vault CRM 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 Veeva Vault & Vault CRM through CData Connect AI.
-
How to create an RPA flow for Azure Synapse Data in UiPath Studio
Use the Azure Synapse ODBC Driver to create workflows that access real-time Azure Synapse without any coding.
-
Integrate LibreChat with Live Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Act CRM from within the chat interface.
-
Connect to Dynamics CRM Data from a Connection Pool in JBoss
Integrate Microsoft Dynamics CRM into Java servlets: Use the Management Console in JBoss to install the Dynamics CRM JDBC Driver.
-
Working with Qualaroo Data in LINQPad
Execute LINQ queries to Qualaroo in LINQPad.
-
How to integrate PivotalTracker with Apache Airflow
Access and process PivotalTracker in Apache Airflow using the CData JDBC Driver.