CData Software - Knowledge Base

Recent Articles

• «
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• »

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

  Connect to Apache HBase in MicroStrategy Web using the CData Software JDBC Driver for HBase.

• Connect to CSV as a Linked Server

  Use CData Connect to set up a linked server for CSV/TSV Files.

• LINQ to Oracle

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

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

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

• Access Live Sugar CRM in Excel (Desktop)

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

• Visualize Power BI XMLA in TIBCO Spotfire through OData

  Integrate Power BI XMLA into dashboards in TIBCO Spotfire.

• Connect to and Query IBM Cloud Data Engine in QlikView over ODBC

  Create data visualizations with IBM Cloud Data Engine in QlikView.

• Import Oracle SCM Using Azure Data Factory

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

• Visualize AlloyDB in TIBCO Spotfire through ODBC

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

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

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

• Create IBM Informix Dataflows on PowerBI.com

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

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

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

• Analyze FHIR with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for FHIR from Power Pivot. You will use the Table Import Wizard to load FHIR. You can visually build the import query or use any SQL supported by the driver.

• How to connect to Azure Synapse from Spring Boot

  Connect to Azure Synapse in a Spring Boot Application using CData JDBC Azure Synapse Driver

• Access HBase from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Apache HBase from HeidiSQL.

• Access QuickBooks Online from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live QuickBooks Online from HeidiSQL.

• DataBind Wijmo Grid to Instagram

  Provide real-time Instagram to interactive controls.

• DataBind Charts to Amazon S3

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Amazon S3 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.

• Connect to Oracle Eloqua in Ruby

  Connect to Oracle Eloqua in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• SAP ByDesign Reporting and Star Schemas in OBIEE

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

• How to create MYOB AccountRight federated tables in MySQL

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

• Connect to and Query SAP Fieldglass in QlikView over ODBC

  Create data visualizations with SAP Fieldglass in QlikView.

• Access Avalara AvaTax in PHP through Connect Server

  Connect to Avalara AvaTax through the standard SQL Server libraries in PHP.

• Establish a Live Connection with MongoDB using Tableau Bridge

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

• Access SAP 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 SAP ERP/NetWeaver.

• How to update Basecamp from Excel

  This article explains how to transfer data from Excel to Basecamp using the Excel Add-In for Basecamp.

• Import Real-Time Azure Table in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Azure Table Storage in ColdFusion.

• Automated Continuous Sage 200 Replication to Local Delimited Files

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Sage 50 UK

  Provide connectivity to Sage 50 UK through an SAP BusinessObjects universe.

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

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

• ETL Unbounce in Oracle Data Integrator

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

• How to Query Facebook Ads in MySQL Workbench

  Execute MySQL queries against live Facebook Ads from MySQL Workbench.

• Access Freshdesk from MySQL in PHP

  Connect to Freshdesk through the standard MySQL libraries in PHP.

• Automate SAP Business One Replication to Azure Synapse

  Use CData Sync to customize and automate SAP Business One replication to Azure Synapse.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Create MailChimp-Connected Nintex Workflows

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

• Create OneNote-Connected Nintex Workflows

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

• Automated Continuous Quickbase Replication to Amazon Redshift

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

• Automate ConstantContact Replication to Couchbase

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

• Build Dynamics NAV-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Microsoft Dynamics NAV and build web apps with connectivity to live Microsoft Dynamics NAV.

• Automated SAP Ariba Procurement Replication to Teradata

  Use CData Sync to Customize and automate SAP Ariba Procurement replication to Teradata.

• Replicate Sage 200 for Use in Salesforce Connect

  Replicate Sage 200 to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Publish Crystal Reports on Cvent

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

• Publish Presto-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Presto.

• Build Dashboards with Oracle HCM Cloud in DBxtra

  Create dynamic dashboards and perform analytics based on Oracle HCM Cloud in DBxtra.

• ShipStation Reporting in OBIEE with the ShipStation JDBC Driver

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

• How to connect to Presto from Spring Boot

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

• Create SQL Server Reports on JasperReports Server

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

• How to connect to Office 365 from MS Excel on Mac OS X

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

• Automated Continuous SAP BusinessObjects BI Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Amazon Redshift.

• Automated Continuous Power BI XMLA Replication to Oracle

  Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Oracle.

