CData Software - Knowledge Base

Recent Articles

• «
• 163
• 164
• 165
• 166
• 167
• 168
• 169
• 170
• 171
• 172
• »

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

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

• Integrate Live Reckon Accounts Hosted into Custom Business Apps Built in Power Apps

  Use CData Software Connect Server to create a virtual SQL Server Database for Reckon Accounts Hosted and integrate live Reckon Accounts Hosted into apps built in Microsoft Power Apps.

• Connect to Highrise in RapidMiner

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

• Replicate Adobe Analytics to Multiple Databases

  Replicate Adobe Analytics to disparate databases with a point-and-click configuration.

• How to publish and share WordPress dashboards with Tableau Server

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

• Use the CData SSIS Components to Insert New or Update Existing Cvent Records from SQL Server

  Easily push SQL Server data to Cvent using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Cvent or update existing records with data from a SQL Server database.

• Access Live Xero in Coginiti Pro

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

• Connect to Live Raisers Edge NXT in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Raisers Edge NXT in CData Connect Cloud and connect to your Raisers Edge NXT from PostgreSQL.

• Create Apps from Adobe Analytics in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Adobe Analytics and build apps from live Adobe Analytics in Qlik Sense Cloud.

• Access Greenplum 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 Pivotal GreenPlum.

• Extract, Transform, and Load Klipfolio in Informatica PowerCenter

  Create a simple Workflow for Klipfolio in Informatica PowerCenter.

• Automate Amazon Athena Replication to Couchbase

  Use CData Sync to Customize and automate Amazon Athena replication to Couchbase.

• Replicate MYOB AccountRight for Use in Salesforce Connect

  Replicate MYOB AccountRight to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Visualize Salesloft in TIBCO Spotfire through ODBC

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

• How to Connect the Power BI Service to SAP Fieldglass: Complete Guide

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

• ETL Google Cloud Storage in Oracle Data Integrator

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

• Build Apps with Live GraphQL in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live GraphQL into the Adalo platform and build custom mobile and web applications with real-time GraphQL.

• Connect to Spark in Jaspersoft Studio

  Execute SQL to remote Apache Spark SQL in Jaspersoft Studio.

• Build Apps with Live IBM Informix in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live IBM Informix into the Adalo platform and build custom mobile and web applications with real-time IBM Informix.

• A PostgreSQL Interface for Parquet

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

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

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

• DataBind Wijmo Grid to Asana

  Provide real-time Asana to interactive controls.

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

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

• Automated Continuous Azure DevOps Replication to Local Delimited Files

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

• Access Neo4J as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Neo4J from your Oracle system.

• How to Query OData Services in MySQL Workbench

  Execute MySQL queries against live OData from MySQL Workbench.

• Perform Batch Operations with SQL Server in Apache NiFi

  Connect to Microsoft SQL Server and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Connect to HubDB in as an External Source in Dremio

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

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

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

• How to Query SurveyMonkey in MySQL Workbench

  Execute MySQL queries against live SurveyMonkey from MySQL Workbench.

• Build Visualizations of Microsoft Exchange in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft Exchange in Birst.

• How to connect Amazon QuickSight to Google Sheets

  Create a connection to Google Sheets in CData Connect Cloud and insert Google Sheets into Amazon QuickSight SPICE to build interactive dashboards.

• Use the CData ODBC Driver for Xero in SAS JMP

  You can use the CData ODBC Driver to integrate Xero Accounting into the statistical analysis tools available in SAS JMP. This article shows how to use Xero Accounting in the Graph Builder and Query Builder.

• Visualize Google Spanner in TIBCO Spotfire through ODBC

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

• How to connect to Azure Active Directory in DBVisualizer

  Integrate Azure Active Directory with visual data analysis tools and data connection wizards in DBVisualizer

• Publish Reports with Oracle Financials Cloud in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Oracle Financials Cloud.

• Extract, Transform, and Load Raisers Edge NXT in Informatica PowerCenter

  Create a simple Workflow for Raisers Edge NXT in Informatica PowerCenter.

• Extract, Transform, and Load ADP in Informatica PowerCenter

  Create a simple Workflow for ADP in Informatica PowerCenter.

• How to import Facebook into Apache Solr

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

• LINQ to Wave Financial

  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 Wave Financial Data Provider.

• How to Build an ETL App for Twitter Ads in Python with CData

  Create ETL applications and real-time data pipelines for Twitter Ads in Python with petl.

• Visualize Zenefits in Tableau Desktop (through CData Connect)

  Create a virtual SQL Server database for Zenefits in CData Software Connect (or Connect Server) and build visualizations from live Zenefits in Tableau Desktop.

• Create Apps from Acumatica in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Acumatica and build apps from live Acumatica ERP in Qlik Sense Cloud.

• Build Slack Visualizations in Tableau Cloud

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

• Query SQL Analysis Services in DataGrip

  Create a Data Source for SQL Analysis Services in DataGrip and use SQL to query live SQL Analysis Services.

• Access Twitter from MySQL in Amazon QuickSight

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

• Automated Continuous SharePoint Replication to Vertica

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

