CData Software - Knowledge Base
Recent Articles
-
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.
-
Create Informatica Mappings From/To a JDBC Data Source for Onfleet
Create Onfleet data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Coda Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Coda facts in real time.
-
Build Charts with Facebook Data in Clear Analytics
Create dynamic charts and perform analytics based on Facebook data in Clear Analytics.
-
Connect to ScrapingBee Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ScrapingBee and work with ScrapingBee data in your FileMaker applications.
-
Query REST Data as a MySQL Database in Node.js
Execute MySQL queries against REST data from Node.js.
-
Access Live Neo4J Data in AWS Lambda
Connect to live Neo4J data in AWS Lambda using the CData JDBC Driver.
-
Build Dashboards with Oracle Eloqua Data in DBxtra
Create dynamic dashboards and perform analytics based on Oracle Eloqua data in DBxtra.
-
Connect to Quaderno Data in RazorSQL
Connect to Quaderno from wizards and query Quaderno data from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData SSIS Components for IBM Informix
Complete guide to installing, licensing, and connecting with the CData SSIS Components for IBM Informix.
-
Integrating Boomi Agentstudio with CSV Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to CSV data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrate Dify with Live LinkedIn Ads 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 LinkedIn Ads data.
-
Analyze Customer.io Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Customer.io data with the CData JDBC Driver for Customer.io.
-
Prepare, Blend, and Analyze Google Calendar Data in Alteryx Designer (Connect AI)
Build workflows to access live Google Calendar data for self-service data analytics.
-
Query Live Twitter Ads Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Twitter Ads data directly from the development environment.
-
How to Connect to & Open Mistral AI Data in Microsoft Excel
This article uses the CData ODBC driver for Mistral AI to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Moving Data from Mailjet to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Mailjet data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Visualize Amazon Marketplace Data in Tableau
The CData ODBC driver for Amazon Marketplace enables you integrate Amazon Marketplace data into Tableau dashboards.
-
Build Automated Sybase IQ-Connected Workflows in Zapier
Use CData Connect AI to connect to live Sybase IQ data and build automated workflows in Zapier.
-
Create Datasets from ZarMoney in Domo Workbench and Build Visualizations of ZarMoney Data in Domo
Use the CData Software ODBC Driver for ZarMoney to create datasets from ZarMoney data in Domo Workbench and then build visualizations in the Domo service.
-
Import Real-Time ShipEngine Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ShipEngine data in ColdFusion.
-
Connect to CircleCI Data in CloverDX (formerly CloverETL)
Transfer CircleCI data using the visual workflow in the CloverDX data integration tool.
-
Build a Singer.io Tap for Jira With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Jira data using the CData Python Connector.
-
Connect to Accelo from a Connection Pool in WebLogic
Use the CData JDBC Driver for Accelo to connect to Accelo data from Web applications running on WebLogic.
-
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.
-
How to Visualize Amazon S3 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 Amazon S3 data in Python.
-
Analyze Brex Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Brex from Power Pivot. You will use the Table Import Wizard to load Brex data. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous SAP Business One Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SAP Business One replication to Google Cloud SQL.
-
Automated Continuous WordPress Replication to Vertica
Use CData Sync for automated, continuous, customizable WordPress replication to Vertica.
-
Establish a Live Connection with Redshift Data using Tableau Bridge
The CData ODBC Driver for Redshift enables you to integrate live Redshift data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build SAP HANA XS Advanced-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP HANA XS Advanced data and build web apps with connectivity to live SAP HANA XS Advanced data.
-
Query SAS xpt Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAS xpt data from Node.js.
-
How to Connect to Live Smartsheet 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 Smartsheet data for you.
-
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.
-
Use the CData Software JDBC Driver for Suadeo in MicroStrategy Desktop
Connect to Suadeo data in MicroStrategy Desktop using the CData Software JDBC Driver for Suadeo.
-
Query SAS xpt Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAS xpt data from Node.js.
-
Build AI Agents with Google Analytics 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 Google Analytics data through CData Connect AI.
-
Create Samanage Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Samanage data access from reports, embedded analytics, and more.
-
Connect to Dynamics 365 Business Central Data in CloverDX (formerly CloverETL)
Transfer Dynamics 365 Business Central data using the visual workflow in the CloverDX data integration tool.
-
Integrating LlamaIndex with Paymo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Paymo data in real time.
-
Analyze Kintone Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Kintone data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Automated Workflows with Live RSS Feeds in Workato
Use CData Connect AI to connect to live RSS feeds and build automated workflows in Workato.
-
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.
-
Adobe Commerce Reporting in OBIEE with the Adobe Commerce JDBC Driver
Deploy the Adobe Commerce JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Prepare, Blend, and Analyze Kafka Data in Alteryx Designer (Connect AI)
Build workflows to access live Kafka data for self-service data analytics.
-
Prepare, Blend, and Analyze Apollo Data in Alteryx Designer (ODBC)
Build workflows to access live Apollo data for self-service data analytics.
-
How to Connect to Live Raisers Edge NXT Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Raisers Edge NXT data securely in real time.
-
Integrate Egnyte Data in Pentaho Data Integration
Build ETL pipelines based on Egnyte data in the Pentaho Data Integration tool.
-
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.
-
Integrating LlamaIndex with HBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on HBase data in real time.
-
Analyze CSV Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze CSV data in Microsoft R Open.
-
Extract, Transform, and Load SAP Fieldglass Data in Informatica PowerCenter
Create a simple Workflow for SAP Fieldglass data in Informatica PowerCenter.
-
Manage Procore Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Procore.
-
DataBind Charts to Qualaroo Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Qualaroo 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.
-
LINQ to SAP Ariba Procurement 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 SAP Ariba Procurement Data Provider.
-
Easily Integrate Productboard Data in Lazarus Pascal IDE
Learn how to easily integrate live Productboard data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Pipeliner CRM Data in DBeaver
Use the CData ODBC Driver to connect to Pipeliner CRM data in DBeaver.
-
Automated Continuous Customer.io Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Customer.io replication to Azure SQL Database.
-
Access Dynamics NAV Data from MySQL in Amazon QuickSight
Connect to Dynamics NAV and build visualizations of Dynamics NAV data using a MySQL Connection in Amazon QuickSight.
-
Getting Started with the CData Connect AI Python SDK for Raisers Edge NXT
Install the CData Connect AI Python SDK to read live Raisers Edge NXT data with standard DB-API 2.0 Python code.
-
Connect to Marketo Data in RazorSQL
Connect to Marketo from wizards and query Marketo data from the GUI in the RazorSQL database management tool.
-
Create QuickBooks-Connected Applications in Appsmith
Connect to QuickBooks Data via CData Connect AI in Appsmith and create custom business applications with real-time access to QuickBooks data.
-
Import Freshservice Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Freshservice Data and provide access to live Freshservice data for custom reports in the Power BI Service.
-
Moving Data from ActiveCampaign to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ActiveCampaign data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Analyze Live Sybase Data in SAS Viya
Use CData Connect AI to connect to Sybase data from SAS Viya and deploy self-service analytics using live Sybase data.
-
Connect to Certinia Data from a Connection Pool in Jetty
The Certinia JDBC Driver supports connection pooling: This article shows how to connect faster to Certinia data from Web apps in Jetty.
-
Interact with Live Bright Data Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Bright Data data.
-
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.
-
How to Work with SuiteCRM Data in ETL Validator JDBC
Connect to SuiteCRM from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Mode Data in ACL Analytics
Connect to Mode data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Mode data.
-
Use ChatGPT to Talk to Your SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your SAP Business One data for you.
-
Connect to Lakebase Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Lakebase data.
-
Integrating LangChain with Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Instagram data within automated workflows.
-
Visualize Live Microsoft Planner Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Planner data.
-
Build an OLAP Cube in SSAS from IBM Informix Data
Establish a connection to IBM Informix data data from SQL Server Analysis Services, and use the IBM Informix Data Provider to build OLAP cubes for use in analytics and reporting.
-
Working with Optimizely Data in LINQPad
Execute LINQ queries to Optimizely data in LINQPad.
-
Use Azure AI Foundry to Talk to Your Freshteam 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 Freshteam data for you.
-
Build Google Cloud Storage-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Cloud Storage Data and create custom apps in Mendix.
-
How to Connect to Oracle Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Oracle data. Leverage the pyodbc module for ODBC in Python.
-
Migrating data from Microsoft Planner to Databricks using CData SSIS Components.
Easily push Microsoft Planner data to Databricks using the CData SSIS Tasks for Microsoft Planner and Databricks.
-
Create Power BI Reports on Real-Time CSV Data
Use the CData ODBC Driver for CSV to visualize CSV data in Power BI Desktop.
-
Create Pinterest-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Pinterest Data from Klipfolio and build custom visualizations using live Pinterest data.
-
Connect Webflow to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Webflow with IBM WebSphere for seamless data integration and connectivity.
-
Choosing the Best Method to Connect Sendwithus to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Sendwithus data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to IBM Cloud Object Storage Data in Google Apps Script via Connect AI
Use CData Connect AI to access IBM Cloud Object Storage data in Google Apps Script.
-
Automated Continuous Act CRM Replication to Vertica
Use CData Sync for automated, continuous, customizable Act CRM replication to Vertica.
-
Connect Cassandra to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Cassandra data using the CData Python MCP Server.
-
Build a Singer.io Tap for ShipEngine With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ShipEngine data using the CData Python Connector.
-
Connect to Instantly Data in HULFT Integrate
Connect to Instantly as a JDBC data source in HULFT Integrate
-
Automated Continuous BambooHR Replication to AlloyDB
Use CData Sync for automated, continuous, customizable BambooHR replication to AlloyDB.
-
Moving Data from MYOB AccountRight to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live MYOB AccountRight data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Query NASA Data in MySQL Workbench
Execute MySQL queries against live NASA data from MySQL Workbench.
-
Integrate Smartsheet Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Smartsheet data and integrate live Smartsheet data into your Power Automate tasks.
-
Use the CData Software ODBC Driver for Aweber in MicroStrategy Desktop
Connect to Aweber data in MicroStrategy Desktop using the CData Software ODBC Driver for Aweber.
-
Connect to EnterpriseDB Data in DBeaver
Use the CData ODBC Driver to connect to EnterpriseDB data in DBeaver.
-
Use the CData Software ODBC Driver for Pushbullet in MicroStrategy Desktop
Connect to Pushbullet data in MicroStrategy Desktop using the CData Software ODBC Driver for Pushbullet.
-
Build Cosmos DB-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 Cosmos DB data without replication.
-
How to create JobNimbus federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for JobNimbus data in MySQL .
-
How to Connect to Live ServiceDesk Plus 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 ServiceDesk Plus data for you.