CData Software Knowledge Base

Process & Analyze CockroachDB in Databricks (AWS)

Use CData, AWS, and Databricks to perform data engineering and data science on live CockroachDB .

Connect to Avalara AvaTax as an External Data Source using PolyBase

Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Avalara AvaTax.

Easily Integrate MarkLogic in Lazarus Pascal IDE

Learn how to easily integrate live MarkLogic in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

Connect to ShipStation in DigitalSuite Studio through RunMyProcess DSEC

Use Arkobi Digital

How to Access Live Redis in Visual Studio Code via Cline

Run the CData MCP Server for Redis on Windows Subsytem for Linux (WSL) and connect to live Redis from the Cline extension in Visual Studio Code.

Analyze Marketo in Infragistics Reveal

Use the CData API Server to create an OData API on top of Marketo and visualize live Marketo in Ingragistics Reveal.

Choosing the Best Method to Connect Zoho CRM to SQL Server: 5 Options Explained

Discover multiple ways to connect and use Zoho CRM from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

Connect to QuickBooks Time in CloverDX (formerly CloverETL)

Transfer QuickBooks Time using the visual workflow in the CloverDX data integration tool.

Access Stripe from MySQL in Amazon QuickSight

Connect to Stripe and build visualizations of Stripe using a MySQL Connection in Amazon QuickSight.

Connect to and Visualize Live eBay Analytics in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live eBay Analytics.

Rapidly Develop Facebook-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.

Replicate Spark from PowerShell

Write a quick PowerShell script to query Apache Spark SQL. Use connectivity to the live data to replicate Apache Spark SQL to SQL Server.

Build CockroachDB-Connected Apps in Mendix

Use CData Connect Cloud to create an OData feed for CockroachDB and create custom apps in Mendix.

Working with Marketo in LINQPad

Execute LINQ queries to Marketo in LINQPad.

How to create an RPA flow for Microsoft Project in UiPath Studio

Use the Microsoft Project ODBC Driver to create workflows that access real-time Microsoft Project without any coding.

How to import Drip into Apache Solr

Use the CData Software JDBC Driver for Drip in Data Import Handler and create an automated import of Drip to Apache Solr Enterprise Search platform.

Automate Tasks in Power Automate Using the CData API Server

Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.

Use JayDeBeApi to access Google Spanner in Python

Use standard Python scripting and the development environment of your choice to access live Google Spanner.

Viewing Clio in RAD Studio Data Explorer

How to view Clio in RAD Studio Data Explorer using the CData ODBC Driver for Clio.

Build Semantic Layer Views for Twitter Ads in APOS Live Data Gateway

Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Twitter Ads.

Migrating data from TaxJar to Snowflake using CData SSIS Components.

Easily push TaxJar to Snowflake using the CData SSIS Tasks for TaxJar and Snowflake.

Connect to Access in DBArtisan

Use wizards in DBArtisan to configure Microsoft Access as a data source.

Build MVC Applications with Connectivity to DB2

This article shows how to use only the Entity Framework and the CData ADO.NET provider to access DB2 from an ASP.NET MVC application.

Consume Jira OData Feeds in PowerBuilder

This article demonstrates how to consume Atlassian Jira as OData feeds from PowerBuilder using the API Server.

Connect to Google Calendar from Blazor Apps

Build ASP.NET Core Blazor C# apps that integrate with real-time Google Calendar using standard SQL.

How to Connect DBeaver to Amazon Marketplace via a JDBC Driver

Manage Amazon Marketplace with visual tools in DBeaver like the query browser.

Automated Continuous CData Connect Cloud Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable CData Connect Cloud replication to delimited files (CSV/TSV).

Create Datasets from Odoo in Domo Workbench and Build Visualizations of Odoo in Domo

Use the CData Software ODBC Driver for Odoo to create datasets from Odoo ERP in Domo Workbench and then build visualizations in the Domo service.

Connect to Confluence in ACL Analytics

Connect to Atlassian Confluence via CData Connect Cloud in ACL Analytics to run your data analysis workflows with real-time access to Atlassian Confluence.

Create Apps from SAP Ariba Procurement in Qlik Sense Cloud

Use CData Connect Cloud to connect to SAP Ariba Procurement and build apps from live SAP Ariba Procurement in Qlik Sense Cloud.

Integrate Live Dynamics CRM into Amazon SageMaker Canvas with RDS

Use CData Connect Cloud to connect to Dynamics CRM from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Microsoft Dynamics CRM.

Connect and Query Live Snapchat Ads Data in Databricks with CData Connect Cloud

Use CData Connect Cloud to integrate live Snapchat Ads into Databricks

Build Semantic Layer Views for DocuSign in APOS Live Data Gateway

Use the CData Connector for DocuSign in APOS Live Data Gateway to build Semantic Layer Views for DocuSign.

Automated Continuous FHIR Replication to SQLite

Use CData Sync for automated, continuous, customizable FHIR replication to SQLite.

Use JayDeBeApi to access DocuSign in Python

Use standard Python scripting and the development environment of your choice to access live DocuSign.

Access Live Oracle Sales in AWS Lambda (with IntelliJ IDEA)

Connect to live Oracle Sales in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

Connect to and Visualize Live Adobe Target in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Adobe Target.

Use the CData API Server to Access SAP Concur in Microsoft PowerPivot

Use the CData API Server to connect to live SAP Concur in the Power Pivot business intelligence tool.

Access Live Adobe Analytics in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

Connect to Adobe Analytics from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

Automated Continuous Excel Replication to SingleStore

Use CData Sync for automated, continuous, customizable Excel replication to SingleStore.

Connect to Facebook from a Connection Pool in WebLogic

Use the CData JDBC Driver for Facebook to connect to Facebook from Web applications running on WebLogic.

Integrate MYOB AccountRight in Your Informatica Cloud Instance

Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MYOB AccountRight from Informatica Cloud.

Connect to Confluence in RapidMiner

Integrate Atlassian Confluence with standard components and data source configuration wizards in RapidMiner Studio.

CData Software - Knowledge Base

Recent Articles