CData Software - Knowledge Base

Recent Articles

• «
• 304
• 305
• 306
• 307
• 308
• 309
• 310
• 311
• 312
• 313
• »

• Create Reports with JotForm in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date JotForm.

• Use the CData Software JDBC Driver for QuickBooks in MicroStrategy Desktop

  Connect to QuickBooks Desktop in MicroStrategy Desktop using the CData Software JDBC Driver for QuickBooks.

• How to connect to SharePoint Excel Services with Squirrel SQL client

  Connect to SharePoint Excel Services and execute queries in the Squirrel SQL Client.

• Build MVC Applications with Connectivity to Google Ads

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

• Analyze Xero in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of Xero Accounting and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

• How to Connect to Live Google Sheets in n8n Workflows and Agents (via CData Connect Cloud)

  Leverage the CData Connect Cloud Remote MCP Server to enable n8n to securely read and take actions on your Google Sheets for you.

• Connect to REST in Ruby

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

• Connect and Query Live Cloudant Data in Databricks with CData Connect Cloud

  Use CData Connect Cloud to integrate live IBM Cloudant into Databricks

• Natively Connect to Sage 50 UK in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Sage 50 UK. Leverage the native support for ODBC in PHP.

• ETL Microsoft Teams in Oracle Data Integrator

  This article shows how to transfer Microsoft Teams into a data warehouse using Oracle Data Integrator.

• Connect to Microsoft Planner in ACL Analytics

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

• Create Datasets from Gmail in Domo Workbench and Build Visualizations of Gmail in Domo

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

• Add Oracle Financials Cloud to Informatica Enterprise Data Catalog

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

• Build Semantic Layer Views for Zoho Books in APOS Live Data Gateway

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

• How to connect to Twitter Ads with Squirrel SQL client

  Connect to Twitter Ads and execute queries in the Squirrel SQL Client.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP Ariba Procurement

  Provide connectivity to SAP Ariba Procurement through an SAP BusinessObjects universe.

• Automated Continuous SAP HANA Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable SAP HANA replication to Amazon S3.

• Integrate Authorize.Net in the Pentaho Report Designer

  Publish reports based on Authorize.Net in the Pentaho BI tool.

• Access Live IBM Informix in Excel (Desktop) via Connect Cloud

  Use CData Connect Cloud to gain access to live IBM Informix from your Excel spreadsheets.

• Connect to Elasticsearch in DBArtisan

  Use wizards in DBArtisan to configure Elasticsearch as a data source.

• Query DB2 through ODBC in Node.js

  Use node-odbc to execute SQL queries against IBM DB2 from Node.js.

• Edit and Search Quickbase External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of Quickbase to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Quickbase objects that you can access from apps and the dashboard.

• Use the CData Software JDBC Driver for Dynamics 365 in MicroStrategy

  Connect to Microsoft Dynamics 365 in MicroStrategy Developer using the CData Software JDBC Driver for Dynamics 365.

• Build Semantic Layer Views for Sage 300 in APOS Live Data Gateway

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

• Create Twitter Dataflows on PowerBI.com

  Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

• Excel Spreadsheet Automation on Shopify with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Replicate CSV from PowerShell

  Write a quick PowerShell script to query CSV/TSV Files. Use connectivity to the live data to replicate CSV/TSV Files to SQL Server.

• Build Automated Oracle SCM-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live Oracle SCM and build automated workflows in Zapier.

• How to integrate Metabase with Oracle Service Cloud

  Use CData Connect Cloud to connect to live Oracle Service Cloud and create an interactive dashboard in Metabase from Oracle Service Cloud.

• Building Dynamic Web Pages with Office 365 Using AngularJS

  Create single-page applications with live connectivity to Office 365 using the CData API Server.

• Connect to SAP SuccessFactors in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for SAP SuccessFactors in Airbyte.

• Natively Connect to Basecamp in PHP

  The CData ODBC driver for Basecamp enables you to create PHP applications with connectivity to Basecamp. Leverage the native support for ODBC in PHP.

• How to import Trello into Apache Solr

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

• Use the CData Software JDBC Driver for Epicor Kinetic in MicroStrategy Desktop

  Connect to Epicor Kinetic in MicroStrategy Desktop using the CData Software JDBC Driver for Epicor Kinetic.

• 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.

• Migrating data from Trello to Snowflake using CData SSIS Components.

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

• Natively Connect to Access in PHP

  The CData ODBC driver for Access enables you to create PHP applications with connectivity to Microsoft Access. Leverage the native support for ODBC in PHP.

• Access CouchDB from MySQL in Amazon QuickSight

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

• How to Seamlessly Import Harvest Data into IBM SPSS Modeler

  Integrate Harvest data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Connect to Microsoft Teams from HeidiSQL

  Use CData Connect Cloud to connect to and query live Microsoft Teams from HeidiSQL.

• Use the CData Software ODBC Driver for Aha in MicroStrategy Web

  Connect to Aha! in MicroStrategy Web using the CData Software ODBC Driver for Aha.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed Invoiced to Power BI dashboards. Simply drag and drop Invoiced into data visuals on the Power BI canvas.

• Create Dynamic Cosmos DB Grids Using the Infragistics XamDataGrid

  Learn how you can connect Cosmos DB to Infragistics XamDataGrid to build dynamic grids.

• Write a Simple Go Application to work with BigQuery on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google BigQuery.

• Create Data Visualizations in Cognos BI with WordPress

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

• Import Real-Time Act CRM via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Act CRM in ColdFusion.

• Connect to Power BI XMLA from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Power BI XMLA to connect to Power BI XMLA from Web applications running on WebLogic.

