CData Software - Knowledge Base

Recent Articles

• «
• 88
• 89
• 90
• 91
• 92
• 93
• 94
• 95
• 96
• 97
• »

• Access Slack in PHP through Connect Server

  Connect to Slack through the standard SQL Server libraries in PHP.

• Use the CData ODBC Driver for SuiteCRM from SharePoint Excel Services

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

• Create Dynamics NAV Data Visualizations in Power BI

  The CData ODBC Driver for Dynamics NAV provides straightforward connectivity to live data for self-service business intelligence tools like Power BI: Create Power BI dashboards that you can refresh on demand.

• Load Raisers Edge NXT to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Raisers Edge NXT to a database.

• Create Data Visualizations in Cognos BI with Drift

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

• Analyze MongoDB in Looker

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

• Validate Cassandra with QuerySurge

  Access and validate Apache Cassandra in QuerySurge using the CData JDBC Driver.

• Author and Share Power BI Reports on Real-Time SQL Analysis Services

  Use the CData ODBC Driver for SQL Analysis Services to visualize SQL Analysis Services in Power BI Desktop and then upload to the Power BI service.

• Integrate Oracle Sales with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Oracle Sales with External Services.

• Automated Continuous Sage Cloud Accounting Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Azure SQL.

• Back Up Square to SQL Server through SSIS

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

• Analyze Live Amazon Athena in SAS Viya

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

• How to connect PolyBase to DB2

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

• Connect to Exact Online in Google Apps Script

  Use CData Connect Cloud to access Exact Online in Google Apps Script.

• Create Azure Data Catalog-Connected Nintex Workflows

  Use CData Software Connect Server to connect to Azure Data Catalog from Nintex Workflow Cloud and build custom workflows using live Azure Data Catalog.

• Use the CData Software JDBC Driver for Google Ads in MicroStrategy

  Connect to Google Ads in MicroStrategy Developer using the CData Software JDBC Driver for Google Ads.

• How to Connect to Monday.com in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Monday.com. Leverage the pyodbc module for ODBC in Python.

• Connect to QuickBooks Time as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live QuickBooks Time.

• View Reports on Real-Time Adobe Commerce in Power BI Report Server

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

• Automated Continuous Drift Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable Drift replication to Azure SQL.

• Integrate Elasticsearch into Power Automate Desktop using CData Connect

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

• Load ServiceNow to a Database Using Embulk

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

• Automated Continuous Xero Replication to Databricks

  Use CData Sync for automated, continuous, customizable Xero replication to Databricks.

• Access Zoho CRM as a Remote Oracle Database

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

• How to Connect the Power BI Service to SAS xpt: Complete Guide

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

• Access Okta 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 Okta.

• Analyze Amazon S3 in Looker

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

• Query MarkLogic through ODBC in Node.js

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

• How to Work with Google Sheets in AWS Glue Jobs Using JDBC

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

• Integrate Real-Time Access to AlloyDB in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google AlloyDB in real time.

• How to create BigCommerce federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for BigCommerce in MySQL .

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

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

• Back Up Twitter Ads to SQL Server through SSIS

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

• Automate Azure Synapse Replication to Azure Data Lake

  Use CData Sync to customize and automate Azure Synapse replication to Azure Data Lake.

• How to work with Twitter Ads in Apache Spark using SQL

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

• DataBind SAP SuccessFactors to the DevExpress Data Grid

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

• Automated Continuous Sage 50 UK Replication to Local Delimited Files

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

• Connect to Splunk from PowerBuilder

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

• Automated Continuous Parquet Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Parquet replication to Google Cloud SQL.

• Use JayDeBeApi to access Power BI XMLA in Python

  Use standard Python scripting and the development environment of your choice to access live Power BI XMLA.

• Design BIRT Reports on Workday

  Provide current Workday to your embedded analytics.

• MailChimp Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on MailChimp facts in real time.

• Build Amazon Athena-Connected Apps in Bubble

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

• Analyze Snapchat Ads in SAP Analytics Cloud

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

• Publish Quickbase-Connected Dashboards in Tableau Server

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

• How to Access Amazon S3 Using Entity Framework

  This article shows how to access Amazon S3 using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• A PostgreSQL Interface for Azure Data Lake Storage

  Use the Remoting features of the Azure Data Lake Storage JDBC Driver to create a PostgreSQL entry-point for data access.

• Automated Continuous Google Ads Replication to PostgreSQL

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

• Visualize Pipedrive in TIBCO Spotfire through ADO.NET

  Integrate Pipedrive into dashboards in TIBCO Spotfire.

• Use the CData Software JDBC Driver for CouchDB in MicroStrategy

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

• Visualize CSV in Tableau Desktop (through CData Connect)

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

