CData Software - Knowledge Base

Recent Articles

• «
• 76
• 77
• 78
• 79
• 80
• 81
• 82
• 83
• 84
• 85
• »

• Access Confluence from MySQL in Amazon QuickSight

  Connect to Confluence and build visualizations of Atlassian Confluence using a MySQL Connection in Amazon QuickSight.

• Analyze Epicor Kinetic in R

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

• Build Google Sheets Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live Google Sheets and build visualizations in Tableau Cloud.

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

  Provide connectivity to Microsoft SharePoint through an SAP BusinessObjects universe.

• Connect to MailChimp from a Connection Pool in Jetty

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

• How to Query eBay in MySQL Workbench

  Execute MySQL queries against live eBay from MySQL Workbench.

• Use Dash to Build to Web Apps on SAP Hybris C4C

  Create Python applications that use pandas and Dash to build SAP Hybris C4C-connected web apps.

• Integrate with Teradata using Apache Camel2

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

• Build Azure Table-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Azure Table from Zoho Analytics and import live Azure Table Storage.

• Working with Zenefits in LINQPad

  Execute LINQ queries to Zenefits in LINQPad.

• Import Real-Time RSS Feeds in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use RSS Feeds in ColdFusion.

• Access Live Salesforce Marketing in Coginiti Pro

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

• Choosing the Best Method to Connect Oracle HCM Cloud to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use Oracle HCM Cloud from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Connect to Splunk from a Connection Pool in Jetty

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

• Publish Reports with Google Data Catalog in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Google Data Catalog.

• Use the CData SSIS Components to Insert New or Update Existing Outreach.io Records from SQL Server

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

• Create SAP Hybris C4C Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for SAP Hybris C4C to build custom dashboards in Bold BI.

• Automated Continuous SAP Concur Replication to PostgreSQL

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

• Analyze Active Directory in Looker

  Use CData Connect Cloud to connect to Active Directory from Looker and build custom apps using live Active Directory.

• Connect to Raisers Edge NXT in the Denodo Platform

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

• Automated Continuous Pinterest Replication to IBM DB2

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

• PowerShell Scripting to Replicate QuickBooks Time to MySQL

  Write a simple PowerShell script to replicate QuickBooks Time to a MySQL database.

• Natively Connect to Google Cloud Storage in PHP

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

• Process & Analyze Odoo in Databricks (AWS)

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

• Access Live Oracle Service Cloud in AWS Lambda

  Connect to live Oracle Service Cloud in AWS Lambda using the CData JDBC Driver.

• Working with MailChimp in LINQPad

  Execute LINQ queries to MailChimp in LINQPad.

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

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

• How to connect and process CSV from Azure Databricks

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

• Working with Elasticsearch in LINQPad

  Execute LINQ queries to Elasticsearch in LINQPad.

• Create Dynamic Oracle Financials Cloud Grids Using the Infragistics XamDataGrid

  Learn how you can connect Oracle Financials Cloud to Infragistics XamDataGrid to build dynamic grids.

• DataBind Controls to Salesloft in C++Builder

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

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

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

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

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

• Model Twilio Using Azure Analysis Services

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

• Access Teradata as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Teradata from your Oracle system.

• Connect to Databricks as a SQL Server Linked Server

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

• Connect to Zoho Creator in Google Apps Script

  Use CData Connect Cloud to access Zoho Creator in Google Apps Script.

• Query Freshdesk in ColdFusion

  Write standard ColdFusion data access code to connect to Freshdesk.

• How to connect to Avalara AvaTax in DBVisualizer

  Integrate Avalara AvaTax with visual data analysis tools and data connection wizards in DBVisualizer

• How to Work with Dynamics CRM in AWS Glue Jobs Using JDBC

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

• Access Microsoft OneDrive from MySQL in HeidiSQL

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

• Connect to Excel in DBeaver

  Use the CData ODBC Driver to connect to Microsoft Excel in DBeaver.

• Todoist Reporting and Star Schemas in OBIEE

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

• How to Connect the Power BI Service to NetSuite: Complete Guide

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

• Viewing Greenplum in RAD Studio Data Explorer

  How to view Pivotal GreenPlum in RAD Studio Data Explorer using the CData ODBC Driver for Greenplum.

• Connect to Snowflake from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Snowflake from Filemaker Pro on Mac.

• Integrate Shippo with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Shippo with External Services.

• Integrate LDAP Objects into Automated Tasks with Power Automate

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

• Visualize Live Blackbaud FE NXT in the Power BI Service

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

• Connect to Cvent as a Linked Server

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

