CData Software - Knowledge Base
Recent Articles
-
Access Live CouchDB Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apache CouchDB from your Google Sheets.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ZeroBounce
Provide connectivity to ZeroBounce through an SAP BusinessObjects universe.
-
Build Pipelines with Live Google Search Results in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Search from Google Cloud Data Fusion, enabling the integration of live Google Search into the building and management of effective data pipelines.
-
How to import Amazon DynamoDB Data into Apache Solr
Use the CData Software JDBC Driver for Amazon DynamoDB in Data Import Handler and create an automated import of Amazon DynamoDB to Apache Solr Enterprise Search platform.
-
Automated Continuous XML Replication to MongoDB
Use CData Sync for automated, continuous, customizable XML replication to MongoDB.
-
Integrating Teradata Data in Talend Cloud Data Management Platform
Connect Teradata Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Teradata.
-
Getting Started with the CData JDBC Driver for Strava
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Strava.
-
Use JayDeBeApi to access Zoho CRM Data in Python
Use standard Python scripting and the development environment of your choice to access live Zoho CRM.
-
Build Apps with Live Perigon Data Using the Low-Code Development Platform of Mendix
Connect Perigon with Mendix to build apps using the CData API Driver for JDBC.
-
Integrate Cline with Live FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live FTP Servers from within your IDE.
-
Using the CData Software ODBC Driver for Pinecone in PyCharm
Connect to Pinecone as an ODBC data source in PyCharm using the CData Software ODBC Driver for Pinecone.
-
Write a Simple Go Application to work with Recurly Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Recurly.
-
Connect to Real-Time Mailjet Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Mailjet in Power Apps.
-
Create Data Visualizations Based On Sage 200 Data in Mode
Use CData Connect AI to connect to Sage 200 Data from Mode and build visualizations using live
-
View Reports on Real-Time ZohoDesk Data in Power BI Report Server
Use the CData ODBC Driver for ZohoDesk to visualize ZohoDesk in Power BI Desktop and then publish them to Power BI Report Server.
-
Automate Oracle Eloqua Reporting Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Oracle Eloqua Reporting and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Access SAS Data Sets Data from MySQL in Amazon QuickSight
Connect to SAS Data Sets and build visualizations of SAS Data Sets using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Clio Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Clio replication to AlloyDB.
-
Create Apps from Oracle Sales Data in Qlik Sense Cloud
Use CData Connect AI to connect to Oracle Sales Data and build apps from live Oracle Sales in Qlik Sense Cloud.
-
Object-Relational Mapping (ORM) with Clio Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Clio into a Java-based ORM framework, Hibernate.
-
Aircall Reporting in OBIEE with the Aircall JDBC Driver
Deploy the Aircall JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Manage Rebilly Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Rebilly.
-
Connect to Real-Time Freshdesk Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Freshdesk and Dataflow to import and use Freshdesk in Power Apps.
-
Create PabblySubscriptions Dataflows on PowerBI.com
Connect to the CData Power BI Connector for PabblySubscriptions from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build MVC Applications with Connectivity to Excel Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Excel from an ASP.NET MVC application.
-
How to Query XML Data in MySQL Workbench
Execute MySQL queries against live XML Files from MySQL Workbench.
-
How to create an RPA flow for Tally Data in UiPath Studio
Use the Tally ODBC Driver to create workflows that access real-time Tally ERP without any coding.
-
Connect to Real-Time Unbounce Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Unbounce in Power Apps.
-
Connect to Webex Data in Jaspersoft Studio
Execute SQL to remote Webex in Jaspersoft Studio.
-
Integrate Cursor with Live PostgreSQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live PostgreSQL from within the editor.
-
CData Virtuality 4.8 Release Notes: Resource Governor, Timezone Support for Jobs, New connectors, and More
Read the release notes for CData Virtuality 4.8, including the new Resource Governor, timezone support for jobs, new connectors, and a lot more.
-
Create Dynamic Cohere Grids Using the Infragistics XamDataGrid
Learn how you can connect Cohere to Infragistics XamDataGrid to build dynamic grids.
-
Create Informatica Mappings From/To a JDBC Data Source for Spark
Create Spark data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Seamlessly Import Airtable Data into IBM SPSS Modeler
Integrate Airtable data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
View Reports on Real-Time Wistia Data in Power BI Report Server
Use the CData ODBC Driver for Wistia to visualize Wistia in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to LightSpeedRetail from Asprova with CData Software ODBC Driver for LightSpeedRetail
This article shows how to connect faster to LightSpeedRetail data from Asprova.
-
Create a Data Access Object for Dynamics 365 Business Central Data using JDBI
A brief overview of creating a SQL Object API for Dynamics 365 Business Central in JDBI.
-
Automate Google Sheets Data Replication to Azure Synapse
Use CData Sync to customize and automate Google Sheets replication to Azure Synapse.
-
Use Claude to Talk to Your MariaDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your MariaDB for you.
-
Connect to Exa Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Exa and work with Exa in your FileMaker applications.
-
Use the CData Software ODBC Driver for Azure Data Catalog in MicroStrategy Desktop
Connect to Azure Data Catalog in MicroStrategy Desktop using the CData Software ODBC Driver for Azure Data Catalog.
-
Connect to SurveyMonkey Data from AWS Glue
Use CData Connect AI to gain access to live SurveyMonkey from your AWS Glue jobs.
-
Add PolarTeamPro Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for PolarTeamPro with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating OpenCode Terminal with SQL Server 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.
-
Feed LaunchDarkly Data into FineReport
How to set LaunchDarkly as a JDBC data source in FineReport.
-
Use the CData ODBC Driver for Azure Analysis Services from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Azure Analysis Services to connect to Azure Analysis Services from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Azure Analysis Services in Excel.
-
How to integrate Metabase with Shopify Data
Use CData Connect AI to connect to live Shopify and create an interactive dashboard in Metabase from Shopify.
-
Analyze Presto Data in Looker
Use CData Connect AI to connect to Presto Data from Looker and build custom apps using live Presto.
-
How to Work with Unbounce Data in AWS Glue Jobs Using JDBC
Connect to Unbounce from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Import Procore Data Using Azure Data Factory
Use CData Connect AI to connect to Procore Data from Azure Data Factory and import live Procore.
-
Connect to Real-Time Mixpanel Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Mixpanel in Power Apps.
-
Create Float Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Float from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating Gumloop with SAP Netweaver Gateway Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP Netweaver Gateway within automated workflows.
-
Access Live Anaplan Data in Coginiti Pro
Connect to and query live Anaplan from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect the Power BI Service to GitLab: Complete Guide
Connect to the CData Software Power BI Connector for GitLab from PowerBI.com to provide real-time GitLab across the organization.
-
How to Access Google Ads Data Using Entity Framework
This article shows how to access Google Ads using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Stream Accelo Data into Apache Kafka Topics
Access and stream Accelo in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Charts with Microsoft Entra ID Data in Clear Analytics
Create dynamic charts and perform analytics based on Microsoft Entra ID in Clear Analytics.
-
DataBind Charts to SAP BusinessObjects BI Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP BusinessObjects BI from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Analyze SAS Data Sets Data in Cognos Analytics
Use CData Connect AI to connect to SAS Data Sets Data from Cognos Analytics and analyze live SAS Data Sets.
-
Use Dash to Build to Web Apps on Azure DevOps Data
Create Python applications that use pandas and Dash to build Azure DevOps-connected web apps.
-
Import Real-Time Supabase Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Supabase in ColdFusion.
-
Operational Reporting on Attio Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Attio.
-
Stream Miro Data into Apache Kafka Topics
Access and stream Miro in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Import and Visualize XML Data in Power View
Create data visualizations based on XML Files in Excel.
-
Access Live Freshdesk Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Freshdesk from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate Asana with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Asana with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Asana.
-
Connect to PDFMonkey Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to PDFMonkey and work with PDFMonkey in your FileMaker applications.
-
A PostgreSQL Interface for PhantomBuster Data using the CData ODBC Driver
Use the SQL Gateway and PhantomBuster ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData SSIS Components to Insert New or Update Existing QuickBooks Records from SQL Server
Easily push SQL Server data to QuickBooks using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into QuickBooks or update existing records with data from a SQL Server database.
-
DataBind Controls to Gumroad Data in Delphi
DataBind to Gumroad in Delphi with standard data access components and controls.
-
Import Real-Time EmailOctopus Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use EmailOctopus in ColdFusion.
-
Migrating data from Paymo to Google BigQuery using CData SSIS Components.
Easily push Paymo to Google BigQuery using the CData SSIS Tasks for Paymo and Google BigQuery.
-
Analyze SAP BusinessObjects BI Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of SAP BusinessObjects BI and visualize live SAP BusinessObjects BI in Infragistics Reveal.
-
Seamlessly Bring Pipedrive Data into Retool Using CData Connect AI
Integrate Pipedrive data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Use Claude to Talk to Your Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Veeva Vault & Vault CRM for you.
-
DataBind Controls to HubSpot Data in C++Builder
DataBind to HubSpot in C++Builder with standard components and controls.
-
Automated Continuous Google Tasks Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Google Tasks replication to Apache Cassandra.
-
Import and Visualize AfterShip Data in Power View
Create data visualizations based on AfterShip in Excel.
-
Automate ZarMoney Data Replication to SAP HANA
Use CData Sync to customize and automate ZarMoney replication to SAP HANA.
-
Query Webex Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Webex from Node.js.
-
How to Easily Query Tickspot Data in OpenOffice Base
Connect to Tickspot data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Design Cvent Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Cvent from mobile and tablet Power Apps.
-
Integrate with Redshift Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Amazon Redshift to a JSON file on disk.
-
How to Access Live SharePoint Excel Services Data in Visual Studio Code via Cline
Run CData MCP Server for SharePoint Excel Services on Windows Subsytem for Linux (WSL) and connect to live SharePoint Excel Services from the Cline extension in Visual Studio Code.
-
Replicate Multiple Google Cloud Storage Accounts via the CData Sync CLI
Replicate multiple Google Cloud Storage accounts to one or many databases.
-
Import CockroachDB Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access CockroachDB. In this article, you will use the OData format to import CockroachDB into Microsoft Power Query.
-
Create Data Visualizations Based On Google Analytics Data in Mode
Use CData Connect AI to connect to Google Analytics Data from Mode and build visualizations using live
-
Automated Continuous MailChimp Replication to Amazon S3
Use CData Sync for automated, continuous, customizable MailChimp replication to Amazon S3.
-
Automated Continuous AgileCRM Replication to Oracle
Use CData Sync for automated, continuous, customizable AgileCRM replication to Oracle.
-
Automated Continuous MarkLogic Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable MarkLogic replication to Apache Kafka.
-
Use the CData ODBC Driver for Adobe Commerce from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Adobe Commerce to connect to Adobe Commerce from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Adobe Commerce in Excel.
-
DataBind Controls to Epicor Kinetic Data in Delphi
DataBind to Epicor Kinetic in Delphi with standard data access components and controls.
-
How to Connect to Live BigQuery Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google BigQuery securely in real time.
-
Connect to Short.io Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Short.io and the SQL Gateway to access Short.io from Google Apps Script.
-
Use the CData Software ODBC Driver for Cvent in SAS for Real-Time Reporting and Analytics
Connect to real-time Cvent in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Cvent.
-
Visualize Live Oracle Sales Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Oracle Sales using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build an OLAP Cube in SSAS from PostgreSQL Data
Establish a connection to PostgreSQL data from SQL Server Analysis Services, and use the PostgreSQL Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Typeform Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Typeform.
-
Getting Started with the CData Python Connector for Perigon
Learn to install and license the CData Python Connector