CData Software - Knowledge Base

Recent Articles

• «
• 439
• 440
• 441
• 442
• 443
• 444
• 445
• 446
• 447
• 448
• »

• Connect to Zoho Creator as an External Source in Dremio

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

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

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

• Connect to Avro from PowerBuilder via JDBC

  This article demonstrates how to access Apache Avro from PowerBuilder using the Avro JDBC Driver.

• Create Data Visualizations in Cognos BI with Printful

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

• Connect to Twitter in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• A PostgreSQL Interface for Jira Assets using the CData ODBC Driver

  Use the SQL Gateway and Jira Assets ODBC Driver to create a PostgreSQL entry-point for data access.

• How to Connect DBeaver to QuickBooks via a JDBC Driver

  Manage QuickBooks Desktop with visual tools in DBeaver like the query browser.

• How to connect to DB2 in DBVisualizer

  Integrate IBM DB2 with visual data analysis tools and data connection wizards in DBVisualizer

• Visualize Access from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Microsoft Access.

• Create SAP HANA Reports on JasperReports Server

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

• How to connect PolyBase to Oracle Financials Cloud

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

• Automated Continuous Redis Replication to Microsoft Access

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

• Query Greenplum in ColdFusion

  Write standard ColdFusion data access code to connect to Pivotal GreenPlum.

• Consume Google Campaign Manager 360 OData Feeds in PowerBuilder

  This article demonstrates how to consume Google Campaign Manager 360 as OData feeds from PowerBuilder using the API Server.

• Connect to Redshift in NetBeans

  Connect to Amazon Redshift in NetBeans with the data source configuration wizard.

• Integrate Sybase in the Pentaho Report Designer

  Publish reports based on Sybase in the Pentaho BI tool.

• Publish Reports with Calendly in SAP Crystal Reports

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

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

  Use CData JDBC drivers to import and use Apache Phoenix in ColdFusion.

• Visualize Twitter in TIBCO Spotfire through ADO.NET

  Integrate Twitter into dashboards in TIBCO Spotfire.

• How to pipe JotForm to CSV in PowerShell

  Use standard PowerShell cmdlets to access JotForm tables.

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

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

• ETL WordPress in Oracle Data Integrator

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

• How to Work with Zoho Creator in ETL Validator JDBC

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

• Connect to and Visualize Live Azure Data Catalog in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Azure Data Catalog.

• Use the CData Software JDBC Driver for Google Ads in MicroStrategy

  Connect to Google Ads in MicroStrategy Developer using the CData Software JDBC Driver for Google Ads.

• Connect HCL Domino to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your HCL Domino using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Build Automated Workflows with Live Oracle SCM in Workato

  Use CData Connect Cloud to connect to live Oracle SCM and build automated workflows in Workato.

• Natively Connect to Power BI XMLA in PHP

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

• Visualize JotForm in TIBCO Spotfire through ODBC

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

• A PostgreSQL Interface for AlloyDB using the CData ODBC Driver

  Use the SQL Gateway and AlloyDB ODBC Driver to create a PostgreSQL entry-point for data access.

• How to create SQL Server federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft SQL Server in MySQL .

• Visualize Live Sage 50 UK of Power BI Report Builder in Power BI Service

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

• How to connect to Exact Online from Spring Boot

  Connect to Exact Online in a Spring Boot Application using CData JDBC Exact Online Driver

• Analyze ActiveCampaign in R via JDBC

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

• Consume Instagram OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on Instagram feeds that reflect any changes in SAP Lumira.

• Connect to OneNote from PowerBuilder via ODBC

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

• Connect to and Query ActiveCampaign in QlikView over ODBC

  Create data visualizations with ActiveCampaign in QlikView.

• Automated Continuous SAP Concur Replication to Google Cloud SQL

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

• Analyze CSV in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of CSV/TSV Files and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

• How to Connect to & Open Gmail in Microsoft Excel

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

• Integrate TaxJar with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate TaxJar with External Services.

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

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

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

• Automated Continuous Spark Replication to Vertica

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

• How to create Monday.com federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Monday.com in MySQL .

• Automate Zoom Replication to Couchbase

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

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

• Using the CData Software ODBC Driver for eBay Analytics in PyCharm

  Connect to eBay Analytics as an ODBC data source in PyCharm using the CData Software ODBC Driver for eBay Analytics.

• Establish a Live Connection with Sage 200 using Tableau Bridge

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

• Zoho CRM Cloud Connectivity

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

• Using the CData Software ODBC Driver for ServiceNow in PyCharm

  Connect to ServiceNow as an ODBC data source in PyCharm using the CData Software ODBC Driver for ServiceNow.