• Prepare, Blend, and Analyze Aha in Alteryx Designer

  Build workflows to access live Aha! for self-service data analytics.

• Visualize Zendesk in TIBCO Spotfire through ODBC

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

• Connect to Reckon from PowerBuilder

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

• DataBind Controls to Clio in Delphi

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

• Connect to and Query Databricks in QlikView over ODBC

  Create data visualizations with Databricks in QlikView.

• Back Up xBase to SQL Server through SSIS

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

• Extract, Transform, and Load HDFS in Informatica PowerCenter

  Create a simple Workflow for Apache HDFS in Informatica PowerCenter.

• A PostgreSQL Interface for Email

  Use the SQL Gateway and Email ODBC Driver to create a PostgreSQL entry-point for data access.

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

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

• Connect to REST in Aqua Data Studio

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

• Connect to Exact Online in Jaspersoft Studio

  Execute SQL to remote Exact Online in Jaspersoft Studio.

• Connect to HubSpot from PowerBuilder

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

• How to create REST federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for REST in MySQL .

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

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

• A PostgreSQL Interface for Zoho Creator

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

• Connect to Pinterest in Aqua Data Studio

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

• Automated Continuous ServiceNow Replication to Local Delimited Files

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

• How to create an RPA flow for SharePoint Excel Services in UiPath Studio

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

• Natively Connect to Power BI XMLA in PHP

  Create PHP applications on Linux/UNIX machines with connectivity to Power BI XMLA. Leverage the native support for ODBC in PHP.

• Use the Connect Server to Access Coinbase in Microsoft Power Pivot

  Use the Connect Server to connect to live Coinbase in the Power Pivot business intelligence tool.

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

  Connect to Authorize.Net 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.

• Visualize Live Kintone of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Kintone using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Access Live AlloyDB in Google Sheets

  Use CData Connect Cloud to gain access to live Google AlloyDB from your Google Sheets.

• How to connect PolyBase to Active Directory

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

• Automate Kafka Integration Tasks from PowerShell

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

• Access SingleStore in PHP through Connect Server

  Connect to SingleStore through the standard SQL Server libraries in PHP.

• Build Charts with Google Spanner in Clear Analytics

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

• Visualize your Salesforce Data in Tibco Spotfire

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

• Analyze LinkedIn in R

  Create data visualizations and use high-performance statistical functions to analyze LinkedIn in Microsoft R Open.

• Automate Airtable Replication to Azure Synapse

  Use CData Sync to customize and automate Airtable replication to Azure Synapse.

• Connect to SharePoint Excel Services from PowerBuilder

  This article demonstrates how to use the CData ODBC Driver for SharePoint Excel Services to connect to SharePoint Excel Services and execute queries in PowerBuilder.

• Visualize IBM Informix in Tableau

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

• Connect to Spark from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Apache Spark SQL from Crystal Reports.

• Build Interactive Dashboards from JSON Services in Amazon QuickSight

  Create a virtual SQL Server database for JSON in CData Software Connect Server and import JSON into Amazon QuickSight SPICE to build interactive dashboards.

• Use the CData Software JDBC Driver for Coinbase in MicroStrategy

  Connect to Coinbase in MicroStrategy Developer using the CData Software JDBC Driver for Coinbase.

• Access Live SAP Business One in Coginiti Pro

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

• Access Oracle SCM from MySQL in PHP

  Connect to Oracle SCM through the standard MySQL libraries in PHP.

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

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

• Creating Phoenix-Connected Applications in Unqork

  You can use CData Connect to feed Apache Phoenix to Unqork and build custom business apps.

• Create Reports with Microsoft Dataverse in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Microsoft Dataverse (CDS).

• Connect to Google Sheets from Crystal Reports

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

• Connect to Oracle Sales in SpagoBI

  Create reports featuring live Oracle Sales in SpagoBI Studio. Host Oracle Sales reports on SpagoBI Server.

• Visualize Redshift in Sisense

  Create an ElastiCube in Sisense app with access to Amazon Redshift.

• Edit and Search External Spark Objects in Salesforce Connect

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

• Automate Elasticsearch Replication to SAP HANA

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

• Connect to Sage 200 from a Connection Pool in JBoss

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

• Automated Continuous EventBrite Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable EventBrite replication to Microsoft Access.

• How to create an RPA flow for Sage Cloud Accounting in UiPath Studio

  Use the Sage Cloud Accounting ODBC Driver to create workflows that access real-time Sage Business Cloud Accounting without any coding.

• Visualize Reckon from Tableau

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

• «
• 88
• 89
• 90
• 91
• 92
• 93
• 94
• 95
• 96
• 97
• »