CData Software - Knowledge Base

Recent Articles

• «
• 184
• 185
• 186
• 187
• 188
• 189
• 190
• 191
• 192
• 193
• »

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

• DataBind Wijmo Grid to Google Sheets

  Provide real-time Google Sheets to interactive controls.

• Connect to MYOB AccountRight as a Linked Server

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

• Query BigCommerce as a MySQL Database in Node.js

  Execute MySQL queries against BigCommerce from Node.js.

• Visualize Spark in TIBCO Spotfire through ADO.NET

  Integrate Apache Spark SQL into dashboards in TIBCO Spotfire.

• How to Connect to & Open eBay in Microsoft Excel

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

• Bidirectional Access to Amazon S3 from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Amazon S3 in Filemaker Pro for Mac or Windows.

• Author and Share Power BI Reports on Real-Time Twitter Ads

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

• Access MongoDB from MySQL in Amazon QuickSight

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

• Automated Continuous Tableau CRM Analytics Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Tableau CRM Analytics replication to SingleStore.

• Build Charts with Jira Assets in Clear Analytics

  Create dynamic charts and perform analytics based on Jira Assets in Clear Analytics.

• Create YouTube Analytics-Connected Business Apps in AppSheet

  Connect to YouTube Analytics via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to YouTube Analytics.

• Publish MongoDB-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live MongoDB.

• Integrate Live Cloudant into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to IBM Cloudant and integrate live IBM Cloudant into apps built in Microsoft Power Apps.

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

  Provide connectivity to Quickbase through an SAP BusinessObjects universe.

• How to connect PolyBase to Dynamics 365

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

• Connect to DocuSign in DBArtisan

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

• Create Bing Search-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Bing Search Results from OutSystems and build custom enterprise apps using live Bing Search.

• Add HDFS to Informatica Enterprise Data Catalog

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

• PowerShell Scripting to Replicate Greenplum to MySQL

  Write a simple PowerShell script to replicate Pivotal GreenPlum to a MySQL database.

• Replicate Presto to Multiple Databases

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

• Build a Simple VCL Application for CockroachDB

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

• Connect to Kintone in CloverDX (formerly CloverETL)

  Transfer Kintone using the visual workflow in the CloverDX data integration tool.

• Prepare, Blend, and Analyze Exact Online in Alteryx Designer

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

• Automated Continuous DocuSign Replication to Google BigQuery

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

• How to work with IBM Cloud Data Engine in Apache Spark using SQL

  Access and process IBM Cloud Data Engine in Apache Spark using the CData Software JDBC Driver.

• How to update DB2 from Excel

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

• Using AngularJS to Build Dynamic Web Pages with Twilio

  Use the CData Connect Server to create Twilio OData feeds and build single-page applications with live Twilio.

• Write a Simple Go Application to work with Zoho Creator on Linux

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

• How to Access Live SAP Hybris C4C in Power Automate Desktop via ODBC

  The CData ODBC Driver for SAP Hybris C4C enables you to integrate SAP Hybris C4C into workflows built using Microsoft Power Automate Desktop.

• Create Datasets from Tableau CRM Analytics in Domo Workbench and Build Visualizations of Tableau CRM Analytics in Domo

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

• Automated Continuous Zoho CRM Replication to MySQL

  Use CData Sync for automated, continuous, customizable Zoho CRM replication to MySQL.

• How to update Pipedrive from Excel

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

• Connect to Live Typeform in MicroStrategy through CData Software Connect Server

  Create a virtual database for Typeform in CData Software Connect Server and connect to it from MicroStrategy.

• Access Jira Service Management from MySQL in PHP

  Connect to Jira Service Management through the standard MySQL libraries in PHP.

• Configure the CData JDBC Driver for Todoist in a Connection Pool in Tomcat

  Connect to Todoist from a connection pool in Tomcat.

• How to pipe EventBrite to CSV in PowerShell

  Use standard PowerShell cmdlets to access EventBrite tables.

• Build MVC Applications with Connectivity to Zuora

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

• How to load EventBrite data into Elasticsearch via Logstash

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

• Automated Salesforce Pardot Replication to Teradata

  Use CData Sync to Customize and automate Salesforce Pardot replication to Teradata.

• Load QuickBooks Time to a Database Using Embulk

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

• DataBind Wijmo Grid to WordPress

  Provide real-time WordPress to interactive controls.

• Access Live MongoDB in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for MongoDB to create a MongoDB source in TIBCO Data Virtualization Studio and gain access to live MongoDB from your TDV Server.

• Create Reports from Square in Looker Studio

  Use CData Connect Cloud to gain access to live Square and create custom reports in Looker Studio.

• Integrate SAP BusinessObjects BI in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP BusinessObjects BI from Informatica Cloud.

• Integrate with live MariaDB in Jitterbit

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

• Analyze Google Campaign Manager 360 in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Google Campaign Manager 360 and visualize Google Campaign Manager 360 in SAP Analytics Cloud.

• Replicate Klipfolio for Use in Salesforce Connect

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

• Automated Continuous Shippo Replication to Apache Cassandra

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

• Use the CData Software JDBC Driver for SAP Ariba Source in MicroStrategy Desktop

  Connect to SAP Ariba Source in MicroStrategy Desktop using the CData Software JDBC Driver for SAP Ariba Source.

• Build Interactive Dashboards from Azure Data Catalog in Amazon QuickSight

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

• How to connect to Shippo from IntelliJ

  Integrate connectivity to Shippo with wizards in IntelliJ.

• Connect to Salesforce from HeidiSQL

  Use CData Connect Cloud to connect to and query live Salesforce & Force.com from HeidiSQL.

• Model PostgreSQL Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and PostgreSQL, enabling the direct import of real-time PostgreSQL.

• How to connect and process Clio from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Clio

• Access Live Square in Excel for the Web (Excel 365/Online)

  Connect to Square from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Automated Continuous SAP Netweaver Gateway Replication to MongoDB

  Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to MongoDB.

• Connect to Stripe in HULFT Integrate

  Connect to Stripe as a JDBC data source in HULFT Integrate

• Analyze Act CRM in Infragistics Reveal

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

• Build Dashboards with Square in Dundas BI

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

• Connect to and Query Google Analytics in QlikView over ODBC

  Create data visualizations with Google Analytics in QlikView.

• DataBind Controls to Oracle Eloqua in C++Builder

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

• Stream Stripe into Apache Kafka Topics

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

• Automated Continuous Amazon Athena Replication to Amazon Redshift

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

• ETL Jira Assets in Oracle Data Integrator

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

• Automated Continuous Couchbase Replication to AlloyDB

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

• Analyze Facebook Ads in Looker

  Use CData Connect Cloud to connect to Facebook Ads from Looker and build custom apps using live Facebook Ads.

• Publish Excel-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Excel.

• How to Access Live Tableau CRM Analytics in Power Automate Desktop via ODBC

  The CData ODBC Driver for Tableau CRM Analytics enables you to integrate Tableau CRM Analytics into workflows built using Microsoft Power Automate Desktop.

• Connect to Raisers Edge NXT in DBArtisan

  Use wizards in DBArtisan to configure Raisers Edge NXT as a data source.

• Build Slack Visualizations in Tableau Cloud

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

• Automated Continuous Google Ads Replication to Databricks

  Use CData Sync for automated, continuous, customizable Google Ads replication to Databricks.

• Build AI/ML Models with Live Google Search Data using Dataiku

• «
• 184
• 185
• 186
• 187
• 188
• 189
• 190
• 191
• 192
• 193
• »