Show articles by: Integration Technology | Driver Technology | Recent Articles

CData Software - Knowledge Base

Recent Articles

PowerShell Scripting to Replicate PayPal to MySQL

Write a simple PowerShell script to replicate PayPal to a MySQL database.
Integrate Splunk in Your Informatica Cloud Instance

Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Splunk from Informatica Cloud.
Exact Online Reporting and Star Schemas in OBIEE

Create a star schema that shows perspectives on Exact Online facts in real time.
How to integrate Salesforce Data Cloud with Apache Airflow

Access and process Salesforce Data Cloud in Apache Airflow using the CData JDBC Driver.
Natively Connect to DB2 in PHP via ODBC (Linux)

Create PHP applications on Linux/UNIX machines with connectivity to IBM DB2. Leverage the native support for ODBC in PHP.
How to Work with Impala in AWS Glue Jobs Using JDBC

Connect to Impala from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
Automate SAP HANA Tasks in Power Automate Using CData API Server

With CData API Server, easily create OData endpoints for live SAP HANA and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
Integrate with Live Azure Active Directory in MuleSoft (via CData Connect Cloud)

Use CData Connect Cloud to connect to Azure Active Directory from the MuleSoft Anypoint Platform to integrate live Azure Active Directory into custom reports and dashboards.
Use the CData Software JDBC Driver for EventBrite in MicroStrategy

Connect to Eventbrite in MicroStrategy Developer using the CData Software JDBC Driver for EventBrite.
Analyze Instagram with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Instagram from Power Pivot. You will use the Table Import Wizard to load Instagram. You can visually build the import query or use any SQL supported by the driver.
Seamlessly Bring Salesforce Marketing into Retool Using CData Connect Cloud

Integrate Salesforce Marketing data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.
How to Import Data from Reckon Accounts Hosted into Google Sheets

Import Reckon Accounts Hosted into a Google spreadsheet that is automatically refreshed.
Visualize Azure Table in Sisense

Create an ElastiCube in Sisense app with access to Azure Table Storage.
Use the CData Software JDBC Driver for Clio in MicroStrategy

Connect to Clio in MicroStrategy Developer using the CData Software JDBC Driver for Clio.
Microsoft Planner Reporting in OBIEE with the Microsoft Planner JDBC Driver

Deploy the Microsoft Planner JDBC driver on OBIEE to provide real-time reporting across the enterprise.
How to connect to Klaviyo from Spring Boot

Connect to Klaviyo in a Spring Boot Application using CData JDBC Klaviyo Driver
Build MVC Applications with Connectivity to Sage Cloud Accounting

This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Sage Cloud Accounting from an ASP.NET MVC application.
How to pipe Microsoft Teams to CSV in PowerShell

Use standard PowerShell cmdlets to access Microsoft Teams tables.
Create SSAS Tabular Models from OData Services

How to build a SQL Server Analysis Service Tabular Model from OData using CData drivers.
Access Live JotForm in SAS JMP via ODBC

You can use the CData ODBC Driver to integrate JotForm into the statistical analysis tools available in SAS JMP. This article shows how to use JotForm in the Graph Builder and Query Builder.
Stream Exact Online into Apache Kafka Topics

Access and stream Exact Online in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
Connect to Jira Service Management in DBArtisan

Use wizards in DBArtisan to configure Atlassian Jira Service Management as a data source.
How to update Couchbase from Excel

This article explains how to transfer data from Excel to Couchbase using the Excel Add-In for Couchbase.
Migrating data from Oracle Sales to Snowflake using CData SSIS Components.

Easily push Oracle Sales to Snowflake using the CData SSIS Tasks for Oracle Sales and Snowflake.
Use the CData Software ODBC Driver for Printful in MicroStrategy Desktop

Connect to Printful in MicroStrategy Desktop using the CData Software ODBC Driver for Printful.
Manage Coinbase in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for Coinbase.
Build Reckon-Connected Apps in Bubble

Use CData Connect Cloud to create an OData feed for Reckon and create custom apps in Bubble.
Design BIRT Reports on OData Services

Provide current OData to your embedded analytics.
Connect to Reckon Accounts Hosted 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 Reckon Accounts Hosted.
How to connect to Blackbaud FE NXT with Squirrel SQL client

Connect to Blackbaud FE NXT and execute queries in the Squirrel SQL Client.
Build Automated Azure Active Directory-Connected Workflows in Zapier

Use CData Connect Cloud to connect to live Azure Active Directory and build automated workflows in Zapier.
Create Dynamic Cassandra Grids Using the Infragistics XamDataGrid

Learn how you can connect Cassandra to Infragistics XamDataGrid to build dynamic grids.
Integrate Live Amazon DynamoDB into Amazon SageMaker Canvas with RDS

Use CData Connect Cloud to connect to Amazon DynamoDB from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Amazon DynamoDB.
How to Import Data from Square into Google Sheets

Import Square into a Google spreadsheet that is automatically refreshed.
Visualize Live Cloudant in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live IBM Cloudant.
Work with Live Facebook in Power Query

Use CData Connect Cloud to connect to Facebook and work with live Facebook in Microsoft Power Query.
Automated Continuous Access Replication to OneLake in Microsoft Fabric

Use CData Sync for automated, continuous, customizable Microsoft Access replication to OneLake in Microsoft Fabric.
Connect to Acumatica from Crystal Reports

Use CData Connect Cloud to connect to and report on live Acumatica ERP from Crystal Reports.
How to Access Square Using Entity Framework

This article shows how to access Square using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
How to create Parquet federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Apache Parquet in MySQL .
Bill an Invoice with the CData Excel Add-In for QuickBooks

The CData Excel Add-In for QuickBooks makes it easy to transfer data in and out of QuickBooks Desktop and QuickBooks Online. In this article, you will create an Invoice spreadsheet that can be sent to customers. Customers can then insert the Invoice data as Bills to their company files or their company on QuickBooks Online.
Use the CData Software JDBC Driver for Quickbase in MicroStrategy

Connect to Quickbase in MicroStrategy Developer using the CData Software JDBC Driver for Quickbase.
Access Live Sugar CRM in Coginiti Pro

Connect to and query live Sugar CRM from the GUI in the Coginiti Pro: SQL Analytics Tool.
Access Live Confluence in Excel (Desktop) through Connect Spreadsheets

Use Connect Spreadsheets by CData to gain access to live Atlassian Confluence from your Excel spreadsheets.
Connect to SAP Concur in DigitalSuite Studio through RunMyProcess DSEC

Use Arkobi Digital
Connect to Google Calendar as a Linked Server via SQL Gateway

Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Calendar.
Build Automated Workflows with Live CockroachDB in Workato

Use CData Connect Cloud to connect to live CockroachDB and build automated workflows in Workato.
Automated Google Analytics Replication to Teradata

Use CData Sync to Customize and automate Google Analytics replication to Teradata.
Integrate Live Cvent into Blue Prism for Intelligent Robotic Process Automation (RPA)