CData Software - Knowledge Base

Recent Articles

• «
• 555
• 556
• 557
• 558
• 559
• 560
• 561
• 562
• 563
• 564
• »

• Access Live Power BI XMLA in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Power BI XMLA into the statistical analysis tools available in SAS JMP. This article shows how to use Power BI XMLA in the Graph Builder and Query Builder.

• Load Dynamics NAV to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Dynamics NAV to a database.

• Integrate with Email using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Email to a JSON file on disk.

• DataBind Controls to Azure Data Catalog in Delphi

  DataBind to Azure Data Catalog in Delphi with standard data access components and controls.

• LINQ to Spark

  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 Spark Data Provider.

• How to Import Data from Box into Google Sheets

  Import Box into a Google spreadsheet that is automatically refreshed.

• Establish a Live Connection with SAP HANA XS Advanced using Tableau Bridge

  The CData ODBC Driver for SAP HANA XS Advanced enables you to integrate live SAP HANA XS Advanced into Tableau Cloud dashboards using the Tableau Bridge.

• How to Query SAP Ariba Procurement in MySQL Workbench

  Execute MySQL queries against live SAP Ariba Procurement from MySQL Workbench.

• Connect to Google Sheets in Aqua Data Studio

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

• Build Data Flows from Facebook to SQL Server using SSIS

  Easily back up Facebook to SQL Server using the SSIS components for Facebook.

• How to Create Power BI Visual Reports with Real-Time Excel Online

  Use CData Power BI Connectors to visualize Microsoft Excel Online in Power BI.

• Visualize Live Reckon Accounts Hosted in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Reckon Accounts Hosted.

• Migrating data from QuickBooks Online to Snowflake using CData SSIS Components.

  Easily push QuickBooks Online to Snowflake using the CData SSIS Tasks for QuickBooks Online and Snowflake.

• Extend Google Sheets with Highrise

  Make calls to the API Server from Google Apps Script.

• Sage Intacct Reporting and Star Schemas in OBIEE

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

• Connect to XML in HULFT Integrate

  Connect to XML as a JDBC data source in HULFT Integrate

• Notice for all Marketo Driver Users Regarding December 2024 Release

  This article serves as a notice to all users regarding the CData Software Marketo connectivity solutions update from December 2024.

• Connect to Live GMO MakeShop in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to GMO MakeShop in CData Connect Cloud and connect to your GMO MakeShop from PostgreSQL.

• Build Dynamics CRM-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live Microsoft Dynamics CRM and build Dynamics CRM-connected web apps with Axios.

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

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

• Add Parquet to Informatica Enterprise Data Catalog

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

• Connect to Presto from Crystal Reports

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

• Automated Continuous WooCommerce Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable WooCommerce replication to Apache Kafka.

• How to connect to Jira Assets with Squirrel SQL client

  Connect to Jira Assets and execute queries in the Squirrel SQL Client.

• Automate IBM Cloud Object Storage Replication to SAP HANA

  Use CData Sync to customize and automate IBM Cloud Object Storage replication to SAP HANA.

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

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

• Choosing the Best Method to Connect Elasticsearch to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use Elasticsearch from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• How to Query DB2 in MySQL Workbench

  Execute MySQL queries against live IBM DB2 from MySQL Workbench.

• Access Live OneNote in Google Sheets via Connect Cloud

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

• Build a Simple VCL Application for Jira Assets

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

• Dropbox Reporting and Star Schemas in OBIEE

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

• Integrate Shippo with External Services using SnapLogic

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

• Create HCL Domino-Connected Business Apps in AppSheet

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

• Validate Oracle Eloqua with QuerySurge

  Access and validate Oracle Eloqua in QuerySurge using the CData JDBC Driver.

• How to use SQLAlchemy ORM to access PingOne in Python

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

• Connect to MongoDB in JRuby

  Create a simple JRuby app with access to live MongoDB.

• Query Spark through ODBC in Node.js

  Use node-odbc to execute SQL queries against Apache Spark SQL from Node.js.

• Automated Continuous Airtable Replication to Local Delimited Files

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

• Create SSAS Tabular Models from WordPress

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

• Import and Visualize Sage 200 in Power View

  Create data visualizations based on Sage 200 in Excel.

• How to connect SharePoint with Harvest through external lists

  Provide Harvest to SharePoint users as an external list.

• Visualize Trello from Tableau

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

• Connect to Kintone in Jaspersoft Studio

  Execute SQL to remote Kintone in Jaspersoft Studio.

• Automate Harvest Replication to Azure Data Lake

  Use CData Sync to customize and automate Harvest replication to Azure Data Lake.

• Access Live Monday.com Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live Monday.com data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• How to load MongoDB data into Elasticsearch via Logstash

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

• Create Dashboards and Visualize Live SAP HANA in Geckoboard

  Use CData Connect Cloud to connect to live SAP HANA and create dashboards for real-time monitoring and visualization in Geckoboard.

