CData Software - Knowledge Base

Recent Articles

• «
• 188
• 189
• 190
• 191
• 192
• 193
• 194
• 195
• 196
• 197
• »

• Automated Continuous CouchDB Replication to Oracle

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

• How to connect to Invoiced from MS Excel on Mac OS X

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

• Build WooCommerce Visualizations in Tableau Desktop

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

• Build Square-Connected Apps in Bubble

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

• How to connect to Calendly from Google Apps Script

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

• Connect to Oracle Eloqua from AWS Glue

  Use CData Connect Cloud to gain access to live Oracle Eloqua from your AWS Glue jobs.

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

  Use CData Power BI Connectors to visualize Microsoft Access in Power BI.

• How to connect PolyBase to Google Campaign Manager 360

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

• Access Live QuickBooks Online in Google Sheets via Connect Cloud

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

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

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

• Integrate DB2 in Your Informatica Cloud Instance

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

• Create Informatica Mappings From/To an ODBC Data Source for Blackbaud FE NXT

  Create an ODBC connection to Blackbaud FE NXT in Informatica and browse and transfer Blackbaud FE NXT.

• Build PostgreSQL Visualizations in Tableau Cloud

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

• How to Seamlessly Import Sage 200 Data into IBM SPSS Modeler

  Integrate Sage 200 data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Integrate Pipedrive in the Pentaho Report Designer

  Publish reports based on Pipedrive in the Pentaho BI tool.

• Analyze DocuSign in Cognos Analytics

  Use CData Connect Cloud to connect to DocuSign from Cognos Analytics and analyze live DocuSign.

• Object-Relational Mapping (ORM) with Access Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Microsoft Access into a Java-based ORM framework, Hibernate.

• Integrate with TigerGraph in JReport Designer

  Create charts and reports based on TigerGraph in JReport Designer.

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

  Provide connectivity to Salesforce & Force.com through an SAP BusinessObjects universe.

• Connect to Sybase in Ruby

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

• Analyze ClickUp with Power Pivot

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

• Connect to Authorize.Net from a Connection Pool in JBoss

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

• ETL Cosmos DB in Oracle Data Integrator

  This article shows how to transfer Azure Cosmos DB into a data warehouse using Oracle Data Integrator.

• Create Reports with REST in SAP Crystal Reports

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

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

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

• Connect to BigCommerce in RapidMiner

  Integrate BigCommerce with standard components and data source configuration wizards in RapidMiner Studio.

• Replicate Sybase IQ to Multiple Databases via the CData Sync CLI

  Replicate Sybase IQ to disparate databases with a single configuration.

• How to publish and share AlloyDB dashboards with Tableau Server

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

• Access Sage Cloud Accounting as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sage Business Cloud Accounting from your Oracle system.

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

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

• How to connect to Couchbase from Spring Boot

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

• Build Charts with Twitter in Clear Analytics

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

• Analyze DocuSign in R via JDBC

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

• How to Connect to SAP Ariba Source in Using Python: 6 Steps

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

• Design BIRT Reports on IBM Informix

  Provide current IBM Informix to your embedded analytics.

• Operational Reporting on Sage 200 from Spotfire Server

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

• Query, Visualize, and Share live Smaregi in Redash

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

• Connect to and Visualize Live Zoho Inventory in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Zoho Inventory.

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

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

• Connect to RSS Feeds in Google Apps Script via SQL Gateway

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

• Import Real-Time BambooHR via JDBC in ColdFusion to Build Applications

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

• Natively Connect to eBay Analytics in PHP

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

• Build ServiceNow-Connected Visualizations in datapine

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

• Enable the PostgreSQL JDBC Driver in KNIME

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

• Create Oracle Eloqua-Connected Business Apps in AppSheet

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

• Connect to Sugar CRM in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for Sugar CRM and connect to Sugar CRM in Akorbi Digital RunMyProcess.

• Connect to IBM Cloud Data Engine in the Denodo Platform

  Use CData driver technologies to create a virtual data source for IBM Cloud Data Engine in the Denodo Virtual DataPort Administrator.

• Connect to Google Directory in JRuby

  Create a simple JRuby app with access to live Google Directory.

• Connect to Oracle HCM Cloud in HULFT Integrate

  Connect to Oracle HCM Cloud as a JDBC data source in HULFT Integrate

• Access SharePoint Excel Services in PHP through Connect Server

  Connect to SharePoint Excel Services through the standard SQL Server libraries in PHP.

• Create Apps from Snapchat Ads in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Snapchat Ads and build apps from live Snapchat Ads in Qlik Sense Cloud.

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

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

• How to Work with eBay Analytics in ETL Validator JDBC

  Connect to eBay Analytics from ETL Validator jobs using the CData Software JDBC Driver.

