CData Software - Knowledge Base

Recent Articles

• «
• 211
• 212
• 213
• 214
• 215
• 216
• 217
• 218
• 219
• 220
• »

• How to load Drip data into Elasticsearch via Logstash

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

• Connect to Cassandra in JRuby

  Create a simple JRuby app with access to live Apache Cassandra.

• Automated Continuous Cassandra Replication to Google BigQuery

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

• Analyze BigCommerce in Infragistics Reveal

  Use CData Connect Cloud to create on OData API on top of BigCommerce and visualize live BigCommerce in Infragistics Reveal.

• Automated Continuous xBase Replication to OneLake in Microsoft Fabric

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

• Build Automated Workflows with Live Odoo in Workato

  Use CData Connect Cloud to connect to live Odoo ERP and build automated workflows in Workato.

• Replicate Multiple IBM Informix Accounts

  Replicate multiple IBM Informix accounts to one or many databases.

• Create Zoho Books Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time Zoho Books data access from reports, embedded analytics, and more.

• Add Google Ads to Informatica Enterprise Data Catalog

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

• Query Odoo in ColdFusion

  Write standard ColdFusion data access code to connect to Odoo ERP.

• Access Live SingleStore Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live SingleStore data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• Edit and Search External GMO MakeShop Objects in Salesforce Connect

  Use CData Connect Cloud to securely provide OData feeds of GMO MakeShop to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create GMO MakeShop objects that you can access from apps and the dashboard.

• Query CSV using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume CSV entities in PHP by modeling them as objects.

• Replicate Multiple Invoiced Accounts via the CData Sync CLI

  Replicate multiple Invoiced accounts to one or many databases.

• Automated Continuous Sage 300 Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Sage 300 replication to Amazon S3.

• Connect to SAP ByDesign from AWS Glue

  Use CData Connect Cloud to gain access to live SAP Business ByDesign from your AWS Glue jobs.

• Connect to Pipedrive in Ruby

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

• Create Power BI Reports on Real-Time Google Analytics

  Use the CData ODBC Driver for Google Analytics to visualize Google Analytics in Power BI Desktop.

• Visualize Live Gmail in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live Gmail into custom reports in Power BI.

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

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

• Integrate Live Cosmos DB into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to Azure Cosmos DB and integrate live Azure Cosmos DB into apps built in Microsoft Power Apps.

• Replicate Multiple Amazon S3 Accounts via the CData Sync CLI

  Replicate multiple Amazon S3 accounts to one or many databases.

• How to connect PolyBase to DocuSign

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live DocuSign.

• Automated Continuous Harvest Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Harvest replication to PostgreSQL.

• Feed Act-On into FineReport

  How to set Act-On as a JDBC data source in FineReport.

• How to Connect the Power BI Service to Microsoft Teams: Complete Guide

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

• How to connect SharePoint with Instagram through external lists

  Provide Instagram to SharePoint users as an external list.

• Import LinkedIn Using Azure Data Factory

  Use CData Connect Cloud to connect to LinkedIn from Azure Data Factory and import live LinkedIn.

• Connect to Hive 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 Apache Hive.

• Build Sybase IQ-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Sybase IQ.

• Connect to Adobe Commerce in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for Adobe Commerce and connect to Adobe Commerce in Akorbi Digital RunMyProcess.

• Trigger WordPress IFTTT Flows in Azure App Service

  This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.

• Publish Okta-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Okta.

• How to Build an ETL App for Google Cloud Storage in Python with CData

  Create ETL applications and real-time data pipelines for Google Cloud Storage in Python with petl.

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

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

• Object-Relational Mapping (ORM) with Zuora Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Zuora into a Java-based ORM framework, Hibernate.

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for QuickBooks Time

  Provide connectivity to QuickBooks Time through an SAP BusinessObjects universe.

• Connect to and Query Sage 200 in QlikView over ODBC

  Create data visualizations with Sage 200 in QlikView.

• Manage Google Sheets in DBArtisan as a JDBC Source

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

• Build a Singer.io Tap for Airtable With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live Airtable data using

• Analyze API in Infragistics Reveal

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

• Automate Tableau CRM Analytics Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Tableau CRM Analytics and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Integrate Real-Time Access to GitHub in SAPUI5 MVC Apps

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

• How to Access Live Azure Table in Visual Studio Code via Cline

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

• Connect to Workday through External Services in Salesforce

  Use CData Connect Cloud to securely connect Salesforce External Services with Workday using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Automated Continuous Certinia Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Certinia replication to Amazon Redshift.

