CData Software - Knowledge Base

Recent Articles

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

• Create Apps from Sage 200 in Qlik Sense Cloud

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

• Integrate SAP Concur in Pentaho Data Integration

  Build ETL pipelines based on SAP Concur in the Pentaho Data Integration tool.

• LINQ to Sage Cloud Accounting

  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 Sage Cloud Accounting Data Provider.

• Establish a Live Connection with Bullhorn CRM using Tableau Bridge

  The CData ODBC Driver for Bullhorn CRM enables you to integrate live Bullhorn CRM into Tableau Cloud dashboards using the Tableau Bridge.

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

  Provide connectivity to HubDB through an SAP BusinessObjects universe.

• Creating Oracle Service Cloud-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Oracle Service Cloud to Unqork and build custom business apps.

• Create Power BI XMLA-Connected Business Apps in AppSheet

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

• Replicate Hive for Use in Salesforce Connect

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

• Use the CData ODBC Driver for QuickBooks Time from SharePoint Excel Services

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

• Natively Connect to Oracle HCM Cloud in PHP

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

• Create LinkedIn-Connected Dashboards in Grafana

  Connect to LinkedIn via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to LinkedIn.

• Build Dashboards with Google Directory in Dundas BI

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

• Create Google Cloud Storage Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for Google Cloud Storage to build custom dashboards in Bold BI.

• How to connect Amazon QuickSight to Microsoft Project

  Create a connection to Microsoft Project in CData Connect Cloud and insert Microsoft Project into Amazon QuickSight SPICE to build interactive dashboards.

• Automated Continuous Zendesk Replication to SingleStore

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

• Connect to Elasticsearch in DBeaver

  Use the CData ODBC Driver to connect to Elasticsearch in DBeaver.

• Connect to Quickbase from a Connection Pool in Jetty

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

• Create SSAS Tabular Models from Zuora

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

• Create ActiveCampaign Dashboards in Bold BI

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

• Analyze Microsoft Teams in R via ODBC

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

• Automate SAP BusinessObjects BI Replication to Couchbase

  Use CData Sync to Customize and automate SAP BusinessObjects BI replication to Couchbase.

• How to create Visio diagrams from Microsoft Project

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

• Connect to Microsoft Planner in SpagoBI

  Create reports featuring live Microsoft Planner in SpagoBI Studio. Host Microsoft Planner reports on SpagoBI Server.

• Access SAP ByDesign as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP Business ByDesign from your Oracle system.

• Access Google Sheets from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Google Sheets from HeidiSQL.

• Query CockroachDB as a MySQL Database in Node.js

  Execute MySQL queries against CockroachDB from Node.js.

• Import Workday Using Azure Data Factory

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

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

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

• Automated Continuous Typeform Replication to MySQL

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

• Access Live IBM Informix in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to IBM Informix from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Connect to Smartsheet from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Smartsheet, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• How to connect to Impala from Spring Boot

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

• How to Use a Microsoft Access Database to Update Google Sheets in Real Time

  Update Google Sheets data by creating a linked table in Microsoft Access with the CData Google Sheets ODBC Driver.

• Build Salesforce Pardot-Connected Apps in Choreo

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

• Connect to SAP ByDesign in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access SAP Business ByDesign in Google Apps Script.

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

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

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

  Connect to Apache Spark SQL from a connection pool in Tomcat.

• Analyze Amazon S3 in R via JDBC

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

• Connect to Cvent in RapidMiner

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

• Build a Simple VCL Application for SAP Ariba Procurement

  How to build a simple VCL Application to view SAP Ariba Procurement in RAD Studio using the CData ODBC Driver for SAP Ariba Procurement.

• Connect to IBM Informix from Asprova with CData Software ODBC Driver for IBM Informix

  This article shows how to connect faster to IBM Informix data from Asprova.

• How to Query Shippo in MySQL Workbench

  Execute MySQL queries against live Shippo from MySQL Workbench.

• DataBind Aha to the DevExpress Data Grid

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

• Use the CData Software JDBC Driver for Square in MicroStrategy

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

• Query MailChimp in DataGrip

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

• Query JSON Services in MySQL Workbench

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

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

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

• Replicate Dynamics 365 Business Central to Multiple Databases via the CData Sync CLI

  Replicate Dynamics 365 Business Central to disparate databases with a single configuration.

• Automated Continuous Salesforce Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Salesforce replication to Amazon Redshift.

• Connect to Neo4J in HULFT Integrate

  Connect to Neo4J as a JDBC data source in HULFT Integrate

• Manage Bullhorn CRM in DBArtisan as a JDBC Source

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

• Integrate IBM Cloud Object Storage into Automated Tasks with Power Automate

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

• How to load JDBC-ODBC Bridge data into Elasticsearch via Logstash

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

• Build a Simple VCL Application for Sugar CRM

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

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

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

• How to Build an ETL App for Impala in Python with CData

  Create ETL applications and real-time data pipelines for Apache Impala in Python with petl.

• Connect to SAP HANA XS Advanced in JRuby

  Create a simple JRuby app with access to live SAP HANA XS Advanced.

• Work with Live ShipStation in Power Query

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

• Use the CData Software ODBC Driver for Blackbaud FE NXT in MicroStrategy

  Connect to Blackbaud FE NXT in MicroStrategy Developer using the CData Software ODBC Driver for Blackbaud FE NXT.

• Back Up MariaDB to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for MariaDB. In this article, we will employ an SSIS workflow to populate a database with MariaDB data.

• Create Apps from SAP Fieldglass in Qlik Sense Cloud

  Use the CData Connect Server to create an OData API for SAP Fieldglass and build apps from live SAP Fieldglass in Qlik Sense Cloud.

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

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

• Automated Continuous Excel Replication to Google BigQuery

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

• How to Query Live Access Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Microsoft Access data in natural language using Python.

• Connect to Avalara AvaTax in RapidMiner

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

• Integrate GraphQL in Your Informatica Cloud Instance

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

• Use the CData Software ODBC Driver for Dynamics 365 Business Central in MicroStrategy

  Connect to Dynamics 365 Business Central in MicroStrategy Developer using the CData Software ODBC Driver for Dynamics 365 Business Central.

• Create SSAS Tabular Models from SAP SuccessFactors

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

• Automate Coinbase Integration Tasks from PowerShell

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

• How to Query Live Sybase IQ Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Sybase IQ data in natural language using Python.

• Automated Continuous Certinia Replication to SQL Server

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

• Natively Connect to SAP SuccessFactors in PHP via ODBC (Linux)

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

• Automated Continuous SAP Replication to SQLite

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

• Visualize Live eBay Analytics of Power BI Report Builder in Power BI Service

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

• Connect to Live PCA Sales in MicroStrategy through CData Connect Cloud

  Create a live connection to PCA Sales in CData Connect Cloud and connect to your PCA Sales from MicroStrategy.

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

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

• Create XML Dataflows on PowerBI.com

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

• Integrate Authorize.Net with External Services using SnapLogic

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

• Automated Continuous GraphQL Replication to PostgreSQL

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

• Create HCL Domino Reports on JasperReports Server

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

• ETL Kafka in Oracle Data Integrator

  This article shows how to transfer Apache Kafka into a data warehouse using Oracle Data Integrator.

• How to Work with Google Drive in AWS Glue Jobs Using JDBC

  Connect to Google Drive from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Connect to Real-Time Impala Data in Power Apps Using Dataflows to Build Custom Applications

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