CData Software - Knowledge Base

Recent Articles

• «
• 136
• 137
• 138
• 139
• 140
• 141
• 142
• 143
• 144
• 145
• »

• Build Visualizations of Oracle SCM in Birst

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

• Create Greenplum-Connected Nintex Workflows

  Use CData Connect Cloud to connect to Greenplum from Nintex Workflow Cloud and build custom workflows using live Pivotal GreenPlum.

• Use the CData Software JDBC Driver for Google Campaign Manager 360 in MicroStrategy Web

  Connect to Google Campaign Manager 360 in MicroStrategy Web using the CData Software JDBC Driver for Google Campaign Manager 360.

• Using the CData Software ODBC Driver for Azure Data Lake Storage in PyCharm

  Connect to Azure Data Lake Storage as an ODBC data source in PyCharm using the CData Software ODBC Driver for Azure Data Lake Storage.

• Build Charts with Acumatica in Clear Analytics

  Create dynamic charts and perform analytics based on Acumatica ERP in Clear Analytics.

• Connect to SingleStore in Jaspersoft Studio

  Execute SQL to remote SingleStore in Jaspersoft Studio.

• Automated Continuous Typeform Replication to Vertica

  Use CData Sync for automated, continuous, customizable Typeform replication to Vertica.

• Visualize Phoenix in TIBCO Spotfire through ADO.NET

  Integrate Apache Phoenix into dashboards in TIBCO Spotfire.

• Create Apps from XML in Qlik Sense Cloud

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

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

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

• Integrate SAP Hybris C4C with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate SAP Hybris C4C with External Services.

• A PostgreSQL Interface for Salesloft

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

• Visualize Adobe Analytics in TIBCO Spotfire through ODBC

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

• Author and Share Power BI Reports on Real-Time Monday.com

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

• Automated Continuous Office 365 Replication to AlloyDB

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

• Build Raisers Edge NXT-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for Raisers Edge NXT and create custom apps in Mendix.

• Build Google Spanner-Connected ETL Processes in Google Data Fusion

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

• Import Real-Time CockroachDB in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use CockroachDB in ColdFusion.

• Create Datasets from eBay Analytics in Domo Workbench and Build Visualizations of eBay Analytics in Domo

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

• Automated Continuous Stripe Replication to SingleStore

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

• DataBind Adobe Commerce to the DevExpress Data Grid

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

• Connect to Oracle SCM in as an External Source in Dremio

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

• Query, Visualize, and Share live Azure Analysis Services in Redash

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

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

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

• DataBind Charts to Airtable

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

• Connect to Quickbase in JRuby

  Create a simple JRuby app with access to live Quickbase.

• Query, Visualize, and Share live Google Campaign Manager 360 in Redash

  Use CData Connect Cloud to connect to live Google Campaign Manager 360 in Redash for querying, visualizing, and sharing.

• Export Data from SQL Server to TaxJar through SSIS

  Easily push SQL Server data to TaxJar using the CData SSIS Tasks for TaxJar.

• Automated Continuous Sage 200 Replication to SingleStore

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

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

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

• Stream Highrise into Apache Kafka Topics

  Access and stream Highrise CRM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Access Google Calendar as a Remote Oracle Database

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

• Enable the Sybase IQ JDBC Driver in KNIME

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

• Visualize Exact Online in TIBCO Spotfire through ODBC

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

• Build Dashboards with MongoDB in Dundas BI

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

• Access Live OData Services in Coginiti Pro

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

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

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

• Connect to Salesforce Pardot in JRuby

  Create a simple JRuby app with access to live Salesforce Pardot.

• Import and Visualize Oracle Service Cloud in Power View

  Create data visualizations based on Oracle Service Cloud in Excel.

• Query Google Analytics in ColdFusion

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

• Analyze TaxJar in SAP Analytics Cloud

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

• Build Adobe Commerce-Connected ETL Processes in Google Data Fusion

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

• How to connect to Cosmos DB from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for Cosmos DB and work with Azure Cosmos DB in Microsoft Excel on Mac OS X.

• Excel Online Reporting and Star Schemas in OBIEE

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

• Connect to Amazon DynamoDB in JRuby

  Create a simple JRuby app with access to live Amazon DynamoDB.

• Query QuickBooks through ODBC in Node.js

  Use node-odbc to execute SQL queries against QuickBooks Desktop from Node.js.

• Visualize Live Sage 200 in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Sage 200.

• How to Create Power BI Visual Reports with Real-Time Tally

  Use CData Power BI Connectors to visualize Tally ERP in Power BI.

