CData Software - Knowledge Base

Recent Articles

• «
• 81
• 82
• 83
• 84
• 85
• 86
• 87
• 88
• 89
• 90
• »

• How to Use CData Connect to Access Live Procore in Power Automate

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

• How to Connect the Power BI Service to Splunk: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• Build an OLAP Cube in SSAS from Shopify

  Establish a connection to Shopify data from SQL Server Analysis Services, and use the Shopify Data Provider to build OLAP cubes for use in analytics and reporting.

• How to connect PolyBase to TaxJar

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

• Natively Connect to Dynamics NAV in PHP

  The CData ODBC driver for Dynamics NAV enables you to create PHP applications with connectivity to Microsoft Dynamics NAV. Leverage the native support for ODBC in PHP.

• Connect to Invoiced from PowerBuilder

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

• Connect to Confluence in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Build PostgreSQL-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live PostgreSQL.

• How to Work with Hive in ETL Validator JDBC

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

• Query SAP Hybris C4C as a MySQL Database in Node.js

  Execute MySQL queries against SAP Hybris C4C from Node.js.

• Use the CData Software ODBC Driver for WooCommerce in MicroStrategy

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

• Automated Continuous Shopify Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Shopify replication to Snowflake.

• Replicate Multiple Raisers Edge NXT Accounts

  Replicate multiple Raisers Edge NXT accounts to one or many databases.

• Use Dash to Build to Web Apps on FHIR

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

• DataBind Charts to Microsoft Planner

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

• Visualize Live Google Ads in Power BI (via CData Connect Cloud)

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

• How to Access Impala Using Entity Framework

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

• Build QuickBooks-Connected Dashboards in Redash

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

• Integrate Live HDFS into Custom Business Apps Built in Power Apps

  Use CData Software Connect Server to create a virtual SQL Server Database for Apache HDFS and integrate live Apache HDFS into apps built in Microsoft Power Apps.

• Integrate with Live MySQL in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to MySQL from the MuleSoft Anypoint Platform to integrate live MySQL into custom reports and dashboards.

• Replicate ConstantContact to Multiple Databases

  Replicate ConstantContact to disparate databases with a point-and-click configuration.

• Create Dynamic Dynamics NAV Grids Using the Infragistics XamDataGrid

  Learn how you can connect Dynamics NAV to Infragistics XamDataGrid to build dynamic grids.

• Access Live Oracle SCM in Coginiti Pro

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

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

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

• Access MariaDB from MySQL in Amazon QuickSight

  Connect to MariaDB and build visualizations of MariaDB using a MySQL Connection in Amazon QuickSight.

• Visualize Live SAP HANA in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live SAP HANA.

• Connect to Greenhouse as a Linked Server

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

• Publish Reports with SuiteCRM in SAP Crystal Reports

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

• ETL Avalara AvaTax in Oracle Data Integrator

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

• Integrate with Live SAP Business One in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to SAP Business One from the MuleSoft Anypoint Platform to integrate live SAP Business One into custom reports and dashboards.

• How to integrate Trello with Apache Airflow

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

• Integrate MySQL in Your Informatica Cloud Instance

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

• Model Jira Service Management Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Jira Service Management, enabling the direct import of real-time Atlassian Jira Service Management.

• Create Reports from Oracle HCM Cloud in Looker Studio

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

• Create Raisers Edge NXT-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Raisers Edge NXT from OutSystems and build custom enterprise apps using live Raisers Edge NXT.

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

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

• Stream Pinterest into Apache Kafka Topics

  Access and stream Pinterest in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• How to integrate Dynamics CRM with Apache Airflow

  Access and process Microsoft Dynamics CRM in Apache Airflow using the CData JDBC Driver.

• Facebook Ads Reporting in OBIEE with the Facebook Ads JDBC Driver

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

• Integrate Elasticsearch in the Pentaho Report Designer

  Publish reports based on Elasticsearch in the Pentaho BI tool.

• Integrate with live Zoho CRM in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Zoho CRM in Jitterbit.

• Access Live Amazon DynamoDB in Excel (Desktop)

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

• Import Real-Time Act-On in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Act-On in ColdFusion.

• How to Connect the Power BI Service to Dropbox: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• Automated Continuous Zoho CRM Replication to Databricks

  Use CData Sync for automated, continuous, customizable Zoho CRM replication to Databricks.

• Build Oracle-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Oracle from Zoho Analytics and import live Oracle Database.

