CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live BenchmarkEmail 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 BenchmarkEmail data for you.
-
DataBind Charts to Freshteam Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Freshteam data 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.
-
Use Agno to Talk to Your Lakebase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Lakebase data for you.
-
Use the CData Software JDBC Driver for Toggl in MicroStrategy
Connect to Toggl data in MicroStrategy Developer using the CData Software JDBC Driver for Toggl.
-
Access Live Acumatica Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Acumatica data into the statistical analysis tools available in SAS JMP. This article shows how to use Acumatica data in the Graph Builder and Query Builder.
-
Create Datasets from Zoho Inventory in Domo Workbench and Build Visualizations of Zoho Inventory Data in Domo
Use the CData Software ODBC Driver for Zoho Inventory to create datasets from Zoho Inventory data in Domo Workbench and then build visualizations in the Domo service.
-
Consume Act CRM OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Act CRM feeds that reflect any changes in SAP Lumira.
-
Replicate Oracle Financials Cloud Data from PowerShell
Write a quick PowerShell script to query Oracle Financials Cloud data. Use connectivity to the live data to replicate Oracle Financials Cloud data to SQL Server.
-
Connect to Google Directory Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Google Directory as an External Source in Dremio.
-
Access Live SharePoint Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SharePoint data from your Excel spreadsheets.
-
Migrating data from Salesforce Data 360 to Snowflake using CData SSIS Components.
Easily push Salesforce Data 360 data to Snowflake using the CData SSIS Tasks for Salesforce Data 360 and Snowflake.
-
Access Live Adobe Experience Manager Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Adobe Experience Manager data into the statistical analysis tools available in SAS JMP. This article shows how to use Adobe Experience Manager data in the Graph Builder and Query Builder.
-
Design BIRT Reports on Insightly Data
Provide current Insightly data to your embedded analytics.
-
Use Microsoft Copilot Studio to talk to your Mailgun Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Mailgun data for you.
-
Automated Continuous Greenplum Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Greenplum replication to Amazon Redshift.
-
Feed Gumroad Data into FineReport
How to set Gumroad data as a JDBC data source in FineReport.
-
Integrate Instagram Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Instagram data and integrate live Instagram data into your Power Automate tasks.
-
Access Live Tally Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Tally data from your Google Sheets.
-
How to connect Amazon QuickSight to Mailgun Data
Create a connection to Mailgun data in CData Connect AI and insert Mailgun data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Seamlessly Import FreshBooks Data into IBM SPSS Modeler
Integrate FreshBooks data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connecting Pipedream with Coda 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 Coda data in real time.
-
Prepare, Blend, and Analyze Jira Assets Data in Alteryx Designer (Connect AI)
Build workflows to access live Jira Assets data for self-service data analytics.
-
Access ScrapingBee 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 ScrapingBee data.
-
Connect to Real-Time Excel Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Excel and Dataflow to import and use Excel data in Power Apps.
-
Seamlessly Bring eBay Analytics Data into Retool Using CData Connect AI
Integrate eBay Analytics data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Edit and Search External Microsoft Planner Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft Planner data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Microsoft Planner Data objects that you can access from apps and the dashboard.
-
Create Data Visualizations in Cognos BI with ClickTime Data
Access ClickTime data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated JotForm Data Replication to Teradata
Use CData Sync to Customize and automate JotForm data replication to Teradata.
-
Automated Continuous Moosend Replication to Databricks
Use CData Sync for automated, continuous, customizable Moosend replication to Databricks.
-
Use the CData Software ODBC Driver for Zoho Creator in MicroStrategy
Connect to Zoho Creator data in MicroStrategy Developer using the CData Software ODBC Driver for Zoho Creator.
-
Moving Data from Bannerbear to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Bannerbear data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to work with AfterShip Data in Apache Spark using SQL
Access and process AfterShip Data in Apache Spark using the CData Software JDBC Driver.
-
Design BIRT Reports on Excel Online Data
Provide current Excel Online data to your embedded analytics.
-
How to Easily Query Stripe Data in OpenOffice Base
Connect to Stripe data in OpenOffice Base using the CData ODBC Driver for Stripe and generate reports with live data insights.
-
Connect to Anaplan Data in HULFT Integrate
Connect to Anaplan as a JDBC data source in HULFT Integrate
-
Explore Geographical Relationships in xBase Data with Power Map
Create data visualizations with xBase data in Power Map.
-
How to integrate Qualaroo with Apache Airflow
Access and process Qualaroo data in Apache Airflow using the CData JDBC Driver.
-
Connect Yelp to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Yelp with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Vercel Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Vercel replication to Amazon Redshift.
-
How to Connect Notion Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Notion data in real time using natural language.
-
A PostgreSQL Interface for Copper Data using the CData ODBC Driver
Use the SQL Gateway and Copper ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connecting GenSpark with MailChimp Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to MailChimp data without any replication or custom integration required.
-
Manage Workday Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Workday.
-
Create SSAS Tabular Models from ClickTime Data
How to build a SQL Server Analysis Service Tabular Model from ClickTime data using CData drivers.
-
Create Dashboards and Visualize Live BigQuery Data in Geckoboard
Use CData Connect AI to connect to live BigQuery data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Extract, Transform, and Load Microsoft Entra ID Data in Informatica PowerCenter
Create a simple Workflow for Microsoft Entra ID data in Informatica PowerCenter.
-
How to create PhantomBuster federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for PhantomBuster data in MySQL .
-
Use the CData Software ODBC Driver for SAP Business One in MicroStrategy
Connect to SAP Business One data in MicroStrategy Developer using the CData Software ODBC Driver for SAP Business One.
-
How to load WordPress data into Elasticsearch via Logstash
Introducing a simple method to load WordPress data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build MVC Applications with Connectivity to Demio Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Demio from an ASP.NET MVC application.
-
Automated Continuous Office 365 Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Office 365 replication to Google BigQuery.
-
Manage JobNimbus Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for JobNimbus.
-
How to Query Live CouchDB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live CouchDB data data in natural language using Python.
-
Rapidly Develop Salesforce Data 360-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 Salesforce Data 360.
-
Automated Continuous MongoDB Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable MongoDB replication to Apache Kafka.
-
Connect to SAP BusinessObjects BI Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP BusinessObjects BI data.
-
How to Visualize SAP Fieldglass 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 Fieldglass data in Python.
-
Connect to SAS xpt Data in JRuby
Create a simple JRuby app with access to live SAS xpt data.
-
Access Live Procore Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Procore data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Building Dynamic Web Pages with Square Data Using AngularJS
Create single-page applications with live connectivity to Square using the CData API Server.
-
Analyze ZohoSubscriptions Data in Looker
Use CData Connect AI to connect to ZohoSubscriptions Data from Looker and build custom apps using live ZohoSubscriptions data.
-
How to Connect to Float Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Float data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Snowflake Data in Claris FileMaker Pro
Use the CData ODBC Driver for Snowflake in FileMaker Pro to connect to Snowflake and work with Snowflake data in your FileMaker applications.
-
Connect to Slack Data in Ruby
Connect to Slack data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Query Live SAP SuccessFactors 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 SAP SuccessFactors data through a conversational interface.
-
Connect to Coda Data in DBArtisan
Use wizards in DBArtisan to configure Coda data as a data source.
-
How to Connect MySQL Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live MySQL data in real time using natural language.
-
How to connect to Azure Data Catalog Data in DBVisualizer
Integrate Azure Data Catalog data with visual data analysis tools and data connection wizards in DBVisualizer
-
DataBind Charts to Hugging Face Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Hugging Face data 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.
-
Create Dynamic Amazon S3 Grids Using the Infragistics XamDataGrid
Learn how you can connect Amazon S3 to Infragistics XamDataGrid to build dynamic grids.
-
Import Microsoft Exchange Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Microsoft Exchange Data and provide access to live Microsoft Exchange data for custom reports in the Power BI Service.
-
Bridge Perplexity Connectivity with Apache NiFi
Access and process Perplexity data in Apache NiFi using the CData JDBC Driver.
-
Automate MongoDB Integration Tasks from PowerShell
Are you in search of a quick and easy way to access MongoDB data from PowerShell? This article demonstrates how to utilize the MongoDB Cmdlets for tasks like connecting to MongoDB data, automating operations, downloading data, and more.
-
Build DocuSign-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live DocuSign data without replication.
-
Visualize Google Drive Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Google Drive data into TIBCO Spotfire.
-
Create Timely Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Timely from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous ServiceNow Replication to MySQL
Use CData Sync for automated, continuous, customizable ServiceNow replication to MySQL.
-
Integrating Gumloop with Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Oracle Financials Cloud data within automated workflows.
-
How to Easily Query SharePoint Data in OpenOffice Base
Connect to SharePoint data in OpenOffice Base using the CData ODBC Driver for SharePoint and generate reports with live data insights.
-
Create Data Visualizations in Cognos BI with Google Calendar Data
Access Google Calendar data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Extract, Transform, and Load Pipeline CRM Data in Informatica PowerCenter
Create a simple Workflow for Pipeline CRM data in Informatica PowerCenter.
-
Create Reports with Presto Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Presto data.
-
Creating Google Ad Manager-Connected Applications in Unqork
You can use CData Connect AI to feed Google Ad Manager data to Unqork and build custom business apps.
-
Configure the CData JDBC Driver for Demio in a Connection Pool in Tomcat
Connect to Demio data from a connection pool in Tomcat.
-
Establish a Live Connection with Stripe Data using Tableau Bridge
The CData ODBC Driver for Stripe enables you to integrate live Stripe data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Dashboards with Oracle Data in Dundas BI
Create dynamic dashboards and perform analytics based on Oracle data in Dundas BI.
-
Create Humanity Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Humanity data access from reports, embedded analytics, and more.
-
Analyze SAP HANA Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP HANA data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Deploy the ADO.NET Provider for Google Search on an SSRS Report Server
Connect to Google Search results 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.
-
Create ServiceDesk Plus Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ServiceDesk Plus data access from reports, embedded analytics, and more.
-
How to connect PolyBase to Jodoo
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Jodoo data.
-
How to Visualize Browserless Data in Python with pandas
Use pandas and other modules to analyze and visualize live Browserless data in Python.
-
Access ZendeskSell Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ZendeskSell data from HeidiSQL.
-
Query Kintone Data as a MySQL Database in Node.js
Execute MySQL queries against Kintone data from Node.js.
-
Access Live ADP Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to ADP data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Use the CData Software ODBC Driver for Google Tasks in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Tasks data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Tasks.
-
Create Browserless Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Browserless data access from reports, embedded analytics, and more.
-
How to Connect to Live Oracle Sales 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 Oracle Sales data for you.
-
Create a Data Access Object for Figshare Data using JDBI
A brief overview of creating a SQL Object API for Figshare data in JDBI.
-
Connect to Pipedrive Data from PowerBuilder via ADO.NET
This article demonstrates how to access Pipedrive data from Appeon PowerBuilder using the CData ADO.NET Provider for Pipedrive.