CData Software - Knowledge Base

Recent Articles

• «
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• »

• Connect to Live Xero in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Xero in CData Connect Cloud and connect to your Xero Accounting from PostgreSQL.

• Viewing Xero in RAD Studio Data Explorer

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

• How to integrate Todoist with Apache Airflow

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

• Automated Continuous Trello Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Trello replication to SingleStore.

• Analyze Clio in Infragistics Reveal

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

• Use the CData Software ODBC Driver for Paylocity in MicroStrategy

  Connect to Paylocity in MicroStrategy Developer using the CData Software ODBC Driver for Paylocity.

• Connect to Microsoft Exchange from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Microsoft Exchange from Crystal Reports.

• Build Interactive Dashboards from Phoenix in Amazon QuickSight

  Create a virtual SQL Server database for Apache Phoenix in CData Software Connect Server and import Apache Phoenix into Amazon QuickSight SPICE to build interactive dashboards.

• Validate ServiceNow with QuerySurge

  Access and validate ServiceNow in QuerySurge using the CData JDBC Driver.

• SAP HANA Cloud Connectivity

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

• Extract, Transform, and Load Dynamics CRM in Informatica PowerCenter

  Create a simple Workflow for Microsoft Dynamics CRM in Informatica PowerCenter.

• Integrate Real-Time Access to SQL Analysis Services in SAPUI5 MVC Apps

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

• Create Klipfolio-Connected Nintex Workflows

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

• Create Data Visualizations in Cognos BI with Trello

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

• Connect to PayPal from a Connection Pool in JBoss

  Integrate PayPal into Java servlets: Use the Management Console in JBoss to install the PayPal JDBC Driver.

• Connect to Redshift in Google Apps Script

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

• Connect to Epicor Kinetic from PowerBuilder

  This article demonstrates how to access Epicor Kinetic from PowerBuilder using the Epicor Kinetic JDBC Driver.

• Integrate with Live Jira Service Management in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Jira Service Management from the MuleSoft Anypoint Platform to integrate live Atlassian Jira Service Management into custom reports and dashboards.

• Automated Continuous Amazon Marketplace Replication to Vertica

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

• Natively Connect to BigCommerce in PHP

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

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

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

• Connect to Greenhouse in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Build YouTube Analytics-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to YouTube Analytics from Zoho Analytics and import live YouTube Analytics.

• Connect to and Query Exact Online in QlikView over ODBC

  Create data visualizations with Exact Online in QlikView.

• Perform Batch Operations with Couchbase in Apache NiFi

  Connect to Couchbase and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Create SSAS Tabular Models from Paylocity

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

• Viewing BigCommerce in RAD Studio Data Explorer

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

• Connect to JDBC-ODBC Bridge in the Denodo Platform

  Use CData driver technologies to create a virtual data source for JDBC-ODBC Bridge in the Denodo Virtual DataPort Administrator.

• Build Automated Presto-Connected Workflows in Zapier

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

• Use the CData Software JDBC Driver for Quickbase in MicroStrategy Web

  Connect to Quickbase in MicroStrategy Web using the CData Software JDBC Driver for Quickbase.

• Integrate with GitHub in SnapLogic

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

• Query QuickBooks Time through ODBC in Node.js

  Use node-odbc to execute SQL queries against QuickBooks Time from Node.js.

• Edit and Search NetSuite External Objects in Salesforce

  Consume NetSuite objects in Salesforce filter lists.

• Enable the Google Spanner JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Google Spanner.

• How to connect to Dynamics NAV in DBVisualizer

  Integrate Microsoft Dynamics NAV with visual data analysis tools and data connection wizards in DBVisualizer

• Automated Continuous Snapchat Ads Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Apache Cassandra.

• How to create Visio diagrams from BigQuery

  Automatically update Google BigQuery with the changes you make to Visio master shapes.

• Connect to Sage 300 from Asprova with CData Software ODBC Driver for Sage 300

  This article shows how to connect faster to Sage 300 data from Asprova.

• Connect to Cosmos DB in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Azure Cosmos DB in the Denodo Virtual DataPort Administrator.

• DataBind Wijmo Grid to CouchDB

  Provide real-time Apache CouchDB to interactive controls.

• Create Kintone-Connected Nintex Workflows

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

• Object-Relational Mapping (ORM) with Slack 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 Slack into a Java-based ORM framework, Hibernate.

• Using CData ODBC drivers from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC drivers to connect to an external data source from Excel spreadsheets in SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards in their Excel spreadsheets using data from sources like Salesforce, QuickBooks, Dynamics CRM and many more.

• Connect to Shippo in Jaspersoft Studio

  Execute SQL to remote Shippo in Jaspersoft Studio.

• Build SAS xpt-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to SAS XPORT and build web apps with connectivity to live SAS XPORT.

• Connect to QuickBooks Online in CloverDX (formerly CloverETL)

  Transfer QuickBooks Online using the visual workflow in the CloverDX data integration tool.

• Automated Continuous LDAP Replication to Google BigQuery

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

• Model, Search, and Visualize Live Active Directory in ThoughtSpot

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

• Integrate Redshift in Your Informatica Cloud Instance

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

• Visualize Oracle Service Cloud in Sisense

  Create an ElastiCube in Sisense app with access to Oracle Service Cloud.

