CData Software - Knowledge Base

Recent Articles

• «
• 97
• 98
• 99
• 100
• 101
• 102
• 103
• 104
• 105
• 106
• »

• Access Shopify from MySQL in Amazon QuickSight

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

• Connect to SAP HANA XS Advanced from a Connection Pool in WebLogic

  Use the CData JDBC Driver for SAP HANA XS Advanced to connect to SAP HANA XS Advanced from Web applications running on WebLogic.

• Automated Continuous DB2 Replication to Azure SQL

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

• Validate Twitter with QuerySurge

  Access and validate Twitter in QuerySurge using the CData JDBC Driver.

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

• Visualize Presto in TIBCO Spotfire through OData

  Integrate Presto into dashboards in TIBCO Spotfire.

• How to Visualize Acumatica Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Acumatica ERP in Python.

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

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

• Access Live XML in AWS Lambda

  Connect to live XML Files in AWS Lambda using the CData JDBC Driver.

• Explore Geographical Relationships in Reckon with Power Map

  Create data visualizations with Reckon in Power Map.

• Visualize Live Smartsheet in Tableau

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

• Write a Simple Go Application to work with Act-On on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Act-On.

• Create Apps from Jira in Qlik Sense Cloud

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

• Access SAP from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live SAP ERP/NetWeaver from HeidiSQL.

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

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

• Access Live Azure Active Directory in AWS Lambda

  Connect to live Azure Active Directory in AWS Lambda using the CData JDBC Driver.

• How to create Visio diagrams from Highrise

  Automatically update Highrise CRM with the changes you make to Visio master shapes.

• Automated Continuous Klipfolio Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Klipfolio replication to Amazon S3.

• Connect to Snapchat Ads in JRuby

  Create a simple JRuby app with access to live Snapchat Ads.

• Connect to LinkedIn Ads in SpagoBI

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

• Integrate with Microsoft Planner in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Microsoft Planner in SnapLogic.

• Query Greenplum as a MySQL Database in Node.js

  Execute MySQL queries against Pivotal GreenPlum from Node.js.

• Publish Reports with Azure Data Lake Storage in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Azure Data Lake Storage.

• Connect to Procore as an External Source in Dremio

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

• Automated Continuous Oracle Eloqua Replication to AlloyDB

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

• Connect to Impala in Airbyte ELT Pipelines

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

• How to connect to Twitter Ads from Spring Boot

  Connect to Twitter Ads in a Spring Boot Application using CData JDBC Twitter Ads Driver

• Creating Blackbaud FE NXT-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Blackbaud FE NXT to Unqork and build custom business apps.

• Integrate CSV in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live CSV/TSV Files from Informatica Cloud.

• Automated Continuous LinkedIn Replication to Snowflake

  Use CData Sync for automated, continuous, customizable LinkedIn replication to Snowflake.

• Natively Connect to Tableau CRM Analytics in PHP

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

• Connect to Zoom from PowerBuilder

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

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

  Connect to LDAP from a connection pool in Tomcat.

• LINQ to Shippo

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

• Access Live SingleStore in Excel (Desktop)

  Use Connect Spreadsheets by CData to gain access to live SingleStore from your Excel spreadsheets.

• How to connect to Google Directory from Spring Boot

  Connect to Google Directory in a Spring Boot Application using CData JDBC Google Directory Driver

• Work with Live Act-On in Power Query

  Use CData Connect Cloud to connect to Act-On and work with live Act-On in Microsoft Power Query.

• How to Connect to & Open QuickBooks in Microsoft Excel

  This article uses the CData ODBC driver for QuickBooks to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Create SSAS Tabular Models from SAP Fieldglass

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

• DataBind Controls to CSV in C++Builder

  DataBind to CSV/TSV Files in C++Builder with standard components and controls.

• Connect to Google Cloud Storage as a Linked Server

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

• Connect to Certinia in Ruby

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

• Replicate Reckon for Use in Salesforce Connect

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

• How to Access SAP Netweaver Gateway Using Entity Framework

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

• Import Real-Time Kintone in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Kintone in ColdFusion.

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

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

• How to work with PayPal in Apache Spark using SQL

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

• How to Query ShipStation in MySQL Workbench

  Execute MySQL queries against live ShipStation from MySQL Workbench.

• How to Access Live Azure Data Lake Storage in Power Automate Desktop via ODBC

  The CData ODBC Driver for Azure Data Lake Storage enables you to integrate Azure Data Lake Storage into workflows built using Microsoft Power Automate Desktop.

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

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

