CData Software - Knowledge Base

Recent Articles

• «
• 121
• 122
• 123
• 124
• 125
• 126
• 127
• 128
• 129
• 130
• »

• PowerShell Scripting to Replicate Twitter Ads to MySQL

  Write a simple PowerShell script to replicate Twitter Ads to a MySQL database.

• Build a Simple VCL Application for Clio

  How to build a simple VCL Application to view Clio in RAD Studio using the CData ODBC Driver for Clio.

• Access Live Office 365 in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for Office 365 to create a Microsoft Office 365 source in TIBCO Data Virtualization Studio and gain access to live Microsoft Office 365 from your TDV Server.

• Build MVC Applications with Connectivity to Splunk

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Splunk from an ASP.NET MVC application.

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

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

• Analyze Tally in R via ODBC

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

• How to connect to Shippo with Squirrel SQL client

  Connect to Shippo and execute queries in the Squirrel SQL Client.

• Automated Continuous Calendly Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Calendly replication to Apache Kafka.

• Design BIRT Reports on Clio

  Provide current Clio to your embedded analytics.

• Query Oracle Eloqua as a MySQL Database in Node.js

  Execute MySQL queries against Oracle Eloqua from Node.js.

• Establish a Live Connection with Email using Tableau Bridge

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

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

  Provide connectivity to Active Directory through an SAP BusinessObjects universe.

• Access Live Epicor Kinetic in Google Sheets via Connect Cloud

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

• LINQ to Paylocity

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

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

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

• Connect to Dynamics CRM in NetBeans

  Connect to Microsoft Dynamics CRM in NetBeans with the data source configuration wizard.

• Connect to DocuSign from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live DocuSign from Filemaker Pro on Mac.

• Analyze Wave Financial in R via ODBC

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

• Integrate Live Bing Ads into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to Bing Ads from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Bing Ads.

• How to Visualize Xero Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Xero Accounting in Python.

• A PostgreSQL Interface for HCL Domino using the CData ODBC Driver

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

• Create Reports with Zendesk in SAP Crystal Reports

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

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

  Connect to Veeva Vault & Vault CRM 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.

• Provide OData Services of SAS Data Sets from a WCF Application

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

• Connect to HCL Domino in DBArtisan

  Use wizards in DBArtisan to configure HCL Domino as a data source.

• Publish Avro-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Apache Avro.

• Prepare, Blend, and Analyze Smartsheet in Alteryx Designer (ODBC)

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

• Automated Continuous Access Replication to MySQL

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

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

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

• Use the CData Software JDBC Driver for Google Campaign Manager 360 in MicroStrategy Web

  Connect to Google Campaign Manager 360 in MicroStrategy Web using the CData Software JDBC Driver for Google Campaign Manager 360.

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

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

• Connect to CockroachDB from HeidiSQL

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

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

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

• Use the CData ODBC Driver for SAP ByDesign in Microsoft Power Query

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

• Perform Batch Operations with Sage Cloud Accounting in Apache NiFi

  Connect to Sage Business Cloud Accounting and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Natively Connect to WooCommerce in PHP

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

• Use JayDeBeApi to access Google Cloud Storage in Python

  Use standard Python scripting and the development environment of your choice to access live Google Cloud Storage.

• How to connect PolyBase to Parquet

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

• Build Parquet-Connected ETL Processes in Google Data Fusion

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

• PowerShell Scripting to Replicate FTP to MySQL

  Write a simple PowerShell script to replicate FTP Servers to a MySQL database.

• Build Data Flows from SQL Server to SAP Hybris C4C through SSIS

  Easily push SQL Server data to SAP Hybris C4C using the CData SSIS Tasks for SAP Hybris C4C.

• Build Apps with Live Yahoo! Ads in Adalo using CData Connect Cloud

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

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

  Connect to Microsoft Planner from a connection pool in Tomcat.

• Publish Redis-Connected Dashboards in Tableau Server

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

• Create Datasets from HubSpot in Domo Workbench and Build Visualizations of HubSpot in Domo

  Use the CData Software ODBC Driver for HubSpot to create datasets from HubSpot in Domo Workbench and then build visualizations in the Domo service.

• Connect to Azure Data Catalog in Aqua Data Studio

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

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

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

• Integrate Oracle HCM Cloud into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Oracle HCM Cloud and integrate live Oracle HCM Cloud into your Power Automate tasks.

• Create Azure Synapse-Connected Applications in Appsmith

  Connect to Azure Synapse via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Azure Synapse.

• Build Azure Synapse Visualizations in Tableau Cloud

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

• Create SSAS Tabular Models from ShipStation

  How to build a SQL Server Analysis Service Tabular Model from ShipStation using CData drivers.

• Import TaxJar into Microsoft Power Query

  The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access TaxJar. In this article, you will use the OData format to import TaxJar into Microsoft Power Query.

• How to import Azure Analysis Services into Apache Solr

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

• Connect to SQL Server in Ruby

  Connect to Microsoft SQL Server in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Seamlessly Bring Smartsheet into Retool Using CData Connect Cloud

  Integrate Smartsheet data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.

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

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

• Establish a Live Connection with Sybase IQ using Tableau Bridge

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

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

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

• Visualize Odoo in TIBCO Spotfire through ADO.NET

  Integrate Odoo ERP into dashboards in TIBCO Spotfire.

• Google Sheets Reporting in OBIEE with the Google Sheets JDBC Driver

  Deploy the Google Sheets JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Replicate Cosmos DB for Use in Salesforce Connect

  Replicate Azure Cosmos DB to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Configure the CData JDBC Driver for Azure Analysis Services in a Connection Pool in Tomcat

  Connect to Azure Analysis Services from a connection pool in Tomcat.

• Connect to Amazon Marketplace in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access Amazon Marketplace in Google Apps Script.

• Build AI/ML Models with Live IBM Informix Data using Dataiku

• «
• 121
• 122
• 123
• 124
• 125
• 126
• 127
• 128
• 129
• 130
• »