• How to Work with Procore in ETL Validator JDBC

  Connect to Procore from ETL Validator jobs using the CData Software JDBC Driver.

• Access Greenhouse in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Greenhouse.

• Build PostgreSQL-Connected Apps in Mendix

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

• Visualize Live HubSpot of Power BI Report Builder in Power BI Service

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

• Import Real-Time ClickUp via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use ClickUp in ColdFusion.

• Model, Search, and Visualize Live Splunk in ThoughtSpot

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

• Building Dynamic Web Pages with Aha Using AngularJS

  Create single-page applications with live connectivity to Aha using the CData API Server.

• Build SAP Ariba Source Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live SAP Ariba Source and build visualizations in Tableau Cloud.

• How to load Authorize.Net data into Elasticsearch via Logstash

  Introducing a simple method to load Authorize.Net data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• How to Work with Cloudant in ETL Validator JDBC

  Connect to Cloudant from ETL Validator jobs using the CData Software JDBC Driver.

• Connect Trello to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Trello using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• How to create Amazon Marketplace federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Amazon Marketplace in MySQL .

• Use the CData ODBC Driver for Todoist in Microsoft Power Query

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

• Configure the CData JDBC Driver for Outreach.io in a Connection Pool in Tomcat

  Connect to Outreach.io from a connection pool in Tomcat.

• Connect to WooCommerce as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for WooCommerce.

• Build Apps with Live Sugar CRM in Adalo using CData Connect Cloud

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

• Build Raisers Edge NXT-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Raisers Edge NXT.

• Analyze Instagram in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Instagram and visualize Instagram in SAP Analytics Cloud.

• Connect to Live Jira Service Management in MicroStrategy through CData Connect Cloud

  Create a live connection to Jira Service Management in CData Connect Cloud and connect to your Atlassian Jira Service Management from MicroStrategy.

• Connect to Microsoft Project in HULFT Integrate

  Connect to Microsoft Project as a JDBC data source in HULFT Integrate

• Automated LinkedIn Ads Replication to Teradata

  Use CData Sync to Customize and automate LinkedIn Ads replication to Teradata.

• Automated Continuous MariaDB Replication to Vertica

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

• Integrate with live Smartsheet in Jitterbit

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

• Publish SAP Concur-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live SAP Concur.

• How to create an RPA flow for Cassandra in UiPath Studio

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

• How to connect SharePoint with PostgreSQL through external lists

  Provide PostgreSQL to SharePoint users as an external list.

• Integrate with Odoo in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Odoo ERP in SnapLogic.

• Integrate JSON with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate JSON with External Services.

• Use CData Connect Cloud to Access SAP BusinessObjects BI in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live SAP BusinessObjects BI in the Power Pivot business intelligence tool.

• How to integrate Microsoft Planner with Apache Airflow

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

• Use JayDeBeApi to access Salesforce Data Cloud in Python

  Use standard Python scripting and the development environment of your choice to access live Salesforce Data Cloud.

• Automated Continuous Unbounce Replication to OneLake in Microsoft Fabric

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

• Connect to Acumatica from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Acumatica to connect to Acumatica ERP and execute queries in PowerBuilder.

• Choosing the Best Method to Connect QuickBooks Time to SQL Server: 5 Options Explained

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

• Load Facebook Ads to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Facebook Ads to a database.

• Automated Continuous EventBrite Replication to IBM DB2

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

• How to update PostgreSQL from Excel

  This article explains how to transfer data from Excel to PostgreSQL using the Excel Add-In for PostgreSQL.

• How to Connect to Live GraphQL in n8n Workflows and Agents (via CData Connect Cloud)

  Leverage the CData Connect Cloud Remote MCP Server to enable n8n to securely read and take actions on your GraphQL for you.

• Replicate Multiple Kintone Accounts via the CData Sync CLI

  Replicate multiple Kintone accounts to one or many databases.

• Connect to and Query SAP Hybris C4C in QlikView over ODBC

  Create data visualizations with SAP Hybris C4C in QlikView.

• Create a Data Access Object for SAP Ariba Source using JDBI

  A brief overview of creating a SQL Object API for SAP Ariba Source in JDBI.

• Build an OLAP Cube in SSAS from Shopify

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

• ETL Trello in Oracle Data Integrator

  This article shows how to transfer Trello into a data warehouse using Oracle Data Integrator.

• How to connect to SAP SuccessFactors from Spring Boot

  Connect to SAP SuccessFactors in a Spring Boot Application using CData JDBC SAP SuccessFactors Driver

• How to Visualize Power BI XMLA Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Power BI XMLA in Python.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Oracle Sales

  Provide connectivity to Oracle Sales through an SAP BusinessObjects universe.

• Excel Spreadsheet Automation on DB2 with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Build Tableau CRM Analytics Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Tableau CRM Analytics and build visualizations in Tableau.

• Build Semantic Layer Views for BigQuery in APOS Live Data Gateway

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

• Automate Xero Replication to Azure Data Lake

  Use CData Sync to customize and automate Xero Accounting replication to Azure Data Lake.

• Integrate GraphQL in Your Informatica Cloud Instance

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

• Use the CData API Server to Access SAP SuccessFactors in Microsoft PowerPivot

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

• Use the CData Software ODBC Driver for Avalara AvaTax in SAS for Real-Time Reporting and Analytics

  Connect to real-time Avalara AvaTax in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Avalara AvaTax.

• «
• 304
• 305
• 306
• 307
• 308
• 309
• 310
• 311
• 312
• 313
• »