• Query Zoom in DataGrip

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

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

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

• Query Twitter from Node.js

  Use the OData endpoint of the CData API Server to connect to your Twitter and perform CRUD operations on Twitter from Node.js.

• Connect to MailChimp as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live MailChimp.

• Prepare, Blend, and Analyze Square in Alteryx Designer (ODBC)

  Build workflows to access live Square for self-service data analytics.

• ETL Google Contacts in Oracle Data Integrator

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

• Access Live Elasticsearch in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Elasticsearch from your Excel spreadsheets.

• DataBind Controls to Gmail in Delphi

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

• Build SAP HANA Visualizations in Tableau Cloud

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

• Create Data Visualizations Based On Microsoft Exchange in Mode

  Use CData Connect Cloud to connect to Microsoft Exchange from Mode and build visualizations using live

• How to publish and share Oracle Eloqua dashboards with Tableau Server

  The CData ODBC driver for Oracle Eloqua enables you integrate Oracle Eloqua into Tableau dashboards.

• Import Office 365 into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Office 365 and provide access to live Microsoft Office 365 for custom reports in the Power BI Service.

• How to Query Dropbox in MySQL Workbench

  Execute MySQL queries against live Dropbox from MySQL Workbench.

• Access Live Drip in AWS Lambda

  Connect to live Drip in AWS Lambda using the CData JDBC Driver.

• Build an OLAP Cube in SSAS from SFTP

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

• How to create Active Directory federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Active Directory in MySQL .

• Automated Continuous Epicor Kinetic Replication to Amazon Redshift

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

• Migrating data from eBay Analytics to Databricks using CData SSIS Components.

  Easily push eBay Analytics to Databricks using the CData SSIS Tasks for eBay Analytics and Databricks.

• Access Live Sage 300 Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live Sage 300 data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• Build Charts with HDFS in Clear Analytics

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

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

  Provide connectivity to Klipfolio through an SAP BusinessObjects universe.

• Operational Reporting on Elasticsearch from Spotfire Server

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

• Visualize Live Microsoft Dataverse of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Microsoft Dataverse (CDS) using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Build Amazon Marketplace-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Amazon Marketplace from Choreo and build custom apps using live Amazon Marketplace.

• Enable the ADP JDBC Driver in KNIME

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

• Analyze SAP ByDesign in Looker

  Use CData Connect Cloud to connect to SAP ByDesign from Looker and build custom apps using live SAP Business ByDesign.

• Connect to Google Sheets in Ruby

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

• Integrate NetSuite into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to NetSuite CRM & ERP and integrate live NetSuite CRM & ERP into your Power Automate tasks.

• Back Up Elasticsearch to SQL Server through SSIS

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

• Establish a Live Connection with SurveyMonkey using Tableau Bridge

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

• Build a PostgreSQL Interface for Google Directory using the CData JDBC Driver

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

• How to Design SQL Server Power Apps with Database-Like Connectivity

  This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.

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

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

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed SAP ERP/NetWeaver to Power BI dashboards. Simply drag and drop SAP ERP/NetWeaver into data visuals on the Power BI canvas.

• Build LinkedIn Ads Visualizations in Tableau Cloud

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

• DataBind Salesforce Data Cloud to the DevExpress Data Grid

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

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

  Provide connectivity to Microsoft SharePoint through an SAP BusinessObjects universe.

• Configure the CData JDBC Driver for Cosmos DB in a Connection Pool in Tomcat

  Connect to Azure Cosmos DB from a connection pool in Tomcat.

• Connect to SAP HANA in DBeaver

  Use the CData ODBC Driver to connect to SAP HANA in DBeaver.

• Automated Continuous Quickbase Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Quickbase replication to Apache Cassandra.

• Publish Crystal Reports on SharePoint Excel Services

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

• Faster Reporting using the QuickBooks Provider

  The CData ADO.NET Provider for QuickBooks features advanced caching capabilities. The Auto Cache feature of the Data Provider can be used to execute expensive queries against a local, automatically updated cache.

• Pinterest Reporting in OBIEE with the Pinterest JDBC Driver

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

• DataBind Controls to Redis in Delphi

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

• Create Datasets from Microsoft Exchange in Domo Workbench and Build Visualizations of Microsoft Exchange in Domo

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

• Use JayDeBeApi to access EventBrite in Python

  Use standard Python scripting and the development environment of your choice to access live Eventbrite.

• Replicate EnterpriseDB to Multiple Databases

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

• DataBind Charts to SharePoint

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

• Build Couchbase-Connected Apps in Choreo

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

• «
• 439
• 440
• 441
• 442
• 443
• 444
• 445
• 446
• 447
• 448
• »