CData Software - Knowledge Base

Recent Articles

• «
• 131
• 132
• 133
• 134
• 135
• 136
• 137
• 138
• 139
• 140
• »

• Getting Started with the CData Excel Add-In for Snowflake

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Snowflake.

• A PostgreSQL Interface for HCL Domino (MySQL Remoting via JDBC)

  Use the Remoting features of the HCL Domino JDBC Driver to create a PostgreSQL entry-point for data access.

• Access Epicor Kinetic from MySQL in Amazon QuickSight

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

• How to Access Google Search Results Using Entity Framework

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

• Automate Coinbase Replication to Couchbase

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

• Analyze Azure Synapse in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Azure Synapse in Microsoft R Open.

• Configure the CData JDBC Driver for Klaviyo in a Connection Pool in Tomcat

  Connect to Klaviyo from a connection pool in Tomcat.

• Access Live Adobe Analytics in Excel 365 Online (Excel for the web)

  Connect to Adobe Analytics from Excel 365 Online (Excel for the web) with CData Connect AI.

• Replicate JotForm from PowerShell

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

• Use JayDeBeApi to access Access in Python

  Use standard Python scripting and the development environment of your choice to access live Microsoft Access.

• Visualize SingleStore in TIBCO Spotfire through ODBC

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

• Integrate with Live Jira Service Management in MuleSoft (via CData Connect AI)

  Use CData Connect AI to connect to Jira Service Management from the MuleSoft Anypoint Platform to integrate live Atlassian Jira Service Management into custom reports and dashboards.

• Connect to Oracle Financials Cloud in HULFT Integrate

  Connect to Oracle Financials Cloud as a JDBC data source in HULFT Integrate

• Use the CData ODBC Driver for Certinia in Microsoft Power Query

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

• How to connect and process Pipedrive from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Pipedrive.

• Create Apps from Power BI XMLA in Qlik Sense Cloud

  Use CData Connect AI to connect to Power BI XMLA and build apps from live Power BI XMLA in Qlik Sense Cloud.

• Work with Live Sage Cloud Accounting in Power Query

  Use CData Connect AI to connect to Sage Business Cloud Accounting and work with live Sage Business Cloud Accounting in Microsoft Power Query.

• How to Work with Invoiced in AWS Glue Jobs Using JDBC

  Connect to Invoiced from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Connect Drift to IBM WebSphere Using the CData JDBC Driver

  Use the CData JDBC Driver to connect Drift with IBM WebSphere for seamless data integration and connectivity.

• Automated Continuous SAP Ariba Procurement Replication to MySQL

  Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to MySQL.

• Create Dashboards and Visualize Live Odoo in Geckoboard

  Use CData Connect AI to connect to live Odoo ERP and create dashboards for real-time monitoring and visualization in Geckoboard.

• How to Query Live Jira Service Management in Perplexity MacOS Desktop

  Connect to and query live Jira Service Management in Perplexity Desktop using the CData MCP Server.

• Automated Continuous Power BI XMLA Replication to Snowflake

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

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed Google Drive to Power BI dashboards. Simply drag and drop Google Drive into data visuals on the Power BI canvas.

• Build an OLAP Cube in SSAS from Exact Online

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

• Publish XML-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live XML Files.

• Integrate Live Azure Analysis Services into Amazon SageMaker Canvas with RDS

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

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

  Use CData Power BI Connectors to visualize Okta in Power BI.

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

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

• Excel Spreadsheet Automation on Confluence with the QUERY Formula

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

• How to Connect to Live OData Services from crewAI Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your OData for you.

• Automated Continuous Invoiced Replication to MySQL

  Use CData Sync for automated, continuous, customizable Invoiced replication to MySQL.

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

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

• Use the CData Software ODBC Driver for Harvest in MicroStrategy Desktop

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

• How to Connect Flowise AI Agents to Live Cassandra via CData Connect AI

  Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.

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

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

• Query Dynamics CRM through ODBC in Node.js

  Use node-odbc to execute SQL queries against Microsoft Dynamics CRM from Node.js.

• Visualize Live GitHub in Tableau

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

• Automated Continuous MySQL Replication to Vertica

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

• How to connect SharePoint with SAP Business One through external lists

  Provide SAP Business One to SharePoint users as an external list.

• How to connect and process Salesforce Marketing Cloud from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Salesforce Marketing Cloud.

• Working with Bullhorn CRM in LINQPad

  Execute LINQ queries to Bullhorn CRM in LINQPad.

• Provide OData Services of AlloyDB from a WCF Application

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

• Import and Visualize Calendly in Power View

  Create data visualizations based on Calendly in Excel.

• ETL Azure Data Lake Storage in Oracle Data Integrator

  This article shows how to transfer Azure Data Lake Storage into a data warehouse using Oracle Data Integrator.

• Use Biml to Build SSIS Tasks to Replicate Exact Online to SQL Server

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

• Use the CData Software ODBC Driver for Monday.com in MicroStrategy Desktop

  Connect to Monday.com in MicroStrategy Desktop using the CData Software ODBC Driver for Monday.com.

• Connect to Square from PowerBuilder via ADO.NET

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

• Connect to Quickbase in DBArtisan

  Use wizards in DBArtisan to configure Quickbase as a data source.

