CData Software - Knowledge Base

Recent Articles

• «
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »

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

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

• Publish Crystal Reports on Parquet

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

• How to update Dropbox from Excel

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

• Create Google Ads Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Ads data access from reports, embedded analytics, and more.

• Connect to RSS Feeds in RazorSQL

  Connect to RSS from wizards and query RSS Feeds from the GUI in the RazorSQL database management tool.

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

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

• Create Apps from SingleStore in Qlik Sense Cloud

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

• Build an OLAP Cube in SSAS from GraphQL

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

• Create Azure DevOps-Connected Business Apps in AppSheet

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

• Natively Connect to SingleStore in PHP

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

• Replicate Twitter to Multiple Databases

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

• Build Semantic Layer Views for Bing Search Results in APOS Live Data Gateway

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

• Connect to xBase from a Connection Pool in JBoss

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

• How to Work with AlloyDB in ETL Validator JDBC

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

• Use the CData Software ODBC Driver for SuiteCRM in MicroStrategy Web

  Connect to SuiteCRM in MicroStrategy Web using the CData Software ODBC Driver for SuiteCRM.

• Connect to Procore in CloverDX (formerly CloverETL)

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

• Integrate with live Shopify in Jitterbit

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

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

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

• Connect to HarperDB from a Connection Pool in Jetty

  The HarperDB JDBC Driver supports connection pooling: This article shows how to connect faster to HarperDB from Web apps in Jetty.

• Export Data from SQL Server to Google Contacts through SSIS

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

• Visualize Live Certinia in the Power BI Service

  Use CData Software Connect Server to create a virtual SQL Server database for Certinia and create custom reports in the Power BI Service.

• Work with LinkedIn in FoxPro

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

• A PostgreSQL Interface for PayPal

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

• LINQ to Dynamics NAV

  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 Dynamics NAV Data Provider.

• Access Raisers Edge NXT from MySQL in PHP

  Connect to Raisers Edge NXT through the standard MySQL libraries in PHP.

• Automated Continuous MySQL Replication to MongoDB

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

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

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

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

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

• How to publish and share Xero dashboards with Tableau Server

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

• DataBind Controls to Microsoft OneDrive in C++Builder

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

• Publish CockroachDB-Connected Dashboards in Tableau Server

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

• Connect to SAP Hybris C4C in DBeaver

  Use the CData ODBC Driver to connect to SAP Hybris C4C in DBeaver.

• Use the CData Software JDBC Driver for SharePoint in MicroStrategy Web

  Connect to Microsoft SharePoint in MicroStrategy Web using the CData Software JDBC Driver for SharePoint.

• Use the CData Software JDBC Driver for Teradata in MicroStrategy Web

  Connect to Teradata in MicroStrategy Web using the CData Software JDBC Driver for Teradata.

• Publish Crystal Reports on Sybase

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

• Use the CData Software JDBC Driver for Workday in MicroStrategy Web

  Connect to Workday in MicroStrategy Web using the CData Software JDBC Driver for Workday.

• Build Dashboards with Drip in DBxtra

  Create dynamic dashboards and perform analytics based on Drip in DBxtra.

• Author and Share Power BI Reports on Real-Time Cosmos DB

  Use the CData ODBC Driver for Cosmos DB to visualize Azure Cosmos DB in Power BI Desktop and then upload to the Power BI service.

• How to publish and share Zoom dashboards with Tableau Server

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Spanner

  Provide connectivity to Google Spanner through an SAP BusinessObjects universe.

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

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

• Publish Google Contacts-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Google Contacts.

• Integrate with Drip using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Drip to a JSON file on disk.

• Create a Data Access Object for HCL Domino using JDBI

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

• Publish FHIR-Connected Dashboards in Tableau Server

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

• Create Monday.com-Connected Business Apps in AppSheet

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

• Provide OData Services of Google Directory from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Google Directory by developing a WCF Service Application.

• How to publish and share Bing Ads dashboards with Tableau Server

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

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

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

• How to Connect the Power BI Service to OData: Complete Guide

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

• Query ClickUp in MySQL Workbench

  Create a virtual MySQL database for ClickUp in CData Software Connect (or Connect Server) and work with live ClickUp in MySQL Workbench.

• How to Visualize Google Sheets Data in Python with pandas

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

• Using the CData Software ODBC Driver for Azure Analysis Services in PyCharm

  Connect to Azure Analysis Services as an ODBC data source in PyCharm using the CData Software ODBC Driver for Azure Analysis Services.

