CData Software - Knowledge Base

Recent Articles

• «
• 114
• 115
• 116
• 117
• 118
• 119
• 120
• 121
• 122
• 123
• »

• How to work with Avro in Apache Spark using SQL

  Access and process Avro in Apache Spark using the CData Software JDBC Driver.

• Creating Sugar CRM-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Sugar CRM to Unqork and build custom business apps.

• Access Live Amazon DynamoDB in Excel (Desktop) via Connect Cloud

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

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

• Consume Sage 200 OData Feeds in PowerBuilder

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

• Build Dashboards with Active Directory in DBxtra

  Create dynamic dashboards and perform analytics based on Active Directory in DBxtra.

• Connect to HubSpot in ACL Analytics

  Connect to HubSpot via CData Connect Cloud in ACL Analytics to run your data analysis workflows with real-time access to HubSpot.

• Create Data Visualizations in Cognos BI with Avro

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

• LINQ to HDFS

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

• Working with Databricks in LINQPad

  Execute LINQ queries to Databricks in LINQPad.

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

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

• Publish Drip-Connected Dashboards in Tableau Server via JDBC

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

• Automated Continuous Salesforce Pardot Replication to MongoDB

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

• Use Claude to Talk to Your SAP BusinessObjects BI via CData Connect Cloud

  Leverage CData Connect Cloud Remote MCP to enable Claude to securely answer questions and take actions on your SAP BusinessObjects BI for you.

• Natively Connect to QuickBooks in PHP via ODBC (Linux)

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

• Query Cassandra as a MySQL Database in Node.js

  Execute MySQL queries against Apache Cassandra from Node.js.

• Build Apps with Live SurveyMonkey in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live SurveyMonkey into the Adalo platform and build custom mobile and web applications with real-time SurveyMonkey.

• Create Power BI Reports on Real-Time Authorize.Net

  Use the CData ODBC Driver for Authorize.Net to visualize Authorize.Net in Power BI Desktop.

• Validate Google Spanner with QuerySurge

  Access and validate Google Spanner in QuerySurge using the CData JDBC Driver.

• Create Informatica Mappings From/To a JDBC Data Source for Microsoft Planner

  Create Microsoft Planner data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• How to Work with SAP ByDesign in ETL Validator JDBC

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

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

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

• Build Semantic Layer Views for Google Calendar in APOS Live Data Gateway

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

• Publish Google Campaign Manager 360-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Google Campaign Manager 360.

• Extend Google Sheets with Clio

  Make calls to the API Server from Google Apps Script.

• Connect to Live Google Ads in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Google Ads in CData Connect Cloud and connect to your Google Ads from PostgreSQL.

• Connect to Tableau CRM Analytics from AWS Glue

  Use CData Connect Cloud to gain access to live Tableau CRM Analytics from your AWS Glue jobs.

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

• Edit and Search External Hive Objects in Salesforce Connect

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

• Access Live JDBC-ODBC Bridge in AWS Lambda (with IntelliJ IDEA)

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

• How to Create Power BI Visual Reports with Real-Time Adobe Commerce

  Use CData Power BI Connectors to visualize Adobe Commerce in Power BI.

• Publish Reports with HubDB in SAP Crystal Reports

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

• Automated Continuous Kafka Replication to SQLite

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

• Automated Continuous Wave Financial Replication to SQL Server

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

• Visualize Live ClickUp in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live ClickUp.

• Connect to DB2 as a Linked Server via SQL Gateway

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

• Automated Continuous OneNote Replication to Google Cloud SQL

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

• Access Amazon DynamoDB as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Amazon DynamoDB from your Oracle system.

• How to work with Certinia in Apache Spark using SQL

  Access and process Certinia in Apache Spark using the CData Software JDBC Driver.

• Connect to Salesloft in RapidMiner

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

• Use Claude to Talk to Your Instagram via CData Connect Cloud

  Leverage CData Connect Cloud Remote MCP to enable Claude to securely answer questions and take actions on your Instagram for you.

• Analyze BambooHR with Power Pivot

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

• Automated Continuous SuiteCRM Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable SuiteCRM replication to AlloyDB.

• Connect to HCL Domino in DBArtisan

  Use wizards in DBArtisan to configure HCL Domino as a data source.

• Work with EnterpriseDB in FoxPro

  Load EnterpriseDB into a FoxPro database. This article includes full code and a walk-through of the process.

• Build Visualizations of Zoho Books in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zoho Books in Birst.

• Access Live Klipfolio Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live Klipfolio data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• Natively Connect to Certinia in PHP via ODBC (Linux)

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

• Prepare, Blend, and Analyze Google Analytics in Alteryx Designer (ODBC)

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

• How to create Access federated tables in MySQL

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

• Integrate with Epicor Kinetic in JReport Designer

  Create charts and reports based on Epicor Kinetic in JReport Designer.

• How to create an RPA flow for Google Spanner in UiPath Studio

  Use the Google Spanner ODBC Driver to create workflows that access real-time Google Spanner without any coding.

• How to connect to Redis from IntelliJ

  Integrate connectivity to Redis with wizards in IntelliJ.

• Connect to Shopify as a Linked Server via SQL Gateway

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

• Access Live LinkedIn Ads in Excel (Desktop) via Connect Cloud

  Use CData Connect Cloud to gain access to live LinkedIn Ads from your Excel spreadsheets.

• Analyze Excel in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of Microsoft Excel and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

• Visualize Dynamics CRM from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Microsoft Dynamics CRM.

• Automated Continuous Amazon Athena Replication to IBM DB2

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

• Build Google Ads-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Google Ads and build web apps with connectivity to live Google Ads.

• Process & Analyze GraphQL in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live GraphQL .

• Connect to HCL Domino in the Denodo Platform

  Use CData driver technologies to create a virtual data source for HCL Domino in the Denodo Virtual DataPort Administrator.

• Analyze Zoho CRM in Looker

  Use CData Connect Cloud to connect to Zoho CRM from Looker and build custom apps using live Zoho CRM.

• Create Reports with SAP BusinessObjects BI in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date SAP BusinessObjects BI.

• How to Easily Query ShipStation in OpenOffice Base

• «
• 114
• 115
• 116
• 117
• 118
• 119
• 120
• 121
• 122
• 123
• »