CData Software Knowledge Base

Using the CData Software ODBC Driver for WordPress in PyCharm

Connect to WordPress as an ODBC data source in PyCharm using the CData Software ODBC Driver for WordPress.

Visualize Live MarkLogic of Power BI Report Builder in Power BI Service

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

Create Facebook-Connected Nintex Workflows

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

Visualize SendGrid in TIBCO Spotfire through ADO.NET

Integrate SendGrid into dashboards in TIBCO Spotfire.

Integrate with Live Instagram in MuleSoft (via CData Connect Cloud)

Use CData Connect Cloud to connect to Instagram from the MuleSoft Anypoint Platform to integrate live Instagram into custom reports and dashboards.

Integrate Live JotForm into Custom Business Apps Built in Power Apps

Use CData Software Connect Server to create a virtual SQL Server Database for JotForm and integrate live JotForm into apps built in Microsoft Power Apps.

Connect to Drift in Google Apps Script via SQL Gateway

Use the ODBC Driver for Drift and the SQL Gateway to access Drift from Google Apps Script.

Query Dynamics 365 Business Central in DataGrip

Create a Data Source for Dynamics 365 Business Central in DataGrip and use SQL to query live Dynamics 365 Business Central.

Automated Continuous Microsoft OneLake Replication to Azure SQL

Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to Azure SQL.

Automated Continuous Pinterest Replication to Azure SQL

Use CData Sync for automated, continuous, customizable Pinterest replication to Azure SQL.

Build Dashboards with Salesforce Marketing in Dundas BI

Create dynamic dashboards and perform analytics based on Salesforce Marketing Cloud in Dundas BI.

Query Dropbox in ColdFusion

Write standard ColdFusion data access code to connect to Dropbox.

Connect to Salesforce Marketing in SpagoBI

Create reports featuring live Salesforce Marketing Cloud in SpagoBI Studio. Host Salesforce Marketing reports on SpagoBI Server.

Connect to Zoho Books from HeidiSQL

Use CData Connect Cloud to connect to and query live Zoho Books from HeidiSQL.

Model, Search, and Visualize Live ShipStation in ThoughtSpot

Use CData Connect Cloud to connect to live ShipStation for modeling, searching, and visualizing.

Author and Share Power BI Reports on Real-Time Zenefits

Use the CData ODBC Driver for Zenefits to visualize Zenefits in Power BI Desktop and then upload to the Power BI service.

Automated Continuous Reckon Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable Reckon replication to Google Cloud SQL.

Connect to Wave Financial from a Connection Pool in WebLogic

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

Stream Asana into Apache Kafka Topics

Access and stream Asana in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

Build SAP Hybris C4C-Connected Apps in Bubble

Use CData Connect Cloud to create an OData feed for SAP Hybris C4C and create custom apps in Bubble.

Extract, Transform, and Load Act-On in Informatica PowerCenter

Create a simple Workflow for Act-On in Informatica PowerCenter.

Use the CData ODBC Driver for WordPress in Microsoft Power Query

You can use the CData WordPress ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import WordPress into Microsoft Power Query.

Build an OLAP Cube in SSAS from Amazon S3

Establish a connection to Amazon S3 data from SQL Server Analysis Services, and use the Amazon S3 Data Provider to build OLAP cubes for use in analytics and reporting.

Author and Share Power BI Reports on Real-Time Google Search Results

Use the CData ODBC Driver for Google Search to visualize Google Search in Power BI Desktop and then upload to the Power BI service.

Connect to Salesforce Marketing from AWS Glue

Use CData Connect Cloud to gain access to live Salesforce Marketing Cloud from your AWS Glue jobs.

Connect to SAP Netweaver Gateway in RazorSQL

Connect to SAP Netweaver Gateway from wizards and query SAP Netweaver Gateway from the GUI in the RazorSQL database management tool.

Analyze Microsoft Dataverse in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of Microsoft Dataverse (CDS) and visualize Microsoft Dataverse (CDS) in SAP Analytics Cloud.

Query MySQL in MySQL Workbench

Create a virtual MySQL database for MySQL in CData Software Connect (or Connect Server) and work with live MySQL in MySQL Workbench.

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

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

Automated Continuous Adobe Commerce Replication to Google BigQuery

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

DataBind ConstantContact to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for ConstantContact with the DevExpress Windows Forms and Web controls to provide ConstantContact to a chart.

Integrate Google Spanner in Your Informatica Cloud Instance

Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google Spanner from Informatica Cloud.

Automated Continuous Veeva Vault Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable Veeva Vault replication to Google Cloud SQL.

Build a Simple VCL Application for Microsoft Exchange

How to build a simple VCL Application to view Microsoft Exchange in RAD Studio using the CData ODBC Driver for Microsoft Exchange.

How to integrate Freshdesk with Apache Airflow

Access and process Freshdesk in Apache Airflow using the CData JDBC Driver.

Access Sugar CRM from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live Sugar CRM from HeidiSQL.

How to integrate Zoho Books with Apache Airflow

Access and process Zoho Books in Apache Airflow using the CData JDBC Driver.