• Connect to Snowflake in CloverDX (formerly CloverETL)

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

• Query SingleStore as a MySQL Database in Node.js

  Execute MySQL queries against SingleStore from Node.js.

• Access Todoist from MySQL in HeidiSQL

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

• DataBind Wijmo Grid to Veeva

  Provide real-time Veeva Vault to interactive controls.

• Connect to Asana in Airbyte ELT Pipelines

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

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

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

• Connect to Klipfolio in as an External Source in Dremio

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

• Import Real-Time Workday in ColdFusion to Build Applications

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

• Build Amazon DynamoDB Visualizations in Tableau Desktop

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

• Build LinkedIn Ads-Connected ETL Processes in Google Data Fusion

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

• Connect to Calendly in CloverDX (formerly CloverETL)

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

• Build Automated Workflows with Live ADP in Workato

  Use CData Connect Cloud to connect to live ADP and build automated workflows in Workato.

• How to work with Aha in Apache Spark using SQL

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

• Use the CData Software ODBC Driver for Drift in MicroStrategy Desktop

  Connect to Drift in MicroStrategy Desktop using the CData Software ODBC Driver for Drift.

• Create BigCommerce-Connected Business Apps in AppSheet

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

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

  Create a live connection to BigQuery in CData Connect Cloud and connect to your Google BigQuery from PostgreSQL.

• Replicate Amazon DynamoDB from PowerShell

  Write a quick PowerShell script to query Amazon DynamoDB. Use connectivity to the live data to replicate Amazon DynamoDB to SQL Server.

• How to integrate Jira with Apache Airflow

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

• How to connect and process Gmail from Azure Databricks

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

• Connect to Xero in HULFT Integrate

  Connect to Xero as a JDBC data source in HULFT Integrate

• How to connect to BigCommerce in DBVisualizer

  Integrate BigCommerce with visual data analysis tools and data connection wizards in DBVisualizer

• Connect to ServiceNow from PowerBuilder

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

• Access Reckon from MySQL in HeidiSQL

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

• Connect to Google Analytics from PowerBuilder

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

• Create Zoho Books Dataflows on PowerBI.com

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

• Write a Simple Go Application to work with Microsoft Project on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Project.

• Create Reports from Zoho Books in Looker Studio

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

• Connect to Microsoft OneDrive in SpagoBI

  Create reports featuring live Microsoft OneDrive in SpagoBI Studio. Host Microsoft OneDrive reports on SpagoBI Server.

• Visualize Live Google Drive in the Power BI Service

  Use CData Software Connect Server to create a virtual SQL Server database for Google Drive and create custom reports in the Power BI Service.

• Connect to HDFS in RazorSQL

  Connect to HDFS from wizards and query Apache HDFS from the GUI in the RazorSQL database management tool.

• Integrate PostgreSQL in the Pentaho Report Designer

  Publish reports based on PostgreSQL in the Pentaho BI tool.

• Automated Continuous Azure Active Directory Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Azure Active Directory replication to PostgreSQL.

• Automate HubSpot Integration Tasks from PowerShell

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

• Connect to Monday.com in Jaspersoft Studio

  Execute SQL to remote Monday.com in Jaspersoft Studio.

• Visualize AlloyDB from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Google AlloyDB.

• Build Procore-Connected Dashboards in Redash

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

• Import Real-Time SAP SuccessFactors in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use SAP SuccessFactors in ColdFusion.

• Work with QuickBooks Time in FoxPro

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

• How to connect Amazon QuickSight to Google Search Results

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

• Connect to Phoenix in DBeaver

  Use the CData ODBC Driver to connect to Apache Phoenix in DBeaver.

• Visualize Dynamics 365 in TIBCO Spotfire through ADO.NET

  Integrate Microsoft Dynamics 365 into dashboards in TIBCO Spotfire.

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

• Connect to Amazon Marketplace in HULFT Integrate

  Connect to Amazon Marketplace as a JDBC data source in HULFT Integrate

• Publish Crystal Reports on Hive

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

• Query MailChimp as a MySQL Database in Node.js

  Execute MySQL queries against MailChimp from Node.js.

• Build Charts with Facebook in Clear Analytics

  Create dynamic charts and perform analytics based on Facebook in Clear Analytics.

• Use the CData Software JDBC Driver for Salesforce in MicroStrategy Web

  Connect to Salesforce & Force.com in MicroStrategy Web using the CData Software JDBC Driver for Salesforce.

• «
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »