CData Software - Knowledge Base

Recent Articles

• «
• 179
• 180
• 181
• 182
• 183
• 184
• 185
• 186
• 187
• 188
• »

• Query Outreach.io as a MySQL Database in Node.js

  Execute MySQL queries against Outreach.io from Node.js.

• Migrating data from ClickUp to Databricks using CData SSIS Components.

  Easily push ClickUp to Databricks using the CData SSIS Tasks for ClickUp and Databricks.

• Sugar CRM Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Sugar CRM through CData Connect AI using different applications and tools.

• Integrate Live Microsoft Planner into Amazon SageMaker Canvas with RDS

  Use CData Connect AI to connect to Microsoft Planner from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Microsoft Planner.

• Automated Continuous Trello Replication to SQL Server

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

• Connect to Excel Online as a SQL Server Linked Server

  Use CData Connect AI to create a linked server for live Microsoft Excel Online.

• Operational Reporting on Oracle from Spotfire Server

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

• Analyze Klipfolio with Power Pivot

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

• Create Google Search-Connected Business Apps in AppSheet

  Connect to Google Search Results via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Google Search.

• Access Zoho CRM from MySQL in Amazon QuickSight

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

• Use Biml to Build SSIS Tasks to Replicate Sage 300 to SQL Server

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

• ServiceNow Reporting in OBIEE with the ServiceNow JDBC Driver

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

• Stream Kafka into Apache Kafka Topics

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

• Visualize Live SAP BusinessObjects BI of Power BI Report Builder in Power BI Service

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

• Publish Crystal Reports on Microsoft Exchange

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

• Build a Singer.io Tap for Paylocity With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live Paylocity data using

• Use JayDeBeApi to access Salesforce in Python

  Use standard Python scripting and the development environment of your choice to access live Salesforce & Force.com.

• Analyze SharePoint in Cognos Analytics

  Use CData Connect AI to connect to SharePoint from Cognos Analytics and analyze live Microsoft SharePoint.

• How to work with SQL Server in Apache Spark using SQL

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

• Connect to Box from PowerBuilder via ADO.NET

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

• How to load CockroachDB data into Elasticsearch via Logstash

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

• Replicate Multiple Google Ad Manager Accounts via the CData Sync CLI

  Replicate multiple Google Ad Manager accounts to one or many databases.

• Connect to Google Campaign Manager 360 from Filemaker Pro (Mac)

  Use CData Connect AI to connect to and query live Google Campaign Manager 360 from Filemaker Pro on Mac.

• Feed Acumatica into FineReport

  How to set Acumatica ERP as a JDBC data source in FineReport.

• Explore Geographical Relationships in Epicor Kinetic with Power Map

  Create data visualizations with Epicor Kinetic in Power Map.

• Connect to PayPal in SpagoBI

  Create reports featuring live PayPal in SpagoBI Studio. Host PayPal reports on SpagoBI Server.

• Use the CData Software JDBC Driver for HubDB in MicroStrategy Desktop

  Connect to HubDB in MicroStrategy Desktop using the CData Software JDBC Driver for HubDB.

• Connect to Aha from Asprova with CData Software ODBC Driver for Aha

  This article shows how to connect faster to Aha data from Asprova.

• Replicate Cassandra from PowerShell

  Write a quick PowerShell script to query Apache Cassandra. Use connectivity to the live data to replicate Apache Cassandra to SQL Server.

• Create Reports with Couchbase in SAP Crystal Reports

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

• How to Connect to & Open ADP in Microsoft Excel

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

• Automate Google Search Results Replication to Couchbase

  Use CData Sync to Customize and automate Google Search replication to Couchbase.

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

• Access Live Harvest Data in Tableau with CData API Server

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

• Import ActiveCampaign into the Power BI Service for Visualizations

  Use CData Connect AI to connect to ActiveCampaign and provide access to live ActiveCampaign for custom reports in the Power BI Service.

• Automate Microsoft Exchange Replication to Couchbase

  Use CData Sync to Customize and automate Microsoft Exchange replication to Couchbase.

• Visualize Live Workday in the Power BI Service

  Use CData Connect AI to connect to live Workday and create custom reports in the Power BI Service through the On-Premises Gateway.

• Analyze Live SAP Hybris C4C in SAS Viya

  Use CData Connect AI to connect to SAP Hybris C4C from SAS Viya and deploy self-service analytics using live SAP Hybris C4C.

• Replicate Tableau CRM Analytics from PowerShell

  Write a quick PowerShell script to query Tableau CRM Analytics. Use connectivity to the live data to replicate Tableau CRM Analytics to SQL Server.

• Connect to Google Sheets from HeidiSQL

  Use CData Connect AI to connect to and query live Google Sheets from HeidiSQL.

• Use the CData Software ODBC Driver for Amazon Marketplace in MicroStrategy

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

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

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

• Integrate Live Asana into Amazon SageMaker Canvas with RDS

  Use CData Connect AI to connect to Asana from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Asana.

• Automated Continuous Excel Online Replication to Local Delimited Files

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

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

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

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

  Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Microsoft SharePoint.

• Access Acumatica from MySQL in Amazon QuickSight

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

• Automate Elasticsearch Replication to Azure Data Lake

  Use CData Sync to customize and automate Elasticsearch replication to Azure Data Lake.

• How to connect to FTP with Squirrel SQL client

  Connect to FTP Servers and execute queries in the Squirrel SQL Client.

• Build Tally-Connected ETL Processes in Google Data Fusion

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

• DataBind Wave Financial to the DevExpress Data Grid

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

• Connect to SAP HANA XS Advanced in Aqua Data Studio

  Access SAP HANA XS Advanced from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Microsoft Exchange Reporting in OBIEE with the Microsoft Exchange JDBC Driver

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

• Publish Crystal Reports on Excel

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

• Build Dashboards with Gmail in DBxtra

  Create dynamic dashboards and perform analytics based on Gmail in DBxtra.

• Connect to Google Drive from Blazor Apps

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

• DataBind Controls to Zoho Creator in C++Builder

  DataBind to Zoho Creator in C++Builder with standard components and controls.

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

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

• GraphQL Reporting and Star Schemas in OBIEE

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

• Access Live Marketo in Excel (Desktop) via Connect AI

  Use CData Connect AI to gain access to live Marketo from your Excel spreadsheets.

• Build Agents in Relevance AI with Access to Live Tableau CRM Analytics via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Tableau CRM Analytics within intelligent agent workflows.

• Build MVC Applications with Connectivity to Presto

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Presto from an ASP.NET MVC application.

• Connect to MarkLogic in DBeaver

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

• Connect to SAP BusinessObjects BI as an External Data Source using PolyBase

  Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live SAP BusinessObjects BI.

• Freshdesk Reporting in OBIEE with the Freshdesk JDBC Driver

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

• Connect to Paylocity from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Paylocity to connect to Paylocity and execute queries in PowerBuilder.

• Provide OData Services of Impala from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Apache Impala by developing a WCF Service Application.

• Create Data Visualizations in Cognos BI with Azure Synapse

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

• Connect to Zoho Books in Claris FileMaker Pro

• «
• 179
• 180
• 181
• 182
• 183
• 184
• 185
• 186
• 187
• 188
• »