CData Software - Knowledge Base
Recent Articles
-
Build Automated Blackbaud FE NXT-Connected Workflows in Zapier
Use CData Connect AI to connect to live Blackbaud FE NXT and build automated workflows in Zapier.
-
Automated Continuous Act CRM Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Act CRM replication to Amazon S3.
-
Provide OData Services of Salesforce Pardot Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Salesforce Pardot by developing a WCF Service Application.
-
Integrating Kiro CLI with Blackbaud FE NXT 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.
-
How to Access Cohere Data Using Entity Framework
This article shows how to access Cohere using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Semantic Layer Views for Teamgate Data in APOS Live Data Gateway
Use the CData Connector for Teamgate in APOS Live Data Gateway to build Semantic Layer Views for Teamgate.
-
Create a Data Access Object for Greenplum Data using JDBI
A brief overview of creating a SQL Object API for Pivotal GreenPlum in JDBI.
-
How to Connect to FHIR Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to FHIR. Leverage the pyodbc module for ODBC in Python.
-
Access Shippo Data from MySQL in Amazon QuickSight
Connect to Shippo and build visualizations of Shippo using a MySQL Connection in Amazon QuickSight.
-
Build Twilio-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Twilio to explore live Twilio Data in Gemini Code Assist to assist with building Twilio-powered applications.
-
Connect to eBay Data in Claris FileMaker Pro
Use the CData ODBC Driver for eBay in FileMaker Pro to connect to eBay and work with eBay in your FileMaker applications.
-
Access Live Qualaroo Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Qualaroo into the statistical analysis tools available in SAS JMP. This article shows how to use Qualaroo in the Graph Builder and Query Builder.
-
Publish Eventbrite-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Eventbrite.
-
Viewing Excel Online Data in RAD Studio Data Explorer
How to view Microsoft Excel Online in RAD Studio Data Explorer using the CData ODBC Driver for Excel Online.
-
Getting Started with the CData ODBC Driver for ConvertAPI
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ConvertAPI.
-
How to integrate PayPal with Apache Airflow
Access and process PayPal in Apache Airflow using the CData JDBC Driver.
-
How to load Sybase data into Elasticsearch via Logstash
Introducing a simple method to load Sybase data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
DataBind Oracle Service Cloud Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Oracle Service Cloud with the DevExpress Windows Forms and Web controls to provide Oracle Service Cloud to a chart.
-
Build a PostgreSQL Interface for ShipEngine Data using the CData JDBC Driver
Use the Remoting features of the ShipEngine JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to ZohoMarketingHub Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ZohoMarketingHub in the Denodo Virtual DataPort Administrator.
-
Integrate Cursor with Live Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Sybase IQ from within the editor.
-
Establish a Live Connection with Figshare Data using Tableau Bridge
The CData ODBC Driver for Figshare enables you to integrate live Figshare into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Kintone Data in RazorSQL
Connect to Kintone from wizards and query Kintone from the GUI in the RazorSQL database management tool.
-
Create Mixpanel Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Mixpanel data access from reports, embedded analytics, and more.
-
Migrating data from OpenWeatherMap to Databricks using CData SSIS Components.
Easily push OpenWeatherMap to Databricks using the CData SSIS Tasks for OpenWeatherMap and Databricks.
-
Replicate SAP Netweaver Gateway Data in Heroku for Use in Salesforce Connect
Replicate SAP Netweaver Gateway to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to connect SharePoint with SAP HANA XS Advanced Data through external lists
Provide SAP HANA XS Advanced to SharePoint users as an external list.
-
Integrate WooCommerce Data in Pentaho Data Integration
Build ETL pipelines based on WooCommerce in the Pentaho Data Integration tool.
-
Integrate Pipeliner CRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Pipeliner CRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Pipeliner CRM.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Bitly
Provide connectivity to Bitly through an SAP BusinessObjects universe.
-
Extract, Transform, and Load Mixpanel Data in Informatica PowerCenter
Create a simple Workflow for Mixpanel in Informatica PowerCenter.
-
How to work with Foursquare Data in Apache Spark using SQL
Access and process Foursquare Data in Apache Spark using the CData Software JDBC Driver.
-
Object-Relational Mapping (ORM) with SQL Server 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 Microsoft SQL Server into a Java-based ORM framework, Hibernate.
-
Analyze LinkedIn Ads Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for LinkedIn Ads from Power Pivot. You will use the Table Import Wizard to load LinkedIn Ads. You can visually build the import query or use any SQL supported by the driver.
-
Connect to QuickBooks Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Natively Connect to Contentful Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Contentful. Leverage the native support for ODBC in PHP.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Copper
Provide connectivity to Copper through an SAP BusinessObjects universe.
-
Connect to Typeform Data in CloverDX (formerly CloverETL)
Transfer Typeform using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous AlloyDB Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable AlloyDB replication to Apache Kafka.
-
Migrating data from SpaceX to Snowflake using CData SSIS Components.
Easily push SpaceX to Snowflake using the CData SSIS Tasks for SpaceX and Snowflake.
-
Using the CData Software ODBC Driver for Mistral AI in PyCharm
Connect to Mistral AI as an ODBC data source in PyCharm using the CData Software ODBC Driver for Mistral AI.
-
Automated Continuous OnePageCrm Replication to Amazon S3
Use CData Sync for automated, continuous, customizable OnePageCrm replication to Amazon S3.
-
Analyze Google Directory Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Directory with the CData JDBC Driver for Google Directory.
-
Connect and Query Live Shopify Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Shopify into Databricks
-
Model GitHub Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and GitHub, enabling the direct import of real-time GitHub.
-
Build Dashboards with Clockify Data in DBxtra
Create dynamic dashboards and perform analytics based on Clockify in DBxtra.
-
Import Real-Time Teamwork Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Teamwork in ColdFusion.
-
How to create Presto federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Presto in MySQL .
-
How to create Visio diagrams from Azure Synapse Data
Automatically update Azure Synapse with the changes you make to Visio master shapes.
-
AdRoll Reporting in OBIEE with the AdRoll JDBC Driver
Deploy the AdRoll JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Live Microsoft Ads Data in TIBCO Data Virtualization
Use the Microsoft Ads Tibco DV Adapter to create a Microsoft Ads data source in TIBCO Data Virtualization Studio and gain access to live Microsoft Ads from your TDV Server.
-
Use the CData Software ODBC Driver for Azure Data Lake Storage in MicroStrategy Web
Connect to Azure Data Lake Storage in MicroStrategy Web using the CData Software ODBC Driver for Azure Data Lake Storage.
-
Use the CData API Server to Access Google Sheets Data in Microsoft PowerPivot
Use the CData API Server to connect to live Google Sheets in the Power Pivot business intelligence tool.
-
Connect to Sugar CRM Data in Claris FileMaker Pro
Use the CData ODBC Driver for Sugar CRM in FileMaker Pro to connect to Sugar CRM and work with Sugar CRM in your FileMaker applications.
-
Access Live MongoDB Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MongoDB from your Excel spreadsheets.
-
Automated Continuous Shopify Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Shopify replication to delimited files (CSV/TSV).
-
Analyze Dynamics 365 Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft Dynamics 365 and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Getting Started with the CData Connect AI Python SDK for SAP Fieldglass
Install the CData Connect AI Python SDK to read and write live SAP Fieldglass with standard DB-API 2.0 Python code.
-
Integrate ElevenLabs Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ElevenLabs from Informatica Cloud.
-
How to Work with xBase Data in ETL Validator JDBC
Connect to xBase from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating GitHub Copilot CLI with Microsoft Excel 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 CockroachDB via CData CLI
Connect CockroachDB to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to work with SAP Concur Data in Apache Spark using SQL
Access and process SAP Concur Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for Stack Exchange in SAS for Real-Time Reporting and Analytics
Connect to real-time Stack Exchange in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Stack Exchange.
-
How to Access Epicor Kinetic Data Using Entity Framework
This article shows how to access Epicor Kinetic using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live Square Data in Excel 365 Online (Excel for the web)
Connect to Square from Excel 365 Online (Excel for the web) with CData Connect AI.
-
ETL Oracle Sales in Oracle Data Integrator
This article shows how to transfer Oracle Sales into a data warehouse using Oracle Data Integrator.
-
Deploy the ADO.NET Provider for Office 365 on an SSRS Report Server
Connect to Microsoft Office 365 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.
-
Natively Connect to Sybase IQ Data in PHP
The CData ODBC driver for Sybase IQ enables you to create PHP applications with connectivity to Sybase IQ. Leverage the native support for ODBC in PHP.
-
Timely Reporting in OBIEE with the Timely JDBC Driver
Deploy the Timely JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to work with SurveyMonkey Data in Apache Spark using SQL
Access and process SurveyMonkey Data in Apache Spark using the CData Software JDBC Driver.
-
Write a Simple Go Application to work with PabblySubscriptions Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to PabblySubscriptions.
-
Build Dashboards with HDFS Data in DBxtra
Create dynamic dashboards and perform analytics based on Apache HDFS in DBxtra.
-
Connect to Humanity Data from PowerBuilder via JDBC
This article demonstrates how to access Humanity from PowerBuilder using the Humanity JDBC Driver.
-
Publish Crystal Reports on Gong Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Gong.
-
Build a Singer.io Tap for Spotify With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Spotify data using
-
Understanding the API Limits in Dynamics 365 and Dataverse (CDS): Behavior, Monitoring, and How It Impacts the CData Dynamics 365 / Dataverse Driver
A fully updated guide to Microsoft Dataverse and Dynamics 365 API request limits, service protection throttling, request allocations, and how these rules impact the behavior of the CData Dynamics 365 / Dataverse Driver.
-
Build Apps with Live ActiveCampaign in Adalo using CData Connect AI
Use CData Connect AI to integrate live ActiveCampaign into the Adalo platform and build custom mobile and web applications with real-time ActiveCampaign.
-
Automated Continuous DB2 for i Replication to Oracle
Use CData Sync for automated, continuous, customizable DB2 for i replication to Oracle.
-
Design BIRT Reports on Chargebee Data
Provide current Chargebee to your embedded analytics.
-
Replicate Excel Data to Multiple Databases via the CData Sync CLI
Replicate Microsoft Excel to disparate databases with a single configuration.
-
Build Visualizations of Salesforce CRM Analytics Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Salesforce CRM Analytics in Birst.
-
Visualize Live Google Ad Manager Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google Ad Manager.
-
How to Connect the Power BI Service to Amazon Marketplace: Complete Guide
Connect to the CData Software Power BI Connector for Amazon Marketplace from PowerBI.com to provide real-time Amazon Marketplace across the organization.
-
Create Datasets from Aha! in Domo Workbench and Build Visualizations of Aha! Data in Domo
Use the CData Software ODBC Driver for Aha! to create datasets from Aha! in Domo Workbench and then build visualizations in the Domo service.
-
Analyze Act CRM Data in Looker
Use CData Connect AI to connect to Act CRM Data from Looker and build custom apps using live Act CRM.
-
How to connect to Salesforce Pardot Data from Spring Boot
Connect to Salesforce Pardot in a Spring Boot Application using the CData JDBC Driver for Salesforce Pardot
-
Connect to Blackbaud FE NXT Data from a Connection Pool in Jetty
The Blackbaud FE NXT JDBC Driver supports connection pooling: This article shows how to connect faster to Blackbaud FE NXT from Web apps in Jetty.
-
Connect to ServiceDesk Plus Data in NetBeans
Connect to ServiceDesk Plus in NetBeans with the data source configuration wizard.
-
Connect and Visualize Live Zoom Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Zoom into the Databricks platform and create visualization dashboards with real-time Zoom.
-
Connect to Impala Data in Jaspersoft Studio
Execute SQL to remote Apache Impala in Jaspersoft Studio.
-
How to Seamlessly Import CouchDB Data into IBM SPSS Modeler
Integrate CouchDB data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to connect and process SAP HANA XS Advanced from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP HANA XS Advanced.
-
Automate Lakebase Data Replication to Couchbase
Use CData Sync to Customize and automate Lakebase replication to Couchbase.
-
Visualize Dynamics NAV Data in Tableau
The CData ODBC driver for Dynamics NAV enables you integrate Microsoft Dynamics NAV into Tableau dashboards.
-
LINQ to ADP 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 ADP Data Provider.
-
Connect HDFS to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect HDFS with IBM WebSphere for seamless data integration and connectivity.
-
Create ActiveCampaign-Connected Applications in Appsmith
Connect to ActiveCampaign Data via CData Connect AI in Appsmith and create custom business applications with real-time access to ActiveCampaign.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Yelp
Provide connectivity to Yelp through an SAP BusinessObjects universe.
-
Use the CData Software ODBC Driver for PabblySubscriptions in SAS for Real-Time Reporting and Analytics
Connect to real-time PabblySubscriptions in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for PabblySubscriptions.