CData Software - Knowledge Base

Recent Articles

• «
• 315
• 316
• 317
• 318
• 319
• 320
• 321
• 322
• 323
• 324
• »

• Query Pinterest as a SQL Server in Node.js

  Execute SQL Server queries against Pinterest from Node.js.

• Visualize Live Oracle HCM Cloud in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Oracle HCM Cloud.

• Automated Continuous JSON Replication to SingleStore

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

• Access Live Kafka in AWS Lambda

  Connect to live Apache Kafka in AWS Lambda using the CData JDBC Driver.

• Explore Geographical Relationships in Google Drive with Power Map

  Create data visualizations with Google Drive in Power Map.

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

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

• A PostgreSQL Interface for Hive (MySQL Remoting via JDBC)

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

• Build Visualizations of SuiteCRM in Birst

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

• Automate Kintone Replication to Couchbase

  Use CData Sync to Customize and automate Kintone replication to Couchbase.

• PowerShell Scripting to Replicate Salesloft to MySQL

  Write a simple PowerShell script to replicate Salesloft to a MySQL database.

• Excel Spreadsheet Automation on Zoho Creator with the QUERY Formula

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

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

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

• Replicate Smartsheet to Multiple Databases

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

• Import MarkLogic into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for MarkLogic and create custom reports in the Power BI Service.

• Access Shippo from MySQL in Amazon QuickSight

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

• DataBind Charts to Clio

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Clio from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• Quickbase Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Quickbase facts in real time.

• Connect to Kintone from PowerBuilder via JDBC

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

• Connect to Zendesk as a SQL Server Linked Server

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

• Build an OLAP Cube in SSAS from Xero

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

• Build Semantic Layer Views for Act-On in APOS Live Data Gateway

  Use the CData Connector for Act-On in APOS Live Data Gateway to build Semantic Layer Views for Act-On.

• Automated Continuous Zoho Books Replication to PostgreSQL

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

• Automated Continuous SQL Server Replication to Azure SQL

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

• Prepare, Blend, and Analyze FTP in Alteryx Designer (ODBC)

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

• Query Google Calendar through ODBC in Node.js

  Use node-odbc to execute SQL queries against Google Calendar from Node.js.

• How to create Visio diagrams from Dynamics NAV

  Automatically update Microsoft Dynamics NAV with the changes you make to Visio master shapes.

• LINQ to Microsoft Teams

  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 Microsoft Teams Data Provider.

• Process & Analyze SAP BusinessObjects BI in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live SAP BusinessObjects BI .

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

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

• How to connect and process Microsoft Planner from Azure Databricks

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

• How to Work with Sage Intacct in ETL Validator JDBC

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

• Integrate with DB2 in JReport Designer

  Create charts and reports based on IBM DB2 in JReport Designer.

• How to Visualize Monday.com Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Monday.com in Python.

• Automate SingleStore Replication to SAP HANA

  Use CData Sync to customize and automate SingleStore replication to SAP HANA.

• Integrate with xBase in JReport Designer

  Create charts and reports based on xBase in JReport Designer.

• Automated Continuous HDFS Replication to Vertica

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

• Access Asana as a Remote Oracle Database

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

• Access Microsoft Project from MySQL in PHP

  Connect to Microsoft Project through the standard MySQL libraries in PHP.

• PowerShell Scripting to Replicate Coinbase to MySQL

  Write a simple PowerShell script to replicate Coinbase to a MySQL database.

• Build Visualizations of Workday in Birst

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

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

• Integrate Real-Time Access to Microsoft OneDrive in SAPUI5 MVC Apps

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

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

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

• Build Jira Assets-Connected Web Apps in Servoy

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

• Use the CData ODBC Driver for OData from SharePoint Excel Services

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

• Connect to Databricks in RapidMiner

  Integrate Databricks with standard components and data source configuration wizards in RapidMiner Studio.

• Automated Continuous Coinbase Replication to Local Delimited Files

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

• Automated Continuous Cloudant Replication to PostgreSQL

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

• Use the CData Software ODBC Driver for Pinterest in MicroStrategy Desktop

  Connect to Pinterest in MicroStrategy Desktop using the CData Software ODBC Driver for Pinterest.

• Design BIRT Reports on Basecamp

  Provide current Basecamp to your embedded analytics.

• Connect to and Visualize Live Microsoft Project in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Project.

• How to connect to FTP from MS Excel on Mac OS X

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

• Access Live Google Drive in AWS Lambda (with IntelliJ IDEA)

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

• Automated Excel Online Replication to Teradata

  Use CData Sync to Customize and automate Microsoft Excel Online replication to Teradata.

• Integrate SharePoint Excel Services with External Services using SnapLogic

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

• How to connect to SharePoint from Spring Boot

  Connect to SharePoint in a Spring Boot Application using CData JDBC SharePoint Driver

