CData Software - Knowledge Base

Recent Articles

• «
• 65
• 66
• 67
• 68
• 69
• 70
• 71
• 72
• 73
• 74
• »

• Creating Square-Connected Applications in Unqork

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

• Migrating data from Amazon S3 to Google BigQuery using CData SSIS Components.

  Easily push Amazon S3 to Google BigQuery using the CData SSIS Tasks for Amazon S3 and Google BigQuery.

• Use JayDeBeApi to access SharePoint in Python

  Use standard Python scripting and the development environment of your choice to access live Microsoft SharePoint.

• Establish a Live Connection with Epicor Kinetic using Tableau Bridge

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

• Build a Singer.io Tap for SAP SuccessFactors With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live SAP SuccessFactors data using

• Connect to Azure Active Directory from HeidiSQL

  Use CData Connect Cloud to connect to and query live Azure Active Directory from HeidiSQL.

• Create Google Analytics Reports on JasperReports Server

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

• Connect to NetSuite from a Connection Pool in Jetty

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

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

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

• How to connect Amazon QuickSight to Office 365

  Create a connection to Microsoft Office 365 in CData Connect Cloud and insert Microsoft Office 365 into Amazon QuickSight SPICE to build interactive dashboards.

• Manage Oracle Sales in DBArtisan as a JDBC Source

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

• Integrate Real-Time Access to Oracle Financials Cloud in SAPUI5 MVC Apps

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

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

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

• How to Visualize Sybase Data in Python with pandas

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

• Connect to and Visualize Live Zendesk in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Zendesk.

• How to import Spark into Apache Solr

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

• How to Query Microsoft Teams in MySQL Workbench

  Execute MySQL queries against live Microsoft Teams from MySQL Workbench.

• Establish a Live Connection with Airtable using Tableau Bridge

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

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed WooCommerce to Power BI dashboards. Simply drag and drop WooCommerce into data visuals on the Power BI canvas.

• Integrate with live CockroachDB in Jitterbit

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

• Validate Google Calendar with QuerySurge

  Access and validate Google Calendar in QuerySurge using the CData JDBC Driver.

• Perform Batch Operations with Google Spanner in Apache NiFi

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

• Connect to and Visualize Live Basecamp in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Basecamp.

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

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

• Automated Continuous LinkedIn Replication to Amazon S3

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

• How to Import Data from SAP Business One into Google Sheets

  Import SAP Business One into a Google spreadsheet that is automatically refreshed.

• Publish Reports with Microsoft Project in SAP Crystal Reports

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

• Query Oracle HCM Cloud through ODBC in Node.js

  Use node-odbc to execute SQL queries against Oracle HCM Cloud from Node.js.

• Automate Microsoft Dataverse Replication to SAP HANA

  Use CData Sync to customize and automate Microsoft Dataverse (CDS) replication to SAP HANA.

• Analyze Azure Table in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Azure Table Storage and visualize Azure Table Storage in SAP Analytics Cloud.

• Build Epicor Kinetic-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Epicor Kinetic.

• Import and Visualize Airtable in Power View

  Create data visualizations based on Airtable in Excel.

• How to connect to IBM Informix from Spring Boot

  Connect to IBM Informix in a Spring Boot Application using CData JDBC IBM Informix Driver

• Work with Live BigQuery in Power Query

  Use CData Connect Cloud to connect to Google BigQuery and work with live Google BigQuery in Microsoft Power Query.

• Bidirectional Access to HBase from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Apache HBase in Filemaker Pro for Mac or Windows.

• Access Invoiced from MySQL in PHP

  Connect to Invoiced through the standard MySQL libraries in PHP.

• Visualize Zoho Creator from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Zoho Creator.

• Use Biml to Build SSIS Tasks to Replicate SAP HANA XS Advanced to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP HANA XS Advanced to SQL Server.

• Replicate Acumatica from PowerShell

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

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

• Integrate Drift in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Drift from Informatica Cloud.

• Automate REST Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live REST and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Build Dashboards with Facebook Ads in DBxtra

  Create dynamic dashboards and perform analytics based on Facebook Ads in DBxtra.

• Automated Continuous Certinia Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Certinia replication to IBM DB2.

• Connect to Act CRM from a Connection Pool in JBoss

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

• Connect to ShipStation from Crystal Reports

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

• Connect to SAS Data Sets from a Connection Pool in JBoss

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

• Migrating data from Dynamics 365 to Databricks using CData SSIS Components.

  Easily push Microsoft Dynamics 365 to Databricks using the CData SSIS Tasks for Dynamics 365 and Databricks.

• Use the CData Software ODBC Driver for ClickUp in MicroStrategy

  Connect to ClickUp in MicroStrategy Developer using the CData Software ODBC Driver for ClickUp.

• Connect to Sage Cloud Accounting as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Sage Business Cloud Accounting.

