CData Software - Knowledge Base

Recent Articles

• «
• 317
• 318
• 319
• 320
• 321
• 322
• 323
• 324
• 325
• 326
• »

• How to connect PolyBase to Google Directory

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

• Connect to Redshift from PowerBuilder

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

• Process & Analyze BambooHR in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live BambooHR .

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

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

• How to use SQLAlchemy ORM to access Azure Data Lake Storage in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure Data Lake Storage.

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

  Provide connectivity to Odoo ERP through an SAP BusinessObjects universe.

• Connect to Cosmos DB as a Linked Server

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Azure Cosmos DB.

• Query Active Directory as a MySQL Database in Node.js

  Execute MySQL queries against Active Directory from Node.js.

• Query Dynamics 365 Business Central as a MySQL Database in Node.js

  Execute MySQL queries against Dynamics 365 Business Central from Node.js.

• Create Informatica Mappings From/To an ODBC Data Source for Redis

  Create an ODBC connection to Redis in Informatica and browse and transfer Redis.

• Connect to Twilio in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Natively Connect to Outreach.io in PHP

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

• Automated Continuous Azure Data Catalog Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Apache Kafka.

• How to publish and share CouchDB dashboards with Tableau Server

  The CData ODBC driver for CouchDB enables you integrate Apache CouchDB into Tableau dashboards.

• View Reports on Real-Time Azure Analysis Services in Power BI Report Server

  Use the CData ODBC Driver for Azure Analysis Services to visualize Azure Analysis Services in Power BI Desktop and then publish them to Power BI Report Server.

• Access Live SharePoint Excel Services in TIBCO Data Virtualization

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

• Replicate PostgreSQL for Use in Salesforce Connect

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

• Access Live Microsoft Planner in Google Sheets

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

• Connect to Reckon Accounts Hosted in Google Apps Script

  Use the ODBC Driver for Reckon Accounts Hosted and the SQL Gateway to access Reckon Accounts Hosted from Google Apps Script.

• Use the CData Software JDBC Driver for LinkedIn in MicroStrategy Web

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

• How to load SingleStore data into Elasticsearch via Logstash

  Introducing a simple method to load SingleStore data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Connect to Google Ads in DBeaver

  Use the CData ODBC Driver to connect to Google Ads in DBeaver.

• Query NetSuite as a MySQL Database in Node.js

  Execute MySQL queries against NetSuite CRM & ERP from Node.js.

• Automate Dynamics 365 Business Central Replication to SAP HANA

  Use CData Sync to customize and automate Dynamics 365 Business Central replication to SAP HANA.

• A PostgreSQL Interface for eBay

  Use the Remoting features of the eBay ODBC Driver to create a PostgreSQL entry-point for data access.

• Publish Reports with Hive in SAP Crystal Reports

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

• Automated SAP SuccessFactors Replication to Teradata

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

• Provide OData Services of Reckon from a WCF Application

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

• Connect to QuickBooks in the Denodo Platform

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

• Analyze Google Search Results in R

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

• Load Google Spanner to a Database Using Embulk

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

• Visualize LinkedIn in TIBCO Spotfire through ADO.NET

  Integrate LinkedIn into dashboards in TIBCO Spotfire.

• Automated Continuous YouTube Analytics Replication to Apache Cassandra

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

• Build Dynamics CRM-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Dynamics CRM from Zoho Analytics and import live Microsoft Dynamics CRM.

• Provide OData Services of JotForm from a WCF Application

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

• Access Live Raisers Edge NXT in Excel 365 Online (Excel for the web)

  Connect to Raisers Edge NXT from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• Query Zendesk in ColdFusion

  Write standard ColdFusion data access code to connect to Zendesk.

• Use the CData Software ODBC Driver for Zenefits in MicroStrategy

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

• Visualize Impala in Tableau

  The CData ODBC driver for Impala enables you integrate Apache Impala into Tableau dashboards.

• Establish a Live Connection with Google Sheets using Tableau Bridge

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

• Integrate WordPress in Your Informatica Cloud Instance

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

• Operational Reporting on Teradata from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Teradata.

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

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

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

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

• Access Live Kintone in Google Sheets

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

• DataBind Controls to Shippo in Delphi

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

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

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

• Create Google Ad Manager-Connected Visualizations in Klipfolio

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

• Automated Continuous Dynamics NAV Replication to Google Cloud SQL

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

• How to create Visio diagrams from QuickBooks

  Automatically update QuickBooks Desktop with the changes you make to Visio master shapes.

• Using the CData Software ODBC Driver for Amazon S3 in PyCharm

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

