CData Software - Knowledge Base

Recent Articles

• «
• 70
• 71
• 72
• 73
• 74
• 75
• 76
• 77
• 78
• 79
• »

• ETL xBase in Oracle Data Integrator

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

• Sage Intacct Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Sage Intacct through CData Connect Cloud using different applications and tools.

• Build Dashboards with Dropbox in DBxtra

  Create dynamic dashboards and perform analytics based on Dropbox in DBxtra.

• Automated Continuous Reckon Replication to AlloyDB

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

• Automated Continuous ConstantContact Replication to SingleStore

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

• Bridge Zoho Books Connectivity with Apache NiFi

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

• Analyze Shippo in SAP Analytics Cloud

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

• Build Automated Workflows with Live Cloudant in Workato

  Use CData Connect Cloud to connect to live IBM Cloudant and build automated workflows in Workato.

• Access SingleStore from MySQL in PHP

  Connect to SingleStore through the standard MySQL libraries in PHP.

• Automated Continuous EventBrite Replication to SQL Server

  Use CData Sync for automated, continuous, customizable EventBrite replication to SQL Server.

• How to Query Sage 50 UK in MySQL Workbench

  Execute MySQL queries against live Sage 50 UK from MySQL Workbench.

• Stream Greenplum into Apache Kafka Topics

  Access and stream Pivotal GreenPlum in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• How to Import Google Calendar into SQL Server using SSIS

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

• Extract, Transform, and Load Workday in Informatica PowerCenter

  Create a simple Workflow for Workday in Informatica PowerCenter.

• How to Connect to Sage Cloud Accounting in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Sage Business Cloud Accounting. Leverage the pyodbc module for ODBC in Python.

• Create Bullhorn CRM-Connected Business Apps in AppSheet

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

• 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 Bullhorn CRM-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Bullhorn CRM from Zoho Analytics and import live Bullhorn CRM.

• Stream SAP HANA XS Advanced into Apache Kafka Topics

  Access and stream SAP HANA XS Advanced in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Automated Continuous Exact Online Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Exact Online replication to MongoDB.

• Connect to Box as a Linked Server

  Use CData Connect to set up a linked server for Box.

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

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

• Edit and Search External Zoho Projects Objects in Salesforce Connect

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

• Import ADP Using Azure Data Factory

  Use CData Connect Cloud to connect to ADP from Azure Data Factory and import live ADP.

• How to connect PolyBase to SAP Business One

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

• Manage SurveyMonkey in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for SurveyMonkey.

• Design BIRT Reports on Exact Online

  Provide current Exact Online to your embedded analytics.

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

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

• Build Cosmos DB-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for Cosmos DB and create custom apps in Mendix.

• Build Automated Workflows with Live HCL Domino in Workato

  Use CData Connect Cloud to connect to live HCL Domino and build automated workflows in Workato.

• Build Charts with QuickBooks in Clear Analytics

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

• LINQ to Shopify

  LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Shopify Data Provider.

• Automated Continuous EventBrite Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable EventBrite replication to Google BigQuery.

• Connect to Zoho CRM in SpagoBI

  Create reports featuring live Zoho CRM in SpagoBI Studio. Host Zoho CRM reports on SpagoBI Server.

• Analyze Live CockroachDB in SAS Viya

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

• Connect to Cassandra in HULFT Integrate

  Connect to Cassandra as a JDBC data source in HULFT Integrate

• Integrate IBM Cloud Data Engine in Your Informatica Cloud Instance

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

• Access Live Amazon Athena in Excel 365 Online (Excel for the web)

  Connect to Amazon Athena from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• Access Tally as a Remote Oracle Database

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

• Access Live Odoo in Google Sheets

  Use CData Connect Cloud to gain access to live Odoo ERP from your Google Sheets.

• Access Zoho Inventory as a Remote Oracle Database

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

• Create Shopify Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time Shopify data access from reports, embedded analytics, and more.

• Automated Continuous QuickBooks Online Replication to AlloyDB

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

• Query Google Drive through ODBC in Node.js

  Use node-odbc to execute SQL queries against Google Drive from Node.js.

• Import Zuora Using Azure Data Factory

  Use CData Connect Cloud to connect to Zuora from Azure Data Factory and import live Zuora.

• Viewing Google Contacts in RAD Studio Data Explorer

  How to view Google Contacts in RAD Studio Data Explorer using the CData ODBC Driver for Google Contacts.

• Query Box in DataGrip

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

• How to connect PolyBase to Couchbase

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

• Connect to Oracle from Filemaker Pro (Mac)

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

• Create Apps from Azure Analysis Services in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Azure Analysis Services and build apps from live Azure Analysis Services in Qlik Sense Cloud.

