CData Software - Knowledge Base
Recent Articles
-
Object-Relational Mapping (ORM) with Auth0 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 Auth0 into a Java-based ORM framework, Hibernate.
-
Object-Relational Mapping (ORM) with Mailgun 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 Mailgun into a Java-based ORM framework, Hibernate.
-
Getting Started with the CData SSIS Components for Invoiced
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Invoiced.
-
Build a Singer.io Tap for Accelo With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Accelo data using
-
Working with Google Cloud Storage Data in LINQPad
Execute LINQ queries to Google Cloud Storage in LINQPad.
-
Visualize EmailOctopus Data in Sisense
Create an ElastiCube in Sisense app with access to EmailOctopus.
-
Deploy the ADO.NET Provider for Marketo on an SSRS Report Server
Connect to Marketo 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.
-
Analyze Google Translate Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Translate from Power Pivot. You will use the Table Import Wizard to load Google Translate. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Google Analytics Data in RazorSQL
Connect to Google Analytics from wizards and query Google Analytics from the GUI in the RazorSQL database management tool.
-
Use the CData ODBC Driver for Klaviyo in Microsoft Power Query
You can use the CData Klaviyo ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Klaviyo into Microsoft Power Query.
-
How to import Slack Data into Apache Solr
Use the CData Software JDBC Driver for Slack in Data Import Handler and create an automated import of Slack to Apache Solr Enterprise Search platform.
-
How to Access Live SAS Data Sets Data in Visual Studio Code via Cline
Run CData MCP Server for SAS Data Sets on Windows Subsytem for Linux (WSL) and connect to live SAS Data Sets from the Cline extension in Visual Studio Code.
-
Work with SAP SuccessFactors LMS Data in FoxPro
Load SAP SuccessFactors LMS into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software JDBC Driver for Basecamp in MicroStrategy
Connect to Basecamp in MicroStrategy Developer using the CData Software JDBC Driver for Basecamp.
-
Connect to Real-Time Productboard Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Productboard in Power Apps.
-
Bridge SendGrid Connectivity with Apache NiFi
Access and process SendGrid in Apache NiFi using the CData JDBC Driver.
-
Build MYOB AccountRight-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to MYOB AccountRight and build web apps with connectivity to live MYOB AccountRight.
-
Publish Crystal Reports on Amazon Marketplace Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Amazon Marketplace.
-
How to Connect to Apify Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Apify. Leverage the pyodbc module for ODBC in Python.
-
Natively Connect to Workable Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Workable. Leverage the native support for ODBC in PHP.
-
Automated Continuous Teradata Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Teradata replication to AlloyDB.
-
Build Highrise-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Highrise Data and create custom apps in Mendix.
-
How to publish and share Deel Data dashboards with Tableau Server
The CData ODBC driver for Deel enables you integrate Deel into Tableau dashboards.
-
Build Amazon Marketplace Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Amazon Marketplace and build visualizations in Tableau.
-
Getting Started with the CData Tableau Connector for Mocean
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to delimited files (CSV/TSV).
-
Enable the Jira JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Atlassian Jira.
-
Bind Live Zoho Recruit Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Zoho Recruit data
-
Automated Continuous NetSuite SuiteAnalytics Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Google BigQuery.
-
Build Microsoft Ads-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Microsoft Ads to explore live Microsoft Ads Data in Claude Code to assist with building Microsoft Ads-powered applications.
-
Integrate LightSpeedRetail Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live LightSpeedRetail from Informatica Cloud.
-
Create Couchbase Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Couchbase data access from reports, embedded analytics, and more.
-
Connect to Hugging Face Data from PowerBuilder via ADO.NET
This article demonstrates how to access Hugging Face from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Create Reports with ChargeOver Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ChargeOver.
-
How to Visualize Marketo Data in Python with pandas
Use pandas and other modules to analyze and visualize live Marketo in Python.
-
Migrating data from Azure Data Catalog to Snowflake using CData SSIS Components.
Easily push Azure Data Catalog to Snowflake using the CData SSIS Tasks for Azure Data Catalog and Snowflake.
-
Using the CData Software ODBC Driver for DB2 in PyCharm
Connect to DB2 as an ODBC data source in PyCharm using the CData Software ODBC Driver for DB2.
-
Automate CampaignMonitor Data Replication to SAP HANA
Use CData Sync to customize and automate CampaignMonitor replication to SAP HANA.
-
Visualize Grafana Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Grafana into TIBCO Spotfire.
-
How to Work with Impala Data in ETL Validator JDBC
Connect to Impala from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect and Query Live Azure Synapse Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Azure Synapse into Databricks
-
Visualize Perigon Data in Sisense
Create an ElastiCube in Sisense app with access to Perigon.
-
Build Couchbase Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Couchbase and build visualizations in Tableau.
-
Automated Continuous Dynamics CRM Replication to MySQL
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to MySQL.
-
Visualize SAP Concur Data in TIBCO Spotfire through OData
Integrate SAP Concur into dashboards in TIBCO Spotfire.
-
Validate WooCommerce Data with QuerySurge
Access and validate WooCommerce in QuerySurge using the CData JDBC Driver.
-
Query CampaignMonitor Data through ODBC in Node.js
Use node-odbc to execute SQL queries against CampaignMonitor from Node.js.
-
How to Work with Teamwork Data in AWS Glue Jobs Using JDBC
Connect to Teamwork from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Import Real-Time Rebilly Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Rebilly in ColdFusion.
-
How to Access Datadog Data Using Entity Framework
This article shows how to access Datadog using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Process & Analyze Odoo Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Odoo Data.
-
Back Up Chargebee 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 Chargebee data.
-
Automated Continuous SparkPost Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SparkPost replication to Amazon Redshift.
-
Connect to Cassandra Data from AWS Glue
Use CData Connect AI to gain access to live Apache Cassandra from your AWS Glue jobs.
-
Replicate Slack Data in Heroku for Use in Salesforce Connect
Replicate Slack to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrating Antigravity CLI with Atlassian Jira via CData CLI
Connect Atlassian Jira to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to work with Exact Online Data in Apache Spark using SQL
Access and process Exact Online Data in Apache Spark using the CData Software JDBC Driver.
-
Query Sybase IQ Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Sybase IQ entities in PHP by modeling them as objects.
-
Access SAP Netweaver Gateway Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for SAP Netweaver Gateway.
-
Replicate PayPal Data to Multiple Databases via the CData Sync CLI
Replicate PayPal to disparate databases with a single configuration.
-
How to update Azure Table from Excel
This article explains how to transfer data from Excel to Azure Table using the Excel Add-In for Azure Table.
-
Build Reckon Accounts Hosted-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Reckon Accounts Hosted and build Reckon Accounts Hosted-connected web apps with Axios.
-
Connect TaxJar Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your TaxJar using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use CData Connect AI to Access IBM Informix Data in Microsoft Power Pivot
Use CData Connect AI to connect to live IBM Informix in the Power Pivot business intelligence tool.
-
Connecting Agentforce with Neo4J Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Neo4J for you.
-
How to Build an ETL App for ZohoExpense Data in Python with CData
Create ETL applications and real-time data pipelines for ZohoExpense in Python with petl.
-
Build Dashboards with Elasticsearch Data in Dundas BI
Create dynamic dashboards and perform analytics based on Elasticsearch in Dundas BI.
-
Edit and Search Postmark External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Postmark to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Postmark objects that you can access from apps and the dashboard.
-
How to work with RSS Feeds in Apache Spark using SQL
Access and process RSS Feeds in Apache Spark using the CData Software JDBC Driver.
-
ETL Excel in Oracle Data Integrator
This article shows how to transfer Microsoft Excel into a data warehouse using Oracle Data Integrator.
-
How to Work with Freshsales Data in AWS Glue Jobs Using JDBC
Connect to Freshsales from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Analyze SageHR Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SageHR from Power Pivot. You will use the Table Import Wizard to load SageHR. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous SharePoint Replication to Oracle
Use CData Sync for automated, continuous, customizable SharePoint replication to Oracle.
-
Build Sage 300-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Sage 300 to explore live Sage 300 Data in Gemini Code Assist to assist with building Sage 300-powered applications.
-
DataBind Charts to Salesloft Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Salesloft 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.
-
How to connect Amazon QuickSight to Azure Table Data
Create a connection to Azure Table Storage in CData Connect AI and insert Azure Table Storage into Amazon QuickSight SPICE to build interactive dashboards.
-
Automate Pipedrive Data Replication to SAP HANA
Use CData Sync to customize and automate Pipedrive replication to SAP HANA.
-
Connect to FHIR Data in JRuby
Create a simple JRuby app with access to live FHIR.
-
Build Zoho Projects-Connected Apps in Choreo
Use CData Connect AI to connect to Zoho Projects Data from Choreo and build custom apps using live Zoho Projects.
-
Consume Access OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft Access as OData feeds from PowerBuilder using the API Server.
-
Write a Simple Go Application to work with Workable Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Workable.
-
Using the CData Software ODBC Driver for SAP ByDesign in PyCharm
Connect to SAP ByDesign as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP ByDesign.
-
Create SSAS Tabular Models from HelloSign Data
How to build a SQL Server Analysis Service Tabular Model from HelloSign using CData drivers.
-
Connect to Amazon Marketplace Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Amazon Marketplace.
-
Use Dash to Build to Web Apps on LinkedIn Data
Create Python applications that use pandas and Dash to build LinkedIn-connected web apps.
-
Use the CData Software ODBC Driver for PabblySubscriptions in MicroStrategy Web
Connect to PabblySubscriptions in MicroStrategy Web using the CData Software ODBC Driver for PabblySubscriptions.
-
Integrating Claude Code CLI with SAS Data Sets 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 Create Power BI Visual Reports with Real-Time Teamwork Data
Use CData Power BI Connectors to visualize Teamwork in Power BI.
-
Use Biml to Build SSIS Tasks to Replicate Dropbox Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Dropbox to SQL Server.
-
How to connect SharePoint with Google Campaign Manager 360 Data through external lists
Provide Google Campaign Manager 360 to SharePoint users as an external list.
-
Create Hive Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Hive data access from reports, embedded analytics, and more.
-
Integrating OpenCode Terminal with Elasticsearch 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.
-
Analyze Live Snapchat Ads Data in SAS Viya
Use CData Connect AI to connect to Snapchat Ads from SAS Viya and deploy self-service analytics using live Snapchat Ads.
-
Viewing Quickbase Data in RAD Studio Data Explorer
How to view Quickbase in RAD Studio Data Explorer using the CData ODBC Driver for Quickbase.
-
Query Insightly Data in DataGrip
Create a Data Source for Insightly in DataGrip and use SQL to query live Insightly.
-
Use Microsoft Copilot Studio to talk to your ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your ActiveCampaign for you.
-
Use JayDeBeApi to access Box Data in Python
Use standard Python scripting and the development environment of your choice to access live Box.
-
Consume LDAP OData Feeds in PowerBuilder
This article demonstrates how to consume LDAP as OData feeds from PowerBuilder using the API Server.
-
Getting Started with the CData ADO.NET Provider for Amplitude
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrate Twilio Data into Power Automate Desktop using CData Connect
CData Connect for Twilio Data enables you to integrate Twilio into workflows built using Microsoft Power Automate Desktop.