CData Software - Knowledge Base

Recent Articles

• «
• 68
• 69
• 70
• 71
• 72
• 73
• 74
• 75
• 76
• 77
• »

• Connect to Dynamics NAV as a Linked Server

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Dynamics NAV.

• Connect to Live Veeva in MicroStrategy through CData Connect Cloud

  Create a live connection to Veeva in CData Connect Cloud and connect to your Veeva Vault from MicroStrategy.

• Build MVC Applications with Connectivity to Avalara AvaTax

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

• Automate Google Contacts Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Google Contacts from PowerShell? This article demonstrates how to utilize the Google Contacts Cmdlets for tasks like connecting to Google Contacts, automating operations, downloading data, and more.

• Build Charts with IBM Cloud Object Storage in Clear Analytics

  Create dynamic charts and perform analytics based on IBM Cloud Object Storage in Clear Analytics.

• Replicate Multiple NetSuite Accounts

  Replicate multiple NetSuite accounts to one or many databases.

• DataBind QuickBooks Time to the DevExpress Data Grid

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

• SQL Access to Redis Data

  An article highlighting the available features and functionality of CData Software Drivers for Redis.

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Azure Table

  Provide connectivity to Azure Table Storage through an SAP BusinessObjects universe.

• Query Oracle HCM Cloud through ODBC in Node.js

  Use node-odbc to execute SQL queries against Oracle HCM Cloud from Node.js.

• Query RSS Feeds as a MySQL Database in Node.js

  Execute MySQL queries against RSS Feeds from Node.js.

• Replicate Multiple Monday.com Accounts

  Replicate multiple Monday.com accounts to one or many databases.

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

  Connect to real-time Microsoft Dataverse (CDS) in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Microsoft Dataverse.

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

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

• How to connect and process DB2 from Azure Databricks

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

• Automated Continuous Paylocity Replication to SQL Server

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

• Automate Instagram Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Instagram from PowerShell? This article demonstrates how to utilize the Instagram Cmdlets for tasks like connecting to Instagram, automating operations, downloading data, and more.

• Visualize Odoo from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Odoo ERP.

• Build Visualizations of Live Pipedrive in Power BI (through CData Connect)

  Use CData Connect to create a virtual database for Pipedrive and build custom reports in Power BI.

• Replicate Monday.com to Multiple Databases

  Replicate Monday.com to disparate databases with a single configuration.

• How to Visualize Salesloft Data in Python with pandas

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

• How to publish and share Reckon Accounts Hosted dashboards with Tableau Server

  The CData ODBC driver for Reckon Accounts Hosted enables you integrate Reckon Accounts Hosted into Tableau dashboards.

• Connect to Live Phoenix in MicroStrategy through CData Software Connect Server

  Create a virtual database for Phoenix in CData Software Connect Server and connect to it from MicroStrategy.

• Build OData-Connected ETL Processes in Google Data Fusion

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

• How to connect to Klaviyo from Spring Boot

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

• Create Datasets from Asana in Domo Workbench and Build Visualizations of Asana in Domo

  Use the CData Software ODBC Driver for Asana to create datasets from Asana in Domo Workbench and then build visualizations in the Domo service.

• How to connect to HarperDB from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for HarperDB and work with HarperDB in Microsoft Excel on Mac OS X.

• Analyze Invoiced in R

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

• Connect to Confluence in CloverDX (formerly CloverETL)

  Transfer Atlassian Confluence using the visual workflow in the CloverDX data integration tool.

• DataBind SAP BusinessObjects BI to the DevExpress Data Grid

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

• Connect to Typeform from a Connection Pool in JBoss

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

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

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

• Connect to Elasticsearch in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Elasticsearch in Airbyte.

• Analyze Avro with Power Pivot

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

• How to pipe Authorize.Net to CSV in PowerShell

  Use standard PowerShell cmdlets to access Authorize.Net tables.

• Connect to Dynamics 365 from PowerBuilder

  This article demonstrates how to access Microsoft Dynamics 365 from PowerBuilder using the Dynamics 365 JDBC Driver.

• Analyze Live eBay in SAS Viya

  Use CData Connect Cloud to connect to eBay from SAS Viya and deploy self-service analytics using live eBay.

• Connect to SAP ByDesign in Jaspersoft Studio

  Execute SQL to remote SAP Business ByDesign in Jaspersoft Studio.

• Automated Continuous SAP HANA Replication to AlloyDB

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

• Use CData Connect Cloud to Access Redshift in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Amazon Redshift in the Power Pivot business intelligence tool.

• Back Up Azure Data Catalog to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Azure Data Catalog. In this article, we will employ an SSIS workflow to populate a database with Azure Data Catalog data.

• Connect to AlloyDB in JRuby

  Create a simple JRuby app with access to live Google AlloyDB.

• Automated Continuous Zendesk Replication to Apache Kafka

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

• Automated Zendesk Replication to Teradata

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

• Connect to EnterpriseDB in SpagoBI

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

• Build Dashboards with Bitbucket in Dundas BI

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

• Build Trello-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for Trello and create custom apps in Mendix.

• Connect to Harvest from PowerBuilder

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

• Connect to TaxJar in RapidMiner

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

• Create a Data Access Object for Slack using JDBI

  A brief overview of creating a SQL Object API for Slack in JDBI.

