CData Software - Knowledge Base
Recent Articles
-
Access Live Instantly Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Instantly data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Natively Connect to ElevenLabs Data in PHP
The CData ODBC driver for ElevenLabs enables you to create PHP applications with connectivity to ElevenLabs. Leverage the native support for ODBC in PHP.
-
Integrate Cline with Live SAP HANA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP HANA from within your IDE.
-
Connect to Sendwithus Data in CloverDX (formerly CloverETL)
Transfer Sendwithus using the visual workflow in the CloverDX data integration tool.
-
Use the CData Software JDBC Driver for Certinia in MicroStrategy Desktop
Connect to Certinia in MicroStrategy Desktop using the CData Software JDBC Driver for Certinia.
-
Configure the CData JDBC Driver for Eventbrite in a Connection Pool in Tomcat
Connect to Eventbrite from a connection pool in Tomcat.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zoho CRM
Provide connectivity to Zoho CRM through an SAP BusinessObjects universe.
-
View Reports on Real-Time NetSuite Data in Power BI Report Server
Use the CData ODBC Driver for NetSuite to visualize NetSuite CRM & ERP in Power BI Desktop and then publish them to Power BI Report Server.
-
Use JayDeBeApi to access Certinia Data in Python
Use standard Python scripting and the development environment of your choice to access live Certinia.
-
Getting Started with the CData Tableau Connector for HCL Domino
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for HCL Domino.
-
Connect to Zoho Projects Data in RazorSQL
Connect to Zoho Projects from wizards and query Zoho Projects from the GUI in the RazorSQL database management tool.
-
Automated Continuous Teamgate Replication to SQLite
Use CData Sync for automated, continuous, customizable Teamgate replication to SQLite.
-
Connect to SuiteCRM Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SuiteCRM and the Script function in FileMaker Pro to connect to SuiteCRM and work with SuiteCRM in your FileMaker application.
-
DataBind Charts to Zoho Creator Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho Creator 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.
-
Build a Simple VCL Application for HelloSign Data
How to build a simple VCL Application to view HelloSign in RAD Studio using the CData ODBC Driver for HelloSign.
-
Use the CData Software JDBC Driver for Timely in MicroStrategy Web
Connect to Timely in MicroStrategy Web using the CData Software JDBC Driver for Timely.
-
Load Wrike Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Wrike to a database.
-
How to Create Power BI Visual Reports with Real-Time Microsoft Ads Data
Use CData Power BI Connectors to visualize Microsoft Ads in Power BI.
-
Analyze SharePoint Excel Services Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SharePoint Excel Services and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Easily Integrate Phoenix Data in Lazarus Pascal IDE
Learn how to easily integrate live Apache Phoenix in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect to & Open Azure DevOps Data in Microsoft Excel
This article uses the CData ODBC driver for Azure DevOps to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to ZohoSubscriptions Data from PowerBuilder via JDBC
This article demonstrates how to access ZohoSubscriptions from PowerBuilder using the ZohoSubscriptions JDBC Driver.
-
Create ConstantContact Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ConstantContact data access from reports, embedded analytics, and more.
-
Access Cosmos DB Data from MySQL in PHP
Connect to Cosmos DB through the standard MySQL libraries in PHP.
-
Getting Started with the CData Excel Add-In for Egnyte
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Egnyte.
-
Visualize Bannerbear Data in TIBCO Spotfire through ADO.NET
Integrate Bannerbear into dashboards in TIBCO Spotfire.
-
Access Live Confluence Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Atlassian Confluence into the statistical analysis tools available in SAS JMP. This article shows how to use Atlassian Confluence in the Graph Builder and Query Builder.
-
Replicate Apify Data from PowerShell
Write a quick PowerShell script to query Apify. Use connectivity to the live data to replicate Apify to SQL Server.
-
Replicate Lakebase Data from PowerShell
Write a quick PowerShell script to query Lakebase. Use connectivity to the live data to replicate Lakebase to SQL Server.
-
How to Import Data from Clio into Google Sheets
Import Clio into a Google spreadsheet that is automatically refreshed.
-
Build Semantic Layer Views for Zoho Books Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Zoho Books.
-
Automated Continuous HBase Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable HBase replication to Google Cloud SQL.
-
How to create an RPA flow for Box Data in UiPath Studio
Use the Box ODBC Driver to create workflows that access real-time Box without any coding.
-
How to Connect to Live Presto 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 Presto for you.
-
Connect to Splunk Data in DBArtisan
Use wizards in DBArtisan to configure Splunk as a data source.
-
Query Supabase Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Supabase entities in PHP by modeling them as objects.
-
Connect to HDFS Data in DBeaver
Use the CData ODBC Driver to connect to Apache HDFS in DBeaver.
-
Bridge Spotify Connectivity with Apache NiFi
Access and process Spotify in Apache NiFi using the CData JDBC Driver.
-
Validate ConvertAPI Data with QuerySurge
Access and validate ConvertAPI in QuerySurge using the CData JDBC Driver.
-
How to import HubDB Data into Apache Solr
Use the CData Software JDBC Driver for HubDB in Data Import Handler and create an automated import of HubDB to Apache Solr Enterprise Search platform.
-
Integrate Contentful Data in Pentaho Data Integration
Build ETL pipelines based on Contentful in the Pentaho Data Integration tool.
-
Build Automated Gong-Connected Workflows in Zapier
Use CData Connect AI to connect to live Gong and build automated workflows in Zapier.
-
Migrating data from FHIR to Snowflake using CData SSIS Components.
Easily push FHIR to Snowflake using the CData SSIS Tasks for FHIR and Snowflake.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Act-On within intelligent workflows.
-
Use the CData ODBC Driver for LionDesk from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for LionDesk to connect to LionDesk from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring LionDesk in Excel.
-
Integrate BigCommerce Data in Pentaho Data Integration
Build ETL pipelines based on BigCommerce in the Pentaho Data Integration tool.
-
Prepare, Blend, and Analyze PhantomBuster Data in Alteryx Designer (ODBC)
Build workflows to access live PhantomBuster for self-service data analytics.
-
How to create an RPA flow for Teradata Data in UiPath Studio
Use the Teradata ODBC Driver to create workflows that access real-time Teradata without any coding.
-
Automate Microsoft OneDrive Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft OneDrive from PowerShell? This article demonstrates how to utilize the Microsoft OneDrive Cmdlets for tasks like connecting to Microsoft OneDrive, automating operations, downloading data, and more.
-
Automated Continuous Zoho Creator Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Zoho Creator replication to IBM DB2.
-
Use the CData Software JDBC Driver for Gumroad in MicroStrategy Web
Connect to Gumroad in MicroStrategy Web using the CData Software JDBC Driver for Gumroad.
-
Visualize Excel Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Excel.
-
Connect to Marketo Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Marketo as an External Source in Dremio.
-
Connect to Spotify Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Spotify to connect to Spotify and execute queries in PowerBuilder.
-
Getting Started with the CData ADO.NET Provider for JSON
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for JSON.
-
Integrate LibreChat with Live CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live CockroachDB from within the chat interface.
-
How to Work with Zendesk Data in ETL Validator JDBC
Connect to Zendesk from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software JDBC Driver for Aircall in MicroStrategy Desktop
Connect to Aircall in MicroStrategy Desktop using the CData Software JDBC Driver for Aircall.
-
Analyze FreeAgent Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of FreeAgent and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Live Hugging Face Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Hugging Face to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Prepare, Blend, and Analyze Greenplum Data in Alteryx Designer (Connect AI)
Build workflows to access live Pivotal GreenPlum for self-service data analytics.
-
Access Live ServiceNow Data in TIBCO Data Virtualization
Use the ServiceNow Tibco DV Adapter to create a ServiceNow data source in TIBCO Data Virtualization Studio and gain access to live ServiceNow from your TDV Server.
-
Enable the Exact Online JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Exact Online.
-
Integrate SAP Concur Data into Power Automate Desktop using CData Connect
CData Connect for SAP Concur Data enables you to integrate SAP Concur into workflows built using Microsoft Power Automate Desktop.
-
Replicate Mocean Data from PowerShell
Write a quick PowerShell script to query Mocean. Use connectivity to the live data to replicate Mocean to SQL Server.
-
Query Autopilot Data in DataGrip
Create a Data Source for Autopilot in DataGrip and use SQL to query live Autopilot.
-
Connect CockroachDB to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live CockroachDB using the CData Python MCP Server.
-
Access Live Amazon Marketplace Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Amazon Marketplace data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Create a Data Access Object for CapsuleCRM Data using JDBI
A brief overview of creating a SQL Object API for CapsuleCRM in JDBI.
-
Integrate ZohoMarketingHub with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ZohoMarketingHub with External Services.
-
Getting Started with the CData Power BI Connector for CircleCI
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Getting Started with the CData ODBC Driver for Pingdom
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Pingdom.
-
Query Elasticsearch Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Elasticsearch entities in PHP by modeling them as objects.
-
Automated Continuous SAP HANA Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP HANA replication to PostgreSQL.
-
Connect Landbot Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Landbot using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Live PostgreSQL Data in AWS Lambda (with IntelliJ IDEA)
Connect to live PostgreSQL in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Quickbase Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Quickbase in Airbyte.
-
Getting Started with the CData Tableau Connector for Amplitude
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create MongoDB-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to MongoDB Data from OutSystems and build custom enterprise apps using live MongoDB.
-
Build an OLAP Cube in SSAS from BambooHR Data
Establish a connection to BambooHR data from SQL Server Analysis Services, and use the BambooHR Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous SharePoint Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Microsoft SharePoint replication to OneLake in Microsoft Fabric.
-
Access Live Epicor Kinetic Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Epicor Kinetic from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Flowlu from Asprova with CData Software ODBC Driver for Flowlu
This article shows how to connect faster to Flowlu data from Asprova.
-
How to Work with SharePoint Data in AWS Glue Jobs Using JDBC
Connect to SharePoint from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Publish Reports with Apollo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apollo.
-
Integrate with Shopify Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Shopify to a JSON file on disk.
-
How to Connect to Live Box Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Box without replication.
-
Use the CData Software JDBC Driver for Zoom in MicroStrategy
Connect to Zoom in MicroStrategy Developer using the CData Software JDBC Driver for Zoom.
-
How to use SQLAlchemy ORM to access Keap Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Keap.
-
Connecting Pipedream with AlloyDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on AlloyDB data in real time.
-
Build a PostgreSQL Interface for FreshBooks Data using the CData JDBC Driver
Use the Remoting features of the FreshBooks JDBC Driver to create a PostgreSQL entry-point for data access.
-
Perform Batch Operations with QuickBooks Online Data in Apache NiFi
Connect to QuickBooks Online and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Presto Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Presto Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Access Live PostgreSQL Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live PostgreSQL from your Excel spreadsheets.
-
Build Microsoft Ads-Connected Apps in Choreo
Use CData Connect AI to connect to Microsoft Ads Data from Choreo and build custom apps using live Microsoft Ads.
-
Visualize Live Dropbox Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Dropbox using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData Tableau Connector for Elorus
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous PostgreSQL Replication to Snowflake
Use CData Sync for automated, continuous, customizable PostgreSQL replication to Snowflake.
-
Build Microsoft Teams-Connected Apps in Choreo
Use CData Connect AI to connect to Microsoft Teams Data from Choreo and build custom apps using live Microsoft Teams.
-
Getting Started with the CData JDBC Driver for ConvertAPI
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ConvertAPI.