CData Software - Knowledge Base
Recent Articles
-
Integrate with Salesforce Marketing Data in JReport Designer
Create charts and reports based on Salesforce Marketing data in JReport Designer.
-
Connect to Cassandra Data in JRuby
Create a simple JRuby app with access to live Cassandra data.
-
Create Reports with Google Calendar Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Calendar data.
-
Use Biml to Build SSIS Tasks to Replicate Perplexity Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Perplexity data to SQL Server.
-
Analyze Oracle Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Oracle data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Azure Data Catalog Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Azure Data Catalog data in the Denodo Virtual DataPort Administrator.
-
Integrate Sybase IQ Data in the Pentaho Report Designer
Publish reports based on Sybase IQ data in the Pentaho BI tool.
-
Connecting Agentforce with SAP Business One 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 SAP Business One data for you.
-
Prepare, Blend, and Analyze Intercom Data in Alteryx Designer (ODBC)
Build workflows to access live Intercom data for self-service data analytics.
-
How to publish and share Jumpseller Data dashboards with Tableau Server
The CData ODBC driver for Jumpseller enables you integrate Jumpseller data into Tableau dashboards.
-
Automated Continuous Jira Assets Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Jira Assets replication to AlloyDB.
-
Integrating OpenCode with Printful 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 Datasets from Elasticsearch in Domo Workbench and Build Visualizations of Elasticsearch Data in Domo
Use the CData Software ODBC Driver for Elasticsearch to create datasets from Elasticsearch data in Domo Workbench and then build visualizations in the Domo service.
-
Establish a Live Connection with Retently Data using Tableau Bridge
The CData ODBC Driver for Retently enables you to integrate live Retently data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Unbounce-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Unbounce data and build web apps with connectivity to live Unbounce data.
-
Integrate Shippo Data in the Pentaho Report Designer
Publish reports based on Shippo data in the Pentaho BI tool.
-
Create ActiveCampaign-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to ActiveCampaign Data from OutSystems and build custom enterprise apps using live ActiveCampaign data.
-
Migrating data from SAP to Google BigQuery using CData SSIS Components.
Easily push SAP data to Google BigQuery using the CData SSIS Tasks for SAP and Google BigQuery.
-
How to connect PolyBase to Pipedrive
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Pipedrive data.
-
How to create Amazon S3 federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Amazon S3 data in MySQL .
-
Replicate LaunchDarkly Data in Heroku for Use in Salesforce Connect
Replicate LaunchDarkly data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Clockify Data from MySQL in PHP
Connect to Clockify through the standard MySQL libraries in PHP.
-
Visualize Pipedrive Data in Sisense
Create an ElastiCube in Sisense app with access to Pipedrive data.
-
Use the CData ODBC Driver for Suadeo from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Suadeo to connect to Suadeo data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Suadeo data in Excel.
-
Publish Reports with PDFMonkey Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PDFMonkey data.
-
Connect to MailChimp Data as an External Source in Dremio
Use the CData JDBC Driver to connect to MailChimp as an External Source in Dremio.
-
Connect and Query Live PolarTeamPro Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live PolarTeamPro data into Databricks and enable direct, live querying and analysis without replication.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Scrapfly
Provide connectivity to Scrapfly data through an SAP BusinessObjects universe.
-
Working with Figshare Data in LINQPad
Execute LINQ queries to Figshare data in LINQPad.
-
Integrate Ontraport Data in Pentaho Data Integration
Build ETL pipelines based on Ontraport data in the Pentaho Data Integration tool.
-
Visualize GitHub 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 GitHub data into TIBCO Spotfire.
-
A PostgreSQL Interface for Billsby Data (MySQL Remoting via JDBC)
Use the Remoting features of the Billsby JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build AI Agents with Instagram 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 Instagram data through CData Connect AI.
-
Visualize Act-On Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Act-On data.
-
Query Superchat Data in DataGrip
Create a Data Source for Superchat in DataGrip and use SQL to query live Superchat data.
-
Build Bullhorn CRM-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Bullhorn CRM Data from Zoho Analytics and import live Bullhorn CRM data.
-
ETL Suadeo in Oracle Data Integrator
This article shows how to transfer Suadeo data into a data warehouse using Oracle Data Integrator.
-
Use Biml to Build SSIS Tasks to Replicate Google Cloud Storage Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Cloud Storage data to SQL Server.
-
Integrate Google's Antigravity Agent with Live GetResponse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live GetResponse data using the Model Context Protocol.
-
LINQ to Yelp 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 Yelp Data Provider.
-
Sage Intacct Reporting in OBIEE with the Sage Intacct JDBC Driver
Deploy the Sage Intacct JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Trello-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Trello Data from Zoho Analytics and import live Trello data.
-
Analyze LeadDesk Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for LeadDesk from Power Pivot. You will use the Table Import Wizard to load LeadDesk data. You can visually build the import query or use any SQL supported by the driver.
-
Integrate CapsuleCRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate CapsuleCRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to CapsuleCRM data.
-
Connect to Demio from Asprova with CData Software ODBC Driver for Demio
This article shows how to connect faster to Demio data from Asprova.
-
How to connect to Demio Data in DBVisualizer
Integrate Demio data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to import Trello Data into Apache Solr
Use the CData Software JDBC Driver for Trello in Data Import Handler and create an automated import of Trello data to Apache Solr Enterprise Search platform.
-
Connect to Billsby Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Billsby and the SQL Gateway to access Billsby data from Google Apps Script.
-
Query HCL Domino Data in ColdFusion
Write standard ColdFusion data access code to connect to HCL Domino data.
-
Build Apps with Live Monday.com data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Monday.com data into the Adalo platform and build custom mobile and web applications with real-time Monday.com data.
-
Connecting GenSpark with Jira Assets Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Jira Assets data without any replication or custom integration required.
-
Integrate Cline with Live ShipStation Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live ShipStation data from within your IDE.
-
Power BI XMLA Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Power BI XMLA facts in real time.
-
Getting Started with the CData Tableau Connector for Quaderno
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrate Odoo with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Odoo with External Services.
-
Automated Continuous JobNimbus Replication to SingleStore
Use CData Sync for automated, continuous, customizable JobNimbus replication to SingleStore.
-
Connect to NetSuite SuiteAnalytics Data from HeidiSQL
Use CData Connect AI to connect to and query live NetSuite SuiteAnalytics data from HeidiSQL.
-
Build Charts with ZohoPeople Data in Clear Analytics
Create dynamic charts and perform analytics based on ZohoPeople data in Clear Analytics.
-
How to Connect RSS Feeds to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live RSS data in real time using natural language.
-
Visualize Mouseflow Data in TIBCO Spotfire through ADO.NET
Integrate Mouseflow data into dashboards in TIBCO Spotfire.
-
Use the CData Software ODBC Driver for Microsoft Ads in MicroStrategy Web
Connect to Microsoft Ads data in MicroStrategy Web using the CData Software ODBC Driver for Microsoft Ads.
-
Connect to Dropbox from Asprova with CData Software ODBC Driver for Dropbox
This article shows how to connect faster to Dropbox data from Asprova.
-
Automated Continuous Reckon Replication to Databricks
Use CData Sync for automated, continuous, customizable Reckon replication to Databricks.
-
Access Live Postmark Data in AWS Lambda
Connect to live Postmark data in AWS Lambda using the CData JDBC Driver.
-
Connect to Outlook Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Outlook to connect to Outlook data and execute queries in PowerBuilder.
-
Analyze Adobe Target Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Adobe Target data in Microsoft R Open.
-
Use Dash to Build to Web Apps on Email Data
Create Python applications that use pandas and Dash to build Email-connected web apps.
-
Build Data Flows from Jodoo to SQL Server using SSIS
Easily back up Jodoo data to SQL Server using the SSIS components for Jodoo.
-
Connect to Act-On Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Act-On as an External Source in Dremio.
-
Rapidly Develop Monday.com-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 Monday.com.
-
How to Connect to Live Sendwithus Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Sendwithus data for you.
-
How to connect to Google Search Results with Squirrel SQL client
Connect to Google Search results and execute queries in the Squirrel SQL Client.
-
Import Egnyte Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Egnyte Data and provide access to live Egnyte data for custom reports in the Power BI Service.
-
Query Stripe Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Stripe data from Node.js.
-
Automated Continuous Sugar CRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Sugar CRM replication to delimited files (CSV/TSV).
-
Integrating OpenCode with HubDB 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.
-
Integrate Onfleet Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Onfleet data from Informatica Cloud.
-
Publish Reports with XML Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date XML data.
-
Use ChatGPT to Talk to Your DB2 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 DB2 data for you.
-
Connect to Vault CRM Data in ACL Analytics
Connect to Vault CRM data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Vault CRM data.
-
Stream Pinecone Data into Apache Kafka Topics
Access and stream Pinecone data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Azure Data Lake Storage Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Azure Data Lake Storage data in Airbyte.
-
Build Semantic Layer Views for ZohoPeople Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for ZohoPeople data.
-
Create Dashboards and Visualize Live Sendwithus Data in Geckoboard
Use CData Connect AI to connect to live Sendwithus data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Analyze Paddle Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Paddle data with the CData JDBC Driver for Paddle.
-
Connect to Redis Data in DBeaver
Use the CData ODBC Driver to connect to Redis data in DBeaver.
-
Replicate FreeAgent Data in Heroku for Use in Salesforce Connect
Replicate FreeAgent data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData Software JDBC Driver for Reckon in MicroStrategy Web
Connect to Reckon data in MicroStrategy Web using the CData Software JDBC Driver for Reckon.
-
Query Pipedrive Data as a SQL Server Database in Node.js
Execute SQL Server queries against Pipedrive data from Node.js.
-
Automated Continuous Zoom Replication to Vertica
Use CData Sync for automated, continuous, customizable Zoom replication to Vertica.
-
Use Biml to Build SSIS Tasks to Replicate Sage Cloud Accounting Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Sage Cloud Accounting data to SQL Server.
-
Migrating data from Stack Exchange to Databricks using CData SSIS Components.
Easily push Stack Exchange data to Databricks using the CData SSIS Tasks for Stack Exchange and Databricks.
-
Access Live Avalara AvaTax Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Avalara AvaTax data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Analyze Freshservice Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Freshservice data with the CData JDBC Driver for Freshservice.
-
A PostgreSQL Interface for Placid Data (MySQL Remoting via JDBC)
Use the Remoting features of the Placid JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live PayPal Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live PayPal data into custom reports in Power BI.
-
Integrating Kiro with SAP 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.
-
How to Access Live Zoho Inventory Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Zoho Inventory enables you to integrate Zoho Inventory data into workflows built using Microsoft Power Automate Desktop.
-
Visualize CloudConvert 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 CloudConvert data into TIBCO Spotfire.
-
Working with SAP Ariba Source Data in LINQPad
Execute LINQ queries to SAP Ariba Source data in LINQPad.