CData Software - Knowledge Base

Recent Articles

• «
• 157
• 158
• 159
• 160
• 161
• 162
• 163
• 164
• 165
• 166
• »

• Visualize Google Analytics from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Google Analytics.

• Stream Tally into Apache Kafka Topics

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

• Analyze SAP Concur in Looker

  Use CData Connect Cloud to connect to SAP Concur from Looker and build custom apps using live SAP Concur.

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

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

• Analyze Redis in SAP Analytics Cloud

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

• Access Live Marketo in Google Sheets via Connect Cloud

  Use CData Connect Cloud to gain access to live Marketo from your Google Sheets.

• How to Access Email Using Entity Framework

  This article shows how to access Email using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Access Live Smartsheet in AWS Lambda (with IntelliJ IDEA)

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

• Visualize PostgreSQL in TIBCO Spotfire through OData

  Integrate PostgreSQL into dashboards in TIBCO Spotfire.

• How to connect to Amazon Athena from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for Amazon Athena and work with Amazon Athena in Microsoft Excel on Mac OS X.

• Process & Analyze ClickUp in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live ClickUp .

• Import Zenefits into Microsoft Power Query

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

• How to load Cloudant data into Elasticsearch via Logstash

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

• Import Trello into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Trello and provide access to live Trello for custom reports in the Power BI Service.

• Access Live BigQuery in AWS Lambda (with IntelliJ IDEA)

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

• Access Outreach.io as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Outreach.io from your Oracle system.

• Excel Spreadsheet Automation on Sage 50 UK with the QUERY Formula

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

• Create a Data Access Object for xBase using JDBI

  A brief overview of creating a SQL Object API for xBase in JDBI.

• Automated Continuous GraphQL Replication to MySQL

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

• How to connect PolyBase to EnterpriseDB

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

• Use the CData Software JDBC Driver for Snapchat Ads in MicroStrategy

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

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

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

• Working with Azure Table in LINQPad

  Execute LINQ queries to Azure Table Storage in LINQPad.

• How to Connect DBeaver to Oracle SCM via a JDBC Driver

  Manage Oracle SCM with visual tools in DBeaver like the query browser.

• How to Work with Dropbox in ETL Validator JDBC

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

• Replicate Multiple NetSuite Accounts

  Replicate multiple NetSuite accounts to one or many databases.

• Connect to Calendly from Asprova with CData Software ODBC Driver for Calendly

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

• Query Active Directory in MySQL Workbench

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

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

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

• How to create Power BI XMLA federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Power BI XMLA in MySQL .

• Create Square-Connected Business Apps in AppSheet

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

• Access SAP Netweaver Gateway from MySQL in HeidiSQL

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

• Query, Visualize, and Share live Jira in Redash

  Use CData Connect Cloud to connect to live Atlassian Jira in Redash for querying, visualizing, and sharing.

• Analyze CSV in Infragistics Reveal

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

• Automated Continuous Sage 200 Replication to Snowflake

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

• Load Wave Financial to a Database Using Embulk

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

• Create Twilio Reports on JasperReports Server

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

• Visualize Live Splunk in the Power BI Service

  Use CData Connect Cloud to connect to live Splunk and create custom reports in the Power BI Service through the On-Premises Gateway.

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

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

• Visualize Sybase IQ in TIBCO Spotfire through OData

  Integrate Sybase IQ into dashboards in TIBCO Spotfire.

• How to Connect to Amazon Marketplace in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Amazon Marketplace. Leverage the pyodbc module for ODBC in Python.

• Analyze Workday in SAP Analytics Cloud

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

• Analyze Highrise in R via ODBC

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

• Work with Live WooCommerce in Power Query

  Use CData Connect Cloud to connect to WooCommerce and work with live WooCommerce in Microsoft Power Query.

• Build a PostgreSQL Interface for Gmail using the CData JDBC Driver

  Use the Remoting features of the Gmail JDBC Driver to create a PostgreSQL entry-point for data access.

• Natively Connect to TigerGraph in PHP

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

• Replicate Multiple Facebook Accounts via the CData Sync CLI

  Replicate multiple Facebook accounts to one or many databases.

• Connect to BigQuery in Google Apps Script via SQL Gateway

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

• Bidirectional Access to Power BI XMLA from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Power BI XMLA in Filemaker Pro for Mac or Windows.

• Automated Continuous CSV Replication to Google BigQuery

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

• Validate SingleStore with QuerySurge

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

• How to publish and share Snapchat Ads dashboards with Tableau Server

  The CData ODBC driver for Snapchat Ads enables you integrate Snapchat Ads into Tableau dashboards.

• Build Charts with Sage Intacct in Clear Analytics

  Create dynamic charts and perform analytics based on Sage Intacct in Clear Analytics.

• Connect to Google Ad Manager from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Google Ad Manager to connect to Google Ad Manager from Web applications running on WebLogic.

• Automated Continuous SAP BusinessObjects BI Replication to SingleStore

  Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to SingleStore.

• Build OData-Connected Web Apps in Servoy

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

• Build Square Visualizations in Tableau Cloud

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

• Integrating Oracle SCM in Talend Cloud Data Management Platform

• «
• 157
• 158
• 159
• 160
• 161
• 162
• 163
• 164
• 165
• 166
• »