CData Software - Knowledge Base

Recent Articles

• «
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• »

• A PostgreSQL Interface for Monday.com

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

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

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

• Work with Odoo in FoxPro

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

• Connect to Twitter in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Twitter in the Denodo Virtual DataPort Administrator.

• Integrate with live Oracle HCM Cloud in Jitterbit

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

• Connect to SAP Business One from Asprova with CData Software ODBC Driver for SAP Business One

  This article shows how to connect faster to SAP Business One data from Asprova.

• Import and Visualize Snapchat Ads in Power View

  Create data visualizations based on Snapchat Ads in Excel.

• Connect to QuickBooks in RapidMiner

  Integrate QuickBooks Desktop with standard components and data source configuration wizards in RapidMiner Studio.

• Access OData Services from MySQL in PHP

  Connect to OData through the standard MySQL libraries in PHP.

• Connect to Presto in Airbyte ELT Pipelines

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

• Replicate Jira Service Management to Multiple Databases

  Replicate Atlassian Jira Service Management to disparate databases with a single configuration.

• Automate Sage Cloud Accounting Replication to Azure Synapse

  Use CData Sync to customize and automate Sage Business Cloud Accounting replication to Azure Synapse.

• Integrate with LinkedIn Ads in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live LinkedIn Ads in SnapLogic.

• PowerShell Scripting to Replicate Airtable to MySQL

  Write a simple PowerShell script to replicate Airtable to a MySQL database.

• Visualize Google Campaign Manager 360 in TIBCO Spotfire through OData

  Integrate Google Campaign Manager 360 into dashboards in TIBCO Spotfire.

• Connect to HCL Domino in Aqua Data Studio

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

• How to Query Harvest in MySQL Workbench

  Execute MySQL queries against live Harvest from MySQL Workbench.

• Connect to OneNote from PowerBuilder

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

• Using the CData Software ODBC Driver for Microsoft Exchange in PyCharm

  Connect to Microsoft Exchange as an ODBC data source in PyCharm using the CData Software ODBC Driver for Microsoft Exchange.

• Connect to and Visualize Live Jira in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Atlassian Jira.

• Extract, Transform, and Load Google Campaign Manager 360 in Informatica PowerCenter

  Create a simple Workflow for Google Campaign Manager 360 in Informatica PowerCenter.

• Import Teradata into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for Teradata and create custom reports in the Power BI Service.

• Connect to SAP Hybris C4C from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live SAP Hybris C4C from Filemaker Pro on Mac.

• Automate TaxJar Integration Tasks from PowerShell

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

• Build SAP Concur Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live SAP Concur and build visualizations in Tableau Cloud.

• Create Apps from JSON Services in Qlik Sense Cloud

  Use the CData Connect Server to create an OData API for JSON and build apps from live JSON in Qlik Sense Cloud.

• How to connect to Klipfolio in DBVisualizer

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

• A PostgreSQL Interface for Power BI XMLA

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

• Create Zenefits-Connected Visualizations in Klipfolio

  Use CData Software Connect Server to connect to Zenefits from Klipfolio and build custom visualizations using live Zenefits.

• Integrate SAS Data Sets into Automated Tasks with Power Automate

  Use CData Software Connect Server to create a virtual SQL Server database for SAS Data Sets and integrate live SAS Data Sets into your Power Automate (Microsoft Flow) tasks.

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

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

• Natively Connect to Amazon DynamoDB in PHP

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

• Build Charts with Google Directory in Clear Analytics

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

• Replicate Dynamics CRM for Use in Salesforce Connect

  Replicate Microsoft Dynamics CRM to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Author and Share Power BI Reports on Real-Time HubDB

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

• Connect to Live Google Directory in PostGresSQL Interface through CData Connect Cloud

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

• Connect to Excel Online in Google Apps Script

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

• Create SAP Hybris C4C-Connected Nintex Workflows

  Use CData Connect Cloud to connect to SAP Hybris C4C from Nintex Workflow Cloud and build custom workflows using live SAP Hybris C4C.

• How to connect Amazon QuickSight to Veeva

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

• Connect to Act CRM through External Services in Salesforce

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

• Build Visualizations of Snapchat Ads in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Snapchat Ads in Birst.

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

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

• Build Visualizations of SAP SuccessFactors in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP SuccessFactors in Birst.

• Build Greenplum Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Pivotal GreenPlum and build visualizations in Tableau.

• Build a Simple VCL Application for Microsoft Teams

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

• Analyze Google Sheets in R

  Use standard R functions and the development environment of your choice to analyze Google Sheets with the CData JDBC Driver for Google Sheets.

