CData Software - Knowledge Base
Recent Articles
-
Automate Freshservice Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Freshservice data from PowerShell? This article demonstrates how to utilize the Freshservice Cmdlets for tasks like connecting to Freshservice data, automating operations, downloading data, and more.
-
Build Dashboards with EnterpriseDB Data in Dundas BI
Create dynamic dashboards and perform analytics based on EnterpriseDB data in Dundas BI.
-
Zoho Projects Reporting in OBIEE with the Zoho Projects JDBC Driver
Deploy the Zoho Projects JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate Live AdRoll Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live AdRoll data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Automated Continuous Acumatica Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Acumatica replication to Apache Cassandra.
-
Integrate SAP Concur with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP Concur with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP Concur data.
-
Automated Continuous Printful Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Printful replication to Amazon S3.
-
Interact with Live Dynamics NAV Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Dynamics NAV data.
-
Build Voice Agents in ElevenLabs with access to Live Sendwithus Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Sendwithus data.
-
Building Dynamic Web Pages with Azure Data Catalog Data Using AngularJS
Create single-page applications with live connectivity to Azure Data Catalog using the CData API Server.
-
Create Power BI Reports on Real-Time HDFS Data
Use the CData ODBC Driver for HDFS to visualize HDFS data in Power BI Desktop.
-
Visualize Live SAP Business One Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP Business One data.
-
Configure the CData JDBC Driver for Copper in a Connection Pool in Tomcat
Connect to Copper data from a connection pool in Tomcat.
-
How to Connect to Live BambooHR Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your BambooHR data for you.
-
How to Seamlessly Import Sybase Data into IBM SPSS Modeler
Integrate Sybase data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build HubSpot-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to HubSpot data and build web apps with connectivity to live HubSpot data.
-
Automated Continuous Scrapfly Replication to SQL Server
Use CData Sync for automated, continuous, customizable Scrapfly replication to SQL Server.
-
Integrating LangChain with Cassandra Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Cassandra data within automated workflows.
-
Access Live MailerSend Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate MailerSend data into the statistical analysis tools available in SAS JMP. This article shows how to use MailerSend data in the Graph Builder and Query Builder.
-
Connect to Adobe Analytics Data from a Connection Pool in JBoss
Integrate Adobe Analytics data into Java servlets: Use the Management Console in JBoss to install the Adobe Analytics JDBC Driver.
-
Connect to Google Search Results from PowerBuilder via JDBC
This article demonstrates how to access Google Search results from PowerBuilder using the Google Search JDBC Driver.
-
Automated Continuous Active Directory Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Active Directory replication to Azure SQL Database.
-
Integrating Claude Code CLI with Azure DevOps 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.
-
Build Charts with Harvest Data in Clear Analytics
Create dynamic charts and perform analytics based on Harvest data in Clear Analytics.
-
Add Bitly Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Bitly with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Adobe Analytics Data from PowerBuilder via JDBC
This article demonstrates how to access Adobe Analytics data from PowerBuilder using the Adobe Analytics JDBC Driver.
-
Integrate with Live Salesforce Data 360 Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Salesforce Data 360 from the MuleSoft Anypoint Platform to integrate live Salesforce Data 360 data into custom reports and dashboards.
-
DataBind Blackbaud FE NXT Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Blackbaud FE NXT with the DevExpress Windows Forms and Web controls to provide Blackbaud FE NXT data to a chart.
-
Integrate Trae with Live Redis Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Redis data from within the AI-powered IDE.
-
Migrating data from Placid to Google BigQuery using CData SSIS Components.
Easily push Placid data to Google BigQuery using the CData SSIS Tasks for Placid and Google BigQuery.
-
Access Live Asana Data in AWS Lambda
Connect to live Asana data in AWS Lambda using the CData JDBC Driver.
-
How to publish and share Jira Data dashboards with Tableau Server
The CData ODBC driver for Jira enables you integrate Jira data into Tableau dashboards.
-
Prepare, Blend, and Analyze Confluence Data in Alteryx Designer (Connect AI)
Build workflows to access live Confluence data for self-service data analytics.
-
Integrate Theia IDE with Live SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live SQL Server data from within the development environment.
-
Use Manus AI to Talk to Your Vault CRM 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 Vault CRM data.
-
Automated Continuous Timely Replication to SQL Server
Use CData Sync for automated, continuous, customizable Timely replication to SQL Server.
-
Migrating data from Greenhouse to Google BigQuery using CData SSIS Components.
Easily push Greenhouse data to Google BigQuery using the CData SSIS Tasks for Greenhouse and Google BigQuery.
-
How to Visualize Salesforce Pardot Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Salesforce Pardot data in Python.
-
Automate Microsoft Entra ID Data Replication to Couchbase
Use CData Sync to Customize and automate Microsoft Entra ID data replication to Couchbase.
-
Build Data Flows from SQL Server to Cloudant through SSIS
Easily push SQL Server data to Cloudant using the CData SSIS Tasks for Cloudant.
-
Visualize Live Drip Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Drip data.
-
Integrate OpenCode with Live Egnyte Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Egnyte data from within your AI coding agent.
-
Analyze Microsoft Entra ID Data in Cognos Analytics
Use CData Connect AI to connect to Microsoft Entra ID Data from Cognos Analytics and analyze live Microsoft Entra ID data.
-
Access Telegram Data from MySQL in PHP
Connect to Telegram through the standard MySQL libraries in PHP.
-
Build Apps with Live Sybase data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Sybase data into the Adalo platform and build custom mobile and web applications with real-time Sybase data.
-
Use Claude to Talk to Your Exa Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Exa data for you.
-
Feed ZendeskSell Data into FineReport
How to set ZendeskSell data as a JDBC data source in FineReport.
-
Create Apps from FHIR Data in Qlik Sense Cloud
Use CData Connect AI to connect to FHIR Data and build apps from live FHIR data in Qlik Sense Cloud.
-
Visualize Live Epicor Kinetic Data in the Power BI Service
Use CData Connect AI to connect to live Epicor Kinetic data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Oracle SCM Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle SCM and the Script function in FileMaker Pro to connect to Oracle SCM and work with Oracle SCM data in your FileMaker application.
-
Create Data Visualizations Based On Sage Cloud Accounting Data in Mode
Use CData Connect AI to connect to Sage Cloud Accounting Data from Mode and build visualizations using live Sage Cloud Accounting data.
-
Getting Started with the CData Tableau Connector for CircleCI
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
DataBind Controls to Reckon Accounts Hosted Data in C++Builder
DataBind to Reckon Accounts Hosted data in C++Builder with standard components and controls.
-
Build Charts with Codat Data in Clear Analytics
Create dynamic charts and perform analytics based on Codat data in Clear Analytics.
-
How to Query Live HubSpot Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live HubSpot data data in natural language using Python.
-
Natively Connect to SharePoint Excel Services Data in PHP
The CData ODBC driver for SharePoint Excel Services enables you to create PHP applications with connectivity to SharePoint Excel Services data. Leverage the native support for ODBC in PHP.
-
Access Live Smartsheet Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Smartsheet data from your Google Sheets.
-
Analyze Spark Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Spark data and visualize live Spark data in Infragistics Reveal.
-
How to load Certinia data into Elasticsearch via Logstash
Introducing a simple method to load Certinia data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating Customer.io Data in Talend Cloud Data Management Platform
Connect Customer.io Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Authenticate and Access Zoom API with OAuth and Postman
Easily connect to Zoom API using OAuth and test it with Postman.
-
How to Easily Query ConvertKit Data in OpenOffice Base
Connect to ConvertKit data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Zendesk Data in CloverDX (formerly CloverETL)
Transfer Zendesk data using the visual workflow in the CloverDX data integration tool.
-
Access ServiceNow 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 ServiceNow data.
-
How to update Bullhorn CRM from Excel
This article explains how to transfer data from Excel to Bullhorn CRM using the Excel Add-In for Bullhorn CRM.
-
Design BIRT Reports on SAP HANA XS Advanced Data
Provide current SAP HANA XS Advanced data to your embedded analytics.
-
Connect to Optimizely Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Optimizely as an External Source in Dremio.
-
Integrate Google's Vertex AI Agent with Live Klipfolio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Klipfolio data within intelligent workflows.
-
How to import GitHub Data into Apache Solr
Use the CData Software JDBC Driver for GitHub in Data Import Handler and create an automated import of GitHub data to Apache Solr Enterprise Search platform.
-
Use JayDeBeApi to access Phoenix Data in Python
Use standard Python scripting and the development environment of your choice to access live Phoenix data.
-
Connect to HelloSign Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to HelloSign.
-
Object-Relational Mapping (ORM) with Act CRM Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Act CRM data into a Java-based ORM framework, Hibernate.
-
Integrating LangChain with AfterShip Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on AfterShip data within automated workflows.
-
How to use SQLAlchemy ORM to access Sugar CRM Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sugar CRM data.
-
Connect to SAP Netweaver Gateway Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAP Netweaver Gateway in FileMaker Pro to connect to SAP Netweaver Gateway and work with SAP Netweaver Gateway data in your FileMaker applications.
-
How to Connect to Neo4J Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Neo4J data. Leverage the pyodbc module for ODBC in Python.
-
Manage ClickUp Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ClickUp.
-
Build Dashboards with ShipStation Data in DBxtra
Create dynamic dashboards and perform analytics based on ShipStation data in DBxtra.
-
Connect to eBay Analytics Data in ACL Analytics
Connect to eBay Analytics data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to eBay Analytics data.
-
Connect to Microsoft Planner Data in Ruby
Connect to Microsoft Planner data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Replicate Multiple Webflow Accounts
Replicate multiple Webflow accounts to one or many databases.
-
DataBind Controls to ChargeOver Data in C++Builder
DataBind to ChargeOver data in C++Builder with standard components and controls.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP Ariba Procurement
Create SAP Ariba Procurement data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Bridge SparkPost Connectivity with Apache NiFi
Access and process SparkPost data in Apache NiFi using the CData JDBC Driver.
-
Connect to Paymo Data from PowerBuilder via ADO.NET
This article demonstrates how to access Paymo data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Automated Continuous Landbot Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Landbot replication to Amazon Redshift.
-
Query Square Data in DataGrip
Create a Data Source for Square in DataGrip and use SQL to query live Square data.
-
Connect to LaunchDarkly Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for LaunchDarkly data.
-
Access Live Asana Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Asana data from your Excel spreadsheets.
-
How to Connect to Live Microsoft Entra ID Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Microsoft Entra ID data without replication.
-
Bridge Egnyte Connectivity with Apache NiFi
Access and process Egnyte data in Apache NiFi using the CData JDBC Driver.
-
Access Live ZendeskSell Data in AWS Lambda
Connect to live ZendeskSell data in AWS Lambda using the CData JDBC Driver.
-
Analyze MailChimp Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze MailChimp data in Microsoft R Open.
-
Use the CData ODBC Driver for Amazon S3 from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Amazon S3 to connect to Amazon S3 data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Amazon S3 data in Excel.
-
Getting Started with the CData Excel Add-In for Contentful
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Contentful.
-
Integrate with Pipedrive Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Pipedrive data in SnapLogic.
-
Provide OData Services of Todoist Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Todoist data by developing a WCF Service Application.
-
Create Informatica Mappings From/To an ODBC Data Source for HBase
Create an ODBC connection to HBase in Informatica and browse and transfer HBase data.
-
Connect to Act CRM Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Act CRM to connect to Act CRM data and execute queries in PowerBuilder.
-
How to Seamlessly Import Vault CRM Data into IBM SPSS Modeler
Integrate Vault CRM data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.