CData Software - Knowledge Base

Recent Articles

• «
• 266
• 267
• 268
• 269
• 270
• 271
• 272
• 273
• 274
• 275
• »

• Visualize SurveyMonkey in Tableau

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

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

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

• How to Build an ETL App for Oracle Service Cloud in Python with CData

  Create ETL applications and real-time data pipelines for Oracle Service Cloud in Python with petl.

• Automated Continuous Greenplum Replication to IBM DB2

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

• Edit and Search External Dynamics 365 Business Central Objects in Salesforce Connect

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

• How to connect SharePoint with SharePoint Excel Services through external lists

  Provide SharePoint Excel Services to SharePoint users as an external list.

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

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

• Publish Adobe Commerce-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Adobe Commerce.

• Excel Spreadsheet Automation on Act-On with the QUERY Formula

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

• How to Connect to & Open Oracle Sales in Microsoft Excel

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

• Query Google Sheets from Node.js

  Use the OData endpoint of the CData API Server to connect to your Google Sheets and perform CRUD operations on Google Sheets from Node.js.

• Create Sage 200 Dataflows on PowerBI.com

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

• How to integrate RSS with Apache Airflow

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

• How to import Printful into Apache Solr

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

• Create Workday-Connected Visualizations in Klipfolio

  Use CData Connect AI to connect to Workday from Klipfolio and build custom visualizations using live Workday.

• Neo4J Reporting and Star Schemas in OBIEE

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

• Connect to Printful from a Connection Pool in JBoss

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

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

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate TaxJar to SQL Server.

• Query Presto using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume Presto entities in PHP by modeling them as objects.

• Automated Continuous Stripe Replication to MongoDB

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

• Build Charts with SQL Server in Clear Analytics

  Create dynamic charts and perform analytics based on Microsoft SQL Server in Clear Analytics.

• Integrate IBM Cloud Object Storage with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate IBM Cloud Object Storage with External Services.

• Build Facebook-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live Facebook.

• Use the CData Software ODBC Driver for Azure Table in MicroStrategy

  Connect to Azure Table Storage in MicroStrategy Developer using the CData Software ODBC Driver for Azure Table.

• Access Tableau CRM Analytics from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Tableau CRM Analytics from HeidiSQL.

• Automated Continuous Sage Cloud Accounting Replication to MySQL

  Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to MySQL.

• Automated eBay Replication to Teradata

  Use CData Sync to Customize and automate eBay replication to Teradata.

• Access Live Oracle HCM Cloud in SAS JMP via ODBC

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

• How to connect to FTP from Spring Boot

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

• How to publish and share Raisers Edge NXT dashboards with Tableau Server

  The CData ODBC driver for Raisers Edge NXT enables you integrate Raisers Edge NXT into Tableau dashboards.

• Configure the CData JDBC Driver for SAP Business One in a Connection Pool in Tomcat

  Connect to SAP Business One from a connection pool in Tomcat.

• Build a Simple VCL Application for CSV

  How to build a simple VCL Application to view CSV/TSV Files in RAD Studio using the CData ODBC Driver for CSV.

• Query Printify in DataGrip

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

• DataBind Odoo to the DevExpress Data Grid

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

• Edit and Search Microsoft Planner External Objects in Salesforce Connect (API Server)

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

• Connect to Salesloft from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Salesloft using standard SQL.

• How to Import Data from Zoho Books into Google Sheets

  Import Zoho Books into a Google spreadsheet that is automatically refreshed.

• Import Facebook Ads into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Facebook Ads. In this article, you will use the OData format to import Facebook Ads into Microsoft Power Query.

• Operational Reporting on Facebook Ads from Spotfire Server

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

• Load Printify to a Database Using Embulk

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

• Building Dynamic Web Pages with Google Spanner Using AngularJS

  Create single-page applications with live connectivity to Google Spanner using the CData API Server.

• PowerShell Scripting to Replicate Azure DevOps to MySQL

  Write a simple PowerShell script to replicate Azure DevOps to a MySQL database.