• Integrate with Smartsheet in SnapLogic

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

• How to connect to Jira Service Management from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for Jira Service Management and work with Atlassian Jira Service Management in Microsoft Excel on Mac OS X.

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

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

• How to Access Live ClickUp in Power Automate Desktop via ODBC

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

• Explore Geographical Relationships in MySQL with Power Map

  Create data visualizations with MySQL in Power Map.

• Create Dashboards and Visualize Live Reckon in Geckoboard

  Use CData Connect Cloud to connect to live Reckon and create dashboards for real-time monitoring and visualization in Geckoboard.

• Connect to Google Search Results in NetBeans

  Connect to Google Search in NetBeans with the data source configuration wizard.

• Query Cosmos DB as a SQL Server Database in Node.js

  Execute SQL Server queries against Azure Cosmos DB from Node.js.

• Visualize Live Azure Data Lake Storage in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Azure Data Lake Storage.

• Integrate with Gmail in JReport Designer

  Create charts and reports based on Gmail in JReport Designer.

• How to connect SharePoint with Elasticsearch through external lists

  Provide Elasticsearch to SharePoint users as an external list.

• Automated Continuous Greenplum Replication to SQL Server

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

• Create a Data Access Object for Dynamics 365 using JDBI

  A brief overview of creating a SQL Object API for Microsoft Dynamics 365 in JDBI.

• Integrate with eBay in JReport Designer

  Create charts and reports based on eBay in JReport Designer.

• Connect to OData Services from PowerBuilder via JDBC

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

• Access Bullhorn CRM from MySQL in PHP

  Connect to Bullhorn CRM through the standard MySQL libraries in PHP.

• View Reports on Real-Time Authorize.Net in Power BI Report Server

  Use the CData ODBC Driver for Authorize.Net to visualize Authorize.Net in Power BI Desktop and then publish them to Power BI Report Server.

• Act CRM Cloud Connectivity

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

• Integrate Salesloft in the Pentaho Report Designer

  Publish reports based on Salesloft in the Pentaho BI tool.

• Connect to Azure DevOps in JRuby

  Create a simple JRuby app with access to live Azure DevOps.

• Query Printful through ODBC in Node.js

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

• How to Design Sugar CRM Power Apps with Database-Like Connectivity

  This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.

• How to Access Live MongoDB in Power Automate Desktop via ODBC

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

• Use the CData Software ODBC Driver for Tableau CRM Analytics in MicroStrategy Web

  Connect to Tableau CRM Analytics in MicroStrategy Web using the CData Software ODBC Driver for Tableau CRM Analytics.

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

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

• Connect to Highrise in HULFT Integrate

  Connect to Highrise as a JDBC data source in HULFT Integrate

• Integrate Oracle Sales in the Pentaho Report Designer

  Publish reports based on Oracle Sales in the Pentaho BI tool.

• Connect to Dynamics GP from PowerBuilder via ADO.NET

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

• How to Seamlessly Import Azure Data Lake Storage Data into IBM SPSS Modeler

  Integrate Azure Data Lake Storage data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• How to Connect to Teradata in Using Python: 6 Steps

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

• How to connect to Excel from Spring Boot

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

• Explore Geographical Relationships in Dropbox with Power Map

  Create data visualizations with Dropbox in Power Map.

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

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

• Replicate Spark for Use in Salesforce Connect

  Replicate Apache Spark SQL to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Connect to and Visualize Live Salesforce in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Salesforce & Force.com.

• Connect to SendGrid in Jaspersoft Studio

  Execute SQL to remote SendGrid in Jaspersoft Studio.

• How to create an RPA flow for Sybase IQ in UiPath Studio

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

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

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

• Automate Zoho CRM Replication to Couchbase

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

• Connect to Spark in Google Apps Script via SQL Gateway

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

• Replicate Multiple Phoenix Accounts via the CData Sync CLI

  Replicate multiple Phoenix accounts to one or many databases.

• Connect to Spark in RazorSQL

  Connect to Spark from wizards and query Apache Spark SQL from the GUI in the RazorSQL database management tool.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Active Directory

  Provide connectivity to Active Directory through an SAP BusinessObjects universe.

• How to connect to EventBrite with Squirrel SQL client

  Connect to Eventbrite and execute queries in the Squirrel SQL Client.

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

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

• How to create HCL Domino federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for HCL Domino in MySQL .

• Connect to and Visualize Live Google Contacts in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Contacts.

• How to create Visio diagrams from Teradata

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

• Enable the Zoho Projects JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Zoho Projects.

• Create IBM Cloud Data Engine Reports on JasperReports Server

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

• Automated Continuous PostgreSQL Replication to Amazon S3

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

• Load Microsoft Project to a Database Using Embulk

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

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed IBM Cloudant to Power BI dashboards. Simply drag and drop IBM Cloudant into data visuals on the Power BI canvas.

• «
• 555
• 556
• 557
• 558
• 559
• 560
• 561
• 562
• 563
• 564
• »