• Automate Zoho Books Replication to Couchbase

  Use CData Sync to Customize and automate Zoho Books replication to Couchbase.

• Connect to Excel Online from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Excel Online to connect to Microsoft Excel Online from Web applications running on WebLogic.

• Stream Twitter into Apache Kafka Topics

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

• Connect to WooCommerce in RunMyProcess through Connect Cloud

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

• Use the CData Software ODBC Driver for SAP Ariba Procurement in SAS for Real-Time Reporting and Analytics

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

• Use Dash to Build to Web Apps on HBase

  Create Python applications that use pandas and Dash to build HBase-connected web apps.

• Create Data Visualizations in Cognos BI with Adobe Commerce

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

• Analyze Azure Data Catalog in SAP Analytics Cloud

  Use the CData Connect Server to create an OData API on top of Azure Data Catalog and visualize Azure Data Catalog in SAP Analytics Cloud.

• Automated Continuous Shopify Replication to Vertica

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

• Analyze Coinbase with Power Pivot

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

• Connect to Salesforce Marketing from AWS Glue

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

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

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

• LINQ to DocuSign

  LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the DocuSign Data Provider.

• How to publish and share Access dashboards with Tableau Server

  The CData ODBC driver for Access enables you integrate Microsoft Access into Tableau dashboards.

• Visualize Tableau CRM Analytics in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Tableau CRM Analytics into TIBCO Spotfire.

• Use the CData SSIS Components to Insert New or Update Existing Reckon Accounts Hosted Records from SQL Server

  Easily push SQL Server data to Reckon Accounts Hosted using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Reckon Accounts Hosted or update existing records with data from a SQL Server database.

• Automated Continuous Salesforce Pardot Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to AlloyDB.

• Connect to Elasticsearch in Google Apps Script

  Use CData Connect Cloud to access Elasticsearch in Google Apps Script.

• Connect to Avro in SpagoBI

  Create reports featuring live Apache Avro in SpagoBI Studio. Host Avro reports on SpagoBI Server.

• How to Build an ETL App for GitHub in Python with CData

  Create ETL applications and real-time data pipelines for GitHub in Python with petl.

• Connect to NetSuite in Jaspersoft Studio

  Execute SQL to remote NetSuite CRM & ERP in Jaspersoft Studio.

• Build Semantic Layer Views for Wave Financial in APOS Live Data Gateway

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

• Connect to Unbounce in NetBeans

  Connect to Unbounce in NetBeans with the data source configuration wizard.

• How to Connect the Power BI Service to Gmail: Complete Guide

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

• How to Build Dynamic React Apps with BambooHR

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

• Automated Continuous PayPal Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable PayPal replication to delimited files (CSV/TSV).

• How to Access Live Zoho Inventory in Power Automate Desktop via ODBC

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

• Import and Visualize Greenhouse in Power View

  Create data visualizations based on Greenhouse in Excel.

• Connect to SAP Netweaver Gateway in SpagoBI

  Create reports featuring live SAP Netweaver Gateway in SpagoBI Studio. Host SAP Netweaver Gateway reports on SpagoBI Server.

• Stream Google Data Catalog into Apache Kafka Topics

  Access and stream Google Data Catalog in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Extract, Transform, and Load Pinterest in Informatica PowerCenter

  Create a simple Workflow for Pinterest in Informatica PowerCenter.

• Access Office 365 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 Microsoft Office 365.

• Use the CData Software ODBC Driver for HCL Domino in MicroStrategy

  Connect to HCL Domino in MicroStrategy Developer using the CData Software ODBC Driver for HCL Domino.

• Integrate with live ServiceNow in Jitterbit

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

• Replicate Act-On to Multiple Databases

  Replicate Act-On to disparate databases with a single configuration.

• Query Salesforce from Node.js

  Execute CRUD queries to live Salesforce data in Node.js.

• Connect to Hive as a SQL Server Linked Server

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

• Visualize GraphQL in TIBCO Spotfire through ADO.NET

  Integrate GraphQL into dashboards in TIBCO Spotfire.

• Access Wave Financial from MySQL in HeidiSQL

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

• Prepare, Blend, and Analyze Stripe in Alteryx Designer

  Build workflows to access live Stripe for self-service data analytics.

• Automated Continuous Amazon S3 Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Amazon S3 replication to SQL Server.

• How to connect Amazon QuickSight to Exact Online

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

• Query SurveyMonkey in ColdFusion

  Write standard ColdFusion data access code to connect to SurveyMonkey.

• How to Build an ETL App for Spark in Python with CData

  Create ETL applications and real-time data pipelines for Apache Spark SQL in Python with petl.

• How to create Visio diagrams from CouchDB

  Automatically update Apache CouchDB with the changes you make to Visio master shapes.

• Create Kafka Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for Apache Kafka to build custom dashboards in Bold BI.

• Natively Connect to Gmail in PHP

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

• Connect to Smartsheet in DBArtisan

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

• How to Create Power BI Visual Reports with Real-Time Office 365

  Use CData Power BI Connectors to visualize Microsoft Office 365 in Power BI.

• Create Dynamic AlloyDB Grids Using the Infragistics XamDataGrid

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

• «
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• »