• Publish Reports with Amazon Marketplace in SAP Crystal Reports

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

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

  Provide connectivity to ActiveCampaign through an SAP BusinessObjects universe.

• How to Query Azure Analysis Services in MySQL Workbench

  Execute MySQL queries against live Azure Analysis Services from MySQL Workbench.

• Replicate NetSuite SuiteAnalytics to Multiple Databases via the CData Sync CLI

  Replicate NetSuite SuiteAnalytics to disparate databases with a single configuration.

• Visualize Impala from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Apache Impala.

• Connect to Shopify in RazorSQL

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

• Connect to OData Services from PowerBuilder via JDBC

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

• Publish Sage Cloud Accounting-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Sage Business Cloud Accounting.

• Connect to Twitter Ads in HULFT Integrate

  Connect to Twitter Ads as a JDBC data source in HULFT Integrate

• Connect to Office 365 in SpagoBI

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

• Connect to Active Directory in HULFT Integrate

  Connect to Active Directory as a JDBC data source in HULFT Integrate

• A PostgreSQL Interface for Dynamics 365 Business Central (MySQL Remoting via JDBC)

  Use the Remoting features of the Dynamics 365 Business Central JDBC Driver to create a PostgreSQL entry-point for data access.

• Connect Bullhorn CRM to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Bullhorn CRM using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Visualize Live Azure Data Lake Storage of Power BI Report Builder in Power BI Service

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

• Build MVC Applications with Connectivity to OneNote

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

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

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

• Work with Trello in FoxPro

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

• How to connect to Salesforce Pardot with Squirrel SQL client

  Connect to Salesforce Pardot and execute queries in the Squirrel SQL Client.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed API to Power BI dashboards. Simply drag and drop API into data visuals on the Power BI canvas.

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

• Viewing Impala in RAD Studio Data Explorer

  How to view Apache Impala in RAD Studio Data Explorer using the CData ODBC Driver for Impala.

• Automated Continuous SAP Hybris C4C Replication to Oracle

  Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Oracle.

• Write a Simple Go Application to work with Access on Linux

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

• PowerShell Scripting to Replicate Oracle HCM Cloud to MySQL

  Write a simple PowerShell script to replicate Oracle HCM Cloud to a MySQL database.

• Use the CData Software JDBC Driver for Avalara AvaTax in MicroStrategy Web

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

• Connect and Query Live Twitter Data in Databricks with CData Connect Cloud

  Use CData Connect Cloud to integrate live Twitter into Databricks

• Replicate Jira Assets from PowerShell

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

• Build Data Flows from SQL Server to Certinia through SSIS

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

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

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

• Automated Continuous Salesforce Pardot Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to OneLake in Microsoft Fabric.

• Working with Box in LINQPad

  Execute LINQ queries to Box in LINQPad.

• Viewing Outreach.io in RAD Studio Data Explorer

  How to view Outreach.io in RAD Studio Data Explorer using the CData ODBC Driver for Outreach.io.

• Analyze Adobe Commerce in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Adobe Commerce and visualize live Adobe Commerce in Ingragistics Reveal.

• Connect to Impala as an External Source in Dremio

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

• Workday: How to Access Live Data from the WQL for a Workday Report

  CData

• Visualize SAS Data Sets from Tableau

  Use the Tableau Desktop business intelligence tool to connect to SAS Data Sets.

• Use Dash to Build to Web Apps on Klipfolio

  Create Python applications that use pandas and Dash to build Klipfolio-connected web apps.

• Integrate with Microsoft Planner in SnapLogic

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

• Connect to CockroachDB from Asprova with CData Software ODBC Driver for CockroachDB

  This article shows how to connect faster to CockroachDB data from Asprova.

• Viewing Tableau CRM Analytics in RAD Studio Data Explorer

  How to view Tableau CRM Analytics in RAD Studio Data Explorer using the CData ODBC Driver for Tableau CRM Analytics.

• Create Reports with OneNote in SAP Crystal Reports

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

• Automated Continuous Google Calendar Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Google Calendar replication to AlloyDB.

• Connect to Live Outreach.io in MicroStrategy through CData Connect Cloud

  Create a live connection to Outreach.io in CData Connect Cloud and connect to your Outreach.io from MicroStrategy.

• Import Real-Time Xero via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Xero Accounting in ColdFusion.

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

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

• Use the CData API Server to Access ADP in Microsoft PowerPivot

  Use the CData API Server to connect to live ADP in the Power Pivot business intelligence tool.

• Automated Continuous ConstantContact Replication to MongoDB

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

• Back Up Act-On to SQL Server through SSIS

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

• Automated Continuous Freshdesk Replication to MongoDB

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

• How to connect to Power BI XMLA in DBVisualizer

  Integrate Power BI XMLA with visual data analysis tools and data connection wizards in DBVisualizer

• «
• 65
• 66
• 67
• 68
• 69
• 70
• 71
• 72
• 73
• 74
• »