• Build MVC Applications with Connectivity to HCL Domino

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

• Build Automated Workflows with Live Zendesk in Workato

  Use CData Connect AI to connect to live Zendesk and build automated workflows in Workato.

• Analyze Adobe Analytics in Cognos Analytics

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

• How to update Zoho CRM from Excel

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

• Replicate BambooHR from PowerShell

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

• How to Query Live Amazon Marketplace in Perplexity MacOS Desktop

  Connect to and query live Amazon Marketplace in Perplexity Desktop using the CData MCP Server.

• Create SSAS Tabular Models from Reckon

  How to build a SQL Server Analysis Service Tabular Model from Reckon using CData drivers.

• Consume Invoiced OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on Invoiced feeds that reflect any changes in SAP Lumira.

• Publish Airtable-Connected Dashboards in Tableau Server

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

• Replicate SAP HANA XS Advanced in Heroku for Use in Salesforce Connect

  Replicate SAP HANA XS Advanced to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Create a Data Access Object for Azure Data Catalog using JDBI

  A brief overview of creating a SQL Object API for Azure Data Catalog in JDBI.

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

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

• Automated Continuous Avro Replication to Azure SQL Database

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

• Build Microsoft Dataverse-Connected Dashboards Using Zoho Analytics

  Use CData Connect AI to connect to Microsoft Dataverse from Zoho Analytics and import live Microsoft Dataverse (CDS).

• Getting Started with the CData SSIS Components for Teradata

  Complete guide to installing, licensing, and connecting with the CData SSIS Components for Teradata.

• Connect to CouchDB in CloverDX (formerly CloverETL)

  Transfer Apache CouchDB using the visual workflow in the CloverDX data integration tool.

• Connect to Zendesk through External Services in Salesforce

  Use CData Connect AI to securely connect Salesforce External Services with Zendesk using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Connect to Sage Cloud Accounting in JRuby

  Create a simple JRuby app with access to live Sage Business Cloud Accounting.

• Integrating Dataiku with Redshift via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Amazon Redshift.

• Automated Continuous Zoom Replication to Amazon Redshift

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

• Access Azure Table from MySQL in PHP

  Connect to Azure Table through the standard MySQL libraries in PHP.

• Migrating data from AlloyDB to Google BigQuery using CData SSIS Components.

  Easily push Google AlloyDB to Google BigQuery using the CData SSIS Tasks for AlloyDB and Google BigQuery.

• Build Dashboards with Square in Dundas BI

  Create dynamic dashboards and perform analytics based on Square in Dundas BI.

• Publish Invoiced-Connected Dashboards in Tableau Server

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

• Create Data Visualizations Based On Xero in Mode

  Use CData Connect AI to connect to Xero from Mode and build visualizations using live

• Access Live Neo4J in Coginiti Pro

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

• Connect to Blackbaud FE NXT as a SQL Server Linked Server

  Use CData Connect AI to create a linked server for live Blackbaud FE NXT.

• Connect to Exact Online from Blazor Apps

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

• Square Cloud Connectivity

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

• Build LinkedIn-Connected Apps in Bubble

  Use CData Connect AI to create an OData feed for LinkedIn and create custom apps in Bubble.

• Connect to MarkLogic from PowerBuilder via ODBC

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

• Automate SAP Fieldglass Replication to Azure Synapse

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

• How to connect and process Quickbase from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Quickbase.

• Create Microsoft Project-Connected Dashboards in Grafana

  Connect to Microsoft Project via CData Connect AI in Grafana and create custom business dashboards with real-time access to Microsoft Project.

• Connect to SharePoint Excel Services in NetBeans

  Connect to SharePoint Excel Services in NetBeans with the data source configuration wizard.

• Build Dashboards with Google Sheets in DBxtra

  Create dynamic dashboards and perform analytics based on Google Sheets in DBxtra.

• Build Data Flows from Email to SQL Server using SSIS

  Easily back up Email to SQL Server using the SSIS components for Email.

• Getting Started with the CData Python Connector for Workday

  Learn to install and license the CData Python Connector

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

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

• Build Microsoft Teams-Connected Web Apps in Servoy

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

• Automate AlloyDB Replication to Azure Synapse

  Use CData Sync to customize and automate Google AlloyDB replication to Azure Synapse.

• ETL Sage 300 in Oracle Data Integrator

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

• How to Query SQL Analysis Services in MySQL Workbench

  Execute MySQL queries against live SQL Analysis Services from MySQL Workbench.

• Automated Impala Replication to Teradata

  Use CData Sync to Customize and automate Apache Impala replication to Teradata.

• Query eBay through ODBC in Node.js

  Use node-odbc to execute SQL queries against eBay from Node.js.

• Access MYOB AccountRight from MySQL in PHP

  Connect to MYOB AccountRight through the standard MySQL libraries in PHP.

• How to pipe Google Spanner to CSV in PowerShell

  Use standard PowerShell cmdlets to access Google Spanner tables.

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

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

• Connect to Real-Time PostgreSQL Data in Power Apps Using Dataflows to Build Custom Applications

• «
• 131
• 132
• 133
• 134
• 135
• 136
• 137
• 138
• 139
• 140
• »