• Import Real-Time BigCommerce via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use BigCommerce in ColdFusion.

• Connect and Visualize Live AlloyDB Data in Databricks Lakehouse Federation with CData Connect Cloud

  Use CData Connect Cloud to integrate live Google AlloyDB into the Databricks platform and create visualization dashboards with real-time Google AlloyDB.

• Automated Continuous Square Replication to IBM DB2

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

• ETL Microsoft Planner in Oracle Data Integrator

  This article shows how to transfer Microsoft Planner into a data warehouse using Oracle Data Integrator.

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

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

• Build Data Flows from MYOB AccountRight to SQL Server using SSIS

  Easily back up MYOB AccountRight to SQL Server using the SSIS components for MYOB AccountRight.

• Replicate Drift to Multiple Databases

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

• Query Todoist as a MySQL Database in Node.js

  Execute MySQL queries against Todoist from Node.js.

• Build Data Flows from Shopify to SQL Server using SSIS

  Easily back up Shopify to SQL Server using the SSIS components for Shopify.

• Add Highrise to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Highrise with the Informatica Enterprise Data Catalog to classify and organize data.

• Create SSAS Tabular Models from GraphQL

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

• Automated Kafka Replication to Teradata

  Use CData Sync to Customize and automate Apache Kafka replication to Teradata.

• Create RSS-Connected Nintex Workflows

  Use CData Software Connect Server to connect to RSS from Nintex Workflow Cloud and build custom workflows using live RSS Feeds.

• Visualize Zoho Books in TIBCO Spotfire through OData

  Integrate Zoho Books into dashboards in TIBCO Spotfire.

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

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

• Automate SAP Ariba Source Replication to Couchbase

  Use CData Sync to Customize and automate SAP Ariba Source replication to Couchbase.

• Query Sybase as a SQL Server in Node.js

  Execute SQL Server queries against Sybase from Node.js.

• Build Spark-Connected Apps in Bubble

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

• How to import Printful into Apache Solr

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

• DataBind Charts to SingleStore

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

• Todoist Reporting and Star Schemas in OBIEE

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

• Automated Continuous Odoo Replication to AlloyDB

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

• Build MVC Applications with Connectivity to Oracle HCM Cloud

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

• Create MySQL-Connected Nintex Workflows

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

• Build OData Visualizations in Tableau Cloud

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

• How to connect to Sybase in DBVisualizer

  Integrate Sybase with visual data analysis tools and data connection wizards in DBVisualizer

• Publish Twilio-Connected Dashboards in Tableau Server via JDBC

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

• Explore Geographical Relationships in QuickBooks Time with Power Map

  Create data visualizations with QuickBooks Time in Power Map.

• Build Workday-Connected Apps in Bubble

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

• Connect to IBM Informix as an External Source in Dremio

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

• Create Dashboards and Visualize Live Act-On in Geckoboard

  Use CData Connect Cloud to connect to live Act-On and create dashboards for real-time monitoring and visualization in Geckoboard.

• Access Live Azure Table in Excel 365 Online (Excel for the web)

  Connect to Azure Table Storage from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• Integrate with SQL Server in JReport Designer

  Create charts and reports based on Microsoft SQL Server in JReport Designer.

• Access Azure Analysis Services 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 Azure Analysis Services.

• Automate HarperDB Integration Tasks from PowerShell

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

• Automated Continuous GitHub Replication to Azure SQL

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

• Connect to Salesforce Marketing from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Salesforce Marketing to connect to Salesforce Marketing Cloud and execute queries in PowerBuilder.

• Use the CData Software ODBC Driver for Salesforce in MicroStrategy

  Connect to Salesforce & Force.com in MicroStrategy Developer using the CData Software ODBC Driver for Salesforce.

• How to pipe HBase to CSV in PowerShell

  Use standard PowerShell cmdlets to access HBase tables.

• Connect to Act-On from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Act-On from Filemaker Pro on Mac.

• Analyze Reckon Accounts Hosted in Cognos Analytics

  Use CData Connect Cloud to connect to Reckon Accounts Hosted from Cognos Analytics and analyze live Reckon Accounts Hosted.

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

• Automated Continuous SharePoint Excel Services Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to PostgreSQL.

• Connect to Reckon Accounts Hosted from Asprova with CData Software ODBC Driver for Reckon Accounts Hosted

  This article shows how to connect faster to Reckon Accounts Hosted data from Asprova.

• Connect to Google Analytics in Jaspersoft Studio

  Execute SQL to remote Google Analytics in Jaspersoft Studio.

• How to Visualize Amazon Athena Data in Python with pandas

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

• Build MVC Applications with Connectivity to BigCommerce

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

• «
• 188
• 189
• 190
• 191
• 192
• 193
• 194
• 195
• 196
• 197
• »