CData Software - Knowledge Base
Recent Articles
-
Validate Egnyte Data with QuerySurge
Access and validate Egnyte in QuerySurge using the CData JDBC Driver.
-
Integrate Google Search Results in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google Search from Informatica Cloud.
-
Integrate with Hacker News Data in JReport Designer
Create charts and reports based on Hacker News in JReport Designer.
-
Using the CData Software ODBC Driver for Monday.com in PyCharm
Connect to Monday.com as an ODBC data source in PyCharm using the CData Software ODBC Driver for Monday.com.
-
Integrate Live Sendwithus Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Sendwithus to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Access Live GitHub Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to GitHub from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect Zendesk to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Zendesk with IBM WebSphere for seamless data integration and connectivity.
-
Import Real-Time CircleCI Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use CircleCI in ColdFusion.
-
Query, Visualize, and Share live Sybase Data in Redash
Use CData Connect AI to connect to live Sybase in Redash for querying, visualizing, and sharing.
-
Automate NetSuite SuiteAnalytics Data Replication to Azure Synapse
Use CData Sync to customize and automate NetSuite SuiteAnalytics replication to Azure Synapse.
-
Connect to Mistral AI Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Mistral AI.
-
Use Biml to Build SSIS Tasks to Replicate Authorize.Net Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Authorize.Net to SQL Server.
-
How to use SQLAlchemy ORM to access Perplexity Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Perplexity.
-
Create SSAS Tabular Models from Oracle HCM Cloud Data
How to build a SQL Server Analysis Service Tabular Model from Oracle HCM Cloud using CData drivers.
-
Import Real-Time Wistia Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Wistia in ColdFusion.
-
Access Kintone Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Kintone from HeidiSQL.
-
Moving Data from SAP HANA to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP HANA data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Access WordPress Data Using Entity Framework
This article shows how to access WordPress using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData Excel Add-In for Salesforce CRM Analytics
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Salesforce CRM Analytics.
-
Integrate with Live Adobe Analytics Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Adobe Analytics from the MuleSoft Anypoint Platform to integrate live Adobe Analytics into custom reports and dashboards.
-
Access Strava Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Strava from HeidiSQL.
-
Automated Continuous Google Directory Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Directory replication to delimited files (CSV/TSV).
-
CData Virtuality 4.9 Release Notes: Enhanced Security Platform, Improved Clustering, Increased Connectivity, and More
Read the release notes for CData Virtuality 4.9, including the enhanced security platform, improved clustering, increased connectivity, and a lot more.
-
Automated Continuous AgileCRM Replication to MySQL
Use CData Sync for automated, continuous, customizable AgileCRM replication to MySQL.
-
Connect to ClickTime Data in JRuby
Create a simple JRuby app with access to live ClickTime.
-
How to Connect Highrise 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 Highrise data in real time using natural language.
-
Configure the CData JDBC Driver for NASA in a Connection Pool in Tomcat
Connect to NASA from a connection pool in Tomcat.
-
Build Charts with Discord Data in Clear Analytics
Create dynamic charts and perform analytics based on Discord in Clear Analytics.
-
Publish Outlook-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Outlook.
-
Automated Continuous SQL Server Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SQL Server replication to Apache Kafka.
-
How to import Outreach.io Data into Apache Solr
Use the CData Software JDBC Driver for Outreach.io in Data Import Handler and create an automated import of Outreach.io to Apache Solr Enterprise Search platform.
-
Create GitLab-Connected Applications in Appsmith
Connect to GitLab Data via CData Connect AI in Appsmith and create custom business applications with real-time access to GitLab.
-
SAP HANA XS Advanced Reporting in OBIEE with the SAP HANA XS Advanced JDBC Driver
Deploy the SAP HANA XS Advanced JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Connect to Live Jira Assets Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Jira Assets for you.
-
Build Semantic Layer Views for Airtable Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Airtable.
-
Bridge Salesforce Pardot Connectivity with Apache NiFi
Access and process Salesforce Pardot in Apache NiFi using the CData JDBC Driver.
-
Connect to Square Data in NetBeans
Connect to Square in NetBeans with the data source configuration wizard.
-
Integrate with Exa Data in JReport Designer
Create charts and reports based on Exa in JReport Designer.
-
Use the CData Software ODBC Driver for MailerSend in MicroStrategy
Connect to MailerSend in MicroStrategy Developer using the CData Software ODBC Driver for MailerSend.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Monday.com to Power BI dashboards. Simply drag and drop Monday.com into data visuals on the Power BI canvas.
-
Integrate Goose with Live Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Azure Analysis Services from within the local AI agent.
-
How to connect to LeadDesk Data in DBVisualizer
Integrate LeadDesk with visual data analysis tools and data connection wizards in DBVisualizer
-
Connecting Moonlit Workflow with Microsoft OneDrive Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Microsoft OneDrive in real time.
-
Design BIRT Reports on Mode Data
Provide current Mode to your embedded analytics.
-
Access Live Microsoft Ads Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Ads from your Google Sheets.
-
Create Reports from Workday Data in Looker Studio
Use CData Connect AI to gain access to live Workday and create custom reports in Looker Studio.
-
Access Live PagerDuty Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate PagerDuty into the statistical analysis tools available in SAS JMP. This article shows how to use PagerDuty in the Graph Builder and Query Builder.
-
Build Agents in Relevance AI with Access to Live ShipStation Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on ShipStation within intelligent agent workflows.
-
Create Odoo Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Odoo data access from reports, embedded analytics, and more.
-
Integrate Teamwork with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Teamwork with External Services.
-
Access Live PabblySubscriptions Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate PabblySubscriptions into the statistical analysis tools available in SAS JMP. This article shows how to use PabblySubscriptions in the Graph Builder and Query Builder.
-
How to Easily Query EmailOctopus Data in OpenOffice Base
Connect to EmailOctopus data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create Informatica Mappings From/To a JDBC Data Source for Hugging Face
Create Hugging Face data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Avaza Data in Jaspersoft Studio
Execute SQL to remote Avaza in Jaspersoft Studio.
-
Visualize Live DocuSign Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live DocuSign using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to Live Oracle Eloqua 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 Eloqua for you.
-
How to connect to Grafana Data with Squirrel SQL client
Connect to Grafana and execute queries in the Squirrel SQL Client.
-
Establish a Live Connection with Autopilot Data using Tableau Bridge
The CData ODBC Driver for Autopilot enables you to integrate live Autopilot into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Query Live Bitbucket Data in Claude Desktop
Connect to and query live Bitbucket Data in Claude Desktop using CData MCP Server.
-
Automate ServiceNow Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ServiceNow from PowerShell? This article demonstrates how to utilize the ServiceNow Cmdlets for tasks like connecting to ServiceNow, automating operations, downloading data, and more.
-
Integrate Live Splunk Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Splunk from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Splunk.
-
DataBind Intercom Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Intercom to a chart.
-
LINQ to SparkPost 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 SparkPost Data Provider.
-
Query Amazon Athena Data in ColdFusion
Write standard ColdFusion data access code to connect to Amazon Athena.
-
Automate PayPal Integration Tasks from PowerShell
Are you in search of a quick and easy way to access PayPal from PowerShell? This article demonstrates how to utilize the PayPal Cmdlets for tasks like connecting to PayPal, automating operations, downloading data, and more.
-
Use the CData Software JDBC Driver for PolarTeamPro in MicroStrategy Desktop
Connect to PolarTeamPro in MicroStrategy Desktop using the CData Software JDBC Driver for PolarTeamPro.
-
How to create an RPA flow for Couchbase Data in UiPath Studio
Use the Couchbase ODBC Driver to create workflows that access real-time Couchbase without any coding.
-
Bind Live Vault CRM Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Vault CRM data
-
Publish Reports with Egnyte Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Egnyte.
-
Prepare, Blend, and Analyze ElevenLabs Data in Alteryx Designer (ODBC)
Build workflows to access live ElevenLabs for self-service data analytics.
-
RSS Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on RSS facts in real time.
-
Build Semantic Layer Views for ZohoPeople Data in APOS Live Data Gateway
Use the CData Connector for ZohoPeople in APOS Live Data Gateway to build Semantic Layer Views for ZohoPeople.
-
Build Data Flows from SpaceX to SQL Server using SSIS
Easily back up SpaceX to SQL Server using the SSIS components for SpaceX.
-
Getting Started with the CData Power BI Connector for Templated
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automated Continuous Teamgate Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Teamgate replication to Amazon Redshift.
-
Validate Azure DevOps Data with QuerySurge
Access and validate Azure DevOps in QuerySurge using the CData JDBC Driver.
-
ETL Jumpseller in Oracle Data Integrator
This article shows how to transfer Jumpseller into a data warehouse using Oracle Data Integrator.
-
Integrate with HubDB Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy HubDB to a JSON file on disk.
-
How to connect to PDFMonkey Data from IntelliJ
Integrate connectivity to PDFMonkey with wizards in IntelliJ.
-
Use the CData ODBC Driver for DocuSign in Microsoft Power Query
You can use the CData DocuSign ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import DocuSign into Microsoft Power Query.
-
Build Spark-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Apache Spark SQL.
-
Build Agents in Relevance AI with Access to Live Cvent Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Cvent within intelligent agent workflows.
-
Using the CData Software ODBC Driver for PolarTeamPro in PyCharm
Connect to PolarTeamPro as an ODBC data source in PyCharm using the CData Software ODBC Driver for PolarTeamPro.
-
Getting Started with the CData Excel Add-In for Snapchat Ads
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Snapchat Ads.
-
How to connect to Flowlu Data with Squirrel SQL client
Connect to Flowlu and execute queries in the Squirrel SQL Client.
-
Build Snapchat Ads-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Snapchat Ads to explore live Snapchat Ads Data in Gemini Code Assist to assist with building Snapchat Ads-powered applications.
-
Use the CData Software JDBC Driver for Clio in MicroStrategy Desktop
Connect to Clio in MicroStrategy Desktop using the CData Software JDBC Driver for Clio.
-
How to Connect DBeaver to Paymo via a JDBC Driver
Manage Paymo with visual tools in DBeaver like the query browser.
-
Automate Snowflake Data Replication to SAP HANA
Use CData Sync to customize and automate Snowflake replication to SAP HANA.
-
Connect to Apollo Data in Jaspersoft Studio
Execute SQL to remote Apollo in Jaspersoft Studio.
-
Stream ActiveCampaign Data into Apache Kafka Topics
Access and stream ActiveCampaign in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Work with Couchbase Data in ETL Validator JDBC
Connect to Couchbase from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Visualize Zoho Projects 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 Zoho Projects in Python.
-
How to Query Live Highrise Data in Perplexity MacOS Desktop
Connect to and query live Highrise Data in Perplexity Desktop using CData MCP Server.
-
Access NetSuite 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 NetSuite CRM & ERP.
-
Integrate Goose with Live Zoho Creator Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Zoho Creator from within the local AI agent.
-
Query ZeroBounce Data as a MySQL Database in Node.js
Execute MySQL queries against ZeroBounce from Node.js.
-
Connect to Dotmailer in SpagoBI
Create reports featuring live Dotmailer in SpagoBI Studio. Host Dotmailer reports on SpagoBI Server.
-
Create SAP Ariba Source Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP Ariba Source data access from reports, embedded analytics, and more.
-
Natively Connect to VWO Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to VWO. Leverage the native support for ODBC in PHP.