• Integrate Unbounce in the Pentaho Report Designer

  Publish reports based on Unbounce in the Pentaho BI tool.

• How to Connect to eBay Analytics in Using Python: 6 Steps

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

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

  Provide connectivity to SAP Ariba Source through an SAP BusinessObjects universe.

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

  Create ETL applications and real-time data pipelines for CSV/TSV Files in Python with petl.

• Query Splunk in ColdFusion

  Write standard ColdFusion data access code to connect to Splunk.

• Write a Simple Go Application to work with Redshift on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Amazon Redshift.

• Query CockroachDB in ColdFusion

  Write standard ColdFusion data access code to connect to CockroachDB.

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

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

• Automated Continuous Todoist Replication to Local Delimited Files

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

• How to Query Amazon Marketplace in MySQL Workbench

  Execute MySQL queries against live Amazon Marketplace from MySQL Workbench.

• Query TigerGraph in DataGrip

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

• Create Data Visualizations in Cognos BI with Zoho Inventory

  Access Zoho Inventory as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• How to create Instagram federated tables in MySQL

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

• Publish CouchDB-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Apache CouchDB.

• DataBind Charts to Couchbase

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

• Publish Reports with HubSpot in SAP Crystal Reports

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

• Excel Spreadsheet Automation with the QUERY Formula

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

• Using the CData Software ODBC Driver for Kintone in PyCharm

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

• Build Automated Workflows with Live Shopify in Workato

  Use CData Connect Cloud to connect to live Shopify and build automated workflows in Workato.

• How to Build Dynamic React Apps with PayPal

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

• How to connect to Act-On with Squirrel SQL client

  Connect to Act-On and execute queries in the Squirrel SQL Client.

• Integrate Freshdesk in the Pentaho Report Designer

  Publish reports based on Freshdesk in the Pentaho BI tool.

• How to connect to SAP HANA with Squirrel SQL client

  Connect to SAP HANA and execute queries in the Squirrel SQL Client.

• Integrate with live Amazon S3 in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Amazon S3 in Jitterbit.

• How to create Reckon federated tables in MySQL

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

• Automated Continuous Zendesk Replication to Vertica

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

• Create Dynamic Google Drive Grids Using the Infragistics XamDataGrid

  Learn how you can connect Google Drive to Infragistics XamDataGrid to build dynamic grids.

• Connect to and Visualize Live Amazon DynamoDB in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Amazon DynamoDB.

• Use the CData Software ODBC Driver for Act-On in MicroStrategy Web

  Connect to Act-On in MicroStrategy Web using the CData Software ODBC Driver for Act-On.

• Create XML-Connected Business Apps in AppSheet

  Use CData Software Connect Server to connect to XML from AppSheet and build custom business apps using live XML Files.

• Connect to Zoho Inventory in HULFT Integrate

  Connect to Zoho Inventory as a JDBC data source in HULFT Integrate

• Connect to Adobe Commerce from Asprova with CData Software ODBC Driver for Adobe Commerce

  This article shows how to connect faster to Adobe Commerce data from Asprova.

• Use the CData Software JDBC Driver for Google Data Catalog in MicroStrategy

  Connect to Google Data Catalog in MicroStrategy Developer using the CData Software JDBC Driver for Google Data Catalog.

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

  Use LlamaIndex to query live Jira Assets data in natural language using Python.

• Connect to Dynamics NAV from a Connection Pool in Jetty

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

• Use Biml to Build SSIS Tasks to Replicate NetSuite to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate NetSuite CRM & ERP to SQL Server.

• Create Reports with Sage Cloud Accounting in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Sage Business Cloud Accounting.

• Object-Relational Mapping (ORM) with SAP Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to SAP ERP/NetWeaver into a Java-based ORM framework, Hibernate.

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

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

• Natively Connect to Klipfolio in PHP

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

• Create Square Reports on JasperReports Server

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

• Automated Continuous Kintone Replication to PostgreSQL

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

• Operational Reporting on Stripe from Spotfire Server

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

• Automated Continuous BambooHR Replication to PostgreSQL

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

• Use the CData ODBC Driver for Sage 50 UK in Microsoft Power Query

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

• Visualize SAP BusinessObjects BI in TIBCO Spotfire through ODBC

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

• Build Apps with Live Kafka Using the Low-Code Development Platform of Mendix

• «
• 81
• 82
• 83
• 84
• 85
• 86
• 87
• 88
• 89
• 90
• »