CData Software - Knowledge Base

Recent Articles

• «
• 328
• 329
• 330
• 331
• 332
• 333
• 334
• 335
• 336
• 337
• »

• How to import Hive into Apache Solr

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

• Connect to Excel Online 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 Microsoft Excel Online.

• Connect to Phoenix in RapidMiner

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

• Rapidly Develop Shippo-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.

• How to create an RPA flow for Klaviyo in UiPath Studio

  Use the Klaviyo ODBC Driver to create workflows that access real-time Klaviyo without any coding.

• Connect to Google Data Catalog in JRuby

  Create a simple JRuby app with access to live Google Data Catalog.

• Analyze WordPress in Looker

  Use CData Connect Cloud to connect to WordPress from Looker and build custom apps using live WordPress.

• Use the CData Software ODBC Driver for Azure Data Catalog in MicroStrategy Desktop

  Connect to Azure Data Catalog in MicroStrategy Desktop using the CData Software ODBC Driver for Azure Data Catalog.

• How to Connect DBeaver to Sage Cloud Accounting via a JDBC Driver

  Manage Sage Business Cloud Accounting with visual tools in DBeaver like the query browser.

• Automated Continuous Microsoft Project Replication to Local Delimited Files

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

• Visualize SurveyMonkey from Tableau

  Use the Tableau Desktop business intelligence tool to connect to SurveyMonkey.

• Manage Shopify in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Shopify.

• How to Work with Zoho Inventory in ETL Validator JDBC

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

• Create EventBrite Dashboards in Bold BI

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

• Bridge Excel Connectivity with Apache NiFi

  Access and process Microsoft Excel in Apache NiFi using the CData JDBC Driver.

• How to connect PolyBase to Instagram

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

• Choosing the Best Method to Connect Google Campaign Manager 360 to SQL Server: 5 Options Explained

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

• Visualize Live Cosmos DB in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Azure Cosmos DB.

• Excel Spreadsheet Automation on BigCommerce with the QUERY Formula

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

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

  Connect to ActiveCampaign 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.

• Build Data Flows from Google Search to SQL Server using SSIS

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

• Creating FTP-Connected Applications in Unqork

  You can use CData Connect to feed FTP Servers to Unqork and build custom business apps.

• How to integrate MailChimp with Apache Airflow

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

• Back Up Azure Table Storage to SQL Server through SSIS

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

• Import Access into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for Access and create custom reports in the Power BI Service.

• How to Query Slack in MySQL Workbench

  Execute MySQL queries against live Slack from MySQL Workbench.

• Analyze Live Outreach.io in SAS Viya

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

• Connect to Facebook Ads in SpagoBI

  Create reports featuring live Facebook Ads in SpagoBI Studio. Host Facebook Ads reports on SpagoBI Server.

• Query Office 365 in DataGrip

  Create a Data Source for Office 365 in DataGrip and use SQL to query live Microsoft Office 365.

• Load Azure Analysis Services to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Azure Analysis Services to a database.

• Using AngularJS to Build Dynamic Web Pages with Google Contacts

  Use the CData Connect Server to create Google Contacts OData feeds and build single-page applications with live Google Contacts.

• Build Semantic Layer Views for Shopify in APOS Live Data Gateway

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

• How to connect PolyBase to Sage Cloud Accounting

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Sage Business Cloud Accounting.

• Automated Continuous SAP Ariba Source Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Google BigQuery.

• Add Procore to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Procore with the Informatica Enterprise Data Catalog to classify and organize data.

• Connect to Xero from HeidiSQL

  Use CData Connect Cloud to connect to and query live Xero Accounting from HeidiSQL.

• Connect to Todoist in Aqua Data Studio

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

• Connect to Google Contacts in RapidMiner

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

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

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

• Create Reports from Google Drive in Looker Studio

  Use CData Connect Cloud to gain access to live Google Drive and create custom reports in Looker Studio.

• How to Work with Snowflake in ETL Validator JDBC

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

• Automated Continuous SAP ByDesign Replication to MySQL

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

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Jira Assets

  Provide connectivity to Jira Assets through an SAP BusinessObjects universe.

• How to Seamlessly Import Cosmos DB Data into IBM SPSS Modeler

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

• Connect to Zoho CRM from a Connection Pool in WebLogic

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

• Build Zoho Inventory Visualizations in Tableau Desktop

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

• PowerShell Scripting to Replicate Klaviyo to MySQL

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

• DataBind Controls to Oracle in C++Builder

  DataBind to Oracle Database in C++Builder with standard components and controls.

