CData Software - Knowledge Base

Recent Articles

• «
• 124
• 125
• 126
• 127
• 128
• 129
• 130
• 131
• 132
• 133
• »

• How to Access Live DocuSign in Power Automate Desktop via ODBC

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

• Create Data Visualizations in Cognos BI with Google Search Results

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

• Create SSAS Tabular Models from QuickBooks Online

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

• Natively Connect to Google Ad Manager in PHP

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

• Publish MailChimp-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live MailChimp.

• Analyze Adobe Analytics in R via ODBC

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

• Automate Zoho Projects Replication to Couchbase

  Use CData Sync to Customize and automate Zoho Projects replication to Couchbase.

• Connect to IBM Cloud Object Storage as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for IBM Cloud Object Storage.

• Visualize SAP Hybris C4C in Tableau

  The CData ODBC driver for SAP Hybris C4C enables you integrate SAP Hybris C4C into Tableau dashboards.

• Integrate BambooHR in Pentaho Data Integration

  Build ETL pipelines based on BambooHR in the Pentaho Data Integration tool.

• Connect to Klaviyo in Google Apps Script via SQL Gateway

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

• Manage Oracle Eloqua in DBArtisan as a JDBC Source

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

• How to work with Quickbase in Apache Spark using SQL

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

• Create Azure Synapse Reports on JasperReports Server

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

• Connect to SAS Data Sets as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for SAS Data Sets.

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

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

• Model Azure Data Lake Storage Using Azure Analysis Services

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

• DataBind Controls to Sage 300 in C++Builder

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

• Edit and Search External Pinterest Objects in Salesforce Connect

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

• DataBind Wijmo Grid to REST

  Provide real-time REST to interactive controls.

• Connect to Google Search Results in NetBeans

  Connect to Google Search in NetBeans with the data source configuration wizard.

• Automated Continuous Oracle Financials Cloud Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Oracle Financials Cloud replication to IBM DB2.

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

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

• Replicate Multiple QuickBooks Accounts via the CData Sync CLI

  Replicate multiple QuickBooks accounts to one or many databases.

• Connect to and Visualize Live Dynamics CRM in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Dynamics CRM.

• Connect to Dynamics CRM as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Microsoft Dynamics CRM.

• Publish Reports with Sage 200 in SAP Crystal Reports

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

• Load Sybase to a Database Using Embulk

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

• Build Cloudant-Connected ETL Processes in Google Data Fusion

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

• Visualize Live BambooHR in the Power BI Service

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

• Build Dashboards with ShipStation in Dundas BI

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

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

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

• Operational Reporting on Google Analytics from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Google Analytics.

• DataBind Controls to Epicor Kinetic in Delphi

  DataBind to Epicor Kinetic in Delphi with standard data access components and controls.

• Connect to HubSpot from a Connection Pool in Jetty

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

• Integrate with Airtable in JReport Designer

  Create charts and reports based on Airtable in JReport Designer.

• Query HCL Domino in ColdFusion

  Write standard ColdFusion data access code to connect to HCL Domino.

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

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

• Build Automated Workflows with Live Azure Data Lake Storage in Workato

  Use CData Connect Cloud to connect to live Azure Data Lake Storage and build automated workflows in Workato.

• Connect to Exact Online from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Exact Online using standard SQL.

• Viewing eBay in RAD Studio Data Explorer

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

• Replicate eBay Analytics to Multiple Databases via the CData Sync CLI

  Replicate eBay Analytics to disparate databases with a single configuration.

• Automated Continuous SAP Replication to MySQL

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

• Visualize Marketo in TIBCO Spotfire through ADO.NET

  Integrate Marketo into dashboards in TIBCO Spotfire.

• Create Dashboards and Visualize Live SurveyMonkey in Geckoboard

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

• Automated Continuous Calendly Replication to MySQL

  Use CData Sync for automated, continuous, customizable Calendly replication to MySQL.

• Use the CData Software ODBC Driver for Dynamics CRM in MicroStrategy Desktop

  Connect to Microsoft Dynamics CRM in MicroStrategy Desktop using the CData Software ODBC Driver for Dynamics CRM.

• Author and Share Power BI Reports on Real-Time Oracle Service Cloud

  Use the CData ODBC Driver for Oracle Service Cloud to visualize Oracle Service Cloud in Power BI Desktop and then upload to the Power BI service.

• Create LDAP Dashboards in Bold BI

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

• How to Query Printful in MySQL Workbench

  Execute MySQL queries against live Printful from MySQL Workbench.

