CData Software - Knowledge Base

Recent Articles

• «
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• »

• Connect to SendGrid as a Linked Server

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

• Create Datasets from Azure Data Lake Storage in Domo Workbench and Build Visualizations of Azure Data Lake Storage in Domo

  Use the CData Software ODBC Driver for Azure Data Lake Storage to create datasets from Azure Data Lake Storage in Domo Workbench and then build visualizations in the Domo service.

• Access ADP from MySQL in PHP

  Connect to ADP through the standard MySQL libraries in PHP.

• Query Power BI XMLA through ODBC in Node.js

  Use node-odbc to execute SQL queries against Power BI XMLA from Node.js.

• Query SAP ByDesign as a MySQL Database in Node.js

  Execute MySQL queries against SAP Business ByDesign from Node.js.

• Connect to YouTube Analytics in SpagoBI

  Create reports featuring live YouTube Analytics in SpagoBI Studio. Host YouTube Analytics reports on SpagoBI Server.

• DataBind Controls to Printful in Delphi

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

• Build Sage 300 Visualizations in Tableau Cloud

  Use CData Software Connect Server to create a virtual SQL Server Database for Sage 300 and build visualizations in Tableau Cloud.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Integrate with Klaviyo in JReport Designer

  Create charts and reports based on Klaviyo in JReport Designer.

• Access Live BigCommerce in Excel (Desktop)

  Use CData Connect Cloud to gain access to live BigCommerce from your Excel spreadsheets.

• Create FTP Dashboards in Bold BI

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

• Build Semantic Layer Views for Outreach.io in APOS Live Data Gateway

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

• How to use SQLAlchemy ORM to access eBay Analytics in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of eBay Analytics.

• DataBind Controls to Adobe Commerce in C++Builder

  DataBind to Adobe Commerce in C++Builder with standard components and controls.

• Access Live Exact Online in Excel 365 Online (Excel for the web)

  Connect to Exact Online from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• How to Connect to & Open Snowflake in Microsoft Excel

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

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

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

• Use the CData Software JDBC Driver for Cosmos DB in MicroStrategy Web

  Connect to Azure Cosmos DB in MicroStrategy Web using the CData Software JDBC Driver for Cosmos DB.

• How to Query Live Google Cloud Storage Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Google Cloud Storage data in natural language using Python.

• A PostgreSQL Interface for Sugar CRM

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

• Use Dash to Build to Web Apps on HubSpot

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

• Integrate Snowflake in Your Informatica Cloud Instance

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

• Connect to ADP from a Connection Pool in WebLogic

  Use the CData JDBC Driver for ADP to connect to ADP from Web applications running on WebLogic.

• Using AngularJS to Build Dynamic Web Pages with Shopify

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

• Analyze SAP Hybris C4C in SAP Analytics Cloud

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

• Integrate FHIR in Your Informatica Cloud Instance

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

• Integrate Asana in the Pentaho Report Designer

  Publish reports based on Asana in the Pentaho BI tool.

• Access Live Databricks in AWS Lambda

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

• Access Live Zoho Books in Coginiti Pro

  Connect to and query live Zoho Books from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Build Coinbase-Connected Dashboards in Redash

  Use CData Software Connect Server to create a virtual SQL Server Database for Coinbase and build visualizations and dashbaords from Coinbase in Redash.

• DataBind Controls to ShipStation in Delphi

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

• Visualize Salesforce Marketing in TIBCO Spotfire through ADO.NET

  Integrate Salesforce Marketing Cloud into dashboards in TIBCO Spotfire.

• Deploy the ADO.NET Provider for Clio on an SSRS Report Server

  Connect to Clio from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Export Data from SQL Server to Quickbase through SSIS

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

• Automated Continuous Zoho CRM Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Zoho CRM replication to Google Cloud SQL.

• Google Search Reporting and Star Schemas in OBIEE

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

• How to Build Dynamic React Apps with Presto

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

• Visualize YouTube 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 YouTube Analytics into TIBCO Spotfire.

• Bidirectional Access to GraphQL from FileMaker Pro

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

• Operational Reporting on Kintone from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Kintone.

• Access Bullhorn CRM in PHP through Connect Server

  Connect to Bullhorn CRM through the standard SQL Server libraries in PHP.

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

  Connect to Bitbucket from a connection pool in Tomcat.

• How to import Zoom into Apache Solr

  Use the CData Software JDBC Driver for Zoom in Data Import Handler and create an automated import of Zoom to Apache Solr Enterprise Search platform.

• Connect to Microsoft Exchange in RapidMiner

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

• A PostgreSQL Interface for SFTP

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

• Natively Connect to JSON Services in PHP

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

• Import SAP SuccessFactors Using Azure Data Factory

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

• Connect to Live SharePoint in MicroStrategy through CData Connect Cloud

  Create a live connection to SharePoint in CData Connect Cloud and connect to your Microsoft SharePoint from MicroStrategy.

