CData Software - Knowledge Base
Recent Articles
-
How to Access Live Sage 300 Data in Visual Studio Code via Cline
Run CData MCP Server for Sage 300 on Windows Subsytem for Linux (WSL) and connect to live Sage 300 from the Cline extension in Visual Studio Code.
-
Access Live Dropbox Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Dropbox through MCP integration.
-
Use the CData Software JDBC Driver for Webflow in MicroStrategy
Connect to Webflow in MicroStrategy Developer using the CData Software JDBC Driver for Webflow.
-
Back Up Freshsales to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Freshsales data.
-
Create Jodoo Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Jodoo from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Reports with Jumpseller Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Jumpseller.
-
Object-Relational Mapping (ORM) with Kafka 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 Apache Kafka into a Java-based ORM framework, Hibernate.
-
Connect to CampaignMonitor Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for CampaignMonitor to connect to CampaignMonitor and execute queries in PowerBuilder.
-
Using the CData Software ODBC Driver for BigCommerce in PyCharm
Connect to BigCommerce as an ODBC data source in PyCharm using the CData Software ODBC Driver for BigCommerce.
-
Connect to Aha! from a Connection Pool in WebLogic
Use the CData JDBC Driver for Aha! to connect to Aha! from Web applications running on WebLogic.
-
Query Couchbase Data in DataGrip
Create a Data Source for Couchbase in DataGrip and use SQL to query live Couchbase.
-
Natively Connect to Raisers Edge NXT Data in PHP
The CData ODBC driver for Raisers Edge NXT enables you to create PHP applications with connectivity to Raisers Edge NXT. Leverage the native support for ODBC in PHP.
-
Build CSV Visualizations in Tableau Desktop
Use CData Connect AI to connect to live CSV/TSV Files and build visualizations in Tableau.
-
Connect to LinkedIn Ads Data in Ruby
Connect to LinkedIn Ads in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Apps with Live AfterShip Data Using the Low-Code Development Platform of Mendix
Connect AfterShip with Mendix to build apps using the CData API Driver for JDBC.
-
Build Dashboards with TaxJar Data in Dundas BI
Create dynamic dashboards and perform analytics based on TaxJar in Dundas BI.
-
Use Grok to Talk to Your Oracle 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 Oracle Database for you.
-
Build AI/ML Models with Live ZendeskSell Data using Dataiku
Connect ZendeskSell Data with Dataiku using the CData API Driver for JDBC.
-
Query Teradata Data in DataGrip
Create a Data Source for Teradata in DataGrip and use SQL to query live Teradata.
-
Automated Continuous Timely Replication to SQLite
Use CData Sync for automated, continuous, customizable Timely replication to SQLite.
-
Getting Started with the CData SSIS Components for Helpscout
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Helpscout.
-
Using the CData Software ODBC Driver for Amazon S3 in PyCharm
Connect to Amazon S3 as an ODBC data source in PyCharm using the CData Software ODBC Driver for Amazon S3.
-
Replicate Multiple GitHub Accounts via the CData Sync CLI
Replicate multiple GitHub accounts to one or many databases.
-
Extend Google Sheets with YouTube Analytics Data
Make calls to YouTube Analytics from Google Apps Script via the API Server.
-
Access Live Google Drive Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Drive in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Wrike Data Replication to Teradata
Use CData Sync to Customize and automate Wrike replication to Teradata.
-
Getting Started with the CData SSIS Components for Nuclia
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Nuclia.
-
Automated Continuous SendGrid Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SendGrid replication to Google BigQuery.
-
Seamlessly Bring Zoho CRM Data into Retool Using CData Connect AI
Integrate Zoho CRM data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Access Live Teradata Data in Coginiti Pro
Connect to and query live Teradata from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live Google Drive Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Google Drive from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Use the CData ODBC Driver for Adobe Experience Manager in Microsoft Power Query
You can use the CData Adobe Experience Manager ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Adobe Experience Manager into Microsoft Power Query.
-
Build Visualizations of Gumroad Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Gumroad in Birst.
-
Use the CData Software JDBC Driver for PolarTeamPro in MicroStrategy Web
Connect to PolarTeamPro in MicroStrategy Web using the CData Software JDBC Driver for PolarTeamPro.
-
Access Authorize.Net Data from MySQL in PHP
Connect to Authorize.Net through the standard MySQL libraries in PHP.
-
Automated Continuous Google Tasks Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Tasks replication to delimited files (CSV/TSV).
-
Connect to Sybase IQ Data in Aqua Data Studio
Access Sybase IQ from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Zoho Creator Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Zoho Creator Data and connect to Zoho Creator in Akorbi Digital RunMyProcess.
-
Query Asana Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Asana entities in PHP by modeling them as objects.
-
How to Work with Zuora Data in AWS Glue Jobs Using JDBC
Connect to Zuora from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Cvent Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Cvent through CData Connect AI using different applications and tools.
-
Query JSON Services in DataGrip
Create a Data Source for JSON in DataGrip and use SQL to query live JSON.
-
Create Recurly Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Recurly data access from reports, embedded analytics, and more.
-
Access Live ZohoDesk Data in AWS Lambda
Connect to live ZohoDesk in AWS Lambda using the CData JDBC Driver.
-
Analyze Cassandra Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Apache Cassandra and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous Epicor Kinetic Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to AlloyDB.
-
How to connect PolyBase to QuickBooks Time
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live QuickBooks Time.
-
Access Live Contentful Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Contentful in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Jumpseller Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Jumpseller facts in real time.
-
How to Connect to Live Smartsheet 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 Smartsheet for you.
-
Build an OLAP Cube in SSAS from Couchbase Data
Establish a connection to Couchbase data from SQL Server Analysis Services, and use the Couchbase Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to HDFS from Asprova with CData Software ODBC Driver for HDFS
This article shows how to connect faster to HDFS data from Asprova.
-
Integrate Foursquare with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Foursquare with External Services.
-
Create QuickBooks Time-Connected Business Apps in AppSheet
Connect to QuickBooks Time Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to QuickBooks Time.
-
Import Real-Time Shippo Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Shippo in ColdFusion.
-
How to create Discourse federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Discourse in MySQL .
-
Use the CData ODBC Driver for Brex in Microsoft Power Query
You can use the CData Brex ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Brex into Microsoft Power Query.
-
How to Visualize Act CRM 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 Act CRM in Python.
-
Replicate Multiple MySQL Accounts via the CData Sync CLI
Replicate multiple MySQL accounts to one or many databases.
-
Integrate with Phoenix Data in JReport Designer
Create charts and reports based on Apache Phoenix in JReport Designer.
-
Use the CData ODBC Driver for Google Ads in Microsoft Power Query
You can use the CData Google Ads ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Ads into Microsoft Power Query.
-
Automated Continuous FreeAgent Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable FreeAgent replication to Apache Cassandra.
-
Build an OLAP Cube in SSAS from ZohoDesk Data
Establish a connection to ZohoDesk data from SQL Server Analysis Services, and use the ZohoDesk Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ClickTime
Provide connectivity to ClickTime through an SAP BusinessObjects universe.
-
Getting Started with the CData Tableau Connector for Pipeliner CRM
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect Excel to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Microsoft Excel using the CData Python MCP Server.
-
Build Data Flows from SQL Server to Bitbucket through SSIS
Easily push SQL Server data to Bitbucket using the CData SSIS Tasks for Bitbucket.
-
Connect to MYOB AccountRight Data in Google Apps Script via Connect AI
Use CData Connect AI to access MYOB AccountRight in Google Apps Script.
-
ETL Blackbaud FE NXT in Oracle Data Integrator
This article shows how to transfer Blackbaud FE NXT into a data warehouse using Oracle Data Integrator.
-
Connect to Telegram Data in Ruby
Connect to Telegram in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Publish Reports with Basecamp Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Basecamp.
-
Create Reports from ShipStation Data in Looker Studio
Use CData Connect AI to gain access to live ShipStation and create custom reports in Looker Studio.
-
Access Sybase IQ Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sybase IQ from your Oracle system.
-
Rapidly Develop Microsoft Entra ID-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 Microsoft Entra ID.
-
Connect to HelloSign Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for HelloSign to connect to HelloSign and execute queries in PowerBuilder.
-
Access Live Neo4J Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Neo4J through MCP integration.
-
Connect Google Calendar to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Google Calendar with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Real-Time Access to Oracle in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Oracle Database in real time.
-
Design BIRT Reports on LinkedIn Ads Data
Provide current LinkedIn Ads to your embedded analytics.
-
Connect to Sybase IQ Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Sybase IQ in Airbyte.
-
Natively Connect to Timely Data in PHP
The CData ODBC driver for Timely enables you to create PHP applications with connectivity to Timely. Leverage the native support for ODBC in PHP.
-
Integrate Planio with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Planio with External Services.
-
Connect to Real-Time MongoDB Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for MongoDB and Dataflow to import and use MongoDB in Power Apps.
-
Connect to Real-Time HCL Domino Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for HCL Domino and Dataflow to import and use HCL Domino in Power Apps.
-
Connect to and Query SendPulse Data in QlikView over ODBC
Create data visualizations with SendPulse in QlikView.
-
Create a Data Access Object for Mistral AI Data using JDBI
A brief overview of creating a SQL Object API for Mistral AI in JDBI.
-
Connect to Real-Time Helpscout Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Helpscout in Power Apps.
-
Build Visualizations of Cosmos DB Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Azure Cosmos DB in Birst.
-
How to Connect to & Open GitLab Data in Microsoft Excel
This article uses the CData ODBC driver for GitLab to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
View Reports on Real-Time Freshteam Data in Power BI Report Server
Use the CData ODBC Driver for Freshteam to visualize Freshteam in Power BI Desktop and then publish them to Power BI Report Server.
-
Automate Nethunt Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Nethunt from PowerShell? This article demonstrates how to utilize the Nethunt Cmdlets for tasks like connecting to Nethunt, automating operations, downloading data, and more.
-
Connect to YouTube Analytics Data in Google Apps Script via Connect AI
Use CData Connect AI to access YouTube Analytics in Google Apps Script.
-
Build Automated Workflows with Live Splunk Data in Workato
Use CData Connect AI to connect to live Splunk and build automated workflows in Workato.
-
How to Work with Anaplan Data in ETL Validator JDBC
Connect to Anaplan from ETL Validator jobs using the CData Software JDBC Driver.
-
Replicate Sendwithus Data to Multiple Databases
Replicate Sendwithus to disparate databases with a point-and-click configuration.
-
Automated Continuous Google Campaign Manager 360 Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Google Cloud SQL.
-
Getting Started with the CData ADO.NET Provider for Demio
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous Snapchat Ads Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Google Cloud SQL.
-
Publish Crystal Reports on Marketo Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Marketo.
-
Rapidly Develop SAP Concur-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 SAP Concur.