CData Software - Knowledge Base

Recent Articles

• «
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• »

• Excel Spreadsheet Automation with the QUERY Formula

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

• LINQ to Snowflake

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

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

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

• Analyze OData Services in Infragistics Reveal

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

• Bridge Greenhouse Connectivity with Apache NiFi

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

• How to Visualize SharePoint Excel Services Data in Python with pandas

  Use pandas and other modules to analyze and visualize live SharePoint Excel Services in Python.

• Publish Crystal Reports on Dynamics 365

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Dynamics 365.

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

  Provide connectivity to Apache HBase through an SAP BusinessObjects universe.

• Connect to Typeform as a Linked Server

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

• Integrate Oracle Financials Cloud into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Oracle Financials Cloud and integrate live Oracle Financials Cloud into your Power Automate tasks.

• Access Bullhorn CRM in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Bullhorn CRM.

• Integrate with Certinia using Apache Camel2

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

• Import SAP Fieldglass into the Power BI Service for Visualizations

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

• Build MVC Applications with Connectivity to Azure Synapse

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

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

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

• Edit and Search External Dynamics 365 Objects in Salesforce Connect

  Use CData Connect Cloud to securely provide OData feeds of Microsoft Dynamics 365 to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Dynamics 365 objects that you can access from apps and the dashboard.

• Manage LDAP Objects in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for LDAP.

• Connect to MariaDB in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for MariaDB and connect to MariaDB in Akorbi Digital RunMyProcess.

• Publish Calendly-Connected Dashboards in Tableau Server

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

• Natively Connect to Azure DevOps in PHP

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

• How to Work with Clio in ETL Validator JDBC

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

• Import Zendesk Using Azure Data Factory

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

• Use the CData Software JDBC Driver for QuickBooks Time in MicroStrategy Desktop

  Connect to QuickBooks Time in MicroStrategy Desktop using the CData Software JDBC Driver for QuickBooks Time.

• DataBind Controls to LinkedIn in C++Builder

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

• Prepare, Blend, and Analyze Freshdesk in Alteryx Designer

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

• Connect to Calendly from a Connection Pool in Jetty

  The Calendly JDBC Driver supports connection pooling: This article shows how to connect faster to Calendly from Web apps in Jetty.

• Feed Jira Service Management into FineReport

  How to set Atlassian Jira Service Management as a JDBC data source in FineReport.

• How to create SAP SuccessFactors federated tables in MySQL

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

• Visualize SAP HANA XS Advanced in Tableau Desktop (through CData Connect)

  Create a virtual SQL Server database for SAP HANA XS Advanced in CData Software Connect (or Connect Server) and build visualizations from live SAP HANA XS Advanced in Tableau Desktop.

• How to connect to SAS xpt from Spring Boot

  Connect to SAS xpt in a Spring Boot Application using CData JDBC SAS xpt Driver

• Publish Reports with Bing Ads in SAP Crystal Reports

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

• How to Work with Sybase IQ in ETL Validator JDBC

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

• A PostgreSQL Interface for Dropbox

  Use the SQL Gateway and Dropbox ODBC Driver to create a PostgreSQL entry-point for data access.

• Access Live Quickbase in Coginiti Pro

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

• How to Connect DBeaver to Marketo via a JDBC Driver

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

• Query Google Contacts in DataGrip

  Create a Data Source for Google Contacts in DataGrip and use SQL to query live Google Contacts.

• How to import Jira Service Management into Apache Solr

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

• Automated Continuous Kintone Replication to SQLite

  Use CData Sync for automated, continuous, customizable Kintone replication to SQLite.

• Integrate Spark in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Apache Spark SQL from Informatica Cloud.

• How to connect to QuickBooks Online from Spring Boot

  Connect to QuickBooks Online in a Spring Boot Application using CData JDBC QuickBooks Online Driver

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

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

• How to connect to TigerGraph from IntelliJ

  Integrate connectivity to TigerGraph with wizards in IntelliJ.

• Analyze HubSpot in SAP Analytics Cloud

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

• Publish Reports with Clio in SAP Crystal Reports

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

• Connect to MySQL in JRuby

  Create a simple JRuby app with access to live MySQL.

• Access Live Dynamics GP in AWS Lambda (with IntelliJ IDEA)

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

• Analyze QuickBooks Time in Cognos Analytics

  Use CData Connect Cloud to connect to QuickBooks Time from Cognos Analytics and analyze live QuickBooks Time.

• Create Reports from Odoo in Looker Studio

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

• Visualize SharePoint in TIBCO Spotfire through ADO.NET

  Integrate Microsoft SharePoint into dashboards in TIBCO Spotfire.

• Connect to IBM Cloud Data Engine in NetBeans

  Connect to IBM Cloud Data Engine in NetBeans with the data source configuration wizard.

• Connect to Hive in NetBeans

  Connect to Apache Hive in NetBeans with the data source configuration wizard.