• Integrate Jira Service Management into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Atlassian Jira Service Management and integrate live Atlassian Jira Service Management into your Power Automate tasks.

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

  Execute MySQL queries against Oracle Eloqua from Node.js.

• Work with Twitter Ads in FoxPro

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

• Automate SAP HANA Replication to Azure Synapse

  Use CData Sync to customize and automate SAP HANA replication to Azure Synapse.

• Connect to LinkedIn from PowerBuilder

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

• Replicate JotForm from PowerShell

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

• Build Azure Table-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Azure Table Storage.

• Build BigQuery-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Google BigQuery and build web apps with connectivity to live Google BigQuery.

• How to connect to LDAP Objects from IntelliJ

  Integrate connectivity to LDAP with wizards in IntelliJ.

• How to Query Live Act CRM Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Act CRM data in natural language using Python.

• Query, Visualize, and Share live Google Search Results in Redash

  Use CData Connect Cloud to connect to live Google Search in Redash for querying, visualizing, and sharing.

• How to Visualize CouchDB Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Apache CouchDB in Python.

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

• Zoho Projects Reporting and Star Schemas in OBIEE

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

• PowerShell Scripting to Replicate Act CRM to MySQL

  Write a simple PowerShell script to replicate Act CRM to a MySQL database.

• Google Sheets Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Sheets through CData Connect Cloud using different applications and tools.

• Automated Continuous OData Replication to MongoDB

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

• Automated Azure Synapse Replication to Teradata

  Use CData Sync to Customize and automate Azure Synapse replication to Teradata.

• How to Access SharePoint Using Entity Framework

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

• Load Unbounce to a Database Using Embulk

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

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

  Use CData Power BI Connectors to visualize Bullhorn CRM in Power BI.

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

  Use CData Connect Cloud to connect to Presto and integrate live Presto into apps built in Microsoft Power Apps.

• Build Sage 200-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Sage 200 and build web apps with connectivity to live Sage 200.

• Natively Connect to Sage 300 in PHP

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

• Connect to Oracle Service Cloud in Jaspersoft Studio

  Execute SQL to remote Oracle Service Cloud in Jaspersoft Studio.

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

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

• Automate SAP BusinessObjects BI Replication to SAP HANA

  Use CData Sync to customize and automate SAP BusinessObjects BI replication to SAP HANA.

• Automated Teradata Replication to Teradata

  Use CData Sync to Customize and automate Teradata replication to Teradata.

• Automated Continuous Drip Replication to MongoDB

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

• Replicate MySQL for Use in Salesforce Connect

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

• Query Gmail as a MySQL Database in Node.js

  Execute MySQL queries against Gmail from Node.js.

• Feed ADP into FineReport

  How to set ADP as a JDBC data source in FineReport.

• How to Import Cosmos DB into SQL Server using SSIS

  Easily back up Azure Cosmos DB to SQL Server using the SSIS components for Cosmos DB.

• DataBind Controls to GitHub in Delphi

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

• Automated Continuous Oracle Sales Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Oracle Sales replication to SQL Server.

• Integrate Real-Time Access to Microsoft Project in SAPUI5 MVC Apps

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

• Visualize Live Amazon DynamoDB in the Power BI Service

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

• Export Data from SQL Server to Office 365 through SSIS

  Easily push SQL Server data to Office 365 using the CData SSIS Tasks for Office 365.

• Import Real-Time Marketo in ColdFusion to Build Applications

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

• Access IBM Cloud Data Engine from MySQL in Amazon QuickSight

  Connect to IBM Cloud Data Engine and build visualizations of IBM Cloud Data Engine using a MySQL Connection in Amazon QuickSight.

• Connect to QuickBooks from PowerBuilder

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

• Integrate Live Snapchat Ads into Amazon SageMaker Canvas with RDS

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

• ETL LinkedIn Ads in Oracle Data Integrator

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

• Connect to MarkLogic from Blazor Apps

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

• Replicate Drift from PowerShell

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

• Establish a Live Connection with MailChimp using Tableau Bridge

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

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

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

• How to create Active Directory federated tables in MySQL

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

• Acumatica Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Acumatica ERP through CData Connect Cloud using different applications and tools.

• Connect to Azure Synapse in CloverDX (formerly CloverETL)

  Transfer Azure Synapse using the visual workflow in the CloverDX data integration tool.

• «
• 97
• 98
• 99
• 100
• 101
• 102
• 103
• 104
• 105
• 106
• »