• Access Live Splunk in Excel (Desktop) through Connect Spreadsheets

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

• Automated Continuous Azure Active Directory Replication to MySQL

  Use CData Sync for automated, continuous, customizable Azure Active Directory replication to MySQL.

• Visualize Todoist from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Todoist.

• Replicate Google Analytics to Multiple Databases via the CData Sync CLI

  Replicate Google Analytics to disparate databases with a single configuration.

• Visualize Microsoft OneDrive in Tableau Desktop (through CData Connect)

  Create a virtual SQL Server database for Microsoft OneDrive in CData Software Connect (or Connect Server) and build visualizations from live Microsoft OneDrive in Tableau Desktop.

• NetSuite Reporting in OBIEE with the NetSuite JDBC Driver

  Deploy the NetSuite JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Build Data Flows from SQL Server to Office 365 through SSIS

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

• Automate WooCommerce Replication to Couchbase

  Use CData Sync to Customize and automate WooCommerce replication to Couchbase.

• Use JayDeBeApi to access SAP Business One in Python

  Use standard Python scripting and the development environment of your choice to access live SAP Business One.

• Connect to Amazon DynamoDB in CloverDX (formerly CloverETL)

  Transfer Amazon DynamoDB using the visual workflow in the CloverDX data integration tool.

• Access SQL Analysis Services in PHP through Connect Server

  Connect to SQL Analysis Services through the standard SQL Server libraries in PHP.

• Build Dashboards with Pipedrive in Dundas BI

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

• Work with Salesloft in FoxPro

  Load Salesloft into a FoxPro database. This article includes full code and a walk-through of the process.

• Use the CData Software JDBC Driver for Dynamics GP in MicroStrategy Web

  Connect to Microsoft Dynamics GP in MicroStrategy Web using the CData Software JDBC Driver for Dynamics GP.

• How to connect PolyBase to SharePoint Excel Services

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

• Visualize SFTP in Tableau

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

• Visualize JSON Services in TIBCO Spotfire through ODBC

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

• Build Dashboards with SAP Ariba Source in Dundas BI

  Create dynamic dashboards and perform analytics based on SAP Ariba Source in Dundas BI.

• How to connect to Klipfolio in DBVisualizer

  Integrate Klipfolio with visual data analysis tools and data connection wizards in DBVisualizer

• Build MVC Applications with Connectivity to SAP Hybris C4C

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

• Access Veeva Vault as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Veeva Vault & Vault CRM from your Oracle system.

• Connect to and Query JSON Services in QlikView over ODBC

  Create data visualizations with JSON in QlikView.

• Connect to TigerGraph in NetBeans

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

• Access Live Oracle in TIBCO Data Virtualization

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

• Use the CData Software ODBC Driver for TigerGraph in MicroStrategy

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

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

• Automated Continuous Oracle Financials Cloud Replication to Apache Kafka

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

• DataBind Controls to Tableau CRM Analytics in C++Builder

  DataBind to Tableau CRM Analytics in C++Builder with standard components and controls.

• Build Dashboards with Power BI XMLA in DBxtra

  Create dynamic dashboards and perform analytics based on Power BI XMLA in DBxtra.

• Connect to Cosmos DB in Google Apps Script via SQL Gateway

  Use the ODBC Driver for Cosmos DB and the SQL Gateway to access Azure Cosmos DB from Google Apps Script.

• How to create an RPA flow for QuickBooks Time in UiPath Studio

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

• Google Directory Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Google Directory facts in real time.

• Connect to Dynamics CRM from PowerBuilder via ADO.NET

  This article demonstrates how to access Microsoft Dynamics CRM from Appeon PowerBuilder using the CData ADO.NET Provider for Dynamics CRM.

• Build Google Contacts Visualizations in Tableau Cloud

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

• Feed Google Calendar into FineReport

  How to set Google Calendar as a JDBC data source in FineReport.

• Connect to Azure Data Catalog in JRuby

  Create a simple JRuby app with access to live Azure Data Catalog.

• Create Apps from Paylocity in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Paylocity and build apps from live Paylocity in Qlik Sense Cloud.

• Prepare, Blend, and Analyze Gmail in Alteryx Designer (Connect Cloud)

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

• Stream SAS Data Sets into Apache Kafka Topics

  Access and stream SAS Data Sets in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• How to Visualize Dropbox Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Dropbox in Python.

• Automated Continuous QuickBooks Online Replication to Oracle

  Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Oracle.

• DataBind Controls to Twilio in Delphi

  DataBind to Twilio in Delphi with standard data access components and controls.

• Visualize Live SAP HANA XS Advanced of Power BI Report Builder in Power BI Service

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

• Bridge Kintone Connectivity with Apache NiFi

  Access and process Kintone in Apache NiFi using the CData JDBC Driver.

• «
• 315
• 316
• 317
• 318
• 319
• 320
• 321
• 322
• 323
• 324
• »