• Create SSAS Tabular Models from PostgreSQL

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

• Create SSAS Tabular Models from Invoiced

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

• Connect to Xero through External Services in Salesforce

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

• DataBind Controls to FHIR in Delphi

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

• Access Live eBay in AWS Lambda

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

• How to Query Amazon Athena in MySQL Workbench

  Execute MySQL queries against live Amazon Athena from MySQL Workbench.

• Analyze ActiveCampaign in SAP Analytics Cloud

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

• Use JayDeBeApi to access Sage 300 in Python

  Use standard Python scripting and the development environment of your choice to access live Sage 300.

• Natively Connect to Pinterest in PHP

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

• How to connect to Power BI XMLA with Squirrel SQL client

  Connect to Power BI XMLA and execute queries in the Squirrel SQL Client.

• Build Dashboards with Asana in Dundas BI

  Create dynamic dashboards and perform analytics based on Asana in Dundas BI.

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

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

• ETL Cosmos DB in Oracle Data Integrator

  This article shows how to transfer Azure Cosmos DB into a data warehouse using Oracle Data Integrator.

• Query Zoho Projects through ODBC in Node.js

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

• How to Visualize PostgreSQL Data in Python with pandas

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

• How to Visualize Sugar CRM Data in Python with pandas

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

• How to connect PolyBase to Google Data Catalog

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Data Catalog.

• Connect to and Query Splunk in QlikView over ODBC

  Create data visualizations with Splunk in QlikView.

• Use the CData Software JDBC Driver for Google Contacts in MicroStrategy Web

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

• Import Real-Time Oracle SCM in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Oracle SCM in ColdFusion.

• Replicate Hive for Use in Salesforce Connect

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

• How to update Zoho Projects from Excel

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

• How to connect to Dynamics 365 with Squirrel SQL client

  Connect to Microsoft Dynamics 365 and execute queries in the Squirrel SQL Client.

• How to connect to SAP Hybris C4C from IntelliJ

  Integrate connectivity to SAP Hybris C4C with wizards in IntelliJ.

• How to connect to Google Contacts with Squirrel SQL client

  Connect to Google Contacts and execute queries in the Squirrel SQL Client.

• How to connect to FHIR in DBVisualizer

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

• Perform Batch Operations with Redis in Apache NiFi

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

• How to Connect to & Open Shippo in Microsoft Excel

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

• Feed Redshift into FineReport

  How to set Amazon Redshift as a JDBC data source in FineReport.

• Connect to and Query Reckon in QlikView over ODBC

  Create data visualizations with Reckon in QlikView.

• Automated Continuous Reckon Accounts Hosted Replication to Local Delimited Files

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

• Connect to Bing Search Results in Ruby

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

• Natively Connect to ServiceNow in PHP

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

• Provide OData Services of Google Search Results from a WCF Application

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

• Build Visualizations of Wave Financial in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Wave Financial in Birst.

• DataBind Wijmo Grid to SharePoint Excel Services

  Provide real-time SharePoint Excel Services to interactive controls.

• Automated Continuous Raisers Edge NXT Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to AlloyDB.

• Edit and Search External Shippo Objects in Salesforce Connect

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

• ETL Asana in Oracle Data Integrator

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

• How to Connect the Power BI Service to Office 365: Complete Guide

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

• Replicate SAP BusinessObjects BI from PowerShell

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

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

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

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

  Provide connectivity to Microsoft Excel through an SAP BusinessObjects universe.

• Query, Visualize, and Share live Splunk in Redash

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

• Connect to Authorize.Net in RunMyProcess through Connect Server

  Use CData Connect Server to create an OData API for Authorize.Net and connect to Authorize.Net in Akorbi Digital RunMyProcess.

• Connect to Microsoft Exchange from HeidiSQL

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

• Integrate with Live SAP Hybris C4C in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to SAP Hybris C4C from the MuleSoft Anypoint Platform to integrate live SAP Hybris C4C into custom reports and dashboards.

• Automated Continuous LinkedIn Ads Replication to Databricks

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

• Automated Continuous Instagram Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Instagram replication to Apache Cassandra.

• Replicate Trello to Multiple Databases

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

• Build MongoDB-Connected Web Apps in Servoy

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

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

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

• Analyze EnterpriseDB in SAP Analytics Cloud

  Use the CData Connect Server to create an OData API on top of EnterpriseDB and visualize EnterpriseDB in SAP Analytics Cloud.

• Connect to Oracle Eloqua in CloverDX (formerly CloverETL)

  Transfer Oracle Eloqua using the visual workflow in the CloverDX data integration tool.

• «
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• »