• Work with Bitbucket in FoxPro

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

• ShipStation Reporting and Star Schemas in OBIEE

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

• Access Live Salesforce Pardot in Google Sheets

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

• Analyze SAP Fieldglass in R

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

• How to publish and share Zenefits dashboards with Tableau Server

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

• How to create Visio diagrams from ActiveCampaign

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

• Automate Oracle Eloqua Replication to Azure Synapse

  Use CData Sync to customize and automate Oracle Eloqua replication to Azure Synapse.

• Use the CData ODBC Driver for Dynamics CRM in Microsoft Power Query

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

• Automated Continuous Impala Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Impala replication to SingleStore.

• Build an OLAP Cube in SSAS from Jira

  Establish a connection to Atlassian Jira data from SQL Server Analysis Services, and use the Jira Data Provider to build OLAP cubes for use in analytics and reporting.

• Microsoft Planner Cloud Connectivity

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

• Using AngularJS to Build Dynamic Web Pages with SAP Hybris C4C

  Use the CData Connect Server to create SAP Hybris C4C OData feeds and build single-page applications with live SAP Hybris C4C.

• Create Dynamic Sage 50 UK Grids Using the Infragistics XamDataGrid

  Learn how you can connect Sage 50 UK to Infragistics XamDataGrid to build dynamic grids.

• DataBind Wijmo Grid to JSON Services

  Provide real-time JSON to interactive controls.

• Use Biml to Build SSIS Tasks to Replicate Hive to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Apache Hive to SQL Server.

• Connect to HarperDB as a Linked Server

  Use the SQL Gateway and the ODBC Driver to set up a linked server for HarperDB.

• Create SSAS Tabular Models from SharePoint

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Presto

  Provide connectivity to Presto through an SAP BusinessObjects universe.

• DataBind Wijmo Grid to Sage 300

  Provide real-time Sage 300 to interactive controls.

• A PostgreSQL Interface for Amazon DynamoDB

  Use the Remoting features of the Amazon DynamoDB ODBC Driver to create a PostgreSQL entry-point for data access.

• DataBind Acumatica to the DevExpress Data Grid

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

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

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

• Create Highrise-Connected Business Apps in AppSheet

  Use CData Software Connect Server to connect to Highrise from AppSheet and build custom business apps using live Highrise CRM.

• Connect to Oracle from PowerBuilder

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

• Build ShipStation-Connected Apps in Choreo

  Use CData Connect Cloud to connect to ShipStation from Choreo and build custom apps using live ShipStation.

• Access Unbounce from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Unbounce from HeidiSQL.

• Build NetSuite Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live NetSuite CRM & ERP and build visualizations in Tableau.

• DataBind Controls to Facebook in Delphi

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

• Automate Klipfolio Replication to SAP HANA

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

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

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

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

• Build Google Sheets-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Google Sheets.

• Visualize Presto in TIBCO Spotfire through OData

  Integrate Presto into dashboards in TIBCO Spotfire.

• Automated Continuous Act-On Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Act-On replication to Google Cloud SQL.

• Visualize Klaviyo in Sisense

  Create an ElastiCube in Sisense app with access to Klaviyo.

• Build Instagram-Connected Apps in Bubble

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

• Automated Continuous Amazon DynamoDB Replication to Snowflake

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

• Use the CData Software ODBC Driver for Redis in MicroStrategy Desktop

  Connect to Redis in MicroStrategy Desktop using the CData Software ODBC Driver for Redis.

• Connect to Google Data Catalog from PowerBuilder

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

• Create Dynamics NAV-Connected Visualizations in Klipfolio

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

• Create Apps from HBase in Qlik Sense Cloud

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

• Visualize AlloyDB in TIBCO Spotfire through ODBC

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

• Process & Analyze Azure Data Lake Storage in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Azure Data Lake Storage .

• Connect to SharePoint Excel Services in HULFT Integrate

  Connect to SharePoint Excel Services as a JDBC data source in HULFT Integrate

• How to integrate Metabase with Twitter

  Use CData Connect Cloud to connect to live Twitter and create an interactive dashboard in Metabase from Twitter.

• Create Informatica Mappings From/To a JDBC Data Source for SAP SuccessFactors

  Create SAP SuccessFactors data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

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

  Connect to QuickBooks Online 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.

• Build Azure Active Directory-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live Azure Active Directory and build Azure Active Directory-connected web apps with Axios.

• Back Up Microsoft Dynamics NAV to SQL Server through SSIS

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

• «
• 317
• 318
• 319
• 320
• 321
• 322
• 323
• 324
• 325
• 326
• »