CData Software - Knowledge Base

Recent Articles

• «
• 154
• 155
• 156
• 157
• 158
• 159
• 160
• 161
• 162
• 163
• »

• Automated Typeform Replication to Teradata

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

• Replicate IBM Cloud Object Storage from PowerShell

  Write a quick PowerShell script to query IBM Cloud Object Storage. Use connectivity to the live data to replicate IBM Cloud Object Storage to SQL Server.

• How to Work with Azure Data Catalog in ETL Validator JDBC

  Connect to Azure Data Catalog from ETL Validator jobs using the CData Software JDBC Driver.

• How to pipe Printify to CSV in PowerShell

  Use standard PowerShell cmdlets to access Printify tables.

• Create PCA Sales-Connected Dashboards in Grafana

  Connect to PCA Sales via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to PCA Sales.

• Extend Google Sheets with Google Ads

  Make calls to the API Server from Google Apps Script.

• Process & Analyze BigCommerce in Databricks (AWS)

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

• Create HubSpot-Connected Applications in Appsmith

  Connect to HubSpot via CData Connect Cloud in Appsmith and create custom business applications with real-time access to HubSpot.

• Query, Visualize, and Share live OData Services in Redash

  Use CData Connect Cloud to connect to live OData in Redash for querying, visualizing, and sharing.

• Enable the TaxJar JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with TaxJar.

• Automated Continuous SAP HANA Replication to MySQL

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

• Automate Workday Replication to SAP HANA

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

• How to Work with Sage Intacct in AWS Glue Jobs Using JDBC

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

• Automated Continuous Coinbase Replication to Vertica

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

• Migrating data from SAS Data Sets to Google BigQuery using CData SSIS Components.

  Easily push SAS Data Sets to Google BigQuery using the CData SSIS Tasks for SAS Data Sets and Google BigQuery.

• Automate Dynamics NAV Replication to Couchbase

  Use CData Sync to Customize and automate Microsoft Dynamics NAV replication to Couchbase.

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

  Connect to MySQL from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• How to Seamlessly Import Teradata Data into IBM SPSS Modeler

  Integrate Teradata data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Create Freshdesk Dataflows on PowerBI.com

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

• Create Data Visualizations in Cognos BI with QuickBooks

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

• Design BIRT Reports on Azure Data Lake Storage

  Provide current Azure Data Lake Storage to your embedded analytics.

• Replicate DB2 in Heroku for Use in Salesforce Connect

  Replicate IBM DB2 to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Access Live QuickBooks Time in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live QuickBooks Time from your Google Sheets.

• Use the CData API Server in Microsoft Power BI

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

• Model, Search, and Visualize Live Avalara AvaTax in ThoughtSpot

  Use CData Connect Cloud to connect to live Avalara AvaTax for modeling, searching, and visualizing.

• Connect to Redshift in the Denodo Platform

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

• Connect to SharePoint in ACL Analytics

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

• Build MVC Applications with Connectivity to Amazon S3

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

• Connect to and Visualize Live DocuSign in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live DocuSign.

• Create Wave Financial Dataflows on PowerBI.com

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

• Replicate Multiple Paylocity Accounts

  Replicate multiple Paylocity accounts to one or many databases.

• Automate Facebook Replication to SAP HANA

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

• Access Live CouchDB Data in Tableau with CData API Server

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

• Create HubSpot-Connected Dashboards in Grafana

  Connect to HubSpot via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to HubSpot.

• How to Connect the Power BI Service to Sage 300: Complete Guide

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

• Visualize YouTube Analytics from Tableau

  Use the Tableau Desktop business intelligence tool to connect to YouTube Analytics.

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

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

• Access Presto in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Presto.

• Access Live Salesforce Pardot in Excel 365 Online (Excel for the web)

  Connect to Salesforce Pardot from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• Query, Visualize, and Share live SAP HANA in Redash

  Use CData Connect Cloud to connect to live SAP HANA in Redash for querying, visualizing, and sharing.

• Extract, Transform, and Load Teradata in Informatica PowerCenter

  Create a simple Workflow for Teradata in Informatica PowerCenter.

• Publish Azure Active Directory-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Azure Active Directory.

• How to pipe Sage Cloud Accounting to CSV in PowerShell

  Use standard PowerShell cmdlets to access Sage Cloud Accounting tables.

