CData Software - Knowledge Base

Recent Articles

• «
• 119
• 120
• 121
• 122
• 123
• 124
• 125
• 126
• 127
• 128
• »

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

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

• Use the CData Software ODBC Driver for WordPress in MicroStrategy

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

• Connect to Jira Service Management from HeidiSQL

  Use CData Connect Cloud to connect to and query live Atlassian Jira Service Management from HeidiSQL.

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

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

• How to import Calendly into Apache Solr

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

• Replicate Slack from PowerShell

  Write a quick PowerShell script to query Slack. Use connectivity to the live data to replicate Slack to SQL Server.

• Use the CData Software ODBC Driver for Google Campaign Manager 360 in MicroStrategy Desktop

  Connect to Google Campaign Manager 360 in MicroStrategy Desktop using the CData Software ODBC Driver for Google Campaign Manager 360.

• Viewing Epicor Kinetic in RAD Studio Data Explorer

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

• Publish EventBrite-Connected Dashboards in Tableau Server

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

• How to publish and share Google Campaign Manager 360 dashboards with Tableau Server

  The CData ODBC driver for Google Campaign Manager 360 enables you integrate Google Campaign Manager 360 into Tableau dashboards.

• Connect to Dynamics 365 Business Central from AWS Glue

  Use CData Connect Cloud to gain access to live Dynamics 365 Business Central from your AWS Glue jobs.

• Access Live Google Analytics in Excel (Desktop)

  Use CData Connect Cloud to gain access to live Google Analytics from your Excel spreadsheets.

• Replicate OneNote to Multiple Databases

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

• Connect to Sybase in Google Apps Script

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

• Impala Reporting in OBIEE with the Impala JDBC Driver

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

• How to integrate Aha with Apache Airflow

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

• Replicate PostgreSQL from PowerShell

  Write a quick PowerShell script to query PostgreSQL. Use connectivity to the live data to replicate PostgreSQL to SQL Server.

• Use the CData Software JDBC Driver for Bing Search in MicroStrategy Web

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

• LINQ to Invoiced

  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 Invoiced Data Provider.

• Automated Continuous AlloyDB Replication to SQL Server

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

• How to connect to Asana in DBVisualizer

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

• Choosing the Best Method to Connect MailChimp to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use MailChimp from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Edit and Search External Confluence Objects in Salesforce Connect

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

• Automate SAP Ariba Procurement Replication to Couchbase

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

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

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

• Connect to Quickbase as a Linked Server

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

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

  Use CData Software Connect Server to create a virtual SQL Server Database for Coinbase and integrate live Coinbase into apps built in Microsoft Power Apps.

• Build Charts with Salesforce Marketing in Clear Analytics

  Create dynamic charts and perform analytics based on Salesforce Marketing Cloud in Clear Analytics.

• Replicate Oracle Service Cloud to Multiple Databases

  Replicate Oracle Service Cloud to disparate databases with a point-and-click configuration.

• How to connect to Authorize.Net from IntelliJ

  Integrate connectivity to Authorize.Net with wizards in IntelliJ.

• Feed YouTube Analytics into FineReport

  How to set YouTube Analytics as a JDBC data source in FineReport.

• Automated Continuous Amazon S3 Replication to Local Delimited Files

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

• Natively Connect to Drip in PHP

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

• Access Live Sage Intacct in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for Sage Intacct to create a Sage Intacct source in TIBCO Data Virtualization Studio and gain access to live Sage Intacct from your TDV Server.

• How to use SQLAlchemy ORM to access Google Sheets in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Sheets.

• Build Dashboards with MarkLogic in DBxtra

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

• Work with Sage 50 UK in FoxPro

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

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

  Provide connectivity to Apache HBase through an SAP BusinessObjects universe.

• How to create an RPA flow for Salesforce in UiPath Studio

  Use the Salesforce ODBC Driver to create workflows that access real-time Salesforce & Force.com without any coding.

• DataBind Wijmo Grid to Azure Data Lake Storage

  Provide real-time Azure Data Lake Storage to interactive controls.

• Automated Continuous PayPal Replication to Google BigQuery

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

• Connect to Elasticsearch from Filemaker Pro (Mac)

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

• A PostgreSQL Interface for Jira Assets

  Use the Remoting features of the Jira Assets ODBC Driver to create a PostgreSQL entry-point for data access.

• How to Connect the Power BI Service to Okta: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• Connect to Paylocity in Aqua Data Studio

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

• Connect to Unbounce in DBeaver

  Use the CData ODBC Driver to connect to Unbounce in DBeaver.

• Access Live OneNote in Excel (Desktop)

  Use CData Connect Cloud to gain access to live Microsoft OneNote from your Excel spreadsheets.

• Access Live SharePoint in Coginiti Pro

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

• Visualize BambooHR in Tableau Desktop (through CData Connect)

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

• Replicate Presto for Use in Salesforce Connect

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

• A PostgreSQL Interface for EventBrite

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

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