• Create Apps from Oracle in Qlik Sense Cloud

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

• Feed BambooHR into FineReport

  How to set BambooHR as a JDBC data source in FineReport.

• Connect to Google Directory in JRuby

  Create a simple JRuby app with access to live Google Directory.

• Automated Continuous Cosmos DB Replication to Google Cloud SQL

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

• Automate Microsoft Dataverse Replication to SAP HANA

  Use CData Sync to customize and automate Microsoft Dataverse (CDS) replication to SAP HANA.

• Automate MongoDB Replication to Azure Synapse

  Use CData Sync to customize and automate MongoDB replication to Azure Synapse.

• How to integrate RSS with Apache Airflow

  Access and process RSS Feeds in Apache Airflow using the CData JDBC Driver.

• Connect to Google Data Catalog in JRuby

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

• Connect to Live Jira Service Management in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Jira Service Management in CData Connect Cloud and connect to your Atlassian Jira Service Management from PostgreSQL.

• Create Bullhorn CRM-Connected Nintex Workflows

  Use CData Connect Cloud to connect to Bullhorn CRM from Nintex Workflow Cloud and build custom workflows using live Bullhorn CRM.

• Build Semantic Layer Views for Cassandra in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Apache Cassandra.

• Connect to FTP in HULFT Integrate

  Connect to FTP as a JDBC data source in HULFT Integrate

• Connect to Zoho CRM from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Zoho CRM from Filemaker Pro on Mac.

• Build Semantic Layer Views for Microsoft Project in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Microsoft Project.

• Integrate Live LinkedIn into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to LinkedIn from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live LinkedIn.

• How to create Cosmos DB federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Azure Cosmos DB in MySQL .

• Build Pipedrive-Connected Dashboards in Redash

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

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

  Connect to Epicor Kinetic 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.

• Connect to SAP Hybris C4C from a Connection Pool in Jetty

  The SAP Hybris C4C JDBC Driver supports connection pooling: This article shows how to connect faster to SAP Hybris C4C from Web apps in Jetty.

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

  Connect to Certinia 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.

• Query Microsoft Exchange through ODBC in Node.js

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

• Use the CData Software JDBC Driver for Monday.com in MicroStrategy Desktop

  Connect to Monday.com in MicroStrategy Desktop using the CData Software JDBC Driver for Monday.com.

• Automated Continuous Cosmos DB Replication to SingleStore

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

• Use the CData Software ODBC Driver for Certinia in MicroStrategy

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

• Connect to OData Services in as an External Source in Dremio

  Use the CData JDBC Driver to connect to OData as an External Source in Dremio.

• How to publish and share Klipfolio dashboards with Tableau Server

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

• Visualize MySQL in TIBCO Spotfire through OData

  Integrate MySQL into dashboards in TIBCO Spotfire.

• Integrate Odoo in the Pentaho Report Designer

  Publish reports based on Odoo ERP in the Pentaho BI tool.

• Integrate with live Google Contacts in Jitterbit

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

• Export Data from SQL Server to MySQL through SSIS

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

• Access Live Microsoft Teams in AWS Lambda

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

• Publish Google Search-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Google Search.

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

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

• Connect to Live Oracle HCM Cloud in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Oracle HCM Cloud in CData Connect Cloud and connect to your Oracle HCM Cloud from PostgreSQL.

• Automate HubDB Integration Tasks from PowerShell

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

• Connect to Databricks from HeidiSQL

  Use CData Connect Cloud to connect to and query live Databricks from HeidiSQL.

• Import SuiteCRM into FileMaker Pro

  Create reports that integrate SuiteCRM in Filemaker Pro.

• Create Data Visualizations Based On Hive in Mode

  Use CData Connect Cloud to connect to Hive from Mode and build visualizations using live

• Connect to Twitter Ads as a SQL Server Linked Server

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

• Integrate Elasticsearch with External Services using SnapLogic

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

• A PostgreSQL Interface for Snapchat Ads

  Use the SQL Gateway and Snapchat Ads ODBC Driver to create a PostgreSQL entry-point for data access.

• Automated Continuous Neo4J Replication to MongoDB

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

• How to connect to Amazon S3 with Squirrel SQL client

  Connect to Amazon S3 and execute queries in the Squirrel SQL Client.

• Connect to Kintone in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Create Data Visualizations Based On Salesforce Pardot in Mode

  Use CData Connect Cloud to connect to Salesforce Pardot from Mode and build visualizations using live

• Operational Reporting on Amazon DynamoDB from Spotfire Server

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

• Analyze Elasticsearch in SAP Analytics Cloud

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

• Redshift Reporting in OBIEE with the Redshift JDBC Driver

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

• Build Charts with Google Drive in Clear Analytics

  Create dynamic charts and perform analytics based on Google Drive in Clear Analytics.

• «
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• »