• Integrate with live Paylocity in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Paylocity in Jitterbit.

• Create Apps from Amazon Athena in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Amazon Athena and build apps from live Amazon Athena in Qlik Sense Cloud.

• Build an OLAP Cube in SSAS from Salesloft

  Establish a connection to Salesloft data from SQL Server Analysis Services, and use the Salesloft Data Provider to build OLAP cubes for use in analytics and reporting.

• Create Datasets from Confluence in Domo Workbench and Build Visualizations of Confluence in Domo

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

• Connect to Box in HULFT Integrate

  Connect to Box as a JDBC data source in HULFT Integrate

• Query Spark through ODBC in Node.js

  Use node-odbc to execute SQL queries against Apache Spark SQL from Node.js.

• How to Visualize YouTube Analytics Data in Python with pandas

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

• Build Authorize.Net Visualizations in Tableau Cloud

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

• Integrate Live Power BI XMLA into Custom Business Apps Built in Power Apps

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

• DataBind Controls to Power BI XMLA in Delphi

  DataBind to Power BI XMLA in Delphi with standard data access components and controls.

• Design BIRT Reports on Greenplum

  Provide current Pivotal GreenPlum to your embedded analytics.

• How to Access Live Microsoft Planner in Power Automate Desktop via ODBC

  The CData ODBC Driver for Microsoft Planner enables you to integrate Microsoft Planner into workflows built using Microsoft Power Automate Desktop.

• How to Access Pipedrive Using Entity Framework

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

• Analyze HubSpot in Looker

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

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

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

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

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

• Use CData Connect Cloud to Access Instagram in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Instagram in the Power Pivot business intelligence tool.

• Automate WooCommerce Replication to Couchbase

  Use CData Sync to Customize and automate WooCommerce replication to Couchbase.

• Integrate Real-Time Access to DocuSign in SAPUI5 MVC Apps

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

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

  Use CData Power BI Connectors to visualize CockroachDB in Power BI.

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

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

• Connect to MYOB AccountRight in Ruby

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

• How to Query EventBrite in MySQL Workbench

  Execute MySQL queries against live Eventbrite from MySQL Workbench.

• Connect to Airtable in RunMyProcess through Connect Cloud

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

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

  Provide connectivity to Drift through an SAP BusinessObjects universe.

• Visualize Live HarperDB in the Power BI Service

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

• Build CockroachDB Visualizations in Tableau Cloud

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

• Automated Continuous eBay Analytics Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable eBay Analytics replication to Microsoft Access.

• Query Xero in MySQL Workbench

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

• Extract, Transform, and Load SAP HANA XS Advanced in Informatica PowerCenter

  Create a simple Workflow for SAP HANA XS Advanced in Informatica PowerCenter.

• How to Use a Microsoft Access Database to Update Cvent in Real Time

  Update Cvent data by creating a linked table in Microsoft Access with the CData Cvent ODBC Driver.

• Connect to Live Twitter in MicroStrategy through CData Connect Cloud

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

• How to Connect to SQL Server in Using Python: 6 Steps

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

• Automated Continuous Outreach.io Replication to Vertica

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

• Publish Crystal Reports on Bing Ads

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Bing Ads.

• Analyze ADP in R

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

• Build Facebook-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Facebook from Zoho Analytics and import live Facebook.

• Query Tally through ODBC in Node.js

  Use node-odbc to execute SQL queries against Tally ERP from Node.js.

• Automated Continuous Coinbase Replication to IBM DB2

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

• Access MYOB AccountRight from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live MYOB AccountRight from HeidiSQL.

• Object-Relational Mapping (ORM) with Trello 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 Trello into a Java-based ORM framework, Hibernate.

• How to pipe QuickBooks Online to CSV in PowerShell

  Use standard PowerShell cmdlets to access QuickBooks Online tables.

• Create Excel Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time Excel data access from reports, embedded analytics, and more.

• Create Clio-Connected Nintex Workflows

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

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

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

• Automated Continuous Exact Online Replication to Azure SQL

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

• Automate LDAP Objects Replication to Azure Data Lake

  Use CData Sync to customize and automate LDAP replication to Azure Data Lake.

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

  Provide connectivity to ADP through an SAP BusinessObjects universe.

• How to connect to Raisers Edge NXT from IntelliJ

  Integrate connectivity to Raisers Edge NXT with wizards in IntelliJ.

• Connect to Teradata from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Teradata to connect to Teradata from Web applications running on WebLogic.

• «
• 70
• 71
• 72
• 73
• 74
• 75
• 76
• 77
• 78
• 79
• »