• Connect to Pipedrive in HULFT Integrate

  Connect to Pipedrive as a JDBC data source in HULFT Integrate

• Integrate Live Google Calendar into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to Google Calendar and integrate live Google Calendar into apps built in Microsoft Power Apps.

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

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

• Use Biml to Build SSIS Tasks to Replicate Azure Active Directory to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Azure Active Directory to SQL Server.

• Automate Presto Replication to SAP HANA

  Use CData Sync to customize and automate Presto replication to SAP HANA.

• How to Access Live Square in Power Automate Desktop via ODBC

  The CData ODBC Driver for Square enables you to integrate Square into workflows built using Microsoft Power Automate Desktop.

• Create Act CRM-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Act CRM from Klipfolio and build custom visualizations using live Act CRM.

• Automated Continuous Oracle Financials Cloud Replication to MySQL

  Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to MySQL.

• Connect to Freshdesk in DBArtisan

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

• DataBind Controls to Elasticsearch in Delphi

  DataBind to Elasticsearch in Delphi with standard data access components and controls.

• Build Semantic Layer Views for Oracle Financials Cloud in APOS Live Data Gateway

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

• Visualize NetSuite from Tableau

  Use the Tableau Desktop business intelligence tool to connect to NetSuite CRM & ERP.

• How to update Jira Assets from Excel

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

• Replicate Multiple Zoho Books Accounts

  Replicate multiple Zoho Books accounts to one or many databases.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Connect to Google Analytics as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Google Analytics.

• Connect to Square from PowerBuilder

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

• Access Live Microsoft Exchange in Google Sheets

  Use CData Connect Cloud to gain access to live Microsoft Exchange from your Google Sheets.

• Automated Continuous Slack Replication to PostgreSQL

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

• PowerShell Scripting to Replicate Xero to MySQL

  Write a simple PowerShell script to replicate Xero Accounting to a MySQL database.

• Build Automated Azure Analysis Services-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live Azure Analysis Services and build automated workflows in Zapier.

• Access Live NetSuite in Excel for the Web (Excel 365/Online)

  Connect to NetSuite CRM & ERP from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Access Twitter Ads in PHP through Connect Server

  Connect to Twitter Ads through the standard SQL Server libraries in PHP.

• Import and Visualize Impala in Power View

  Create data visualizations based on Apache Impala in Excel.

• Using AngularJS to Build Dynamic Web Pages with Dynamics GP

  Use the CData Connect Server to create Dynamics GP OData feeds and build single-page applications with live Microsoft Dynamics GP.

• Import Real-Time SQL Server in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Microsoft SQL Server in ColdFusion.

• How to integrate Snowflake with Apache Airflow

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

• Connect to HubSpot as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live HubSpot.

• Automate Bing Search Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Bing Search from PowerShell? This article demonstrates how to utilize the Bing Search Cmdlets for tasks like connecting to Bing Search, automating operations, downloading data, and more.

• How to work with OData Services in Apache Spark using SQL

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

• Access Square from MySQL in HeidiSQL

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

• Integrate with Oracle Service Cloud in JReport Designer

  Create charts and reports based on Oracle Service Cloud in JReport Designer.

• Rapidly Develop SAP Hybris C4C-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

• Natively Connect to Teradata in PHP

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

• Connect to Pipedrive in CloverDX (formerly CloverETL)

  Transfer Pipedrive using the visual workflow in the CloverDX data integration tool.

• Create Data Visualizations Based On GitHub in Mode

  Use CData Connect Cloud to connect to GitHub from Mode and build visualizations using live

• Natively Connect to Oracle HCM Cloud in PHP

  The CData ODBC driver for Oracle HCM Cloud enables you to create PHP applications with connectivity to Oracle HCM Cloud. Leverage the native support for ODBC in PHP.

• Replicate Multiple Salesforce Accounts

  Replicate multiple Salesforce accounts to one or many databases.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Excel Spreadsheet Automation with the QUERY Formula

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

• Create Zoho Inventory Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for Zoho Inventory to build custom dashboards in Bold BI.

• LINQ to eBay Analytics

  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 eBay Analytics Data Provider.

• How to Access Live Redshift in Power Automate Desktop via ODBC

  The CData ODBC Driver for Redshift enables you to integrate Amazon Redshift into workflows built using Microsoft Power Automate Desktop.

• Build Automated Stripe-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live Stripe and build automated workflows in Zapier.

• Use the CData Software ODBC Driver for Oracle Financials Cloud in MicroStrategy Desktop

  Connect to Oracle Financials Cloud in MicroStrategy Desktop using the CData Software ODBC Driver for Oracle Financials Cloud.

• Import MYOB AccountRight into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to MYOB AccountRight and provide access to live MYOB AccountRight for custom reports in the Power BI Service.

• Analyze Microsoft Dataverse in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Microsoft Dataverse (CDS) and visualize Microsoft Dataverse (CDS) in SAP Analytics Cloud.

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

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

• Connect to HCL Domino as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live HCL Domino.

• Build QuickBooks Online Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live QuickBooks Online and build visualizations in Tableau Cloud.

• «
• 68
• 69
• 70
• 71
• 72
• 73
• 74
• 75
• 76
• 77
• »