CData Software - Knowledge Base

Recent Articles

• «
• 289
• 290
• 291
• 292
• 293
• 294
• 295
• 296
• 297
• 298
• »

• Connect to Trello in SpagoBI

  Create reports featuring live Trello in SpagoBI Studio. Host Trello reports on SpagoBI Server.

• Connect to Jira Service Management in Ruby

  Connect to Atlassian Jira Service Management in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Connect to Workday from PowerBuilder

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

• How to connect to ConstantContact from Spring Boot

  Connect to ConstantContact in a Spring Boot Application using CData JDBC ConstantContact Driver

• Automated Continuous Oracle SCM Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Oracle SCM replication to Google Cloud SQL.

• Design BIRT Reports on Google Ad Manager

  Provide current Google Ad Manager to your embedded analytics.

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

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

• A PostgreSQL Interface for SAP HANA XS Advanced

  Use the Remoting features of the SAP HANA XS Advanced ODBC Driver to create a PostgreSQL entry-point for data access.

• How to pipe LinkedIn to CSV in PowerShell

  Use standard PowerShell cmdlets to access LinkedIn tables.

• Using the CData Software ODBC Driver for Epicor Kinetic in PyCharm

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

• How to Query Google Sheets in MySQL Workbench

  Execute MySQL queries against live Google Sheets from MySQL Workbench.

• Connect to Snapchat Ads through External Services in Salesforce

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

• Create Couchbase-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Couchbase from OutSystems and build custom enterprise apps using live Couchbase.

• Import Real-Time Microsoft Project in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Microsoft Project in ColdFusion.

• ETL Cloudant in Oracle Data Integrator

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

• Back Up SendGrid to SQL Server through SSIS

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

• Use the CData ODBC Driver for Dynamics CRM in SAS JMP

  You can use the CData ODBC Driver to integrate Microsoft Dynamics CRM into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Dynamics CRM in the Graph Builder and Query Builder.

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

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

• How to update Hive from Excel

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

• Model, Search, and Visualize Live Spark in ThoughtSpot

  Use CData Connect Cloud to connect to live Apache Spark SQL for modeling, searching, and visualizing.

• Query Jira Service Management through ODBC in Node.js

  Use node-odbc to execute SQL queries against Atlassian Jira Service Management from Node.js.

• Build Sage Cloud Accounting Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live Sage Business Cloud Accounting and build visualizations in Tableau Cloud.

• Build Square-Connected Apps in Bubble

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

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

  Provide connectivity to HubSpot through an SAP BusinessObjects universe.

• Visualize Shippo in TIBCO Spotfire through OData

  Integrate Shippo into dashboards in TIBCO Spotfire.

• Natively Connect to SuiteCRM in PHP

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

• Integrate Real-Time Access to SAP HANA in SAPUI5 MVC Apps

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

• Query Active Directory as a SQL Server Database in Node.js

  Execute SQL Server queries against Active Directory from Node.js.

• Visualize Azure Synapse in TIBCO Spotfire through ADO.NET

  Integrate Azure Synapse into dashboards in TIBCO Spotfire.

• Edit and Search External Coinbase Objects in Salesforce Connect

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

• How to connect to SharePoint in DBVisualizer

  Integrate Microsoft SharePoint with visual data analysis tools and data connection wizards in DBVisualizer

• Configure the CData JDBC Driver for Tableau CRM Analytics in a Connection Pool in Tomcat

  Connect to Tableau CRM Analytics from a connection pool in Tomcat.

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

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

• Use the CData Software ODBC Driver for ConstantContact in MicroStrategy

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

• Write a Simple Go Application to work with Reckon Accounts Hosted on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Reckon Accounts Hosted.

• Connect to Bing Ads in as an External Source in Dremio

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

• How to Query GitHub in MySQL Workbench

  Execute MySQL queries against live GitHub from MySQL Workbench.

• Integrate SAP Ariba Procurement with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate SAP Ariba Procurement with External Services.

• Visualize Live Printify in the Power BI Service

  Use CData Software Connect Server to create a virtual SQL Server database for Printify and create custom reports in the Power BI Service.

• Edit and Search External FTP Objects in Salesforce Connect

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

• Build Dropbox Visualizations in Tableau Cloud

  Use CData Software Connect Server to create a virtual SQL Server Database for Dropbox and build visualizations in Tableau Cloud.

• Connect to Greenhouse from a Connection Pool in JBoss

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

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

• Create ServiceNow-Connected Business Apps in AppSheet

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

• How to Visualize Unbounce Data in Python with pandas

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

• Automated Continuous SAP Ariba Procurement Replication to Oracle

  Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Oracle.

