CData Software - Knowledge Base
Recent Articles
-
Create Pinecone Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Pinecone data access from reports, embedded analytics, and more.
-
Query Google Search Results through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Search results from Node.js.
-
Viewing Attio Data in RAD Studio Data Explorer
How to view Attio data in RAD Studio Data Explorer using the CData ODBC Driver for Attio.
-
How to connect SharePoint with Xero Data through external lists
Provide Xero data to SharePoint users as an external list.
-
Analyze JSON Services in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze JSON services in Microsoft R Open.
-
Manage Google Spanner Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Spanner.
-
Analyze Presto Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Presto data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Avalara AvaTax-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Avalara AvaTax Data and create custom apps in Bubble.
-
Migrating data from Zoom to Databricks using CData SSIS Components.
Easily push Zoom data to Databricks using the CData SSIS Tasks for Zoom and Databricks.
-
Visualize Oracle Data in Tableau
The CData ODBC driver for Oracle enables you integrate Oracle data into Tableau dashboards.
-
Replicate Multiple Redis Accounts via the CData Sync CLI
Replicate multiple Redis accounts to one or many databases.
-
Connect to Gorgias Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Gorgias data.
-
Getting Started with the CData ADO.NET Provider for Cloudant
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Cloudant.
-
Integrate Live Facebook Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Facebook data from within the IDE.
-
How to Easily Query PDFMonkey Data in OpenOffice Base
Connect to PDFMonkey data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Google Calendar Data from Crystal Reports
Use CData Connect AI to connect to and report on live Google Calendar data from Crystal Reports.
-
Getting Started with the CData Python Connector for WooCommerce
Learn to install and license the CData Python Connector and configure a connection to live WooCommerce data.
-
Connect to Blackbaud FE NXT Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Blackbaud FE NXT Data and connect to Blackbaud FE NXT data in Akorbi Digital RunMyProcess.
-
Automate Webflow Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Webflow data from PowerShell? This article demonstrates how to utilize the Webflow Cmdlets for tasks like connecting to Webflow data, automating operations, downloading data, and more.
-
Creating Snapchat Ads-Connected Applications in Unqork
You can use CData Connect AI to feed Snapchat Ads data to Unqork and build custom business apps.
-
Query Templated Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Templated data from Node.js.
-
Using the CData Software ODBC Driver for Stripe in PyCharm
Connect to Stripe as an ODBC data source in PyCharm using the CData Software ODBC Driver for Stripe.
-
Access Live ServiceDesk Plus Data in Coginiti Pro
Connect to and query live ServiceDesk Plus data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Getting Started with the CData Power BI Connector for Google Directory
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Google Directory.
-
Use the CData Software JDBC Driver for xBase in MicroStrategy Desktop
Connect to xBase data in MicroStrategy Desktop using the CData Software JDBC Driver for xBase.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Wrike
Provide connectivity to Wrike data through an SAP BusinessObjects universe.
-
Getting Started with the CData ODBC Driver for OnePageCrm
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for OnePageCrm.
-
Create Power BI Reports on Real-Time Postmark Data
Use the CData ODBC Driver for Postmark to visualize Postmark data in Power BI Desktop.
-
Automated Continuous Authorize.Net Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Authorize.Net replication to Google Cloud SQL.
-
Connect to Bullhorn CRM Data from a Connection Pool in Jetty
The Bullhorn CRM JDBC Driver supports connection pooling: This article shows how to connect faster to Bullhorn CRM data from Web apps in Jetty.
-
Create SSAS Tabular Models from CouchDB Data
How to build a SQL Server Analysis Service Tabular Model from CouchDB data using CData drivers.
-
Integrate Dify with Live Google Campaign Manager 360 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 Campaign Manager 360 data.
-
Publish Bitly-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Bitly data.
-
Integrating Kiro with PhantomBuster 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.
-
Query Azure Analysis Services Data in DataGrip
Create a Data Source for Azure Analysis Services in DataGrip and use SQL to query live Azure Analysis Services data.
-
Connect to Amazon Marketplace Data in CloverDX (formerly CloverETL)
Transfer Amazon Marketplace data using the visual workflow in the CloverDX data integration tool.
-
How to Seamlessly Import SAP SuccessFactors LMS Data into IBM SPSS Modeler
Integrate SAP SuccessFactors LMS data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Query eBay Analytics Data in ColdFusion
Write standard ColdFusion data access code to connect to eBay Analytics data.
-
Integrate Dynamics NAV Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Dynamics NAV data from Informatica Cloud.
-
Connect to SQL Analysis Services Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to SQL Analysis Services.
-
How to connect to Aha! Data from IntelliJ
Integrate connectivity to Aha! data with wizards in IntelliJ.
-
How to Query QuickBooks Online Data in MySQL Workbench
Execute MySQL queries against live QuickBooks Online data from MySQL Workbench.
-
Automate Bitbucket Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Bitbucket data from PowerShell? This article demonstrates how to utilize the Bitbucket Cmdlets for tasks like connecting to Bitbucket data, automating operations, downloading data, and more.
-
Connect to Real-Time Harvest Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Harvest data in Power Apps.
-
Build Cosmos DB-Connected Apps in Choreo
Use CData Connect AI to connect to Cosmos DB Data from Choreo and build custom apps using live Cosmos DB data.
-
Create Paylocity Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Paylocity from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use Dash to Build to Web Apps on Adobe Target Data
Create Python applications that use pandas and Dash to build Adobe Target-connected web apps.
-
Use the CData Software ODBC Driver for Wrike in SAS for Real-Time Reporting and Analytics
Connect to real-time Wrike data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Wrike.
-
Access Live Google Analytics Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Analytics data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Use Agno to Talk to Your MySQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your MySQL data for you.
-
Create Informatica Mappings From/To a JDBC Data Source for Cassandra
Create Cassandra data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use ChatGPT to Talk to Your FHIR 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 FHIR data for you.
-
Feed Sage 200 Data into FineReport
How to set Sage 200 data as a JDBC data source in FineReport.
-
How to connect to Hacker News Data in DBVisualizer
Integrate Hacker News data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Okta Data from a Connection Pool in JBoss
Integrate Okta data into Java servlets: Use the Management Console in JBoss to install the Okta JDBC Driver.
-
Visualize Tally 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 Tally data into TIBCO Spotfire.
-
Create Basecamp-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Basecamp Data from OutSystems and build custom enterprise apps using live Basecamp data.
-
Query Printify Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Printify data from Node.js.
-
Create Apps from Shippo Data in Qlik Sense Cloud
Use CData Connect AI to connect to Shippo Data and build apps from live Shippo data in Qlik Sense Cloud.
-
Import Real-Time Hive Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Hive data in ColdFusion.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Humanity
Provide connectivity to Humanity data through an SAP BusinessObjects universe.
-
Connect to iContact from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from iContact data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData ADO.NET Provider for CampaignMonitor
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create Oracle Financials Cloud Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Oracle Financials Cloud data access from reports, embedded analytics, and more.
-
Getting Started with the CData SSIS Components for Drip
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Drip.
-
Integrating Boomi Agentstudio with Cvent Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Cvent data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Notion Replication to Oracle
Use CData Sync for automated, continuous, customizable Notion replication to Oracle.
-
Connecting GenSpark with Airtable Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Airtable data without any replication or custom integration required.
-
Migrating data from PhantomBuster to Snowflake using CData SSIS Components.
Easily push PhantomBuster data to Snowflake using the CData SSIS Tasks for PhantomBuster and Snowflake.
-
Connect to NetSuite Data in DBeaver
Use the CData ODBC Driver to connect to NetSuite data in DBeaver.
-
Link PolarTeamPro with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate PolarTeamPro data in Filemaker Pro for Mac or Windows.
-
Connect to Reckon in SpagoBI
Create reports featuring live Reckon data in SpagoBI Studio. Host Reckon reports on SpagoBI Server.
-
Prepare, Blend, and Analyze MarkLogic Data in Alteryx Designer (ODBC)
Build workflows to access live MarkLogic data for self-service data analytics.
-
Replicate CapsuleCRM Data from PowerShell
Write a quick PowerShell script to query CapsuleCRM data. Use connectivity to the live data to replicate CapsuleCRM data to SQL Server.
-
How to Connect Flowise AI Agents to Live Databricks Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Databricks data without replication.
-
Query, Visualize, and Share live SingleStore Data in Redash
Use CData Connect AI to connect to live SingleStore data in Redash for querying, visualizing, and sharing.
-
Integrate Workday Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Workday data and integrate live Workday data into your Power Automate tasks.
-
Access IBM Informix Data from MySQL in Amazon QuickSight
Connect to IBM Informix and build visualizations of IBM Informix data using a MySQL Connection in Amazon QuickSight.
-
How to work with Sage Cloud Accounting Data in Apache Spark using SQL
Access and process Sage Cloud Accounting Data in Apache Spark using the CData Software JDBC Driver.
-
Working with VWO Data in LINQPad
Execute LINQ queries to VWO data in LINQPad.
-
Create a Data Access Object for Discourse Data using JDBI
A brief overview of creating a SQL Object API for Discourse data in JDBI.
-
Using the CData Software ODBC Driver for Webex in PyCharm
Connect to Webex as an ODBC data source in PyCharm using the CData Software ODBC Driver for Webex.
-
Integrate Reply.io Data in Pentaho Data Integration
Build ETL pipelines based on Reply.io data in the Pentaho Data Integration tool.
-
Build an OLAP Cube in SSAS from Workday Data
Establish a connection to Workday data data from SQL Server Analysis Services, and use the Workday Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automate JobNimbus Data Replication to Couchbase
Use CData Sync to Customize and automate JobNimbus data replication to Couchbase.
-
Prepare, Blend, and Analyze Act CRM Data in Alteryx Designer (ODBC)
Build workflows to access live Act CRM data for self-service data analytics.
-
A PostgreSQL Interface for Amazon S3 Data (MySQL Remoting via JDBC)
Use the Remoting features of the Amazon S3 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Paymo Data in Looker
Use CData Connect AI to connect to Paymo Data from Looker and build custom apps using live Paymo data.
-
Build Exact Online-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Exact Online Data and create custom apps in Mendix.
-
Integrate Cline with Live NetSuite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live NetSuite data from within your IDE.
-
How to connect to Azure Synapse Data from Spring Boot
Connect to Azure Synapse in a Spring Boot Application using the CData JDBC Driver for Azure Synapse
-
Design BIRT Reports on Box Data
Provide current Box data to your embedded analytics.
-
Basecamp Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Basecamp facts in real time.
-
Getting Started with the CData Connect AI Python SDK for Dynamics CRM
Install the CData Connect AI Python SDK to read and write live Dynamics CRM data with standard DB-API 2.0 Python code.
-
Integrating Kiro with OpenWeatherMap 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.
-
Access Live TaxJar 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 TaxJar data through MCP integration.
-
Rapidly Develop Email-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 Email.
-
Automate LinkedIn Ads Data Replication to SAP HANA
Use CData Sync to customize and automate LinkedIn Ads data replication to SAP HANA.
-
How to Connect to Live Google Spanner 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 Google Spanner data without replication.
-
Automated Continuous Zoho Recruit Replication to Snowflake
Use CData Sync for automated, continuous, customizable Zoho Recruit replication to Snowflake.