CData Software - Knowledge Base
Recent Articles
-
Use the CData Software JDBC Driver for Reckon Accounts Hosted in MicroStrategy Web
Connect to Reckon Accounts Hosted data in MicroStrategy Web using the CData Software JDBC Driver for Reckon Accounts Hosted.
-
Visualize Parquet Data in TIBCO Spotfire through OData
Integrate Parquet data into dashboards in TIBCO Spotfire.
-
How to Connect to Live Lakebase Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Lakebase data without replication.
-
How to Connect the Power BI Service to Rootly: Complete Guide
Connect to the CData Software Power BI Connector for Rootly from PowerBI.com to provide real-time Rootly data across the organization.
-
Connect to Google Directory Data in DBArtisan
Use wizards in DBArtisan to configure Google Directory data as a data source.
-
Integrate Tally with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Tally with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Tally data.
-
Connect to and Visualize Live Testmonitor Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Testmonitor data.
-
How to connect and process Salesforce data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Salesforce data.
-
Access Zendesk Data from MySQL in PHP
Connect to Zendesk through the standard MySQL libraries in PHP.
-
Manage Everhour Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Everhour.
-
Integrate Humanity Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Humanity data from Informatica Cloud.
-
Create Datasets from Xero in Domo Workbench and Build Visualizations of Xero Data in Domo
Use the CData Software ODBC Driver for Xero to create datasets from Xero data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Productboard Data from a Connection Pool in Jetty
The Productboard JDBC Driver supports connection pooling: This article shows how to connect faster to Productboard data from Web apps in Jetty.
-
Query Live Couchbase 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 Couchbase data through a conversational interface.
-
Integrate Anaplan with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Anaplan with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Anaplan data.
-
Integrate Float Data in Pentaho Data Integration
Build ETL pipelines based on Float data in the Pentaho Data Integration tool.
-
LINQ to Asana 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 Asana Data Provider.
-
Integrate Trae with Live CouchDB Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live CouchDB data from within the AI-powered IDE.
-
Access Live Google Spanner Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Spanner data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Grafana Data in HULFT Integrate
Connect to Grafana as a JDBC data source in HULFT Integrate
-
Create Informatica Mappings From/To a JDBC Data Source for Highrise
Create Highrise data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use Manus AI to Talk to Your Dropbox Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Dropbox data.
-
Choosing the Best Method to Connect Google Search to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Search results from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Publish Reports with Oracle HCM Cloud Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle HCM Cloud data.
-
Integrate Amazon Marketplace with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Amazon Marketplace with External Services.
-
Access Live Instagram Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Instagram data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Build an ETL App for PDFMonkey Data in Python with CData
Create ETL applications and real-time data pipelines for PDFMonkey data in Python with petl.
-
Integrate Live SparkPost Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SparkPost data and integrate live SparkPost data into apps built in Microsoft Power Apps.
-
Design BIRT Reports on Eventbrite Data
Provide current Eventbrite data to your embedded analytics.
-
Working with ClickUp Data in LINQPad
Execute LINQ queries to ClickUp data in LINQPad.
-
Publish Reports with ShipEngine Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ShipEngine data.
-
Connect to Cloudflare Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Cloudflare and work with Cloudflare data in your FileMaker applications.
-
Integrate Real-Time Access to SAP Business One in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP Business One data in real time.
-
Use the CData ODBC Driver for Figshare from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Figshare to connect to Figshare data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Figshare data in Excel.
-
Automated Continuous LinkedIn Ads Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to delimited files (CSV/TSV).
-
Model VWO Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and VWO, enabling the direct import of real-time VWO data.
-
Natively Connect to MailerSend Data in PHP
The CData ODBC driver for MailerSend enables you to create PHP applications with connectivity to MailerSend data. Leverage the native support for ODBC in PHP.
-
Connecting Moonlit Workflow with Oracle 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 Oracle data in real time.
-
Use the CData Software JDBC Driver for Amazon Athena in MicroStrategy Desktop
Connect to Amazon Athena data in MicroStrategy Desktop using the CData Software JDBC Driver for Amazon Athena.
-
Replicate SAP BusinessObjects BI Data in Heroku for Use in Salesforce Connect
Replicate SAP BusinessObjects BI data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Gmail-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Gmail data.
-
Migrating data from Monday.com to Databricks using CData SSIS Components.
Easily push Monday.com data to Databricks using the CData SSIS Tasks for Monday.com and Databricks.
-
Getting Started with the CData Tableau Connector for MySQL
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for MySQL.
-
Automated Continuous AdRoll Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable AdRoll replication to Google Cloud SQL.
-
Integrating Codex with Mode 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.
-
Analyze ShipEngine Data in Looker
Use CData Connect AI to connect to ShipEngine Data from Looker and build custom apps using live ShipEngine data.
-
Integrate Real-Time Access to Asana in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Asana data in real time.
-
Create SAP Ariba Source-Connected Nintex Workflows
Use CData Connect AI to connect to SAP Ariba Source Data from Nintex Workflow Cloud and build custom workflows using live SAP Ariba Source data.
-
Automate IBM Cloud Object Storage Data Replication to Azure Synapse
Use CData Sync to customize and automate IBM Cloud Object Storage data replication to Azure Synapse.
-
Access LDAP Objects as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access LDAP objects from your Oracle system.
-
DataBind Controls to NASA Data in Delphi
DataBind to NASA data in Delphi with standard data access components and controls.
-
Create SSAS Tabular Models from SAP Business Warehouse Data
How to build a SQL Server Analysis Service Tabular Model from SAP Business Warehouse data using CData drivers.
-
Analyze Retently Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Retently data in Microsoft R Open.
-
Connect to SharePoint Excel Services Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SharePoint Excel Services as an External Source in Dremio.
-
Publish Crystal Reports on QuickBooks Online Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date QuickBooks Online data.
-
Connect to Real-Time Campaigner Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Campaigner data in Power Apps.
-
Automate Microsoft Ads Data Replication to Couchbase
Use CData Sync to Customize and automate Microsoft Ads data replication to Couchbase.
-
Analyze Gmail Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Gmail data and visualize Gmail data in SAP Analytics Cloud.
-
Connect Everhour Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Everhour data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Consume Greenplum OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Greenplum feeds that reflect any changes in SAP Lumira.
-
Create Microsoft Planner-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Microsoft Planner Data from Klipfolio and build custom visualizations using live Microsoft Planner data.
-
How to Work with Supabase Data in AWS Glue Jobs Using JDBC
Connect to Supabase from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
A PostgreSQL Interface for Printful Data (MySQL Remoting via JDBC)
Use the Remoting features of the Printful JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Crystal Reports on Amazon Athena Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Amazon Athena data.
-
How to Connect to Live Oracle Financials Cloud 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 Financials Cloud data for you.
-
Build Dashboards with Clockify Data in Dundas BI
Create dynamic dashboards and perform analytics based on Clockify data in Dundas BI.
-
Add Freshdesk Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Freshdesk with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Outlook Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Outlook data from Informatica Cloud.
-
Build Dynamics CRM-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Dynamics CRM data.
-
Automated Continuous Twitter Ads Replication to Oracle
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Oracle.
-
Connect to SuiteCRM Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SuiteCRM Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Build Visualizations of Authorize.Net Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Authorize.Net data in Birst.
-
Connecting Moonlit Workflow with QuickBooks Time 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 QuickBooks Time data in real time.
-
Connect to Paymo Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Paymo data.
-
Connect to Redis Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Redis and the SQL Gateway to access Redis data from Google Apps Script.
-
Perform Batch Operations with Email Data in Apache NiFi
Connect to Email data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Visualize Live Greenplum Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Greenplum data.
-
Build Visualizations of Mailjet Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Mailjet data in Birst.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Zoho Creator
Provide connectivity to Zoho Creator data through an SAP BusinessObjects universe.
-
Publish Google Tasks-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Tasks data.
-
How to publish and share Wrike Data dashboards with Tableau Server
The CData ODBC driver for Wrike enables you integrate Wrike data into Tableau dashboards.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Pinecone
Provide connectivity to Pinecone data through an SAP BusinessObjects universe.
-
Connect Reply.io Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Reply.io data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use Biml to Build SSIS Tasks to Replicate Figshare Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Figshare data to SQL Server.
-
Load Nuclia Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Nuclia data to a database.
-
How to integrate Timely with Apache Airflow
Access and process Timely data in Apache Airflow using the CData JDBC Driver.
-
Creating Act CRM-Connected Applications in Unqork
You can use CData Connect AI to feed Act CRM data to Unqork and build custom business apps.
-
Query Live Microsoft Dataverse 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 Microsoft Dataverse data through a conversational interface.
-
Replicate SAP Business One Data from PowerShell
Write a quick PowerShell script to query SAP Business One data. Use connectivity to the live data to replicate SAP Business One data to SQL Server.
-
How to Query Live Browserless Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Browserless data data in natural language using Python.
-
Integrate with Zoho Creator Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Zoho Creator data in SnapLogic.
-
Prepare, Blend, and Analyze Oracle Service Cloud Data in Alteryx Designer (ODBC)
Build workflows to access live Oracle Service Cloud data for self-service data analytics.
-
Connect to xBase from Asprova with CData Software ODBC Driver for xBase
This article shows how to connect faster to xBase data from Asprova.
-
Access Live Toggl Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Toggl data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect to Live SAS Data Sets Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your SAS Data Sets data for you.
-
Connect to Smartsheet Data from AWS Glue
Use CData Connect AI to gain access to live Smartsheet data from your AWS Glue jobs.
-
Automated Continuous Google Ad Manager Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Amazon S3.
-
Connect to Amazon Athena Data in Jaspersoft Studio
Execute SQL to remote Amazon Athena data in Jaspersoft Studio.
-
Connect to Live SAP HANA XS Advanced Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SAP HANA XS Advanced in CData Connect AI and connect to your SAP HANA XS Advanced data from PostgreSQL.
-
Integrate Accelo with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Accelo with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Accelo data.