CData Software - Knowledge Base
Recent Articles
-
Build MVC Applications with Connectivity to Smartsheet Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Smartsheet from an ASP.NET MVC application.
-
Feed Float Data into FineReport
How to set Float data as a JDBC data source in FineReport.
-
Create Datasets from Oracle Sales in Domo Workbench and Build Visualizations of Oracle Sales Data in Domo
Use the CData Software ODBC Driver for Oracle Sales to create datasets from Oracle Sales data in Domo Workbench and then build visualizations in the Domo service.
-
How to create Pipedrive federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Pipedrive data in MySQL .
-
Consume Cassandra OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Cassandra feeds that reflect any changes in SAP Lumira.
-
Visualize Mixpanel 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 Mixpanel data into TIBCO Spotfire.
-
Build a Singer.io Tap for Access With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Access data using the CData Python Connector.
-
How to Connect the Power BI Service to SAP Netweaver Gateway: Complete Guide
Connect to the CData Software Power BI Connector for SAP Netweaver Gateway from PowerBI.com to provide real-time SAP Netweaver Gateway data across the organization.
-
Analyze PayPal Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze PayPal data in Microsoft R Open.
-
Use the CData SSIS Components to Insert New or Update Existing Excel Online Records from SQL Server
Easily push SQL Server data to Excel Online using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Excel Online or update existing records with data from a SQL Server database.
-
Visualize Azure Analysis Services Data in Sisense
Create an ElastiCube in Sisense app with access to Azure Analysis Services data.
-
Connect to SAP Business Warehouse Data in DBArtisan
Use wizards in DBArtisan to configure SAP Business Warehouse data as a data source.
-
Automated Continuous Avalara AvaTax Replication to Snowflake
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Snowflake.
-
LINQ to PolarTeamPro 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 PolarTeamPro Data Provider.
-
Perform Batch Operations with AlloyDB Data in Apache NiFi
Connect to AlloyDB data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to connect to Snapchat Ads Data with Squirrel SQL client
Connect to Snapchat Ads data and execute queries in the Squirrel SQL Client.
-
Automated Continuous Oracle Service Cloud Replication to MongoDB
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to MongoDB.
-
Build Charts with Facebook Data in Clear Analytics
Create dynamic charts and perform analytics based on Facebook data in Clear Analytics.
-
Object-Relational Mapping (ORM) with ZendeskSell 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 ZendeskSell data into a Java-based ORM framework, Hibernate.
-
Create Dynamic Grafana Grids Using the Infragistics XamDataGrid
Learn how you can connect Grafana to Infragistics XamDataGrid to build dynamic grids.
-
Build Visualizations of SAP HANA Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP HANA data in Birst.
-
Use Dash to Build to Web Apps on HDFS Data
Create Python applications that use pandas and Dash to build HDFS-connected web apps.
-
Use the CData Software JDBC Driver for Cloudant in MicroStrategy
Connect to Cloudant data in MicroStrategy Developer using the CData Software JDBC Driver for Cloudant.
-
Integrating Vimeo Data in Talend Cloud Data Management Platform
Connect Vimeo Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Query REST Data as a MySQL Database in Node.js
Execute MySQL queries against REST data from Node.js.
-
Connect to Nethunt Data from PowerBuilder via ADO.NET
This article demonstrates how to access Nethunt data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Back Up Parallel data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Parallel data data.
-
Build Dashboards with Oracle Eloqua Data in DBxtra
Create dynamic dashboards and perform analytics based on Oracle Eloqua data in DBxtra.
-
Integrating Cursor with Basecamp 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 an SAP BusinessObjects Universe on the CData JDBC Driver for Microsoft OneDrive
Provide connectivity to Microsoft OneDrive data through an SAP BusinessObjects universe.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Freshservice
Provide connectivity to Freshservice data through an SAP BusinessObjects universe.
-
Integrating GitHub Copilot with Hacker News 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 Informatica Mappings From/To a JDBC Data Source for Cohere
Create Cohere data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate SAS Data Sets Data in Pentaho Data Integration
Build ETL pipelines based on SAS Data Sets data in the Pentaho Data Integration tool.
-
Connect to Demio Data from a Connection Pool in JBoss
Integrate Demio data into Java servlets: Use the Management Console in JBoss to install the Demio JDBC Driver.
-
Visualize Samanage Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Samanage data.
-
Integrate with Paddle Data in JReport Designer
Create charts and reports based on Paddle data in JReport Designer.
-
Query Live Tavily 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 Tavily data through a conversational interface.
-
Automated Continuous WordPress Replication to Vertica
Use CData Sync for automated, continuous, customizable WordPress replication to Vertica.
-
Connect to Humanity Data in CloverDX (formerly CloverETL)
Transfer Humanity data using the visual workflow in the CloverDX data integration tool.
-
How to publish and share MailerLite Data dashboards with Tableau Server
The CData ODBC driver for MailerLite enables you integrate MailerLite data into Tableau dashboards.
-
Working with Smartsheet Data in LINQPad
Execute LINQ queries to Smartsheet data in LINQPad.
-
View Reports on Real-Time Onfleet Data in Power BI Report Server
Use the CData ODBC Driver for Onfleet to visualize Onfleet data in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Informatica Mappings From/To a JDBC Data Source for Testmonitor
Create Testmonitor data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to SingleStore from Asprova with CData Software ODBC Driver for SingleStore
This article shows how to connect faster to SingleStore data from Asprova.
-
Explore Geographical Relationships in Salesloft Data with Power Map
Create data visualizations with Salesloft data in Power Map.
-
Natively Connect to Zuora Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Zuora data. Leverage the native support for ODBC in PHP.
-
Query Authorize.Net Data as a MySQL Database in Node.js
Execute MySQL queries against Authorize.Net data from Node.js.
-
Integrating Jira Data in Talend Cloud Data Management Platform
Connect Jira Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Jira.
-
How to create an RPA flow for Helpscout Data in UiPath Studio
Use the Helpscout ODBC Driver to create workflows that access real-time Helpscout data without any coding.
-
Visualize MYOB AccountRight Data in TIBCO Spotfire through OData
Integrate MYOB AccountRight data into dashboards in TIBCO Spotfire.
-
Build SAP SuccessFactors LMS-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SAP SuccessFactors LMS Data from Zoho Analytics and import live SAP SuccessFactors LMS data.
-
Connect Twilio to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Twilio data using the CData Python MCP Server.
-
How to Access Amazon DynamoDB Data Using Entity Framework
This article shows how to access Amazon DynamoDB data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP Business One
Provide connectivity to SAP Business One data through an SAP BusinessObjects universe.
-
Extract, Transform, and Load WordPress Data in Informatica PowerCenter
Create a simple Workflow for WordPress data in Informatica PowerCenter.
-
Connecting Mastra with Dropbox Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Dropbox data, no replication required.
-
Connect to Pipeline CRM Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Pipeline CRM and work with Pipeline CRM data in your FileMaker application.
-
Create ZohoInvoice-Connected Applications in Appsmith
Connect to ZohoInvoice Data via CData Connect AI in Appsmith and create custom business applications with real-time access to ZohoInvoice data.
-
Connect to Reckon Data in JRuby
Create a simple JRuby app with access to live Reckon data.
-
Create Informatica Mappings From/To an ODBC Data Source for CircleCI
Create an ODBC connection to CircleCI in Informatica and browse and transfer CircleCI data.
-
Model, Search, and Visualize Live QuickBooks Time Data in ThoughtSpot
Use CData Connect AI to connect to live QuickBooks Time data for modeling, searching, and visualizing.
-
Connect to Live Google Forms Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Google Forms in CData Connect AI and connect to your Google Forms data from PostgreSQL.
-
Use Dash to Build Web Apps on Okta Data via CData Connect AI
Build interactive Dash web apps on live Okta data using pandas and the CData Connect AI Python SDK.
-
Create Informatica Mappings From/To a JDBC Data Source for Facebook
Create Facebook data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Invoiced Replication to Oracle
Use CData Sync for automated, continuous, customizable Invoiced replication to Oracle.
-
Access Live Salesforce Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Salesforce data through MCP integration.
-
Build SageHR-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SageHR Data from Zoho Analytics and import live SageHR data.
-
Access Live Couchbase 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 Couchbase data through MCP integration.
-
How to Connect to Live Jumpseller 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 Jumpseller data for you.
-
Build Act CRM-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Act CRM data and build Act CRM-connected web apps with Axios.
-
How to import Procore Data into Apache Solr
Use the CData Software JDBC Driver for Procore in Data Import Handler and create an automated import of Procore data to Apache Solr Enterprise Search platform.
-
Build Apps with Live Blackbaud FE NXT data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Blackbaud FE NXT data into the Adalo platform and build custom mobile and web applications with real-time Blackbaud FE NXT data.
-
Integrate Theia IDE with Live Presto 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 Presto data from within the development environment.
-
Work with HubSpot Data in FoxPro
Load HubSpot data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Natively Connect to SharePoint Excel Services Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SharePoint Excel Services data. Leverage the native support for ODBC in PHP.
-
Process & Analyze Deel Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Deel Data.
-
Integrating OpenCode with Reply.io 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.
-
Edit and Search External Lakebase Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Lakebase data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Lakebase Data objects that you can access from apps and the dashboard.
-
Automated Continuous EnterpriseDB Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Google Cloud SQL.
-
How to Create Power BI Visual Reports with Real-Time Google Contacts Data
Use CData Power BI Connectors to visualize Google Contacts data in Power BI.
-
Choosing the Best Method to Connect Parallel to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Parallel data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Using the CData Software ODBC Driver for Excel Online in PyCharm
Connect to Excel Online as an ODBC data source in PyCharm using the CData Software ODBC Driver for Excel Online.
-
Access Copper 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 Copper data.
-
Visualize Live Microsoft Planner Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Planner data.
-
Connecting GenSpark with Amazon Athena Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Amazon Athena data without any replication or custom integration required.
-
Visualize Live Vertica Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Vertica data into custom reports in Power BI.
-
Integrating LangGraph with OData Services via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on OData services within automated workflows.
-
How to connect to Oracle Financials Cloud Data from IntelliJ
Integrate connectivity to Oracle Financials Cloud data with wizards in IntelliJ.
-
A PostgreSQL Interface for Google Cloud Storage Data (MySQL Remoting via JDBC)
Use the Remoting features of the Google Cloud Storage JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Theia IDE with Live MYOB AccountRight 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 MYOB AccountRight data from within the development environment.
-
Integrate with Zoho Inventory Data in JReport Designer
Create charts and reports based on Zoho Inventory data in JReport Designer.
-
Connect to Retently Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Retently.
-
A PostgreSQL Interface for CloudConvert Data (MySQL Remoting via JDBC)
Use the Remoting features of the CloudConvert JDBC Driver to create a PostgreSQL entry-point for data access.
-
Timely Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Timely data through CData Connect AI using different applications and tools.
-
Analyze AlloyDB Data in Looker
Use CData Connect AI to connect to AlloyDB Data from Looker and build custom apps using live AlloyDB data.
-
Integrate Dify with Live Google Drive Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Google Drive data.
-
A PostgreSQL Interface for Google Sheets Data using the CData ODBC Driver
Use the SQL Gateway and Google Sheets ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Tally Data in Coginiti Pro
Connect to and query live Tally data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build a PostgreSQL Interface for Paddle Data using the CData JDBC Driver
Use the Remoting features of the Paddle JDBC Driver to create a PostgreSQL entry-point for data access.