CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Python Connector for Lakebase
Learn to install and license the CData Python Connector
-
Query CockroachDB using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume CockroachDB entities in PHP by modeling them as objects.
-
How to Work with Google Contacts in ETL Validator JDBC
Connect to Google Contacts from ETL Validator jobs using the CData Software JDBC Driver.
-
Query XML from Node.js
Use the OData endpoint of the CData API Server to connect to your XML Files and perform CRUD operations on XML from Node.js.
-
Analyze Live Google Sheets in SAS Viya
Use CData Connect AI to connect to Google Sheets from SAS Viya and deploy self-service analytics using live Google Sheets.
-
Integrate Cline with Live Adobe Commerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Adobe Commerce from within your IDE.
-
Automate Zoom Replication to Azure Synapse
Use CData Sync to customize and automate Zoom replication to Azure Synapse.
-
Use Dash to Build to Web Apps on XML
Create Python applications that use pandas and Dash to build XML-connected web apps.
-
Process & Analyze Confluence in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Confluence .
-
Access Live Databricks 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 Databricks through MCP integration.
-
Analyze Sage 200 in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Sage 200 and visualize live Sage 200 in Infragistics Reveal.
-
Using the CData Software ODBC Driver for ShipStation in PyCharm
Connect to ShipStation as an ODBC data source in PyCharm using the CData Software ODBC Driver for ShipStation.
-
Build Automated Workflows with Live Freshdesk in Workato
Use CData Connect AI to connect to live Freshdesk and build automated workflows in Workato.
-
How to Seamlessly Import Adobe Commerce Data into IBM SPSS Modeler
Integrate Adobe Commerce data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
DataBind Charts to LDAP Objects
Use the standard ADO.NET procedures for databinding to provide bidirectional access to LDAP 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 PolyBase to Dropbox
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Dropbox.
-
Build a Singer.io Tap for Splunk With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Splunk data using
-
Build Azure Data Lake Storage-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Azure Data Lake Storage.
-
Build Pipelines with Live PostgreSQL in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to PostgreSQL from Google Cloud Data Fusion, enabling the integration of live PostgreSQL into the building and management of effective data pipelines.
-
Back Up Klaviyo to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Klaviyo. In this article, we will employ an SSIS workflow to populate a database with Klaviyo data.
-
Work with Live Zoho Projects in Power Query
Use CData Connect AI to connect to Zoho Projects and work with live Zoho Projects in Microsoft Power Query.
-
How to Query Live Freshdesk in Perplexity MacOS Desktop
Connect to and query live Freshdesk in Perplexity Desktop using CData Code Assist MCP.
-
Analyze Exact Online in R via JDBC
Use standard R functions and the development environment of your choice to analyze Exact Online with the CData JDBC Driver for Exact Online.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Amazon DynamoDB
Provide connectivity to Amazon DynamoDB through an SAP BusinessObjects universe.
-
Create Informatica Mappings From/To an ODBC Data Source for Stripe
Create an ODBC connection to Stripe in Informatica and browse and transfer Stripe.
-
Access Live FHIR in AWS Lambda
Connect to live FHIR in AWS Lambda using the CData JDBC Driver.
-
Connect to Dynamics 365 in Aqua Data Studio
Access Microsoft Dynamics 365 from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Natively Connect to Wave Financial in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Wave Financial. Leverage the native support for ODBC in PHP.
-
Connect to SendGrid from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SendGrid using standard SQL.
-
Visualize Greenhouse in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Greenhouse into TIBCO Spotfire.
-
Automated Presto Replication to Teradata
Use CData Sync to Customize and automate Presto replication to Teradata.
-
How to integrate ActiveCampaign with Apache Airflow
Access and process ActiveCampaign in Apache Airflow using the CData JDBC Driver.
-
How to connect to SQL Server from Spring Boot
Connect to SQL Server in a Spring Boot Application using CData JDBC SQL Server Driver
-
Automated Continuous Adobe Analytics Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to IBM DB2.
-
Access ConstantContact from MySQL in Amazon QuickSight
Connect to ConstantContact and build visualizations of ConstantContact using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Azure Data Lake Storage Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to OneLake in Microsoft Fabric.
-
How to Query Live Epicor Kinetic in Perplexity MacOS Desktop
Connect to and query live Epicor Kinetic in Perplexity Desktop using CData Code Assist MCP.
-
Connect to HBase in CloverDX (formerly CloverETL)
Transfer Apache HBase using the visual workflow in the CloverDX data integration tool.
-
Visualize Databricks in Sisense
Create an ElastiCube in Sisense app with access to Databricks.
-
Create Reports from Google Campaign Manager 360 in Looker Studio
Use CData Connect AI to gain access to live Google Campaign Manager 360 and create custom reports in Looker Studio.
-
Automated Continuous Splunk Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Splunk replication to Amazon Redshift.
-
Analyze IBM Informix in Infragistics Reveal
Use the CData API Server to create an OData API on top of IBM Informix and visualize live IBM Informix in Infragistics Reveal.
-
Create Dashboards and Visualize Live Kintone in Geckoboard
Use CData Connect AI to connect to live Kintone and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to MongoDB in NetBeans
Connect to MongoDB in NetBeans with the data source configuration wizard.
-
Build Google Directory Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Directory and build visualizations in Tableau Cloud.
-
LINQ to Paylocity
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 Paylocity Data Provider.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for JotForm
Provide connectivity to JotForm through an SAP BusinessObjects universe.
-
Load CockroachDB to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load CockroachDB to a database.
-
Stream JSON Services into Apache Kafka Topics
Access and stream JSON in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Prepare, Blend, and Analyze Azure DevOps in Alteryx Designer (Connect AI)
Build workflows to access live Azure DevOps for self-service data analytics.
-
Build QuickBooks-Powered Applications in GitHub Copilot with CData Code Assist MCP
-