CData Software - Knowledge Base

Recent Articles

• «
• 75
• 76
• 77
• 78
• 79
• 80
• 81
• 82
• 83
• 84
• »

• Automated Continuous Parquet Replication to Amazon Redshift

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

• Use the CData Software JDBC Driver for SAS xpt in MicroStrategy Desktop

  Connect to SAS XPORT in MicroStrategy Desktop using the CData Software JDBC Driver for SAS xpt.

• Consume Google Cloud Storage OData Feeds in PowerBuilder

  This article demonstrates how to consume Google Cloud Storage as OData feeds from PowerBuilder using the API Server.

• View Reports on Real-Time Avalara AvaTax in Power BI Report Server

  Use the CData ODBC Driver for Avalara AvaTax to visualize Avalara AvaTax in Power BI Desktop and then publish them to Power BI Report Server.

• How to connect PolyBase to SharePoint

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft SharePoint.

• Analyze ADP in R via JDBC

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

• Connect to Azure Analysis Services from a Connection Pool in JBoss

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

• Creating Salesforce Pardot-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Salesforce Pardot to Unqork and build custom business apps.

• How to import Odoo into Apache Solr

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

• Analyze PostgreSQL in SAP Analytics Cloud

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

• Connect to MYOB AccountRight from PowerBuilder via JDBC

  This article demonstrates how to access MYOB AccountRight from PowerBuilder using the MYOB AccountRight JDBC Driver.

• Query Impala in DataGrip

  Create a Data Source for Impala in DataGrip and use SQL to query live Apache Impala.

• Build Freshdesk-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Freshdesk.

• Build Gmail-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Gmail from Zoho Analytics and import live Gmail.

• Replicate Snowflake to Multiple Databases via the CData Sync CLI

  Replicate Snowflake to disparate databases with a single configuration.

• Connect to HarperDB in Aqua Data Studio

  Access HarperDB from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Connect to MailChimp from a Connection Pool in WebLogic

  Use the CData JDBC Driver for MailChimp to connect to MailChimp from Web applications running on WebLogic.

• Build Azure Data Lake Storage-Connected ETL Processes in Google Data Fusion

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

• Connect SQL Server to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Microsoft SQL Server using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Build Trello-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Trello.

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

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

• Access Live SAP Business One in Excel (Desktop) via Connect Cloud

  Use CData Connect Cloud to gain access to live SAP Business One from your Excel spreadsheets.

• Import Reckon Accounts Hosted into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Reckon Accounts Hosted and provide access to live Reckon Accounts Hosted for custom reports in the Power BI Service.

• DataBind Controls to SAP Ariba Procurement in Delphi

  DataBind to SAP Ariba Procurement in Delphi with standard data access components and controls.

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

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

• Automated Continuous Google Calendar Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Google Calendar replication to OneLake in Microsoft Fabric.

• Query PingOne through ODBC in Node.js

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

• Import Real-Time Zendesk via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Zendesk in ColdFusion.

• Visualize Parquet in Sisense

  Create an ElastiCube in Sisense app with access to Apache Parquet.

• Connect to HCL Domino from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from HCL Domino, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• How to work with RSS Feeds in Apache Spark using SQL

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

• Automated Continuous SurveyMonkey Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Apache Cassandra.

• Connect to Zuora from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Zuora from Crystal Reports.

• Connect to QuickBooks Online in SpagoBI

  Create reports featuring live QuickBooks Online in SpagoBI Studio. Host QuickBooks Online reports on SpagoBI Server.

• PowerShell Scripting to Replicate SAP Ariba Procurement to MySQL

  Write a simple PowerShell script to replicate SAP Ariba Procurement to a MySQL database.

• Build Google Calendar Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Google Calendar and build visualizations in Tableau.

• Visualize Azure Data Lake Storage in TIBCO Spotfire through OData

  Integrate Azure Data Lake Storage into dashboards in TIBCO Spotfire.

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

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

• Back Up Atlassian Jira Service Management to SQL Server through SSIS

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

• LINQ to Impala

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

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

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

• Connect to Kafka as an External Source in Dremio

  Use the CData JDBC Driver to connect to Kafka as an External Source in Dremio.

• Work with Sybase IQ in FoxPro

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

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

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

• Publish Crystal Reports on Calendly

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

• Access Live ConstantContact in Coginiti Pro

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

• How to Seamlessly Import Google Analytics Data into IBM SPSS Modeler

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

• Analyze SAP ByDesign with Power Pivot

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

• Access Live SharePoint in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Microsoft SharePoint from your Google Sheets.

• Visualize SAP SuccessFactors in TIBCO Spotfire through ADO.NET

  Integrate SAP SuccessFactors into dashboards in TIBCO Spotfire.

• How to Connect to & Open Power BI XMLA in Microsoft Excel

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

• Integrate Microsoft Planner in the Pentaho Report Designer

  Publish reports based on Microsoft Planner in the Pentaho BI tool.

• How to integrate Calendly with Apache Airflow

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

• Publish MongoDB-Connected Dashboards in Tableau Server via JDBC

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

• Use the CData Software ODBC Driver for NetSuite in MicroStrategy

  Connect to NetSuite CRM & ERP in MicroStrategy Developer using the CData Software ODBC Driver for NetSuite.

• Visualize Azure Analysis Services in TIBCO Spotfire through OData

  Integrate Azure Analysis Services into dashboards in TIBCO Spotfire.

• Create SingleStore-Connected Dashboards in Grafana

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

• Excel Spreadsheet Automation on MySQL with the QUERY Formula

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

• Query, Visualize, and Share live Sage Cloud Accounting in Redash

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

• Model, Search, and Visualize Live Twilio in ThoughtSpot

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

• PowerShell Scripting to Replicate Act CRM to MySQL

  Write a simple PowerShell script to replicate Act CRM to a MySQL database.

• Automated Continuous Marketo Replication to MySQL

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

• Integrate with live SendGrid in Jitterbit

  Use CData Connect Cloud to connect to and integrate live SendGrid in Jitterbit.

• Connect to and Query Sage Cloud Accounting in QlikView over ODBC

  Create data visualizations with Sage Business Cloud Accounting in QlikView.

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

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

• Connect to Impala in Ruby

  Connect to Apache Impala in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Create Facebook-Connected Enterprise Applications in OutSystems

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

• Connect to Twitter as a Linked Server via SQL Gateway

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

• Establish a Live Connection with HDFS using Tableau Bridge

  The CData ODBC Driver for HDFS enables you to integrate live Apache HDFS into Tableau Cloud dashboards using the Tableau Bridge.

• Build Data Flows from SQL Server to XML through SSIS

  Easily push SQL Server data to XML using the CData SSIS Tasks for XML.

• Connect to CouchDB in SpagoBI

  Create reports featuring live Apache CouchDB in SpagoBI Studio. Host CouchDB reports on SpagoBI Server.

• Back Up Google Calendar to SQL Server through SSIS

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

• Automated Continuous Microsoft Teams Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Microsoft Teams replication to Snowflake.

• Connect to Pipedrive in Claris FileMaker Pro

• «
• 75
• 76
• 77
• 78
• 79
• 80
• 81
• 82
• 83
• 84
• »