• Create MariaDB-Connected Nintex Workflows

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

• Work with BambooHR in FoxPro

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

• How to Query Oracle Sales in MySQL Workbench

  Execute MySQL queries against live Oracle Sales from MySQL Workbench.

• Automated Continuous Tally Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable Tally replication to Amazon S3.

• How to connect to Zoho Books from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for Zoho Books and work with Zoho Books in Microsoft Excel on Mac OS X.

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

  Provide connectivity to Kintone through an SAP BusinessObjects universe.

• Connect to HDFS in NetBeans

  Connect to Apache HDFS in NetBeans with the data source configuration wizard.

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

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

• Create CSV Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for CSV/TSV Files to build custom dashboards in Bold BI.

• Operational Reporting on Oracle HCM Cloud from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Oracle HCM Cloud.

• Visualize Live Shopify in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Shopify.

• Access Live OneNote in AWS Lambda (with IntelliJ IDEA)

  Connect to live Microsoft OneNote in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Access Live Amazon Marketplace in Google Sheets

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

• Automated Continuous Epicor Kinetic Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Azure SQL.

• Connect to WooCommerce in Google Apps Script

  Use CData Connect Cloud to access WooCommerce in Google Apps Script.

• Build Semantic Layer Views for Excel in APOS Live Data Gateway

  Use the CData Connector for Excel in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Excel.

• How to connect to Neo4J from Google Apps Script

  Use CData Software Connect Server to access Neo4J in Google Apps Script.

• Create SSAS Tabular Models from TigerGraph

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

• Automated Continuous ShipStation Replication to SQLite

  Use CData Sync for automated, continuous, customizable ShipStation replication to SQLite.

• Replicate Multiple BigQuery Accounts

  Replicate multiple BigQuery accounts to one or many databases.

• Prepare, Blend, and Analyze HubSpot in Alteryx Designer

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

• Integrate Oracle SCM in the Pentaho Report Designer

  Publish reports based on Oracle SCM in the Pentaho BI tool.

• Rapidly Develop Microsoft Project-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.

• How to Build an ETL App for ActiveCampaign in Python with CData

  Create ETL applications and real-time data pipelines for ActiveCampaign in Python with petl.

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

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

• Query PostgreSQL as a MySQL Database in Node.js

  Execute MySQL queries against PostgreSQL from Node.js.

• Build Visualizations of Couchbase in Birst

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

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

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

• Automated Continuous Cloudant Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Cloudant replication to Amazon Redshift.

• Connect to Gmail as a Linked Server

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

• Access SharePoint from MySQL in PHP

  Connect to SharePoint through the standard MySQL libraries in PHP.

• Query Power BI XMLA in MySQL Workbench

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

• Write a Simple Go Application to work with NetSuite on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to NetSuite CRM & ERP.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Connect to Xero from HeidiSQL

  Use CData Connect Cloud to connect to and query live Xero Accounting from HeidiSQL.

• Connect to SAP BusinessObjects BI in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to Drift from a Connection Pool in Jetty

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

• How to connect and process Bullhorn CRM from Azure Databricks

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

• Connect to Salesforce Marketing in Google Apps Script

  Use CData Connect Cloud to access Salesforce Marketing Cloud in Google Apps Script.

• Query CouchDB in MySQL Workbench

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

• How to connect to Azure Data Lake Storage from Spring Boot

  Connect to Azure Data Lake Storage in a Spring Boot Application using CData JDBC Azure Data Lake Storage Driver

• Establish a Live Connection with Azure DevOps using Tableau Bridge

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

• Automated Continuous QuickBooks Time Replication to Oracle

  Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Oracle.

• How to integrate Metabase with Snowflake

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

• Query IBM Cloud Object Storage in ColdFusion

  Write standard ColdFusion data access code to connect to IBM Cloud Object Storage.

• Connect to Sage 300 in as an External Source in Dremio

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

• Visualize SAP Netweaver Gateway in TIBCO Spotfire through OData

  Integrate SAP Netweaver Gateway into dashboards in TIBCO Spotfire.

• Connect to ClickUp from PowerBuilder

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

• Build Pipelines with Live Veeva in Google Cloud Data Fusion (via CData Connect Cloud)

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

• Integrate SAP Business One with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate SAP Business One with External Services.

• Connect to Microsoft Teams in Google Apps Script

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

• Connect to Zoom from a Connection Pool in JBoss

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

• «
• 136
• 137
• 138
• 139
• 140
• 141
• 142
• 143
• 144
• 145
• »