• How to connect to BigQuery with Squirrel SQL client

  Connect to Google BigQuery and execute queries in the Squirrel SQL Client.

• Connect to LinkedIn in Aqua Data Studio

  Access LinkedIn from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Import Real-Time Email in ColdFusion to Build Applications

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

• How to Access Live Microsoft Exchange in Power Automate Desktop via ODBC

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

• Automated Continuous Google Ad Manager Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Google Ad Manager replication to SingleStore.

• DataBind Bullhorn CRM to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for Bullhorn CRM with the DevExpress Windows Forms and Web controls to provide Bullhorn CRM to a chart.

• Analyze Sage 200 in Cognos Analytics

  Use CData Connect Cloud to connect to Sage 200 from Cognos Analytics and analyze live Sage 200.

• How to create Visio diagrams from MarkLogic

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

• Validate Salesforce Marketing with QuerySurge

  Access and validate Salesforce Marketing Cloud in QuerySurge using the CData JDBC Driver.

• How to connect PolyBase to Asana

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

• Replicate JSON Services from PowerShell

  Write a quick PowerShell script to query JSON. Use connectivity to the live data to replicate JSON to SQL Server.

• Connect to Oracle Service Cloud from a Connection Pool in JBoss

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

• How to Connect DBeaver to HubDB via a JDBC Driver

  Manage HubDB with visual tools in DBeaver like the query browser.

• Add SAP ByDesign to Informatica Enterprise Data Catalog

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

• Integrate with Dynamics GP in JReport Designer

  Create charts and reports based on Microsoft Dynamics GP in JReport Designer.

• ConstantContact Reporting and Star Schemas in OBIEE

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

• Build Hive-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Hive from Choreo and build custom apps using live Apache Hive.

• How to connect to Presto from Spring Boot

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

• Visualize YouTube Analytics from Tableau

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

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

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

• Automated Continuous Cassandra Replication to Google Cloud SQL

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

• Create Dynamic Zoho Creator Grids Using the Infragistics XamDataGrid

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

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

  Connect to EnterpriseDB from a connection pool in Tomcat.

• Connect to Tally from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Tally to connect to Tally ERP from Web applications running on WebLogic.

• Analyze Drift in R

  Use standard R functions and the development environment of your choice to analyze Drift with the CData JDBC Driver for Drift.

• Connect to Oracle Service Cloud from PowerBuilder

  This article demonstrates how to use the CData ODBC Driver for Oracle Service Cloud to connect to Oracle Service Cloud and execute queries in PowerBuilder.

• Analyze Splunk in Infragistics Reveal

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

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

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

• Build MVC Applications with Connectivity to Twitter

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

• Spring4Shell Overview

  CData is aware of the recently disclosed CVE-2022-22963, a remote code execution in Spring Cloud Function by malicious Spring Expression Spring4Shell (CVE-2022-22965).

• How to connect PolyBase to XML

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

• Using the CData Software ODBC Driver for SAP ByDesign in PyCharm

  Connect to SAP ByDesign as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP ByDesign.

• Natively Connect to BigQuery in PHP

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

• Build LinkedIn-Connected Apps in Choreo

  Use CData Connect Cloud to connect to LinkedIn from Choreo and build custom apps using live LinkedIn.

• How to Access Cosmos DB Using Entity Framework

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

• Visualize SAS Data Sets in Tableau Desktop (through CData Connect)

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

• Excel Spreadsheet Automation with the QUERY Formula

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

• Connect to Email in RapidMiner

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

• Create a Data Access Object for Drift using JDBI

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

• Visualize JotForm in TIBCO Spotfire through OData

  Integrate JotForm into dashboards in TIBCO Spotfire.

• Connect to SAP ByDesign from AWS Glue

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

• Automated Continuous Square Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Square replication to MongoDB.

• Natively Connect to Aha in PHP

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

• Create QuickBooks Dataflows on PowerBI.com

  Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

• Connect to TaxJar in RazorSQL

  Connect to TaxJar from wizards and query TaxJar from the GUI in the RazorSQL database management tool.

• Automated EnterpriseDB Replication to Teradata

  Use CData Sync to Customize and automate EnterpriseDB replication to Teradata.

• How to Connect to SharePoint Excel Services in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to SharePoint Excel Services. Leverage the pyodbc module for ODBC in Python.

• Automate Azure Table Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Azure Table Storage from PowerShell? This article demonstrates how to utilize the Azure Table Cmdlets for tasks like connecting to Azure Table Storage, automating operations, downloading data, and more.

• Publish Reports with Freshdesk in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Freshdesk.

• Integrate Unbounce into Automated Tasks with Power Automate

  Use CData Software Connect Server to create a virtual SQL Server database for Unbounce and integrate live Unbounce into your Power Automate (Microsoft Flow) tasks.

• How to pipe Neo4J to CSV in PowerShell

  Use standard PowerShell cmdlets to access Neo4J tables.

• «
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• »