CData Software Knowledge Base

Import Sybase into Microsoft Power Query

The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Sybase. In this article, you will use the OData format to import Sybase into Microsoft Power Query.

Integrate with live Cloudant in Jitterbit

Use CData Connect Cloud to connect to and integrate live IBM Cloudant in Jitterbit.

Create SSAS Tabular Models from Microsoft OneDrive

How to build a SQL Server Analysis Service Tabular Model from Microsoft OneDrive using CData drivers.

Replicate Multiple Sugar CRM Accounts via the CData Sync CLI

Replicate multiple Sugar CRM accounts to one or many databases.

Automate Tasks in Power Automate Using the CData Software API Server and Salesforce ADO.NET Provider

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

How to Connect to & Open Pipedrive in Microsoft Excel

This article uses the CData ODBC driver for Pipedrive to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

Use JayDeBeApi to access Zuora in Python

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

Process & Analyze REST in Databricks (AWS)

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

Add Databricks to Informatica Enterprise Data Catalog

Use the CData Software JDBC Driver for Databricks with the Informatica Enterprise Data Catalog to classify and organize data.

Build Greenplum-Connected Web Apps with Axios and CData Connect Cloud

Use CData Connect Cloud to connect to live Pivotal GreenPlum and build Greenplum-connected web apps with Axios.

Connect to Drip in RapidMiner

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

Connect to Snapchat Ads from Blazor Apps

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

Redis Reporting and Star Schemas in OBIEE

Create a star schema that shows perspectives on Redis facts in real time.

PowerShell Scripting to Replicate Reckon to MySQL

Write a simple PowerShell script to replicate Reckon to a MySQL database.

Process & Analyze Dynamics GP in Databricks (AWS)

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

Build Apps with Live Raisers Edge NXT in Adalo using CData Connect Cloud

Use CData Connect Cloud to integrate live Raisers Edge NXT into the Adalo platform and build custom mobile and web applications with real-time Raisers Edge NXT.

Connect to Zoho Books in RazorSQL

Connect to Zoho Books from wizards and query Zoho Books from the GUI in the RazorSQL database management tool.

View Reports on Real-Time Acumatica in Power BI Report Server

Use the CData ODBC Driver for Acumatica to visualize Acumatica ERP in Power BI Desktop and then publish them to Power BI Report Server.

Connect to Dynamics NAV in DBArtisan

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

Analyze SendGrid in R via JDBC

Use standard R functions and the development environment of your choice to analyze SendGrid with the CData JDBC Driver for SendGrid.

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

Access QuickBooks Custom Fields in Excel

Update custom fields in QuickBooks using the CData Excel Add-In for QuickBooks.

Connect to Snapchat Ads in HULFT Integrate

Connect to Snapchat Ads as a JDBC data source in HULFT Integrate

Deploy the ADO.NET Provider for Google Cloud Storage on an SSRS Report Server

Connect to Google Cloud Storage 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.

Create Oracle Eloqua-Connected Nintex Workflows

Use CData Connect Cloud to connect to Oracle Eloqua from Nintex Workflow Cloud and build custom workflows using live Oracle Eloqua.

Build Google Calendar-Connected Web Apps with Axios and CData Connect Cloud

Use CData Connect Cloud to connect to live Google Calendar and build Google Calendar-connected web apps with Axios.

How to Visualize Twilio Data in Python with pandas

Use pandas and other modules to analyze and visualize live Twilio in Python.

Replicate BambooHR for Use in Salesforce Connect

Replicate BambooHR to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

Twitter Reporting and Star Schemas in OBIEE

Create a star schema that shows perspectives on Twitter facts in real time.

Visualize Live Exact Online of Power BI Report Builder in Power BI Service

Use CData Power BI Connectors to connect to live Exact Online using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

Automated Continuous MariaDB Replication to Google BigQuery

Use CData Sync for automated, continuous, customizable MariaDB replication to Google BigQuery.

Replicate Oracle Eloqua to Multiple Databases

Replicate Oracle Eloqua to disparate databases with a point-and-click configuration.

Automated Continuous MariaDB Replication to IBM DB2

Use CData Sync for automated, continuous, customizable MariaDB replication to IBM DB2.

Connect to Microsoft OneDrive in Jaspersoft Studio

Execute SQL to remote Microsoft OneDrive in Jaspersoft Studio.

Query Oracle SCM through ODBC in Node.js

Use node-odbc to execute SQL queries against Oracle SCM from Node.js.

Automate Box Replication to Azure Synapse

Use CData Sync to customize and automate Box replication to Azure Synapse.

Zendesk Reporting in OBIEE with the Zendesk JDBC Driver

Deploy the Zendesk JDBC driver on OBIEE to provide real-time reporting across the enterprise.

Create Data Visualizations in Cognos BI with Microsoft Planner

Access Microsoft Planner as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

Manage MarkLogic in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for MarkLogic.

Analyze Confluence with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Confluence from Power Pivot. You will use the Table Import Wizard to load Atlassian Confluence. You can visually build the import query or use any SQL supported by the driver.

Connect to Bing Search Results in Ruby

Connect to Bing Search in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

CData Software - Knowledge Base

Recent Articles