CData Software - Knowledge Base
Recent Articles
-
Connect to Delighted Data from a Connection Pool in JBoss
Integrate Delighted into Java servlets: Use the Management Console in JBoss to install the Delighted JDBC Driver.
-
Connect to Paylocity Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Paylocity.
-
Build an OLAP Cube in SSAS from Access Data
Establish a connection to Microsoft Access data from SQL Server Analysis Services, and use the Access Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect Amazon Athena to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Amazon Athena using the CData Python MCP Server.
-
Automated Continuous Raisers Edge NXT Replication to Databricks
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Databricks.
-
Integrating OpenCode Terminal with Google Tasks 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 Kintone in MicroStrategy Desktop
Connect to Kintone in MicroStrategy Desktop using the CData Software ODBC Driver for Kintone.
-
Query SAP Ariba Source Data in ColdFusion
Write standard ColdFusion data access code to connect to SAP Ariba Source.
-
How to connect to Mailgun Data from Spring Boot
Connect to Mailgun in a Spring Boot Application using the CData API Driver for JDBC
-
Getting Started with the CData JDBC Driver for LeadDesk
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for LeadDesk.
-
Integrating Mixpanel Data in Talend Cloud Data Management Platform
Connect Mixpanel Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to Scrapfly Data in Jaspersoft Studio
Execute SQL to remote Scrapfly in Jaspersoft Studio.
-
Connect to TaxJar Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for TaxJar and the SQL Gateway to access TaxJar from Google Apps Script.
-
Create PostgreSQL Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time PostgreSQL data access from reports, embedded analytics, and more.
-
Visualize Live Recurly Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Recurly using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Import Data from QuickBooks into Google Sheets
Import QuickBooks Desktop into a Google spreadsheet that is automatically refreshed.
-
Create Dynamic Figshare Grids Using the Infragistics XamDataGrid
Learn how you can connect Figshare to Infragistics XamDataGrid to build dynamic grids.
-
Build Dashboards with MySQL Data in Dundas BI
Create dynamic dashboards and perform analytics based on MySQL in Dundas BI.
-
Automated Continuous SurveyMonkey Replication to SQLite
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to SQLite.
-
Enable the Cassandra JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Apache Cassandra.
-
Manage Greenplum Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Greenplum.
-
Connect to Azure Data Lake Storage Data in Google Apps Script via Connect AI
Use CData Connect AI to access Azure Data Lake Storage in Google Apps Script.
-
Query YouTube Analytics Data as a MySQL Database in Node.js
Execute MySQL queries against YouTube Analytics from Node.js.
-
Process & Analyze Flowlu Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Flowlu Data.
-
Getting Started with the CData Tableau Connector for Cosmos DB
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Cosmos DB.
-
Connect to Cassandra Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Cassandra as an External Source in Dremio.
-
Provide OData Services of Parallel Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Parallel by developing a WCF Service Application.
-
DocuSign Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on DocuSign facts in real time.
-
Create Google Ad Manager-Connected Applications in Appsmith
Connect to Google Ad Manager Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Ad Manager.
-
Connect to IBM Cloud Object Storage Data from PowerBuilder via ADO.NET
This article demonstrates how to access IBM Cloud Object Storage from Appeon PowerBuilder using the CData ADO.NET Provider for IBM Cloud Object Storage.
-
Connect to SAS xpt Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAS xpt in FileMaker Pro to connect to SAS xpt and work with SAS XPORT in your FileMaker applications.
-
Use the CData Software ODBC Driver for Azure Data Lake Storage in MicroStrategy
Connect to Azure Data Lake Storage in MicroStrategy Developer using the CData Software ODBC Driver for Azure Data Lake Storage.
-
Build CockroachDB-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for CockroachDB to explore live CockroachDB Data in Cursor to assist with building CockroachDB-powered applications.
-
Create Snapchat Ads-Connected Nintex Workflows
Use CData Connect AI to connect to Snapchat Ads Data from Nintex Workflow Cloud and build custom workflows using live Snapchat Ads.
-
Query HCL Domino Data from Node.js
Use the OData endpoint of the CData API Server to connect to your HCL Domino and perform CRUD operations on HCL Domino from Node.js.
-
Connect to and Visualize Live Google Tasks Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Tasks.
-
Build Semantic Layer Views for ZohoSubscriptions Data in APOS Live Data Gateway
Use the CData Connector for ZohoSubscriptions in APOS Live Data Gateway to build Semantic Layer Views for ZohoSubscriptions.
-
Query Vault CRM Data in DataGrip
Create a Data Source for Vault CRM in DataGrip and use SQL to query live Veeva Vault & Vault CRM.
-
How to Work with SAP Concur Data in AWS Glue Jobs Using JDBC
Connect to SAP Concur from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Getting Started with the CData Power BI Connector for Greenhouse
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Greenhouse.
-
Integrate OpenWeatherMap with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate OpenWeatherMap with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to OpenWeatherMap.
-
Create Informatica Mappings From/To an ODBC Data Source for Oracle HCM Cloud
Create an ODBC connection to Oracle HCM Cloud in Informatica and browse and transfer Oracle HCM Cloud.
-
Consume Kintone OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Kintone feeds that reflect any changes in SAP Lumira.
-
Connect to SFTP Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SFTP using standard SQL.
-
Build a Simple VCL Application for Instagram Data
How to build a simple VCL Application to view Instagram in RAD Studio using the CData ODBC Driver for Instagram.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Access
Provide connectivity to Microsoft Access through an SAP BusinessObjects universe.
-
Connect to Phoenix Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous Pipedrive Replication to MongoDB
Use CData Sync for automated, continuous, customizable Pipedrive replication to MongoDB.
-
Validate Close Data with QuerySurge
Access and validate Close in QuerySurge using the CData JDBC Driver.
-
How to create SAP SuccessFactors federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP SuccessFactors in MySQL .
-
Add Hive Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Hive with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Create Power BI Visual Reports with Real-Time Chargebee Data
Use CData Power BI Connectors to visualize Chargebee in Power BI.
-
Getting Started with the CData JDBC Driver for Pipeline CRM
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Pipeline CRM.
-
Build Certinia-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Certinia.
-
Automated Continuous Amplitude Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Amplitude replication to delimited files (CSV/TSV).
-
How to Work with Couchbase Data in AWS Glue Jobs Using JDBC
Connect to Couchbase from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Real-Time Access to Greenhouse in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Greenhouse in real time.
-
Connect to GitLab Data in NetBeans
Connect to GitLab in NetBeans with the data source configuration wizard.
-
Automated Continuous SharePoint Replication to SingleStore
Use CData Sync for automated, continuous, customizable SharePoint replication to SingleStore.
-
Connect to NetSuite Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with NetSuite Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Access ZarMoney Data Using Entity Framework
This article shows how to access ZarMoney using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Choosing the Best Method to Connect YouTube Analytics to SQL Server: 5 Options Explained
Discover multiple ways to connect and use YouTube Analytics from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to CloudConvert Data in JRuby
Create a simple JRuby app with access to live CloudConvert.
-
Query SAP Netweaver Gateway Data in ColdFusion
Write standard ColdFusion data access code to connect to SAP Netweaver Gateway.
-
Connect to Short.io Data in RazorSQL
Connect to Short.io from wizards and query Short.io from the GUI in the RazorSQL database management tool.
-
Rapidly Develop Amazon Athena-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 Amazon Athena.
-
Integrating Cursor CLI with Templated 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.
-
Automated Continuous Zuora Replication to SQLite
Use CData Sync for automated, continuous, customizable Zuora replication to SQLite.
-
LINQ to RabbitMQ 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 RabbitMQ Data Provider.
-
Connecting Moonlit Workflow with NetSuite Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your NetSuite CRM & ERP in real time.
-
Getting Started with the CData Tableau Connector for RabbitMQ
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Working with Pingdom Data in LINQPad
Execute LINQ queries to Pingdom in LINQPad.
-
Connect to Notion from Asprova with CData Software ODBC Driver for Notion
This article shows how to connect faster to Notion data from Asprova.
-
Build Charts with Avro Data in Clear Analytics
Create dynamic charts and perform analytics based on Apache Avro in Clear Analytics.
-
Connecting Mastra with Azure DevOps Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Azure DevOps, no replication required.
-
Integrate Bitly Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Bitly from Informatica Cloud.
-
Connect to Google Translate Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Translate and the SQL Gateway to access Google Translate from Google Apps Script.
-
Build PostgreSQL-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for PostgreSQL to explore live PostgreSQL Data in Cursor to assist with building PostgreSQL-powered applications.
-
How to connect PolyBase to PayPal
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live PayPal.
-
Publish XML-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live XML Files.
-
Build Lakebase-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Lakebase.
-
Automated Continuous Mailjet Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Mailjet replication to Apache Cassandra.
-
Connect to Salesforce Marketing Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Salesforce Marketing Cloud in the Denodo Virtual DataPort Administrator.
-
Import Real-Time Smartsheet Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Smartsheet in ColdFusion.
-
Natively Connect to Instantly Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Instantly. Leverage the native support for ODBC in PHP.
-
Create a Data Access Object for Google Translate Data using JDBI
A brief overview of creating a SQL Object API for Google Translate in JDBI.
-
Process & Analyze Supabase Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Supabase Data.
-
Automated Continuous Insightly Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Insightly replication to IBM DB2.
-
Automated Continuous AlloyDB Replication to MongoDB
Use CData Sync for automated, continuous, customizable AlloyDB replication to MongoDB.
-
DataBind Controls to Pipeliner CRM Data in Delphi
DataBind to Pipeliner CRM in Delphi with standard data access components and controls.
-
Build a Simple VCL Application for Bitly Data
How to build a simple VCL Application to view Bitly in RAD Studio using the CData ODBC Driver for Bitly.
-
Integrate with Recurly Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Recurly to a JSON file on disk.
-
Object-Relational Mapping (ORM) with SuiteCRM 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 SuiteCRM into a Java-based ORM framework, Hibernate.
-
Visualize Live Highrise Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Highrise CRM using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to & Open Greenplum Data in Microsoft Excel
This article uses the CData ODBC driver for Greenplum to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Getting Started with the CData Connect AI Python SDK for Facebook
Install the CData Connect AI Python SDK to read and write live Facebook with standard DB-API 2.0 Python code.
-
Build Customer.io-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Customer.io and build web apps with connectivity to live Customer.io.
-
How to integrate ZendeskSell with Apache Airflow
Access and process ZendeskSell in Apache Airflow using the CData JDBC Driver.
-
Deploy the ADO.NET Provider for Shortcut on an SSRS Report Server
Connect to Shortcut from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Integrate Salesforce CRM Analytics with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Salesforce CRM Analytics with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Salesforce CRM Analytics.