• Build xBase-Connected Dashboards in Redash

  Use CData Software Connect Server to create a virtual SQL Server Database for xBase and build visualizations and dashbaords from xBase in Redash.

• Edit and Search External SAP Fieldglass Objects in Salesforce Connect

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

• Integrate with Redis in JReport Designer

  Create charts and reports based on Redis in JReport Designer.

• A PostgreSQL Interface for HBase (MySQL Remoting via JDBC)

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

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

• Build Google Campaign Manager 360 Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Google Campaign Manager 360 and build visualizations in Tableau.

• Publish HubDB-Connected Dashboards in Tableau Server

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

• Connect to MYOB AccountRight in NetBeans

  Connect to MYOB AccountRight in NetBeans with the data source configuration wizard.

• Connect to TigerGraph in HULFT Integrate

  Connect to TigerGraph as a JDBC data source in HULFT Integrate

• Create Reports with Greenhouse in SAP Crystal Reports

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

• Model, Search, and Visualize Live Outreach.io in ThoughtSpot

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

• Integrate Live LDAP Objects into Custom Business Apps Built in Power Apps

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

• Extract, Transform, and Load Bing Ads in Informatica PowerCenter

  Create a simple Workflow for Bing Ads in Informatica PowerCenter.

• Load Azure Table to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Azure Table Storage to a database.

• Create Sugar CRM-Connected Business Apps in AppSheet

  Connect to Sugar CRM via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Sugar CRM.

• Query GitHub in ColdFusion

  Write standard ColdFusion data access code to connect to GitHub.

• Automated Continuous Facebook Ads Replication to Local Delimited Files

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

• Build Data Flows from Google Calendar to SQL Server using SSIS

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

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

  Connect to Xero Accounting 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 and Query Avalara AvaTax in QlikView over ODBC

  Create data visualizations with Avalara AvaTax in QlikView.

• Connect to Facebook Ads from PowerBuilder via JDBC

  This article demonstrates how to access Facebook Ads from PowerBuilder using the Facebook Ads JDBC Driver.

• ETL ClickUp in Oracle Data Integrator

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

• How to update HubDB from Excel

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

• Automated Continuous Power BI XMLA Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Google Cloud SQL.

• Automated Continuous Google Contacts Replication to Local Delimited Files

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

• Perform Batch Operations with Box in Apache NiFi

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

• Connect to Google Ad Manager as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Ad Manager.

• Connect to GraphQL from Blazor Apps

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

• Access Redis from MySQL in HeidiSQL

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

• Automated Continuous Oracle Eloqua Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to OneLake in Microsoft Fabric.

• Visualize MarkLogic in TIBCO Spotfire through ODBC

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

• Connect to CSV in Aqua Data Studio

  Access CSV/TSV Files from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

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

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

• Load Google Sheets to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Sheets to a database.

• Connect to SFTP as an External Source in Dremio

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

• Create QuickBooks-Connected Nintex Workflows

  Use CData Software Connect Server to connect to QuickBooks from Nintex Workflow Cloud and build custom workflows using live QuickBooks Desktop.

• Creating Quickbase-Connected Applications in Unqork

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

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

  Provide connectivity to Apache Phoenix through an SAP BusinessObjects universe.

• Excel Spreadsheet Automation on Microsoft Project with the QUERY Formula

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

• Author and Share Power BI Reports on Real-Time Amazon S3

  Use the CData ODBC Driver for Amazon S3 to visualize Amazon S3 in Power BI Desktop and then upload to the Power BI service.

• Back Up Sage 50 UK to SQL Server through SSIS

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

• Create Apps from Smartsheet in Qlik Sense Cloud

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

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

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

• Connect to JotForm in CloverDX (formerly CloverETL)

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

• Visualize Live HubDB in Tableau

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

• Visualize Live Acumatica in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live Acumatica ERP into custom reports in Power BI.

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

  Use the CData Connector for Oracle Sales in APOS Live Data Gateway to build Semantic Layer Views for Oracle Sales.

• Access BambooHR from MySQL in HeidiSQL

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

• DataBind Controls to Quickbase in C++Builder

  DataBind to Quickbase in C++Builder with standard components and controls.

• Build Shopify-Connected Apps in Bubble

  Use CData Connect Cloud to create an OData feed for Shopify and create custom apps in Bubble.

• Connect to SAS Data Sets in SpagoBI

  Create reports featuring live SAS Data Sets in SpagoBI Studio. Host SAS Data Sets reports on SpagoBI Server.

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

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

• «
• 328
• 329
• 330
• 331
• 332
• 333
• 334
• 335
• 336
• 337
• »