CData Software - Knowledge Base
Recent Articles
-
Integrating LangChain with Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Trello within automated workflows.
-
Connect to Perigon 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 Perigon and work with Perigon in your FileMaker application.
-
Create Power BI Reports on Real-Time Oracle SCM Data
Use the CData ODBC Driver for Oracle SCM to visualize Oracle SCM in Power BI Desktop.
-
Access Live NASA Data in AWS Lambda
Connect to live NASA in AWS Lambda using the CData JDBC Driver.
-
Use the CData ODBC Driver for ServiceNow in Microsoft Power Query
You can use the CData ServiceNow ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ServiceNow into Microsoft Power Query.
-
Build a Singer.io Tap for Delighted With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Delighted data using
-
Connect to Zoho Inventory Data in Jaspersoft Studio
Execute SQL to remote Zoho Inventory in Jaspersoft Studio.
-
Connecting Pipedream with YouTube Analytics Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on YouTube Analytics data in real time.
-
Easily Integrate Bannerbear Data in Lazarus Pascal IDE
Learn how to easily integrate live Bannerbear in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Oracle SCM Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Oracle SCM.
-
Process & Analyze PabblySubscriptions Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live PabblySubscriptions Data.
-
Use the CData Software JDBC Driver for Cosmos DB in MicroStrategy Web
Connect to Azure Cosmos DB in MicroStrategy Web using the CData Software JDBC Driver for Cosmos DB.
-
Getting Started with the CData Power BI Connector for Parquet
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Parquet.
-
How to import AgileCRM Data into Apache Solr
Use the CData Software JDBC Driver for AgileCRM in Data Import Handler and create an automated import of AgileCRM to Apache Solr Enterprise Search platform.
-
Integrate with Power BI XMLA Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Power BI XMLA in SnapLogic.
-
Automated Continuous Facebook Ads Replication to SingleStore
Use CData Sync for automated, continuous, customizable Facebook Ads replication to SingleStore.
-
Automated Continuous Monday.com Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Monday.com replication to Azure SQL Database.
-
How to Connect to Attio Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Attio. Leverage the pyodbc module for ODBC in Python.
-
Replicate Multiple Vertica Accounts
Replicate multiple Vertica accounts to one or many databases.
-
Integrate Live NetSuite SuiteAnalytics Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to NetSuite SuiteAnalytics and integrate live NetSuite SuiteAnalytics into apps built in Microsoft Power Apps.
-
How to Connect the Power BI Service to Outlook: Complete Guide
Connect to the CData Software Power BI Connector for Outlook from PowerBI.com to provide real-time Outlook across the organization.
-
How to connect to FreeAgent Data from IntelliJ
Integrate connectivity to FreeAgent with wizards in IntelliJ.
-
Integrate Simplesat Data in the Pentaho Report Designer
Publish reports based on Simplesat in the Pentaho BI tool.
-
Import Real-Time Raisers Edge NXT Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Raisers Edge NXT in ColdFusion.
-
Connect to Spotify Data in JRuby
Create a simple JRuby app with access to live Spotify.
-
Use the CData Software ODBC Driver for Planio in MicroStrategy
Connect to Planio in MicroStrategy Developer using the CData Software ODBC Driver for Planio.
-
How to Query Live Dynamics NAV Data in Perplexity MacOS Desktop
Connect to and query live Dynamics NAV Data in Perplexity Desktop using CData MCP Server.
-
Automated Continuous Figshare Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Figshare replication to Azure SQL Database.
-
LINQ to Toggl 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 Toggl Data Provider.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Quickbase within intelligent workflows.
-
Use Biml to Build SSIS Tasks to Replicate Freshsales Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Freshsales to SQL Server.
-
Connect to Google Search Results as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Search.
-
How to Easily Query Couchbase Data in OpenOffice Base
Connect to Couchbase data in OpenOffice Base using the CData ODBC Driver for Couchbase and generate reports with live data insights.
-
Automated Continuous Elorus Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Elorus replication to IBM DB2.
-
Integrating Oracle Eloqua Data in Talend Cloud Data Management Platform
Connect Oracle Eloqua Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Oracle Eloqua.
-
Connect to and Visualize Live Workday Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Workday.
-
Visualize Templated Data in TIBCO Spotfire through ADO.NET
Integrate Templated into dashboards in TIBCO Spotfire.
-
How to create Aircall federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Aircall in MySQL .
-
Access Live Google Cloud Storage Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Cloud Storage from your Excel spreadsheets.
-
Publish Cvent-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Cvent.
-
Automated Continuous Exa Replication to SQLite
Use CData Sync for automated, continuous, customizable Exa replication to SQLite.
-
Use Microsoft Copilot Studio to talk to your Google Calendar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Google Calendar for you.
-
Automate Tasks in Power Automate Using the CData API Server
Automate EnterpriseDB actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Connect to Live Avalara AvaTax Data in MicroStrategy through CData Connect AI
Create a live connection to Avalara AvaTax Data in CData Connect AI and connect to your Avalara AvaTax from MicroStrategy.
-
How to Connect to Live CouchDB Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Apache CouchDB without replication.
-
Query JotForm Data as a MySQL Database in Node.js
Execute MySQL queries against JotForm from Node.js.
-
Migrating data from Mocean to Databricks using CData SSIS Components.
Easily push Mocean to Databricks using the CData SSIS Tasks for Mocean and Databricks.
-
Use the CData API Server to Access Zoho Creator Data in Microsoft PowerPivot
Use the CData API Server to connect to live Zoho Creator in the Power Pivot business intelligence tool.
-
Connect to Instagram Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Instagram to connect to Instagram and execute queries in PowerBuilder.
-
Integrating Claude Code CLI with HubSpot 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.
-
Use the CData Software ODBC Driver for Google Tasks in MicroStrategy Web
Connect to Google Tasks in MicroStrategy Web using the CData Software ODBC Driver for Google Tasks.
-
DataBind Controls to TigerGraph Data in Delphi
DataBind to TigerGraph in Delphi with standard data access components and controls.
-
How to create Harvest federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Harvest in MySQL .
-
Automated Continuous Google Spanner Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Google Spanner replication to Apache Cassandra.
-
Build Automated Zoho CRM-Connected Workflows in Zapier
Use CData Connect AI to connect to live Zoho CRM and build automated workflows in Zapier.
-
Connect to Square Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Square Data and connect to Square in Akorbi Digital RunMyProcess.
-
Connect to HBase Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Apache HBase in the Denodo Virtual DataPort Administrator.
-
How to use SQLAlchemy ORM to access Google Search Results in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Search.
-
Connect to ShipStation Data in HULFT Integrate
Connect to ShipStation as a JDBC data source in HULFT Integrate
-
Establish a Live Connection with OData Services using Tableau Bridge
The CData ODBC Driver for OData enables you to integrate live OData into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Act-On Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Act-On replication to Google Cloud SQL.
-
Replicate Gumroad Data from PowerShell
Write a quick PowerShell script to query Gumroad. Use connectivity to the live data to replicate Gumroad to SQL Server.
-
Access Live PhantomBuster Data in AWS Lambda
Connect to live PhantomBuster in AWS Lambda using the CData JDBC Driver.
-
Automate Pipedrive Data Replication to Couchbase
Use CData Sync to Customize and automate Pipedrive replication to Couchbase.
-
Integrating LangChain with Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Email within automated workflows.
-
Use the CData Software JDBC Driver for VWO in MicroStrategy Desktop
Connect to VWO in MicroStrategy Desktop using the CData Software JDBC Driver for VWO.
-
Automated Continuous Mailjet Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Mailjet replication to AlloyDB.
-
How to Work with ZarMoney Data in ETL Validator JDBC
Connect to ZarMoney from ETL Validator jobs using the CData Software JDBC Driver.
-
ETL Omnisend in Oracle Data Integrator
This article shows how to transfer Omnisend into a data warehouse using Oracle Data Integrator.
-
Build a PostgreSQL Interface for QuickBooks Online Data using the CData JDBC Driver
Use the Remoting features of the QuickBooks Online JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to import Paylocity Data into Apache Solr
Use the CData Software JDBC Driver for Paylocity in Data Import Handler and create an automated import of Paylocity to Apache Solr Enterprise Search platform.
-
Integrate Live Nuclia Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Nuclia to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Sage 200 Data from PowerBuilder via ADO.NET
This article demonstrates how to access Sage 200 from Appeon PowerBuilder using the CData ADO.NET Provider for Sage 200.
-
Build Office 365-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Office 365 to explore live Office 365 Data in Gemini Code Assist to assist with building Office 365-powered applications.
-
Integrate Zendesk Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Zendesk and integrate live Zendesk into your Power Automate tasks.
-
Create Freshsales Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Freshsales data access from reports, embedded analytics, and more.
-
Connect to Strava Data from PowerBuilder via ADO.NET
This article demonstrates how to access Strava from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Access Live eBay Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate eBay into the statistical analysis tools available in SAS JMP. This article shows how to use eBay in the Graph Builder and Query Builder.
-
Create Reports from OData Services in Looker Studio
Use CData Connect AI to gain access to live OData and create custom reports in Looker Studio.
-
Build Semantic Layer Views for Dynamics CRM Data in APOS Live Data Gateway
Use the CData Connector for Dynamics CRM in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Dynamics CRM.
-
Connect to Couchbase Data in JRuby
Create a simple JRuby app with access to live Couchbase.
-
Connect to Attio Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Attio as an External Source in Dremio.
-
How to Easily Query Office 365 Data in OpenOffice Base
Connect to Office 365 data in OpenOffice Base using the CData ODBC Driver for Office 365 and generate reports with live data insights.
-
Build a PostgreSQL Interface for Beeminder Data using the CData JDBC Driver
Use the Remoting features of the Beeminder JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Dashboards with Pinecone Data in Dundas BI
Create dynamic dashboards and perform analytics based on Pinecone in Dundas BI.
-
Create Reports with Certinia Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Certinia.
-
Validate Onfleet Data with QuerySurge
Access and validate Onfleet in QuerySurge using the CData JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Copper
Create an ODBC connection to Copper in Informatica and browse and transfer Copper.
-
Automated Continuous Act-On Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Act-On replication to delimited files (CSV/TSV).
-
Provide OData Services of Smartsheet Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Smartsheet by developing a WCF Service Application.
-
How to publish and share Vault CRM Data dashboards with Tableau Server
The CData ODBC driver for Vault CRM enables you integrate Veeva Vault & Vault CRM into Tableau dashboards.
-
How to Connect the Power BI Service to Tanda: Complete Guide
Connect to the CData Software Power BI Connector for Tanda from PowerBI.com to provide real-time Tanda across the organization.
-
Automated Continuous Snapchat Ads Replication to Snowflake
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Snowflake.
-
Migrating data from Google Search to Databricks using CData SSIS Components.
Easily push Google Search to Databricks using the CData SSIS Tasks for Google Search and Databricks.
-
Create a Data Access Object for Box Data using JDBI
A brief overview of creating a SQL Object API for Box in JDBI.
-
Connect to Okta Data in JRuby
Create a simple JRuby app with access to live Okta.
-
View Reports on Real-Time SharePoint Data in Power BI Report Server
Use the CData ODBC Driver for SharePoint to visualize Microsoft SharePoint in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect to Exact Online Data from Spring Boot
Connect to Exact Online in a Spring Boot Application using the CData JDBC Driver for Exact Online
-
Connect to Stripe Data from AWS Glue
Use CData Connect AI to gain access to live Stripe from your AWS Glue jobs.
-
How to connect PolyBase to Salesforce Pardot
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Salesforce Pardot.