• Access Amazon DynamoDB from MySQL in Amazon QuickSight

  Connect to Amazon DynamoDB and build visualizations of Amazon DynamoDB using a MySQL Connection in Amazon QuickSight.

• Replicate Multiple Odoo Accounts

  Replicate multiple Odoo accounts to one or many databases.

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

  Create an ODBC connection to Amazon DynamoDB in Informatica and browse and transfer Amazon DynamoDB.

• Create Datasets from Google Data Catalog in Domo Workbench and Build Visualizations of Google Data Catalog in Domo

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

• Automated Continuous Reckon Replication to Snowflake

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

• Connect to Microsoft Exchange in JRuby

  Create a simple JRuby app with access to live Microsoft Exchange.

• How to import Reckon Accounts Hosted into Apache Solr

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

• Load Microsoft Planner to a Database Using Embulk

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

• Integrate Oracle Financials Cloud in Your Informatica Cloud Instance

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

• Connect to SurveyMonkey in JRuby

  Create a simple JRuby app with access to live SurveyMonkey.

• Query Okta in DataGrip

  Create a Data Source for Okta in DataGrip and use SQL to query live Okta.

• Access Live Sugar CRM in Excel (Desktop)

  Use CData Connect Cloud to gain access to live Sugar CRM from your Excel spreadsheets.

• Automate CockroachDB Integration Tasks from PowerShell

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

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

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

• Query, Visualize, and Share live Elasticsearch in Redash

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

• Build Dashboards with GraphQL in Dundas BI

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

• Connect to Veeva in the Denodo Platform

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

• Use the CData Software ODBC Driver for eBay Analytics in MicroStrategy

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

• Visualize Live GitHub in the Power BI Service

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

• Create Snapchat Ads-Connected Business Apps in AppSheet

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

• Integrate BigCommerce in Your Informatica Cloud Instance

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

• Connect to Live YouTube Analytics in MicroStrategy through CData Connect Cloud

  Create a live connection to YouTube Analytics in CData Connect Cloud and connect to your YouTube Analytics from MicroStrategy.

• Automated JotForm Replication to Teradata

  Use CData Sync to Customize and automate JotForm replication to Teradata.

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

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

• Connect to Facebook in as an External Source in Dremio

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

• Natively Connect to Zuora in PHP

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

• Visualize Microsoft Dataverse in TIBCO Spotfire through ADO.NET

  Integrate Microsoft Dataverse (CDS) into dashboards in TIBCO Spotfire.

• Design BIRT Reports on Harvest

  Provide current Harvest to your embedded analytics.

• Analyze Bullhorn CRM in Looker

  Use CData Connect Cloud to connect to Bullhorn CRM from Looker and build custom apps using live Bullhorn CRM.

• Integrate Google Analytics with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Google Analytics with External Services.

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

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

• Visualize Excel in TIBCO Spotfire through ODBC

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

• Integrate Real-Time Access to Microsoft OneDrive in SAPUI5 MVC Apps

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

• Connect to Pinterest in Jaspersoft Studio

  Execute SQL to remote Pinterest in Jaspersoft Studio.

• Build Semantic Layer Views for Salesforce Pardot in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Salesforce Pardot.

• Access Oracle HCM Cloud 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 Oracle HCM Cloud.

• How to create an RPA flow for Microsoft Dataverse in UiPath Studio

  Use the Microsoft Dataverse ODBC Driver to create workflows that access real-time Microsoft Dataverse (CDS) without any coding.

• Analyze JSON Services in R

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

• Automated Continuous FHIR Replication to Apache Kafka

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

• How to Work with Jira Assets in ETL Validator JDBC

  Connect to Jira Assets from ETL Validator jobs using the CData Software JDBC Driver.

• How to connect to Azure Table in DBVisualizer

  Integrate Azure Table Storage with visual data analysis tools and data connection wizards in DBVisualizer

• Natively Connect to Jira in PHP

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

• Automate Power BI XMLA Replication to Azure Synapse

  Use CData Sync to customize and automate Power BI XMLA replication to Azure Synapse.

• Natively Connect to Adobe Commerce in PHP

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

• Connect to XML in Google Apps Script

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

• Write a Simple Go Application to work with Excel Online on Linux

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

• Connect to MariaDB in CloverDX (formerly CloverETL)

  Transfer MariaDB using the visual workflow in the CloverDX data integration tool.

• Design BIRT Reports on Square

  Provide current Square to your embedded analytics.

• How to Visualize Drift Data in Python with pandas

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

• Build Salesforce Pardot-Connected Web Apps with Axios and CData Connect Cloud

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

• «
• 76
• 77
• 78
• 79
• 80
• 81
• 82
• 83
• 84
• 85
• »