CData Software - Knowledge Base

Recent Articles

• «
• 95
• 96
• 97
• 98
• 99
• 100
• 101
• 102
• 103
• 104
• »

• Working with SAP Ariba Source in LINQPad

  Execute LINQ queries to SAP Ariba Source in LINQPad.

• Access Live Coinbase in Coginiti Pro

  Connect to and query live Coinbase from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Visualize Live YouTube Analytics in the Power BI Service

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

• Model Freshdesk Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Freshdesk, enabling the direct import of real-time Freshdesk.

• Create Apps from SQL Analysis Services in Qlik Sense Cloud

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

• How to Connect DBeaver to Harvest via a JDBC Driver

  Manage Harvest with visual tools in DBeaver like the query browser.

• Visualize Trello in Sisense

  Create an ElastiCube in Sisense app with access to Trello.

• Publish Oracle HCM Cloud-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Oracle HCM Cloud.

• Build YouTube Analytics-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live YouTube Analytics and build YouTube Analytics-connected web apps with Axios.

• How to connect and process Epicor Kinetic from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Epicor Kinetic

• Connect to Databricks from PowerBuilder

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

• Excel Spreadsheet Automation with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Create Sybase-Connected Business Apps in AppSheet

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

• How to Access Redis Using Entity Framework

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

• Import Real-Time Google Sheets in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Google Sheets in ColdFusion.

• Visualize Zoho CRM in TIBCO Spotfire through OData

  Integrate Zoho CRM into dashboards in TIBCO Spotfire.

• Automated Continuous Microsoft Planner Replication to Snowflake

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

• Connect to Google Contacts as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Google Contacts.

• Process & Analyze Sage 200 in Databricks (AWS)

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

• Connect to Cassandra in Ruby

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

• Connect to Google Contacts from a Connection Pool in JBoss

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

• Connect to Google Directory as a Linked Server

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

• Create Data Visualizations Based On Google Spanner in Mode

  Use CData Connect Cloud to connect to Google Spanner from Mode and build visualizations using live

• Create Data Visualizations Based On Elasticsearch in Mode

  Use CData Connect Cloud to connect to Elasticsearch from Mode and build visualizations using live

• Use JayDeBeApi to access Microsoft Planner in Python

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

• Query Bing Ads through ODBC in Node.js

  Use node-odbc to execute SQL queries against Bing Ads from Node.js.

• NuGet Repository Overview

  CData is aware of a recently discovered malware published on nuget.org with package names designed to impersonate several vendor products, including CData.

• Publish Crystal Reports on Blackbaud FE NXT

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Blackbaud FE NXT.

• Replicate HCL Domino to Multiple Databases

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

• Bridge Klaviyo Connectivity with Apache NiFi

  Access and process Klaviyo in Apache NiFi using the CData JDBC Driver.

• Automated Continuous Kafka Replication to AlloyDB

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

• Integrate with SAP SuccessFactors using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP SuccessFactors to a JSON file on disk.

• Use Dash to Build to Web Apps on Tableau CRM Analytics

  Create Python applications that use pandas and Dash to build Tableau CRM Analytics-connected web apps.

• Automated Act-On Replication to Teradata

  Use CData Sync to Customize and automate Act-On replication to Teradata.

• Automated Continuous IBM Cloud Data Engine Replication to MongoDB

  Use CData Sync for automated, continuous, customizable IBM Cloud Data Engine replication to MongoDB.

• Use JayDeBeApi to access Typeform in Python

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

• How to Connect DBeaver to Cvent via a JDBC Driver

  Manage Cvent with visual tools in DBeaver like the query browser.

• How to use SQLAlchemy ORM to access Freshdesk in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Freshdesk.

• Replicate SAP HANA XS Advanced to Multiple Databases

  Replicate SAP HANA XS Advanced to disparate databases with a single configuration.

• How to connect PolyBase to MongoDB

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

• Work with SAP Ariba Source in FoxPro

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

• Connect to SingleStore in Google Apps Script

  Use the ODBC Driver for SingleStore and the SQL Gateway to access SingleStore from Google Apps Script.

• DataBind Wijmo Grid to Tableau CRM Analytics

  Provide real-time Tableau CRM Analytics to interactive controls.

• Connect to NetSuite from HeidiSQL

  Use CData Connect Cloud to connect to and query live NetSuite CRM & ERP from HeidiSQL.

• Natively Connect to Zoho Creator in PHP

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

• Access Oracle HCM Cloud from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Oracle HCM Cloud from HeidiSQL.

• Visualize Twitter in Sisense

  Create an ElastiCube in Sisense app with access to Twitter.

• Connect to Azure Data Lake Storage from AWS Glue

  Use CData Connect Cloud to gain access to live Azure Data Lake Storage from your AWS Glue jobs.

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

  Use LlamaIndex to query live NetSuite CRM & ERP data in natural language using Python.

• Create Marketo-Connected Business Apps in AppSheet

  Connect to Marketo via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Marketo.