• Use the CData Software ODBC Driver for SQL Server in MicroStrategy

  Connect to Microsoft SQL Server in MicroStrategy Developer using the CData Software ODBC Driver for SQL Server.

• Access Live Microsoft Teams in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Microsoft Teams from your Excel spreadsheets.

• PowerShell Cmdlets Getting Started Guide

  A basic guide to using the CData PowerShell Cmdlets for Salesforce to access Salesforce data from within PowerShell.

• Query Sage Cloud Accounting through ODBC in Node.js

  Use node-odbc to execute SQL queries against Sage Business Cloud Accounting from Node.js.

• How to Connect to & Open Odoo in Microsoft Excel

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

• Integrate Kintone in the Pentaho Report Designer

  Publish reports based on Kintone in the Pentaho BI tool.

• Access Google Sheets from MySQL in Amazon QuickSight

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

• Create Data Visualizations in Cognos BI with Bitbucket

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

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

  Use CData JDBC drivers to import and use Asana in ColdFusion.

• Integrate BigCommerce into Power Automate Desktop using CData Connect

  CData Connect for BigCommerce enables you to integrate BigCommerce into workflows built using Microsoft Power Automate Desktop.

• Analyze Quickbase in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Quickbase in Microsoft R Open.

• Automate QuickBooks Online Replication to Azure Data Lake

  Use CData Sync to customize and automate QuickBooks Online replication to Azure Data Lake.

• How to Work with eBay Analytics in AWS Glue Jobs Using JDBC

  Connect to eBay Analytics from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Rapidly Develop Dynamics CRM-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 Google Ad Manager to Multiple Databases

  Replicate Google Ad Manager to disparate databases with a point-and-click configuration.

• How to use SQLAlchemy ORM to access Google Sheets in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Sheets.

• Access SFTP from MySQL in HeidiSQL

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

• Connect to and Visualize Live Oracle Sales in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Oracle Sales.

• Integrate Printify in the Pentaho Report Designer

  Publish reports based on Printify in the Pentaho BI tool.

• Write a Simple Go Application to work with Dynamics CRM on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Dynamics CRM.

• Viewing Unbounce in RAD Studio Data Explorer

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

• Build Data Flows from SQL Server to Impala through SSIS

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

• Build Visualizations of QuickBooks Time in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of QuickBooks Time in Birst.

• Query Certinia using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume Certinia entities in PHP by modeling them as objects.

• Launch the CData Connect Azure Virtual Machine

  Host the Java edition of CData Connect on Microsoft Azure using the CData Connect Azure VM.

• Bind Live Outreach.io Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Outreach.io data

• Connect to Couchbase in JRuby

  Create a simple JRuby app with access to live Couchbase.

• How to Connect to & Open Printful in Microsoft Excel

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

• Migrating data from Snowflake to Google BigQuery using CData SSIS Components.

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

• Connect and Query Live Google Directory Data in Databricks with CData Connect Cloud

  Use CData Connect Cloud to integrate live Google Directory into Databricks

• Connect Authorize.Net to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Authorize.Net using the CData Python MCP Server.

• Connect to Phoenix in JRuby

  Create a simple JRuby app with access to live Apache Phoenix.

• Automated Continuous Avalara AvaTax Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Microsoft Access.

• Automated Continuous Oracle SCM Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Oracle SCM replication to Apache Kafka.

• Extend Google Sheets with Acumatica

  Make calls to the API Server from Google Apps Script.

• Seamlessly Bring Oracle into Retool Using CData Connect Cloud

  Integrate Oracle data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.

• Access Live Bullhorn CRM in AWS Lambda (with IntelliJ IDEA)

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

• Connect to Cassandra from a Connection Pool in Jetty

  The Cassandra JDBC Driver supports connection pooling: This article shows how to connect faster to Apache Cassandra from Web apps in Jetty.

• Connect to MailChimp in JRuby

  Create a simple JRuby app with access to live MailChimp.

• How to Connect to & Open IBM Informix in Microsoft Excel

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

• Use the CData ODBC Driver for Sage 50 UK from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Sage 50 UK to connect to Sage 50 UK from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Sage 50 UK in Excel.

• Access Live SharePoint in AWS Lambda

  Connect to live Microsoft SharePoint in AWS Lambda using the CData JDBC Driver.

• Import SAP Netweaver Gateway into Microsoft Power Query

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

• Integrate Live FTP into Blue Prism for Intelligent Robotic Process Automation (RPA)

• «
• 211
• 212
• 213
• 214
• 215
• 216
• 217
• 218
• 219
• 220
• »