CData Software - Knowledge Base
Recent Articles
-
Use JayDeBeApi to access LaunchDarkly Data in Python
Use standard Python scripting and the development environment of your choice to access live LaunchDarkly data.
-
Connect to Greenhouse in SpagoBI
Create reports featuring live Greenhouse data in SpagoBI Studio. Host Greenhouse reports on SpagoBI Server.
-
Visualize AlloyDB Data in TIBCO Spotfire through OData
Integrate AlloyDB data into dashboards in TIBCO Spotfire.
-
Integrate Freshteam Data in the Pentaho Report Designer
Publish reports based on Freshteam data in the Pentaho BI tool.
-
Connect to HBase Data from a Connection Pool in JBoss
Integrate HBase data into Java servlets: Use the Management Console in JBoss to install the HBase JDBC Driver.
-
Import Shortcut Data Using Azure Data Factory
Use CData Connect AI to connect to Shortcut Data from Azure Data Factory and import live Shortcut data.
-
How to Connect to & Open Amazon Marketplace Data in Microsoft Excel
This article uses the CData ODBC driver for Amazon Marketplace to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build SAP SuccessFactors LMS Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP SuccessFactors LMS data and build visualizations in Tableau.
-
Rapidly Develop Amazon DynamoDB-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 Amazon DynamoDB.
-
Build AI/ML Models with Live Discourse Data using Dataiku
Connect Discourse Data with Dataiku using the CData API Driver for JDBC.
-
Use Azure AI Foundry to Talk to Your Excel Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Excel Online data for you.
-
Connect to Act-On Data in JRuby
Create a simple JRuby app with access to live Act-On data.
-
Query Live Procore Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Procore data through a conversational interface.
-
Access Amazon S3 Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Amazon S3 data from your Oracle system.
-
Automated Continuous Impala Replication to SingleStore
Use CData Sync for automated, continuous, customizable Impala replication to SingleStore.
-
Integrate OpenCode with Live ActiveCampaign Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live ActiveCampaign data from within your AI coding agent.
-
Replicate Instantly Data to Multiple Databases via the CData Sync CLI
Replicate Instantly data to disparate databases with a single configuration.
-
Access Live Splunk Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Splunk data from your Excel spreadsheets.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Facebook Ads
Provide connectivity to Facebook Ads data through an SAP BusinessObjects universe.
-
Automated Continuous eBay Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable eBay replication to PostgreSQL.
-
Create Printful Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Printful data access from reports, embedded analytics, and more.
-
Query Live Zuora Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Zuora data through a conversational interface.
-
How to connect to GraphQL Data with Squirrel SQL client
Connect to GraphQL data and execute queries in the Squirrel SQL Client.
-
Connect to Airtable in SpagoBI
Create reports featuring live Airtable data in SpagoBI Studio. Host Airtable reports on SpagoBI Server.
-
Automate SuiteCRM Data Replication to Azure Data Lake
Use CData Sync to customize and automate SuiteCRM data replication to Azure Data Lake.
-
Establish a Live Connection with REST Data using Tableau Bridge
The CData ODBC Driver for REST enables you to integrate live REST data into Tableau Cloud dashboards using the Tableau Bridge.
-
Replicate Spark Data to Multiple Databases via the CData Sync CLI
Replicate Spark data to disparate databases with a single configuration.
-
Connect to SpaceX Data in DBArtisan
Use wizards in DBArtisan to configure SpaceX data as a data source.
-
How to Visualize SAP HANA XS Advanced 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 SAP HANA XS Advanced data in Python.
-
Connect to Live Freshservice Data in MicroStrategy through CData Connect AI
Create a live connection to Freshservice Data in CData Connect AI and connect to your Freshservice data from MicroStrategy.
-
LINQ to Adobe Analytics 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 Adobe Analytics Data Provider.
-
Integrating LangChain with ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on ADP data within automated workflows.
-
Connecting Agentforce with GitHub Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your GitHub data for you.
-
Connect to Mailgun Data in Jaspersoft Studio
Execute SQL to remote Mailgun data in Jaspersoft Studio.
-
Visualize Live Figshare Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Figshare data into custom reports in Power BI.
-
Integrating Cursor with Strava 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.
-
Migrating data from FormSite to Snowflake using CData SSIS Components.
Easily push FormSite data to Snowflake using the CData SSIS Tasks for FormSite and Snowflake.
-
Visualize Basecamp Data in Sisense
Create an ElastiCube in Sisense app with access to Basecamp data.
-
Connecting Pipedream with Highrise 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 Highrise data in real time.
-
Automated Continuous Salesforce Replication to Databricks
Use CData Sync for automated, continuous, customizable Salesforce replication to Databricks.
-
Create SSAS Tabular Models from Missive Data
How to build a SQL Server Analysis Service Tabular Model from Missive data using CData drivers.
-
Automate Salesforce Pardot Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Salesforce Pardot data from PowerShell? This article demonstrates how to utilize the Salesforce Pardot Cmdlets for tasks like connecting to Salesforce Pardot data, automating operations, downloading data, and more.
-
Rapidly Develop Epicor Kinetic-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 Epicor Kinetic.
-
How to Visualize Zoho Creator Data in Python with pandas
Use pandas and other modules to analyze and visualize live Zoho Creator data in Python.
-
Natively Connect to Outlook Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Outlook data. Leverage the native support for ODBC in PHP.
-
Consume Salesforce CRM Analytics OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Salesforce CRM Analytics feeds that reflect any changes in SAP Lumira.
-
Integrating Antigravity CLI with SendInBlue data via CData CLI
Connect SendInBlue data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Intercom-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Intercom data and build web apps with connectivity to live Intercom data.
-
How to connect to IBM Informix Data from Spring Boot
Connect to IBM Informix in a Spring Boot Application using the CData JDBC Driver for IBM Informix
-
Stream LinkedIn Data into Apache Kafka Topics
Access and stream LinkedIn data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
DataBind Controls to SendInBlue Data in C++Builder
DataBind to SendInBlue data in C++Builder with standard components and controls.
-
Publish Reports with Redis Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Redis data.
-
How to Visualize IBM Informix 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 IBM Informix data in Python.
-
Deel Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Deel facts in real time.
-
Publish Oracle Eloqua Reporting-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Oracle Eloqua Reporting data.
-
Connect to SFTP Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SFTP data in Airbyte.
-
Import Real-Time SAP Ariba Source Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP Ariba Source data in ColdFusion.
-
How to Query Live Klaviyo Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Klaviyo data data in natural language using Python.
-
Connect to Yelp Data from a Connection Pool in JBoss
Integrate Yelp data into Java servlets: Use the Management Console in JBoss to install the Yelp JDBC Driver.
-
Viewing HubDB Data in RAD Studio Data Explorer
How to view HubDB data in RAD Studio Data Explorer using the CData ODBC Driver for HubDB.
-
Integrating GitHub Copilot with OneNote 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.
-
Create Drip Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Drip data access from reports, embedded analytics, and more.
-
Integrating Codex with Avro 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.
-
Automated Continuous SingleStore Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SingleStore replication to Google BigQuery.
-
How to connect to SparkPost Data with Squirrel SQL client
Connect to SparkPost data and execute queries in the Squirrel SQL Client.
-
Feed ZohoInvoice Data into FineReport
How to set ZohoInvoice data as a JDBC data source in FineReport.
-
Connect to Stripe Data in Claris FileMaker Pro
Use the CData ODBC Driver for Stripe in FileMaker Pro to connect to Stripe and work with Stripe data in your FileMaker applications.
-
Create Informatica Mappings From/To an ODBC Data Source for Beeminder
Create an ODBC connection to Beeminder in Informatica and browse and transfer Beeminder data.
-
Create PingOne-Connected Dashboards in Grafana
Connect to PingOne Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to PingOne data.
-
Build a PostgreSQL Interface for Dynamics 365 Business Central Data using the CData JDBC Driver
Use the Remoting features of the Dynamics 365 Business Central JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous PolarTeamPro Replication to SingleStore
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to SingleStore.
-
Work with Live Phoenix Data in Power Query
Use CData Connect AI to connect to Phoenix data and work with live Phoenix data in Microsoft Power Query.
-
How to Access Gumroad Data Using Entity Framework
This article shows how to access Gumroad data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build a PostgreSQL Interface for Avalara AvaTax Data using the CData JDBC Driver
Use the Remoting features of the Avalara AvaTax JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Claude Code with Google Forms Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Forms data within assisted coding and automated development workflows.
-
How to integrate Procore with Apache Airflow
Access and process Procore data in Apache Airflow using the CData JDBC Driver.
-
Connect Grafana to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Grafana with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Cohere with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Cohere with External Services.
-
Connect to and Visualize Live Outreach.io Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Outreach.io data.
-
Build Smartsheet-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Smartsheet data and build Smartsheet-connected web apps with Axios.
-
Connect SageHR to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SageHR with IBM WebSphere for seamless data integration and connectivity.
-
Connect to OneNote Data from AWS Glue
Use CData Connect AI to gain access to live OneNote data from your AWS Glue jobs.
-
Visualize Epicor Kinetic Data in TIBCO Spotfire through ADO.NET
Integrate Epicor Kinetic data into dashboards in TIBCO Spotfire.
-
Viewing xBase Data in RAD Studio Data Explorer
How to view xBase data in RAD Studio Data Explorer using the CData ODBC Driver for xBase.
-
Write a Simple Go Application to work with Active Directory Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Active Directory data.
-
Access Everhour Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Everhour data from HeidiSQL.
-
Build Apps with Live Spark data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Spark data into the Adalo platform and build custom mobile and web applications with real-time Spark data.
-
Access Live DB2 Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate DB2 data into the statistical analysis tools available in SAS JMP. This article shows how to use DB2 data in the Graph Builder and Query Builder.
-
Automate Hubstaff Data Replication to Azure Data Lake
Use CData Sync to customize and automate Hubstaff data replication to Azure Data Lake.
-
Build AI Agents with BenchmarkEmail 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 BenchmarkEmail data through CData Connect AI.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Forms
Create Google Forms data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live Kintone Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Kintone data through MCP integration.
-
Publish Nethunt-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Nethunt data.
-
Connect to Vimeo Data in Ruby
Connect to Vimeo data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create xBase-Connected Dashboards in Grafana
Connect to xBase Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to xBase data.
-
Visualize Live Jira Assets Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Jira Assets data into custom reports in Power BI.
-
Validate Square Data with QuerySurge
Access and validate Square data in QuerySurge using the CData JDBC Driver.
-
Connect to Oracle Eloqua Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Oracle Eloqua data from Filemaker Pro on Mac.
-
Build a Singer.io Tap for Samanage With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Samanage data using the CData Python Connector.
-
Bind Live Airtable Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Airtable data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.