CData Software - Knowledge Base
Recent Articles
-
How to Build an ETL App for Spark in Python with CData
Create ETL applications and real-time data pipelines for Apache Spark SQL in Python with petl.
-
How to Access Live Teradata in Visual Studio Code via Cline
Run the CData MCP Server for Teradata on Windows Subsytem for Linux (WSL) and connect to live Teradata from the Cline extension in Visual Studio Code.
-
Replicate Azure DevOps to Multiple Databases
Replicate Azure DevOps to disparate databases with a point-and-click configuration.
-
Build Semantic Layer Views for Microsoft Planner in APOS Live Data Gateway
Use the CData Connector for Microsoft Planner in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Planner.
-
Build Dashboards with Twilio in Dundas BI
Create dynamic dashboards and perform analytics based on Twilio in Dundas BI.
-
Automated Continuous BigCommerce Replication to Oracle
Use CData Sync for automated, continuous, customizable BigCommerce replication to Oracle.
-
Perform Batch Operations with Excel in Apache NiFi
Connect to Microsoft Excel and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Access Live Oracle Service Cloud in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Oracle Service Cloud into the statistical analysis tools available in SAS JMP. This article shows how to use Oracle Service Cloud in the Graph Builder and Query Builder.
-
Visualize Parquet in TIBCO Spotfire through ADO.NET
Integrate Apache Parquet into dashboards in TIBCO Spotfire.
-
Provide OData Services of ServiceNow from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ServiceNow by developing a WCF Service Application.
-
How to integrate Zoho CRM with Apache Airflow
Access and process Zoho CRM in Apache Airflow using the CData JDBC Driver.
-
Consume NetSuite OData Feeds in PowerBuilder
This article demonstrates how to consume NetSuite CRM & ERP as OData feeds from PowerBuilder using the API Server.
-
Publish Reports with Typeform in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Typeform.
-
Access Live Excel in AWS Lambda
Connect to live Microsoft Excel in AWS Lambda using the CData JDBC Driver.
-
Build Oracle Eloqua-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Oracle Eloqua.
-
Query CockroachDB in ColdFusion
Write standard ColdFusion data access code to connect to CockroachDB.
-
Using the CData Software ODBC Driver for Drip in PyCharm
Connect to Drip as an ODBC data source in PyCharm using the CData Software ODBC Driver for Drip.
-
Explore Geographical Relationships in Printful with Power Map
Create data visualizations with Printful in Power Map.
-
How to Access Lakebase Using Entity Framework
This article shows how to access Lakebase using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrating LangGraph with Zuora via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Zuora within automated workflows.
-
Rapidly Develop Google Directory-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Integrate Box in the Pentaho Report Designer
Publish reports based on Box in the Pentaho BI tool.
-
Connect to Invoiced as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Invoiced.
-
Choosing the Best Method to Connect Spark to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Apache Spark SQL from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to connect SharePoint with Shippo through external lists
Provide Shippo to SharePoint users as an external list.
-
Automated Continuous Reckon Accounts Hosted Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Amazon Redshift.
-
Connect Authorize.Net to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Authorize.Net using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData Software ODBC Driver for SharePoint in MicroStrategy Web
Connect to Microsoft SharePoint in MicroStrategy Web using the CData Software ODBC Driver for SharePoint.
-
Visualize HBase in Tableau
The CData ODBC driver for HBase enables you integrate Apache HBase into Tableau dashboards.
-
Back Up Oracle HCM Cloud to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Oracle HCM Cloud. In this article, we will employ an SSIS workflow to populate a database with Oracle HCM Cloud data.
-
Create Data Visualizations Based On Excel Online in Mode
Use CData Connect AI to connect to Excel Online from Mode and build visualizations using live
-
Build AI Agents with BigQuery Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Automate Authorize.Net Replication to Azure Data Lake
Use CData Sync to customize and automate Authorize.Net replication to Azure Data Lake.
-
Trigger Snowflake IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Build MVC Applications with Connectivity to SAP HANA
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP HANA from an ASP.NET MVC application.
-
Edit and Search External Avalara AvaTax Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Avalara AvaTax to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Avalara AvaTax objects that you can access from apps and the dashboard.
-
Integrate with Spark in SnapLogic
Use CData Connect AI to connect to and integrate with live Apache Spark SQL in SnapLogic.
-
How to Query Live Google Contacts in Claude Desktop
Connect to and query live Google Contacts in Claude Desktop using the CData MCP Server.
-
Connect to SAP HANA XS Advanced in DBeaver
Use the CData ODBC Driver to connect to SAP HANA XS Advanced in DBeaver.
-
Build Semantic Layer Views for Drift in APOS Live Data Gateway
Use the CData Connector for Drift in APOS Live Data Gateway to build Semantic Layer Views for Drift.
-
Choosing the Best Method to Connect Cassandra to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Apache Cassandra from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Square from a Connection Pool in WebLogic
Use the CData JDBC Driver for Square to connect to Square from Web applications running on WebLogic.
-
Automated Microsoft Teams Replication to Teradata
Use CData Sync to Customize and automate Microsoft Teams replication to Teradata.
-
Publish Reports with Sugar CRM in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sugar CRM.
-
How to connect to Google Sheets from Spring Boot
Connect to Google Sheets in a Spring Boot Application using CData JDBC Google Sheets Driver
-
How to update SuiteCRM from Excel
This article explains how to transfer data from Excel to SuiteCRM using the Excel Add-In for SuiteCRM.
-
ETL Coinbase in Oracle Data Integrator
This article shows how to transfer Coinbase into a data warehouse using Oracle Data Integrator.
-
Automated Continuous SAP BusinessObjects BI Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Amazon Redshift.
-
Connect to Oracle Sales from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Oracle Sales, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Migrating data from Sybase to Databricks using CData SSIS Components.
Easily push Sybase to Databricks using the CData SSIS Tasks for Sybase and Databricks.
-
A PostgreSQL Interface for Zendesk (MySQL Remoting via JDBC)
Use the Remoting features of the Zendesk JDBC Driver to create a PostgreSQL entry-point for data access.
-
Stream HubDB into Apache Kafka Topics
Access and stream HubDB in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zoom
Provide connectivity to Zoom through an SAP BusinessObjects universe.
-
Design BIRT Reports on Oracle HCM Cloud
Provide current Oracle HCM Cloud to your embedded analytics.
-
Connecting to ODBC Data Sources in Google Apps Script
This article shows how to use the SQL Gateway to access ODBC data sources from Google Apps Script.
-
Connect to Active Directory in CloverDX (formerly CloverETL)
Transfer Active Directory using the visual workflow in the CloverDX data integration tool.
-
How to Build an ETL App for HBase in Python with CData
Create ETL applications and real-time data pipelines for Apache HBase in Python with petl.
-
Connect to Active Directory from PowerBuilder via ADO.NET
This article demonstrates how to access Active Directory from Appeon PowerBuilder using the CData ADO.NET Provider for Active Directory.
-
Import and Visualize Dynamics CRM in Power View
Create data visualizations based on Microsoft Dynamics CRM in Excel.
-
Visualize WooCommerce in TIBCO Spotfire through OData
Integrate WooCommerce into dashboards in TIBCO Spotfire.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Sybase to Power BI dashboards. Simply drag and drop Sybase into data visuals on the Power BI canvas.
-
Automated Continuous Zuora Replication to SQL Server
Use CData Sync for automated, continuous, customizable Zuora replication to SQL Server.
-
Build Data Flows from DocuSign to SQL Server using SSIS
Easily back up DocuSign to SQL Server using the SSIS components for DocuSign.
-
Eloqua: HTTP 400 Too Many Campaigns to Run the Report
In this entry you will find the resolution for the Oracle Eloqua API "too many campaigns to run the report" error.
-
Integrate with Google Calendar in SnapLogic
Use CData Connect AI to connect to and integrate with live Google Calendar in SnapLogic.
-
Build AI/ML Models with Live Access Data using Dataiku
-