CData Software - Knowledge Base

Recent Articles

• «
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• »

• Query Trello as a SQL Server Database in Node.js

  Execute SQL Server queries against Trello from Node.js.

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

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

• Create Data Visualizations in Cognos BI with NetSuite

  Access NetSuite CRM & ERP as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Connect to DB2 in SpagoBI

  Create reports featuring live IBM DB2 in SpagoBI Studio. Host DB2 reports on SpagoBI Server.

• Query, Visualize, and Share live Square in Redash

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

• Connect to Twitter Ads in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Twitter Ads in Airbyte.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Visualize Harvest in Tableau Desktop (through CData Connect)

  Create a virtual SQL Server database for Harvest in CData Software Connect (or Connect Server) and build visualizations from live Harvest in Tableau Desktop.

• How to Work with Certinia in ETL Validator JDBC

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

• Create Reports from Airtable in Looker Studio

  Use CData Connect Cloud to gain access to live Airtable and create custom reports in Looker Studio.

• Publish Reports with SAS xpt in SAP Crystal Reports

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

• Use the CData Software ODBC Driver for Veeva in MicroStrategy Web

  Connect to Veeva Vault in MicroStrategy Web using the CData Software ODBC Driver for Veeva.

• Import Coinbase into FileMaker Pro

  Create reports that integrate Coinbase in Filemaker Pro.

• How to connect Amazon QuickSight to Amazon DynamoDB

  Create a connection to Amazon DynamoDB in CData Connect Cloud and insert Amazon DynamoDB into Amazon QuickSight SPICE to build interactive dashboards.

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

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

• Automated Continuous Highrise Replication to Snowflake

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

• Process & Analyze DocuSign in Databricks (AWS)

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

• How to update Zoho Inventory from Excel

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

• Analyze Coinbase in Infragistics Reveal

  Use the CData Connect Server to create an OData API on top of Coinbase and visualize live Coinbase in Ingragistics Reveal.

• Analyze HBase with Power Pivot

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

• Build Dashboards with IBM Informix in Dundas BI

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

• How to Access Acumatica Using Entity Framework

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

• How to connect to IBM Cloud Object Storage in DBVisualizer

  Integrate IBM Cloud Object Storage with visual data analysis tools and data connection wizards in DBVisualizer

• Automated Continuous Dynamics GP Replication to Azure SQL

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

• Connect to Coinbase in Aqua Data Studio

  Access Coinbase from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Design BIRT Reports on Zoho CRM

  Provide current Zoho CRM to your embedded analytics.

• Analyze Microsoft Project with Power Pivot

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

• Automated Continuous Unbounce Replication to SingleStore

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

• Use the CData ODBC Driver for Dynamics CRM in Microsoft Power Query

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

• Access eBay 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 eBay.

• Visualize Odoo in TIBCO Spotfire through ODBC

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

• PowerShell Scripting to Replicate Google Spanner to MySQL

  Write a simple PowerShell script to replicate Google Spanner to a MySQL database.

• Query SingleStore in DataGrip

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

• Create Data Visualizations in Cognos BI with DB2

  Access IBM DB2 as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Build Exact Online-Connected Apps in Mendix

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

• Access EventBrite as a Remote Oracle Database

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

• Build CSV-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live CSV/TSV Files.

• Access Cloudant as a Remote Oracle Database

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

• Back Up Invoiced to SQL Server through SSIS

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

• Establish a Live Connection with Basecamp using Tableau Bridge

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

• Import and Visualize Acumatica in Power View

  Create data visualizations based on Acumatica ERP in Excel.

• PowerShell Cmdlets Getting Started Guide

  A basic guide to using the CData PowerShell Cmdlets for Salesforce to access Salesforce data from within PowerShell.

• How to connect to Act-On from Spring Boot

  Connect to Act-On in a Spring Boot Application using CData JDBC Act-On Driver

• Automated Continuous Printify Replication to Local Delimited Files

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

• DataBind Gmail to the DevExpress Data Grid

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

• How to Work with Google Ad Manager in AWS Glue Jobs Using JDBC

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

• Automated Continuous Amazon S3 Replication to AlloyDB

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

• Integrate SQL Analysis Services in the Pentaho Report Designer

  Publish reports based on SQL Analysis Services in the Pentaho BI tool.

• Connect to MongoDB in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for MongoDB in Airbyte.

• Visualize Live Azure Synapse in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live Azure Synapse into custom reports in Power BI.