• How to connect Amazon QuickSight to Zoho Creator

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

• Create Apps from Couchbase in Qlik Sense Cloud

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

• Process & Analyze Paylocity in Databricks (AWS)

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

• How to Connect to & Open Zenefits in Microsoft Excel

  This article uses the CData ODBC driver for Zenefits to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Analyze SQL Server in SAP Analytics Cloud

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

• Access Live Paylocity in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Paylocity from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

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

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

• Model Monday.com Using Azure Analysis Services

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

• How to Visualize DB2 Data in Python with pandas

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

• Create Reports with Jira Assets in SAP Crystal Reports

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

• Automate Calendly Replication to Azure Data Lake

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

• Create a Data Access Object for Monday.com using JDBI

  A brief overview of creating a SQL Object API for Monday.com in JDBI.

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

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

• Automated Continuous SendGrid Replication to MySQL

  Use CData Sync for automated, continuous, customizable SendGrid replication to MySQL.

• Bidirectional Access to QuickBooks Time from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate QuickBooks Time in Filemaker Pro for Mac or Windows.

• Visualize Cloudant in Tableau

  The CData ODBC driver for Cloudant enables you integrate IBM Cloudant into Tableau dashboards.

• Automated Continuous Trello Replication to Oracle

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

• Replicate Multiple IBM Cloud Object Storage Accounts via the CData Sync CLI

  Replicate multiple IBM Cloud Object Storage accounts to one or many databases.

• How to Access Google Data Catalog Using Entity Framework

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

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

  Connect to Pivotal GreenPlum in MicroStrategy Web using the CData Software JDBC Driver for Greenplum.

• Connect to TigerGraph as a Linked Server via SQL Gateway

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

• Build Zoho Inventory-Connected Apps in Bubble

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

• PowerShell Scripting to Replicate Shopify to MySQL

  Write a simple PowerShell script to replicate Shopify to a MySQL database.

• Build Data Flows from Todoist to SQL Server using SSIS

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

• Access Teradata from MySQL in Amazon QuickSight

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

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

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

• Provide OData Services of Reckon Accounts Hosted from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Reckon Accounts Hosted by developing a WCF Service Application.

• Visualize Live Snapchat Ads of Power BI Report Builder in Power BI Service

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

• How to Use CData Connect to Access Live EventBrite in Power Automate

  CData Connect for EventBrite enables you to integrate Eventbrite into workflows built using Microsoft Power Automate Desktop.

• How to pipe Jira Assets to CSV in PowerShell

  Use standard PowerShell cmdlets to access Jira Assets tables.

• Connect to xBase in JRuby

  Create a simple JRuby app with access to live xBase.

• Import and Visualize Todoist in Power View

  Create data visualizations based on Todoist in Excel.

• Stream TaxJar into Apache Kafka Topics

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

• How to work with Sage 50 UK in Apache Spark using SQL

  Access and process Sage 50 UK in Apache Spark using the CData Software JDBC Driver.

• Connect to HBase as a Linked Server via CData Connect

  Use CData Connect to set up a linked server for Apache HBase.

• Automated Continuous SAP Hybris C4C Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Microsoft Access.

• Build Oracle Sales-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Oracle Sales from Choreo and build custom apps using live Oracle Sales.

• Automated Continuous Twilio Replication to Oracle

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

• A PostgreSQL Interface for eBay (MySQL Remoting via JDBC)

  Use the Remoting features of the eBay JDBC Driver to create a PostgreSQL entry-point for data access.

• Automated Continuous Reckon Accounts Hosted Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to OneLake in Microsoft Fabric.

• How to import Microsoft OneDrive into Apache Solr

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

• How to connect Amazon QuickSight to Odoo

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

• Connect to Okta from PowerBuilder via ODBC

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

• Automate Acumatica Replication to SAP HANA

  Use CData Sync to customize and automate Acumatica ERP replication to SAP HANA.

• Import Oracle Financials Cloud into FileMaker Pro

  Create reports that integrate Oracle Financials Cloud in Filemaker Pro.

• Analyze Salesforce Pardot in Looker

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

• Import and Visualize Oracle Service Cloud in Power View

  Create data visualizations based on Oracle Service Cloud in Excel.

• Connect to Printful in DBArtisan

  Use wizards in DBArtisan to configure Printful as a data source.

• Build an OLAP Cube in SSAS from Invoiced

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

• Analyze Live Reckon Accounts Hosted in SAS Viya

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

• «
• 124
• 125
• 126
• 127
• 128
• 129
• 130
• 131
• 132
• 133
• »