CData Software - Knowledge Base
Recent Articles
-
Connect to ADP Data in DBArtisan
Use wizards in DBArtisan to configure ADP data as a data source.
-
Build Dashboards with Demio Data in Dundas BI
Create dynamic dashboards and perform analytics based on Demio data in Dundas BI.
-
Visualize Wistia Data in Tableau
The CData ODBC driver for Wistia enables you integrate Wistia data into Tableau dashboards.
-
Automated Continuous ClickTime Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ClickTime replication to Apache Kafka.
-
Access Live Brex Data in AWS Lambda
Connect to live Brex data in AWS Lambda using the CData JDBC Driver.
-
Build Apps with Live SAP Ariba Procurement Data Using the Low-Code Development Platform of Mendix
Connect SAP Ariba Procurement data with Mendix to build apps using the CData JDBC Driver for SAP Ariba Procurement.
-
Integrate Google Analytics Data in the Pentaho Report Designer
Publish reports based on Google Analytics data in the Pentaho BI tool.
-
Automated Continuous JSON Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable JSON replication to Apache Cassandra.
-
Access Live Teamwork Data in Coginiti Pro
Connect to and query live Teamwork data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to load Mailgun data into Elasticsearch via Logstash
Introducing a simple method to load Mailgun data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating Cursor with SAP SuccessFactors LMS 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 SurveyMonkey Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SurveyMonkey data from your Google Sheets.
-
Replicate Multiple LDAP Accounts via the CData Sync CLI
Replicate multiple LDAP accounts to one or many databases.
-
Excel Spreadsheet Automation on Google Directory Data with the QUERY Formula
Pull data from Google Directory, automate spreadsheets, and more with the QUERY formula.
-
Feed Impala Data into FineReport
How to set Impala data as a JDBC data source in FineReport.
-
Connect to PDFMonkey Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for PDFMonkey data.
-
Visualize Live Beeminder Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Beeminder data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Live SAP Concur Data in the Power BI Service
Use CData Connect AI to connect to live SAP Concur data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Tally Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Tally data with the CData JDBC Driver for Tally.
-
LINQ to Rootly 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 Rootly Data Provider.
-
Getting Started with the CData Connect AI Python SDK for ShipEngine
Install the CData Connect AI Python SDK to read live ShipEngine data with standard DB-API 2.0 Python code.
-
Integrate OpenCode with Live Salesforce Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Salesforce data from within your AI coding agent.
-
Connect and Visualize Live Twilio Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Twilio data into the Databricks platform and create visualization dashboards with real-time Twilio data.
-
Trigger Google Sheets IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Google Sheets with standard wizards in Logic Apps.
-
Automate Elasticsearch Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Elasticsearch data from PowerShell? This article demonstrates how to utilize the Elasticsearch Cmdlets for tasks like connecting to Elasticsearch data, automating operations, downloading data, and more.
-
Query AfterShip Data as a MySQL Database in Node.js
Execute MySQL queries against AfterShip data from Node.js.
-
Use Dash to Build Web Apps on Guru Data via CData Connect AI
Build interactive Dash web apps on live Guru data using pandas and the CData Connect AI Python SDK.
-
Access Teradata Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Teradata data from HeidiSQL.
-
Use Grok to Talk to Your ConstantContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your ConstantContact data for you.
-
Automated Continuous Sage 200 Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Sage 200 replication to Google BigQuery.
-
Connect to Retently from Asprova with CData Software ODBC Driver for Retently
This article shows how to connect faster to Retently data from Asprova.
-
Creating Supabase-Connected Applications in Unqork
You can use CData Connect AI to feed Supabase data to Unqork and build custom business apps.
-
Connect to Supabase from a Connection Pool in WebLogic
Use the CData JDBC Driver for Supabase to connect to Supabase data from Web applications running on WebLogic.
-
Analyze Microsoft Exchange Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft Exchange data with the CData JDBC Driver for Microsoft Exchange.
-
Natively Connect to Miro Data in PHP
The CData ODBC driver for Miro enables you to create PHP applications with connectivity to Miro data. Leverage the native support for ODBC in PHP.
-
Back Up ShipStation data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for ShipStation. In this article, we will employ an SSIS workflow to populate a database with ShipStation data data.
-
Access ShipStation Data from MySQL in Amazon QuickSight
Connect to ShipStation and build visualizations of ShipStation data using a MySQL Connection in Amazon QuickSight.
-
Build Pipelines with Live BigQuery Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to BigQuery from Google Cloud Data Fusion, enabling the integration of live BigQuery data into the building and management of effective data pipelines.
-
Close Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Close facts in real time.
-
Getting Started with the CData Tableau Connector for Instagram
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Instagram.
-
Analyze QuickBooks Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of QuickBooks data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Cursor with Live Airtable Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Airtable data from within the editor.
-
Manage Moosend Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Moosend.
-
Use the CData Software JDBC Driver for Billsby in MicroStrategy Web
Connect to Billsby data in MicroStrategy Web using the CData Software JDBC Driver for Billsby.
-
Load FreshBooks Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load FreshBooks data to a database.
-
Integrating Cursor with Facebook 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.
-
Integrating Kiro with Oracle 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.
-
Integrating Antigravity CLI with Google Ad Manager data via CData CLI
Connect Google Ad Manager data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Analyze Spotify Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Spotify from Power Pivot. You will use the Table Import Wizard to load Spotify data. You can visually build the import query or use any SQL supported by the driver.
-
Create PostgreSQL-Connected Business Apps in AppSheet
Connect to PostgreSQL Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to PostgreSQL data.
-
How to Easily Query ZarMoney Data in OpenOffice Base
Connect to ZarMoney data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Amazon Athena Data in RapidMiner
Integrate Amazon Athena data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Freshdesk Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Freshdesk replication to Apache Kafka.
-
How to import OnePageCrm Data into Apache Solr
Use the CData Software JDBC Driver for OnePageCrm in Data Import Handler and create an automated import of OnePageCrm data to Apache Solr Enterprise Search platform.
-
How to Seamlessly Import Dynamics CRM Data into IBM SPSS Modeler
Integrate Dynamics CRM data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize Smartsheet Data in TIBCO Spotfire through OData
Integrate Smartsheet data into dashboards in TIBCO Spotfire.
-
Automate Kafka Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Kafka data from PowerShell? This article demonstrates how to utilize the Kafka Cmdlets for tasks like connecting to Kafka data, automating operations, downloading data, and more.
-
Connect to FTP Data in NetBeans
Connect to FTP data in NetBeans with the data source configuration wizard.
-
How to use SQLAlchemy ORM to access Procore Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Procore data.
-
Connect to Dynamics NAV Data in RazorSQL
Connect to Dynamics NAV from wizards and query Dynamics NAV data from the GUI in the RazorSQL database management tool.
-
Automated Continuous Salesloft Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Salesloft replication to Google Cloud SQL.
-
How to Visualize Apollo Data in Python with pandas
Use pandas and other modules to analyze and visualize live Apollo data in Python.
-
Build ConstantContact-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for ConstantContact Data and create custom apps in Mendix.
-
Build Automated Workflows with Live Airtable Data in Workato
Use CData Connect AI to connect to live Airtable data and build automated workflows in Workato.
-
Integrate xBase Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to xBase data and integrate live xBase data into your Power Automate tasks.
-
Automate Sage Cloud Accounting Data Replication to Azure Synapse
Use CData Sync to customize and automate Sage Cloud Accounting data replication to Azure Synapse.
-
Automated Continuous Factorial Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Factorial replication to Apache Kafka.
-
Automated Continuous Invoiced Replication to MongoDB
Use CData Sync for automated, continuous, customizable Invoiced replication to MongoDB.
-
Create Informatica Mappings From/To a JDBC Data Source for Salesforce Pardot
Create Salesforce Pardot data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Rapidly Develop Cloudflare-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 Cloudflare.
-
Build an OLAP Cube in SSAS from Google Contacts Data
Establish a connection to Google Contacts data data from SQL Server Analysis Services, and use the Google Contacts Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Zoom Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Zoom to connect to Zoom data and execute queries in PowerBuilder.
-
Use JayDeBeApi to access Factorial Data in Python
Use standard Python scripting and the development environment of your choice to access live Factorial data.
-
Integrate SAP HANA with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP HANA with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP HANA data.
-
Integrate Real-Time Access to Excel in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Excel data in real time.
-
Integrate CSV Data in the Pentaho Report Designer
Publish reports based on CSV data in the Pentaho BI tool.
-
Add Guru Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Guru with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData Software JDBC Driver for Rootly in MicroStrategy Desktop
Connect to Rootly data in MicroStrategy Desktop using the CData Software JDBC Driver for Rootly.
-
Build Semantic Layer Views for Moosend Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Moosend data.
-
Connect Google Translate Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google Translate data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build a Singer.io Tap for LeadDesk With the CData Python Connector
Learn how to easily build a Singer.io Tap for live LeadDesk data using the CData Python Connector.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Apollo
Provide connectivity to Apollo data through an SAP BusinessObjects universe.
-
How to Connect to Live Oracle Sales Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Oracle Sales data securely in real time.
-
Access Live Jira Assets Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Jira Assets data into the statistical analysis tools available in SAS JMP. This article shows how to use Jira Assets data in the Graph Builder and Query Builder.
-
Use Grok to Talk to Your AlloyDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your AlloyDB data for you.
-
Integrate with Live SAP ByDesign Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAP ByDesign from the MuleSoft Anypoint Platform to integrate live SAP ByDesign data into custom reports and dashboards.
-
Automate Teamgate Data Replication to SAP HANA
Use CData Sync to customize and automate Teamgate data replication to SAP HANA.
-
Access Timely Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Timely data from HeidiSQL.
-
Build Semantic Layer Views for Bannerbear Data in APOS Live Data Gateway
Use the CData Connector for Bannerbear in APOS Live Data Gateway to build Semantic Layer Views for Bannerbear data.
-
Query, Visualize, and Share live Google Drive Data in Redash
Use CData Connect AI to connect to live Google Drive data in Redash for querying, visualizing, and sharing.
-
Establish a Live Connection with Printful Data using Tableau Bridge
The CData ODBC Driver for Printful enables you to integrate live Printful data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to HCL Domino Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live HCL Domino data from Filemaker Pro on Mac.
-
Connecting Pipedream with Dynamics 365 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 Dynamics 365 data in real time.
-
Build AI/ML Models with Live Qualaroo Data using Dataiku
Connect Qualaroo Data with Dataiku using the CData API Driver for JDBC.
-
How to Visualize Egnyte 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 Egnyte data in Python.
-
Use Agno to Talk to Your Snapchat Ads 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 Snapchat Ads data for you.
-
Integrate Google's Antigravity Agent with Live Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Databricks data using the Model Context Protocol.
-
How to Access EnterpriseDB Data Using Entity Framework
This article shows how to access EnterpriseDB data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Import Real-Time SFTP Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SFTP data in ColdFusion.
-
Connect to Campaigner in SpagoBI
Create reports featuring live Campaigner data in SpagoBI Studio. Host Campaigner reports on SpagoBI Server.