• How to Access Live Microsoft OneDrive in Visual Studio Code via Cline

  Run the CData MCP Server for Microsoft OneDrive on Windows Subsytem for Linux (WSL) and connect to live Microsoft OneDrive from the Cline extension in Visual Studio Code.

• Create Power BI Reports on Real-Time OData Services

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

• Visualize xBase in Tableau

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

• Build an OLAP Cube in SSAS from Oracle Eloqua

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

• Excel Spreadsheet Automation on Bullhorn CRM with the QUERY Formula

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

• How to import Redshift into Apache Solr

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

• How to Seamlessly Import Procore Data into IBM SPSS Modeler

  Integrate Procore data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• How to connect to Dynamics 365 Business Central with Squirrel SQL client

  Connect to Dynamics 365 Business Central and execute queries in the Squirrel SQL Client.

• Create BigCommerce-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to BigCommerce from OutSystems and build custom enterprise apps using live BigCommerce.

• Analyze Couchbase in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Couchbase with the CData JDBC Driver for Couchbase.

• Connect to Jira Service Management in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Atlassian Jira Service Management in Airbyte.

• How to Connect to SharePoint Excel Services in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to SharePoint Excel Services. Leverage the pyodbc module for ODBC in Python.

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

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

• DataBind Controls to SingleStore in Delphi

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

• Use Dash to Build to Web Apps on Excel

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

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Epicor Kinetic

  Provide connectivity to Epicor Kinetic through an SAP BusinessObjects universe.

• Connect and Visualize Live Microsoft Teams Data in Databricks Lakehouse Federation with CData Connect Cloud

  Use CData Connect Cloud to integrate live Microsoft Teams into the Databricks platform and create visualization dashboards with real-time Microsoft Teams.

• Analyze SAP ByDesign in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of SAP Business ByDesign and visualize SAP Business ByDesign in SAP Analytics Cloud.

• LINQ to SAS Data Sets

  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 SAS Data Sets Data Provider.

• Connect to Access in CloverDX (formerly CloverETL)

  Transfer Microsoft Access using the visual workflow in the CloverDX data integration tool.

• Connect to Greenplum from PowerBuilder via ADO.NET

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

• Connect to Google Ads in CloverDX (formerly CloverETL)

  Transfer Google Ads using the visual workflow in the CloverDX data integration tool.

• Visualize your Salesforce Data in Tibco Spotfire

  Connect to Salesforce as an ADO.NET data source and create a simple dashboard in TIBCO Spotfire.

• How to Visualize Zoho Books Data in Python with pandas

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

• Visualize Okta in TIBCO Spotfire through ADO.NET

  Integrate Okta into dashboards in TIBCO Spotfire.

• Use CData Connect Cloud to Access Zoho CRM in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Zoho CRM in the Power Pivot business intelligence tool.

• How to import Power BI XMLA into Apache Solr

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

• Automated Continuous SingleStore Replication to IBM DB2

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

• Connect to OData Services in Google Apps Script via SQL Gateway

  Use the ODBC Driver for OData and the SQL Gateway to access OData from Google Apps Script.

• Connect to and Query Basecamp in QlikView over ODBC

  Create data visualizations with Basecamp in QlikView.

• How to Work with Azure Active Directory in AWS Glue Jobs Using JDBC

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

• Use the CData ODBC Driver for Azure Analysis Services from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Azure Analysis Services to connect to Azure Analysis Services from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Azure Analysis Services in Excel.

• Connect to HCL Domino as a SQL Server Linked Server

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

• Connect to MailChimp in SpagoBI

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

• How to Work with HarperDB in ETL Validator JDBC

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

• Connect to NetSuite from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for NetSuite to connect to NetSuite CRM & ERP and execute queries in PowerBuilder.

• Build a Simple VCL Application for XML

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

• Integrate SAP Business One into Power Automate Desktop using CData Connect

  CData Connect for SAP Business One enables you to integrate SAP Business One into workflows built using Microsoft Power Automate Desktop.

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

• Automated Continuous Redis Replication to Local Delimited Files

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

• Build a PostgreSQL Interface for CSV using the CData JDBC Driver

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

• Publish Reports with Zoho CRM in SAP Crystal Reports

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

• Back Up LDAP to SQL Server through SSIS

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

• Integrating Tableau CRM Analytics in Talend Cloud Data Management Platform

• «
• 154
• 155
• 156
• 157
• 158
• 159
• 160
• 161
• 162
• 163
• »