• Connect to HDFS in the Denodo Platform

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

• Connect to and Query SAP Hybris C4C in QlikView over ODBC

  Create data visualizations with SAP Hybris C4C in QlikView.

• Creating Instagram-Connected Applications in Unqork

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

• Troubleshooting Column Size Restrictions in Microsoft Query

  Microsoft Query limits the total size of all columns selected. When all columns are selected, this may result in an error. The solution is to set the Maximum Column Size property.

• Operational Reporting on ConstantContact from Spotfire Server

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

• Integrate with Spark in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Apache Spark SQL in SnapLogic.

• Connect to Sybase in NetBeans

  Connect to Sybase in NetBeans with the data source configuration wizard.

• Query WooCommerce as a MySQL Database in Node.js

  Execute MySQL queries against WooCommerce from Node.js.

• Query Printful as a MySQL Database in Node.js

  Execute MySQL queries against Printful from Node.js.

• How to import EventBrite into Apache Solr

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

• Create SSAS Tabular Models from SAP ByDesign

  How to build a SQL Server Analysis Service Tabular Model from SAP Business ByDesign using CData drivers.

• Integrate SAP Ariba Source in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Ariba Source from Informatica Cloud.

• Automated Continuous Twitter Replication to MySQL

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

• Automated Continuous OData Replication to AlloyDB

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

• Connect to Azure DevOps from PowerBuilder

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

• Excel Spreadsheet Automation with the QUERY Formula

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

• Operational Reporting on Google Search Results from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Google Search.

• Automated Continuous SAP Hybris C4C Replication to Vertica

  Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Vertica.

• Access Harvest as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Harvest from your Oracle system.

• Use JayDeBeApi to access SAP in Python

  Use standard Python scripting and the development environment of your choice to access live SAP ERP/NetWeaver.

• DataBind Charts to QuickBooks Online

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to QuickBooks Online from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• Choosing the Best Method to Connect Basecamp to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use Basecamp from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Connect to Stripe in DBArtisan

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

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

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

• LINQ to SAP Fieldglass

  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 SAP Fieldglass Data Provider.

• Deploy the ADO.NET Provider for Acumatica on an SSRS Report Server

  Connect to Acumatica ERP from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Connect to Facebook Ads in Ruby

  Connect to Facebook Ads in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• DataBind HarperDB to the DevExpress Data Grid

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

• Enable the Oracle JDBC Driver in KNIME

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

• Visualize Printify in TIBCO Spotfire through ODBC

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

• Connect to Google Spanner in NetBeans

  Connect to Google Spanner in NetBeans with the data source configuration wizard.

• Integrate Live Teradata into Custom Business Apps Built in Power Apps

  Use CData Software Connect Server to create a virtual SQL Server Database for Teradata and integrate live Teradata into apps built in Microsoft Power Apps.

• Automate Blackbaud FE NXT Replication to Azure Data Lake

  Use CData Sync to customize and automate Blackbaud FE NXT replication to Azure Data Lake.

• Automated Continuous SharePoint Replication to PostgreSQL

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

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

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

• Connect to Invoiced in Jaspersoft Studio

  Execute SQL to remote Invoiced in Jaspersoft Studio.

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

  Connect to Microsoft Exchange from a connection pool in Tomcat.

• Connect to Google Cloud Storage from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Google Cloud Storage to connect to Google Cloud Storage from Web applications running on WebLogic.

• Visualize Live Office 365 in the Power BI Service

  Use CData Connect Cloud to connect to live Microsoft Office 365 and create custom reports in the Power BI Service through the On-Premises Gateway.

• Publish Certinia-Connected Dashboards in Tableau Server

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

• Connect to Couchbase in Aqua Data Studio

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

• Build Pipelines with Live SAP Concur in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to SAP Concur from Google Cloud Data Fusion, enabling the integration of live SAP Concur into the building and management of effective data pipelines.

• Explore Geographical Relationships in Sage 50 UK with Power Map

  Create data visualizations with Sage 50 UK in Power Map.

• Connect to Live Hive in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Hive in CData Connect Cloud and connect to your Apache Hive from PostgreSQL.

• Connect to Sage 300 in Aqua Data Studio

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

• PowerShell Scripting to Replicate Zoom to MySQL

  Write a simple PowerShell script to replicate Zoom to a MySQL database.

• How to pipe Redshift to CSV in PowerShell

  Use standard PowerShell cmdlets to access Redshift tables.

• DataBind Controls to Shopify in Delphi

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

• How to Connect DBeaver to Blackbaud FE NXT via a JDBC Driver

  Manage Blackbaud FE NXT with visual tools in DBeaver like the query browser.

• Connect to and Visualize Live Spark in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Apache Spark SQL.

• How to Work with SAP SuccessFactors in AWS Glue Jobs Using JDBC

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

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

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

• How to Build Dynamic React Apps with Neo4J

  Use the CData Connect and React to Build Dynamic Web Apps with Live Neo4J .

• «
• 163
• 164
• 165
• 166
• 167
• 168
• 169
• 170
• 171
• 172
• »