• Integrate Live Hive into Custom Business Apps Built in Power Apps

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

• How to work with Oracle Eloqua in Apache Spark using SQL

  Access and process Oracle Eloqua in Apache Spark using the CData Software JDBC Driver.

• Access Live Databricks in Coginiti Pro

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

• Connect to ADP as a Linked Server

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

• Query NetSuite as a SQL Server Database in Node.js

  Execute SQL Server queries against NetSuite CRM & ERP from Node.js.

• Publish Crystal Reports on Reckon

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

• Integrate Klaviyo in the Pentaho Report Designer

  Publish reports based on Klaviyo in the Pentaho BI tool.

• Using CData ODBC drivers from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC drivers to connect to an external data source from Excel spreadsheets in SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards in their Excel spreadsheets using data from sources like Salesforce, QuickBooks, Dynamics CRM and many more.

• Integrate with Databricks in JReport Designer

  Create charts and reports based on Databricks in JReport Designer.

• Visualize Amazon S3 in TIBCO Spotfire through ADO.NET

  Integrate Amazon S3 into dashboards in TIBCO Spotfire.

• Connect to WooCommerce from a Connection Pool in JBoss

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

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

  Provide connectivity to Amazon DynamoDB through an SAP BusinessObjects universe.

• Automated Continuous CouchDB Replication to Vertica

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

• Automated Continuous Hive Replication to Snowflake

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

• How to integrate Email with Apache Airflow

  Access and process Email in Apache Airflow using the CData JDBC Driver.

• Manage Email in DBArtisan as a JDBC Source

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

• How to Work with Salesforce Pardot in AWS Glue Jobs Using JDBC

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

• Access eBay Analytics as a Remote Oracle Database

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

• Automated Continuous Stripe Replication to Google Cloud SQL

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

• Integrate Amazon DynamoDB in Your Informatica Cloud Instance

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

• Replicate SuiteCRM for Use in Salesforce Connect

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

• Automated Continuous IBM Cloud Object Storage Replication to Snowflake

  Use CData Sync for automated, continuous, customizable IBM Cloud Object Storage replication to Snowflake.

• Integrate with live Active Directory in Jitterbit

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

• Integrate Square into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Square and integrate live Square into your Power Automate tasks.

• Back Up LinkedIn Ads to SQL Server through SSIS

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

• Use Biml to Build SSIS Tasks to Replicate Avalara AvaTax to SQL Server

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

• Create Presto Dashboards in Bold BI

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

• Use the CData Software ODBC Driver for Oracle Financials Cloud in MicroStrategy Web

  Connect to Oracle Financials Cloud in MicroStrategy Web using the CData Software ODBC Driver for Oracle Financials Cloud.

• FHIR Reporting in OBIEE with the FHIR JDBC Driver

  Deploy the FHIR JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Connect to Square from PowerBuilder

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

• Analyze SAS xpt in R

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

• DataBind Sybase IQ to the DevExpress Data Grid

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

• Connect to Stripe in Google Apps Script

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

• Create Reports with ServiceNow in SAP Crystal Reports

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

• Query ShipStation as a SQL Server Database in Node.js

  Execute SQL Server queries against ShipStation from Node.js.

• Feed Zoho Books into FineReport

  How to set Zoho Books as a JDBC data source in FineReport.

• Create a Data Access Object for Kafka using JDBI

  A brief overview of creating a SQL Object API for Apache Kafka in JDBI.

• Use the CData Software ODBC Driver for Salesloft in MicroStrategy Web

  Connect to Salesloft in MicroStrategy Web using the CData Software ODBC Driver for Salesloft.

• How to Build an ETL App for Jira Service Management in Python with CData

  Create ETL applications and real-time data pipelines for Atlassian Jira Service Management in Python with petl.

• How to Access OData Services Using Entity Framework

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

• Visualize HBase from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Apache HBase.

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

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

• Connect to Snowflake in as an External Source in Dremio

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

• How to pipe Elasticsearch to CSV in PowerShell

  Use standard PowerShell cmdlets to access Elasticsearch tables.

• Automated Continuous Stripe Replication to Microsoft Access

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

• Create YouTube Analytics Dataflows on PowerBI.com

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

• Work with Typeform in FoxPro

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

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

• Edit and Search External PostgreSQL Objects in Salesforce Connect

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

• Connect to Outreach.io in NetBeans

  Connect to Outreach.io in NetBeans with the data source configuration wizard.

• «
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• »