• Automated Continuous XML Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable XML replication to PostgreSQL.

• Automate SAP Business One Replication to Couchbase

  Use CData Sync to Customize and automate SAP Business One replication to Couchbase.

• How to connect to Azure Active Directory with Squirrel SQL client

  Connect to Azure Active Directory and execute queries in the Squirrel SQL Client.

• Replicate Dynamics NAV for Use in Salesforce Connect

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

• How to Build Dynamic React Apps with xBase

  Use the CData Connect and React to Build Dynamic Web Apps with Live xBase .

• Author and Share Power BI Reports on Real-Time Dynamics NAV

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

• Build Visualizations of Zenefits in Birst

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

• Extract, Transform, and Load Dynamics GP in Informatica PowerCenter

  Create a simple Workflow for Microsoft Dynamics GP in Informatica PowerCenter.

• Viewing Blackbaud FE NXT in RAD Studio Data Explorer

  How to view Blackbaud FE NXT in RAD Studio Data Explorer using the CData ODBC Driver for Blackbaud FE NXT.

• How to Connect to Office 365 in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Microsoft Office 365. Leverage the pyodbc module for ODBC in Python.

• Access Cosmos DB in PHP through Connect Server

  Connect to Cosmos DB through the standard SQL Server libraries in PHP.

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

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

• Import Calendly into FileMaker Pro

  Create reports that integrate Calendly in Filemaker Pro.

• Access Snapchat Ads 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 Snapchat Ads.

• RSS Reporting and Star Schemas in OBIEE

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

• Build Semantic Layer Views for SAP Ariba Procurement in APOS Live Data Gateway

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

• Automated Continuous Dynamics 365 Business Central Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to MongoDB.

• Automate Highrise Integration Tasks from PowerShell

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

• Enable the DocuSign JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with DocuSign.

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

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

• Integrate with Live HCL Domino in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to HCL Domino from the MuleSoft Anypoint Platform to integrate live HCL Domino into custom reports and dashboards.

• DataBind Charts to Okta

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Okta from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

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

  Provide connectivity to Sybase through an SAP BusinessObjects universe.

• Build a Simple VCL Application for MYOB AccountRight

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

• Integrate Kintone in the Pentaho Report Designer

  Publish reports based on Kintone in the Pentaho BI tool.

• Automated Continuous Sugar CRM Replication to Azure SQL

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

• DataBind Wijmo Grid to Blackbaud FE NXT

  Provide real-time Blackbaud FE NXT to interactive controls.

• How to Connect to Cosmos DB in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Azure Cosmos DB. Leverage the pyodbc module for ODBC in Python.

• Automated Continuous ServiceNow Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable ServiceNow replication to PostgreSQL.

• Connect to Bitbucket in as an External Source in Dremio

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

• DataBind Controls to Neo4J in C++Builder

  DataBind to Neo4J in C++Builder with standard components and controls.

• Automated Continuous SAP BusinessObjects BI Replication to MongoDB

  Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to MongoDB.

• DataBind Controls to Klaviyo in Delphi

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

• Connect to Sage Intacct in DBArtisan

  Use wizards in DBArtisan to configure Sage Intacct as a data source.

• Import Real-Time IBM Cloud Data Engine in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use IBM Cloud Data Engine in ColdFusion.

• Integrate Sage Cloud Accounting into Power Automate Desktop using CData Connect

  CData Connect for Sage Cloud Accounting enables you to integrate Sage Business Cloud Accounting into workflows built using Microsoft Power Automate Desktop.

• Analyze Blackbaud FE NXT in R

  Use standard R functions and the development environment of your choice to analyze Blackbaud FE NXT with the CData JDBC Driver for Blackbaud FE NXT.

• DataBind Charts to Zoho Books

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho Books from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• Integrate Live Oracle Financials Cloud into Custom Business Apps Built in Power Apps

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

• Use the CData Software JDBC Driver for Zoho Creator in MicroStrategy

  Connect to Zoho Creator in MicroStrategy Developer using the CData Software JDBC Driver for Zoho Creator.

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

  Provide connectivity to SuiteCRM through an SAP BusinessObjects universe.

• Export Data from SQL Server to Oracle Service Cloud through SSIS

  Easily push SQL Server data to Oracle Service Cloud using the CData SSIS Tasks for Oracle Service Cloud.

• Automated Continuous Sage 300 Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Sage 300 replication to PostgreSQL.

• Connect to Sybase IQ in as an External Source in Dremio

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

• Build Google Directory-Connected Apps in Choreo

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

• Import and Visualize SQL Server in Power View

  Create data visualizations based on Microsoft SQL Server in Excel.

• Connect to Veeva in RazorSQL

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

• Automated Continuous Sybase IQ Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Sybase IQ replication to Google Cloud SQL.

• Connect to SAP Business One in Aqua Data Studio

  Access SAP Business One from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Back Up Greenhouse to SQL Server through SSIS

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

• «
• 95
• 96
• 97
• 98
• 99
• 100
• 101
• 102
• 103
• 104
• »