• Automated Continuous SAP Concur Replication to Amazon S3

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

• Excel Spreadsheet Automation with the QUERY Formula

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

• Connect to SharePoint Excel Services from PowerBuilder

  This article demonstrates how to access SharePoint Excel Services from PowerBuilder using the SharePoint Excel Services JDBC Driver.

• Connect to Freshdesk in Google Apps Script

  Use CData Connect Cloud to access Freshdesk in Google Apps Script.

• Automated Continuous SAP Fieldglass Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to IBM DB2.

• How to Connect to & Open QuickBooks Time in Microsoft Excel

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

• Bridge JSON Connectivity with Apache NiFi

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

• Model Hive Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Hive, enabling the direct import of real-time Apache Hive.

• Connect to Odoo from a Connection Pool in Jetty

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

• How to create Splunk federated tables in MySQL

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

• Use the CData ODBC Driver for Avro in SAS JMP

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

• Connect to Adobe Commerce in Google Apps Script

  Use CData Connect Cloud to access Adobe Commerce in Google Apps Script.

• Query BigCommerce in MySQL Workbench

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

• Connect to and Visualize Live Google Sheets in Tableau Prep

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

• Create JotForm 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 and Visualize Live Airtable in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Airtable.

• Automated Continuous SharePoint Excel Services Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to PostgreSQL.

• How to connect to WooCommerce with Squirrel SQL client

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

• Publish Crystal Reports on Shippo

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

• Replicate Multiple Dynamics GP Accounts

  Replicate multiple Dynamics GP accounts to one or many databases.

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

• Connect to JDBC-ODBC Bridge from a Connection Pool in JBoss

  Integrate JDBC-ODBC Bridge into Java servlets: Use the Management Console in JBoss to install the JDBC-ODBC Bridge JDBC Driver.

• How to connect to Salesforce Marketing from Spring Boot

  Connect to Salesforce Marketing in a Spring Boot Application using CData JDBC Salesforce Marketing Driver

• How to connect to SendGrid from Spring Boot

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

• Integrate JotForm in the Pentaho Report Designer

  Publish reports based on JotForm in the Pentaho BI tool.

• Connect to Facebook Ads in CloverDX (formerly CloverETL)

  Transfer Facebook Ads using the visual workflow in the CloverDX data integration tool.

• Integrate ServiceNow into Power Automate Desktop using CData Connect

  CData Connect for ServiceNow enables you to integrate ServiceNow into workflows built using Microsoft Power Automate Desktop.

• Build Semantic Layer Views for Salesforce Pardot in APOS Live Data Gateway

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

• Integrate Live Twitter Ads into Amazon SageMaker Canvas with RDS

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

• Connect to PostgreSQL in HULFT Integrate

  Connect to PostgreSQL as a JDBC data source in HULFT Integrate

• Integrate Adobe Analytics into Power Automate Desktop using CData Connect

  CData Connect for Adobe Analytics enables you to integrate Adobe Analytics into workflows built using Microsoft Power Automate Desktop.

• DataBind Controls to Jira in Delphi

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

• Integrate with Sage Intacct in JReport Designer

  Create charts and reports based on Sage Intacct in JReport Designer.

• Integrate with Azure Data Lake Storage using Apache Camel2

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

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

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

• Integrate with Facebook using Apache Camel2

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

• Build Amazon Marketplace-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Amazon Marketplace.

• Automated Continuous YouTube Analytics Replication to SingleStore

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

• Access OneNote from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft OneNote from HeidiSQL.

• Create Reports with SharePoint in SAP Crystal Reports

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

• Automated Continuous Typeform Replication to PostgreSQL

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

• Build Amazon S3-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Amazon S3 from Zoho Analytics and import live Amazon S3.

• Manage Calendly in DBArtisan as a JDBC Source

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

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Monday.com

  Provide connectivity to Monday.com through an SAP BusinessObjects universe.

• Replicate Jira to Multiple Databases

  Replicate Atlassian Jira to disparate databases with a single configuration.

• Access Live Couchbase in Coginiti Pro

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

• Export Data from SQL Server to MailChimp through SSIS

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

• Use CData Connect Cloud to Access Zoho Creator in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Zoho Creator in the Power Pivot business intelligence tool.

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

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

• «
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• »