Connect to Google Calendar as an External Source in Dremio

Use the CData JDBC Driver to connect to Google Calendar as an External Source in Dremio.

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.

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

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

Build Epicor Kinetic-Connected Apps in Bubble

Use CData Connect Cloud to create an OData feed for Epicor Kinetic and create custom apps in Bubble.

Integrate Asana in Your Informatica Cloud Instance

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

Connect to Dynamics 365 Business Central in Jaspersoft Studio

Execute SQL to remote Dynamics 365 Business Central in Jaspersoft Studio.

Replicate Active Directory to Multiple Databases via the CData Sync CLI

Replicate Active Directory to disparate databases with a single configuration.

Replicate Act-On from PowerShell

Write a quick PowerShell script to query Act-On. Use connectivity to the live data to replicate Act-On to SQL Server.

DataBind Controls to ClickUp in C++Builder

DataBind to ClickUp in C++Builder with standard components and controls.

How to Connect the Power BI Service to Google Ad Manager: Complete Guide

Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

Integrate Real-Time Access to Shopify in SAPUI5 MVC Apps

Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Shopify in real time.

Microsoft Project Reporting and Star Schemas in OBIEE

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

Visualize Live Bing Ads of Power BI Report Builder in Power BI Service

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

Automated Continuous SharePoint Replication to Snowflake

Use CData Sync for automated, continuous, customizable SharePoint replication to Snowflake.

How to connect Amazon QuickSight to Sage 200

Create a connection to Sage 200 in CData Connect Cloud and insert Sage 200 into Amazon QuickSight SPICE to build interactive dashboards.

PowerShell Scripting to Replicate MarkLogic to MySQL

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

How to connect Amazon QuickSight to Cloudant

Create a connection to IBM Cloudant in CData Connect Cloud and insert IBM Cloudant into Amazon QuickSight SPICE to build interactive dashboards.

How to Build Dynamic React Apps with XML

Use the CData Connect and React to Build Dynamic Web Apps with Live XML .

Integrate Live Stripe into Amazon SageMaker Canvas with RDS

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

Automated Continuous QuickBooks Online Replication to Apache Kafka

Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Apache Kafka.

Use the CData Software JDBC Driver for ShipStation in MicroStrategy

Connect to ShipStation in MicroStrategy Developer using the CData Software JDBC Driver for ShipStation.

Access Live SharePoint in Excel 365 Online (Excel for the web)

Connect to Microsoft SharePoint from Excel 365 Online (Excel for the web) with CData Connect Cloud.

Feed Oracle Sales into FineReport

How to set Oracle Sales as a JDBC data source in FineReport.

Connect to SAP Concur in DigitalSuite Studio through RunMyProcess DSEC

Use Arkobi Digital

Connect to SurveyMonkey from Filemaker Pro (Mac)

Use CData Connect Cloud to connect to and query live SurveyMonkey from Filemaker Pro on Mac.

Connect to Microsoft Planner in JRuby

Create a simple JRuby app with access to live Microsoft Planner.

DataBind HubSpot to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for HubSpot with the DevExpress Windows Forms and Web controls to provide HubSpot to a chart.

Connect to Neo4J from Asprova with CData Software ODBC Driver for Neo4J

This article shows how to connect faster to Neo4J data from Asprova.

Xero Cloud Connectivity

Explore a compilation of guides and tutorials demonstrating how to establish connections to Xero Accounting through CData Connect Cloud using different applications and tools.

Build Data Flows from SQL Server to Redis through SSIS

Easily push SQL Server data to Redis using the CData SSIS Tasks for Redis.

Automated Continuous Reckon Accounts Hosted Replication to IBM DB2

Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to IBM DB2.

Connect to and Query Act-On in QlikView over ODBC

Create data visualizations with Act-On in QlikView.

Using the CData Software ODBC Driver for Clio in PyCharm

Connect to Clio as an ODBC data source in PyCharm using the CData Software ODBC Driver for Clio.

Build Dashboards with eBay Analytics in Dundas BI

Create dynamic dashboards and perform analytics based on eBay Analytics in Dundas BI.

How to Access Live Hive in Power Automate Desktop via ODBC

The CData ODBC Driver for Hive enables you to integrate Apache Hive into workflows built using Microsoft Power Automate Desktop.

Connect to WordPress as a SQL Server Linked Server

Use CData Connect Cloud to create a linked server for live WordPress.

Splunk Reporting and Star Schemas in OBIEE

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

Automated Continuous Zuora Replication to OneLake in Microsoft Fabric

Use CData Sync for automated, continuous, customizable Zuora replication to OneLake in Microsoft Fabric.

How to use SQLAlchemy ORM to access Aha in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Aha!.

Build Automated Workflows with Live Azure Active Directory in Workato

Use CData Connect Cloud to connect to live Azure Active Directory and build automated workflows in Workato.

Automated Continuous Excel Online Replication to Databricks

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

Connect to Instagram in Google Apps Script via SQL Gateway

Use the ODBC Driver for Instagram and the SQL Gateway to access Instagram from Google Apps Script.

CData Software - Knowledge Base

Recent Articles