• Object-Relational Mapping (ORM) with Teradata 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 Teradata into a Java-based ORM framework, Hibernate.

• Connect Redis to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Redis using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Analyze Google Sheets in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Google Sheets and visualize live Google Sheets in Infragistics Reveal.

• Connect to Tableau CRM Analytics from Crystal Reports

  Use CData Connect AI to connect to and report on live Tableau CRM Analytics from Crystal Reports.

• How to Connect to Live IBM Informix in Mistral AI Workflows

  Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live IBM Informix without replication.

• Design BIRT Reports on TaxJar

  Provide current TaxJar to your embedded analytics.

• Query Freshdesk as a SQL Server Database in Node.js

  Execute SQL Server queries against Freshdesk from Node.js.

• Visualize Xero in TIBCO Spotfire through OData

  Integrate Xero Accounting into dashboards in TIBCO Spotfire.

• How to Query SAP Concur in MySQL Workbench

  Execute MySQL queries against live SAP Concur from MySQL Workbench.

• Bridge Vault CRM Connectivity with Apache NiFi

  Access and process Veeva Vault & Vault CRM in Apache NiFi using the CData JDBC Driver.

• Consume Google Sheets OData Feeds in PowerBuilder

  This article demonstrates how to consume Google Sheets as OData feeds from PowerBuilder using the API Server.

• Model Cassandra Using Azure Analysis Services

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

• How to create Act CRM federated tables in MySQL

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

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

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

• Automated Continuous Vault CRM Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable Vault CRM replication to Azure SQL Database.

• Validate EnterpriseDB with QuerySurge

  Access and validate EnterpriseDB in QuerySurge using the CData JDBC Driver.

• Operational Reporting on SAP HANA XS Advanced from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote SAP HANA XS Advanced.

• Replicate Multiple Google Search Accounts

  Replicate multiple Google Search accounts to one or many databases.

• How to use SQLAlchemy ORM to access WordPress in Python

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

• Use the CData Software ODBC Driver for Epicor Kinetic in MicroStrategy Desktop

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

• Automated Continuous Sugar CRM Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Sugar CRM replication to Apache Cassandra.

• Build Reckon Accounts Hosted-Connected Web Apps with Axios and CData Connect AI

  Use CData Connect AI to connect to live Reckon Accounts Hosted and build Reckon Accounts Hosted-connected web apps with Axios.

• Connect to Blackbaud FE NXT in Google Apps Script via Connect AI

  Use CData Connect AI to access Blackbaud FE NXT in Google Apps Script.

• Replicate Multiple SAP Netweaver Gateway Accounts

  Replicate multiple SAP Netweaver Gateway accounts to one or many databases.

• Use Dash to Build to Web Apps on SAP Concur

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

• How to connect SharePoint with Adobe Commerce through external lists

  Provide Adobe Commerce to SharePoint users as an external list.

• Create Power BI Reports on Real-Time Microsoft Teams

  Use the CData ODBC Driver for Microsoft Teams to visualize Microsoft Teams in Power BI Desktop.

• Connect to Gmail from a Connection Pool in Jetty

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

• Perform Batch Operations with MailChimp in Apache NiFi

  Connect to MailChimp and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Access ConstantContact from MySQL in HeidiSQL

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

• Automated Continuous SAP Netweaver Gateway Replication to MySQL

  Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to MySQL.

• How to Visualize Paylocity Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Paylocity in Python.

• Visualize Live ADP in Power BI (via CData Connect AI)

  Use the CData Power BI Connector and CData Connect AI to integrate live ADP into custom reports in Power BI.

• Feed Google Ad Manager into FineReport

  How to set Google Ad Manager as a JDBC data source in FineReport.

• Build Semantic Layer Views for QuickBooks Online in APOS Live Data Gateway

  Use the CData Connector for QuickBooks Online in APOS Live Data Gateway to build Semantic Layer Views for QuickBooks Online.

• Access Live Hive in TIBCO Data Virtualization

• «
• 266
• 267
• 268
• 269
• 270
• 271
• 272
• 273
• 274
• 275
• »