• Analyze Live Excel Online in SAS Viya

  Use CData Connect Cloud to connect to Microsoft Excel Online from SAS Viya and deploy self-service analytics using live Microsoft Excel Online.

• Automated Continuous Azure Active Directory Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Azure Active Directory replication to Google Cloud SQL.

• Integrate Unbounce in Your Informatica Cloud Instance

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

• Connect to CockroachDB as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live CockroachDB.

• Build Pipelines with Live Dynamics 365 Business Central in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Dynamics 365 Business Central from Google Cloud Data Fusion, enabling the integration of live Dynamics 365 Business Central into the building and management of effective data pipelines.

• How to Connect to HubDB in Using Python: 6 Steps

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

• Bidirectional Access to Dynamics 365 from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Dynamics 365 in Filemaker Pro for Mac or Windows.

• Automate SAP Hybris C4C Replication to Azure Synapse

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

• Connect to SAP in RunMyProcess through Connect Server

  Use CData Connect Server to create an OData API for SAP and connect to SAP ERP/NetWeaver in Akorbi Digital RunMyProcess.

• Automated Continuous CockroachDB Replication to IBM DB2

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

• Query Sage Cloud Accounting in ColdFusion

  Write standard ColdFusion data access code to connect to Sage Business Cloud Accounting.

• Use the CData ODBC Driver for REST in SAS JMP

  You can use the CData ODBC Driver to integrate REST into the statistical analysis tools available in SAS JMP. This article shows how to use REST in the Graph Builder and Query Builder.

• Access Dynamics GP from MySQL in PHP

  Connect to Dynamics GP through the standard MySQL libraries in PHP.

• Connect to Calendly from PowerBuilder

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

• Connect to Live Slack in PostGresSQL Interface through CData Connect Cloud

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

• Build MVC Applications with Connectivity to eBay Analytics

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

• Create REST-Connected Visualizations in Klipfolio

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

• Replicate Jira for Use in Salesforce Connect

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

• Extract, Transform, and Load SAP Ariba Procurement in Informatica PowerCenter

  Create a simple Workflow for SAP Ariba Procurement in Informatica PowerCenter.

• Visualize Google Sheets Data in Tableau

  The CData ODBC driver for Google Sheets enables you integrate Google Sheets data into Tableau dashboards.

• Build Clio-Connected ETL Processes in Google Data Fusion

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

• Use JayDeBeApi to access Avro in Python

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

• DataBind Charts to Amazon Marketplace

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Amazon Marketplace 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.

• Query Greenplum as a MySQL Database in Node.js

  Execute MySQL queries against Pivotal GreenPlum from Node.js.

• Analyze Square with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Square from Power Pivot. You will use the Table Import Wizard to load Square. You can visually build the import query or use any SQL supported by the driver.

• Automated Continuous Blackbaud FE NXT Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to delimited files (CSV/TSV).

• Publish xBase-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live xBase.

• Explore Geographical Relationships in Google Analytics with Power Map

  Create data visualizations with Google Analytics in Power Map.

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

  Connect to YouTube Analytics from a connection pool in Tomcat.

• Connect to Square in Google Apps Script

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

• How to connect to Zoho Creator from IntelliJ

  Integrate connectivity to Zoho Creator with wizards in IntelliJ.

• A PostgreSQL Interface for Dynamics 365 Business Central

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

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

  Connect to SendGrid 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.

• Integrate MariaDB in Your Informatica Cloud Instance

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

• Query Pinterest in MySQL Workbench

  Create a virtual MySQL database for Pinterest in CData Software Connect (or Connect Server) and work with live Pinterest in MySQL Workbench.

• Query BigQuery in ColdFusion

  Write standard ColdFusion data access code to connect to Google BigQuery.

• Query Sage 50 UK in ColdFusion

  Write standard ColdFusion data access code to connect to Sage 50 UK.

• Use JayDeBeApi to access SAP ByDesign in Python

  Use standard Python scripting and the development environment of your choice to access live SAP Business ByDesign.

• Replicate OData Services from PowerShell

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

• Build Square-Connected Apps in Choreo

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

• Replicate MailChimp to Multiple Databases

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

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

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

• Prepare, Blend, and Analyze Outreach.io in Alteryx Designer

  Build workflows to access live Outreach.io for self-service data analytics.

• Working with Adobe Analytics in LINQPad

  Execute LINQ queries to Adobe Analytics in LINQPad.

• Automate Reckon Accounts Hosted Replication to SAP HANA

  Use CData Sync to customize and automate Reckon Accounts Hosted replication to SAP HANA.

• Create BambooHR Dataflows on PowerBI.com

  Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

• Build Apps with Live Pipedrive Using the Low-Code Development Platform of Mendix

• «
• 289
• 290
• 291
• 292
• 293
• 294
• 295
• 296
• 297
• 298
• »