• Use the CData Software ODBC Driver for MariaDB in MicroStrategy Desktop

  Connect to MariaDB in MicroStrategy Desktop using the CData Software ODBC Driver for MariaDB.

• Access Sage 50 UK 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 Sage 50 UK.

• How to Access Amazon Marketplace Using Entity Framework

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

• A PostgreSQL Interface for Sage Intacct

  Use the Remoting features of the Sage Intacct ODBC Driver to create a PostgreSQL entry-point for data access.

• Access Snapchat Ads from MySQL in Amazon QuickSight

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

• Integrate with JDBC-ODBC Bridge in JReport Designer

  Create charts and reports based on JDBC-ODBC Bridge in JReport Designer.

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

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

• Connect to Microsoft Dataverse from PowerBuilder

  This article demonstrates how to use the CData ODBC Driver for Microsoft Dataverse to connect to Microsoft Dataverse (CDS) and execute queries in PowerBuilder.

• Build Dashboards with AlloyDB in Dundas BI

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

• How to connect to Azure Synapse in DBVisualizer

  Integrate Azure Synapse with visual data analysis tools and data connection wizards in DBVisualizer

• Query Microsoft OneDrive as a MySQL Database in Node.js

  Execute MySQL queries against Microsoft OneDrive from Node.js.

• Model, Search, and Visualize Live QuickBooks Online in ThoughtSpot

  Use CData Connect Cloud to connect to live QuickBooks Online for modeling, searching, and visualizing.

• How to import Google Calendar into Apache Solr

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

• Connect to Exact Online in DBeaver

  Use the CData ODBC Driver to connect to Exact Online in DBeaver.

• Build Epicor Kinetic-Connected Visualizations in datapine

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

• A PostgreSQL Interface for Cloudant

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

• Connect to Raisers Edge NXT from PowerBuilder

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

• Use the Connect Server to Access LDAP Objects in Microsoft Power Pivot

  Use the Connect Server to connect to live LDAP in the Power Pivot business intelligence tool.

• Connect to MarkLogic in Google Apps Script

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

• How to pipe SFTP to CSV in PowerShell

  Use standard PowerShell cmdlets to access SFTP tables.

• Use the CData Software ODBC Driver for Avro in MicroStrategy

  Connect to Apache Avro in MicroStrategy Developer using the CData Software ODBC Driver for Avro.

• Slack Cloud Connectivity

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

• Connect to SuiteCRM in HULFT Integrate

  Connect to SuiteCRM as a JDBC data source in HULFT Integrate

• Replicate Typeform to Multiple Databases

  Replicate Typeform to disparate databases with a single configuration.

• Analyze JotForm in Infragistics Reveal

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

• Use the CData ODBC Driver for Outreach.io in SAS JMP

  You can use the CData ODBC Driver to integrate Outreach.io into the statistical analysis tools available in SAS JMP. This article shows how to use Outreach.io in the Graph Builder and Query Builder.

• Automated Continuous Acumatica Replication to Amazon Redshift

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

• Connect to SuiteCRM in Google Apps Script

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

• Visualize SAP ByDesign from Tableau

  Use the Tableau Desktop business intelligence tool to connect to SAP Business ByDesign.

• Create Dynamic Sage Cloud Accounting Grids Using the Infragistics XamDataGrid

  Learn how you can connect Sage Cloud Accounting to Infragistics XamDataGrid to build dynamic grids.

• Analyze Oracle Eloqua in R

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

• Create SSAS Tabular Models from Microsoft OneDrive

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

• Work with SAP Concur in FoxPro

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

• Stream NetSuite into Apache Kafka Topics

  Access and stream NetSuite CRM & ERP in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• How to Connect DBeaver to SAP Ariba Procurement via a JDBC Driver

  Manage SAP Ariba Procurement with visual tools in DBeaver like the query browser.

• Automated Continuous Bullhorn CRM Replication to Microsoft Access

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

• Connect to Asana in CloverDX (formerly CloverETL)

  Transfer Asana using the visual workflow in the CloverDX data integration tool.

• Connect to Bullhorn CRM in Ruby

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

• How to Connect to & Open Email in Microsoft Excel

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

• Integrate with Shopify in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Shopify in SnapLogic.

• Connect to and Query Microsoft Planner in QlikView over ODBC

  Create data visualizations with Microsoft Planner in QlikView.

• Create Datasets from SAP HANA in Domo Workbench and Build Visualizations of SAP HANA in Domo

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

• Automated Continuous SendGrid Replication to Amazon Redshift

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

• Create Facebook Ads-Connected Business Apps in AppSheet

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

• Connect to Live Sage Cloud Accounting in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Sage Cloud Accounting in CData Connect Cloud and connect to your Sage Business Cloud Accounting from PostgreSQL.

• Query Box as a MySQL Database in Node.js

  Execute MySQL queries against Box from Node.js.

• Integrate with Basecamp in JReport Designer

  Create charts and reports based on Basecamp in JReport Designer.

• Create Aha Dashboards in Bold BI

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

• «
• 119
• 120
• 121
• 122
• 123
• 124
• 125
• 126
• 127
• 128
• »