CData Software - Knowledge Base

Recent Articles

• «
• 205
• 206
• 207
• 208
• 209
• 210
• 211
• 212
• 213
• 214
• »

• Create Data Visualizations in Cognos BI with Salesforce Pardot

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

• Build Automated Workflows with Live MySQL in Workato

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

• Create Informatica Mappings From/To an ODBC Data Source for HubDB

  Create an ODBC connection to HubDB in Informatica and browse and transfer HubDB.

• Access Access in PHP through Connect Server

  Connect to Access through the standard SQL Server libraries in PHP.

• Prepare, Blend, and Analyze Amazon DynamoDB in Alteryx Designer

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

• Automated Continuous Confluence Replication to Azure SQL

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

• Replicate Multiple Kafka Accounts

  Replicate multiple Kafka accounts to one or many databases.

• Import and Visualize Klaviyo in Power View

  Create data visualizations based on Klaviyo in Excel.

• Connect to Microsoft Dataverse in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Query SAP ByDesign in MySQL Workbench

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

• Create Apps from WordPress in Qlik Sense Cloud

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

• Automated Continuous Power BI XMLA Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Google Cloud SQL.

• Connect to Tally in Aqua Data Studio

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

• Analyze Azure Data Lake Storage in R

  Use standard R functions and the development environment of your choice to analyze Azure Data Lake Storage with the CData JDBC Driver for Azure Data Lake Storage.

• Feed Box into FineReport

  How to set Box as a JDBC data source in FineReport.

• Connect to HBase in SpagoBI

  Create reports featuring live Apache HBase in SpagoBI Studio. Host HBase reports on SpagoBI Server.

• Use the CData ODBC Driver for Parquet from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Parquet to connect to Apache Parquet from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apache Parquet in Excel.

• ETL Hive in Oracle Data Integrator

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

• A PostgreSQL Interface for Active Directory

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

• Connect to Klaviyo as a Linked Server

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

• Using AngularJS to Build Dynamic Web Pages with Coinbase

  Use the CData Connect Server to create Coinbase OData feeds and build single-page applications with live Coinbase.

• Use JayDeBeApi to access Monday.com in Python

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

• Use Dash to Build to Web Apps on Unbounce

  Create Python applications that use pandas and Dash to build Unbounce-connected web apps.

• Analyze Power BI XMLA in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Power BI XMLA and visualize Power BI XMLA in SAP Analytics Cloud.

• Connect to Couchbase in Google Apps Script

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

• Replicate SAP Concur for Use in Salesforce Connect

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

• Viewing Paylocity in RAD Studio Data Explorer

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

• Automated Continuous SurveyMonkey Replication to IBM DB2

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

• A PostgreSQL Interface for Basecamp

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

• How to integrate SharePoint Excel Services with Apache Airflow

  Access and process SharePoint Excel Services in Apache Airflow using the CData JDBC Driver.

• Use the CData ODBC Driver for SharePoint from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for SharePoint to connect to Microsoft SharePoint from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft SharePoint in Excel.

• Build Pipelines with Live Adobe Analytics in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Adobe Analytics from Google Cloud Data Fusion, enabling the integration of live Adobe Analytics into the building and management of effective data pipelines.

• Connect to Amazon DynamoDB from PowerBuilder

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

• Import Real-Time Zenefits in ColdFusion to Build Applications

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

• 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 Aha from PowerBuilder

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

• How to connect to Calendly in DBVisualizer

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

• Connect to Oracle in CloverDX (formerly CloverETL)

  Transfer Oracle Database using the visual workflow in the CloverDX data integration tool.

• How to Connect to & Open Excel Online in Microsoft Excel

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

• Replicate Freshdesk for Use in Salesforce Connect

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

• Operational Reporting on GitHub from Spotfire Server

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

• Video: API Server Setup

  An introduction to the use and features of the API Server - instant APIs for your databases.

• DataBind SurveyMonkey to the DevExpress Data Grid

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

• Build CouchDB-Connected ETL Processes in Google Data Fusion

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

• Automated Continuous MongoDB Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable MongoDB replication to Apache Kafka.

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

• How to update Cvent from Excel

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

• Create Reports from Oracle Financials Cloud in Looker Studio

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

• Query BambooHR as a SQL Server in Node.js

  Execute SQL Server queries against BambooHR from Node.js.

• Validate Microsoft Project with QuerySurge

  Access and validate Microsoft Project in QuerySurge using the CData JDBC Driver.

• Export Data from SQL Server to LinkedIn through SSIS

  Easily push SQL Server data to LinkedIn using the CData SSIS Tasks for LinkedIn.

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

  Use the FTP ODBC Driver to create workflows that access real-time FTP Servers without any coding.

• Feed Oracle Sales into FineReport

  How to set Oracle Sales as a JDBC data source in FineReport.

• Access LinkedIn from MySQL in HeidiSQL

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

• DataBind Dynamics GP to the DevExpress Data Grid

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

• Automate Phoenix Replication to SAP HANA

  Use CData Sync to customize and automate Apache Phoenix replication to SAP HANA.

• Automated Continuous DB2 Replication to Apache Cassandra

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

• Connect to Dynamics 365 in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Microsoft Dynamics 365 in the Denodo Virtual DataPort Administrator.

• Build Drip-Connected Dashboards in Redash

  Use CData Software Connect Server to create a virtual SQL Server Database for Drip and build visualizations and dashbaords from Drip in Redash.

• ETL Blackbaud FE NXT in Oracle Data Integrator

  This article shows how to transfer Blackbaud FE NXT into a data warehouse using Oracle Data Integrator.

• Build Dashboards with Avro in DBxtra

  Create dynamic dashboards and perform analytics based on Apache Avro in DBxtra.

• Deploy the ADO.NET Provider for Azure DevOps on an SSRS Report Server

  Connect to Azure DevOps from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Build Oracle-Connected Apps in Mendix

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

• Build Dashboards with Snowflake in DBxtra

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

• Automated Continuous Calendly Replication to Snowflake

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

• Use the CData Software JDBC Driver for Bitbucket in MicroStrategy Desktop

  Connect to Bitbucket in MicroStrategy Desktop using the CData Software JDBC Driver for Bitbucket.

• Edit and Search External Hive Objects in Salesforce Connect

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

• Automated Continuous Tableau CRM Analytics Replication to Local Delimited Files

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

• Connect to Cloudant in JRuby

  Create a simple JRuby app with access to live IBM Cloudant.

• Access Oracle Financials Cloud from MySQL in Amazon QuickSight

  Connect to Oracle Financials Cloud and build visualizations of Oracle Financials Cloud using a MySQL Connection in Amazon QuickSight.

• Connect to Access in Jaspersoft Studio

  Execute SQL to remote Microsoft Access in Jaspersoft Studio.

• Automate Google Ad Manager Replication to Azure Data Lake

  Use CData Sync to customize and automate Google Ad Manager replication to Azure Data Lake.

• DataBind Controls to Typeform in C++Builder

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

• Create Reports with SAP Ariba Procurement in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date SAP Ariba Procurement.

• Deploy the ADO.NET Provider for CouchDB on an SSRS Report Server

  Connect to Apache CouchDB from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Automated Continuous OneNote Replication to Vertica

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

• Connect to Phoenix from PowerBuilder

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

• Create SharePoint-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to SharePoint from OutSystems and build custom enterprise apps using live Microsoft SharePoint.

• Analyze LDAP Objects in Infragistics Reveal

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

• Configure the CData JDBC Driver for eBay Analytics in a Connection Pool in Tomcat

  Connect to eBay Analytics from a connection pool in Tomcat.

• Connect to Bing Search Results from AWS Glue

  Use CData Connect Cloud to gain access to live Bing Search from your AWS Glue jobs.

• Bidirectional Access to Greenplum from FileMaker Pro

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

• Feed Salesforce into FineReport

  How to set Salesforce & Force.com as a JDBC data source in FineReport.

• Feed Oracle into FineReport

  How to set Oracle Database as a JDBC data source in FineReport.

• Analyze Live Amazon Marketplace in SAS Viya

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

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

  Provide connectivity to ClickUp through an SAP BusinessObjects universe.

• Explore Geographical Relationships in Oracle with Power Map

  Create data visualizations with Oracle Database in Power Map.

• Replicate eBay Analytics to Multiple Databases

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

• Automate JotForm Replication to SAP HANA

  Use CData Sync to customize and automate JotForm replication to SAP HANA.

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

  Use CData Power BI Connectors to visualize Apache Hive in Power BI.

• How to Access Live Google Directory in Power Automate Desktop via ODBC

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

• Import Real-Time Zoho CRM in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Zoho CRM in ColdFusion.

• How to Connect to & Open DB2 in Microsoft Excel

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

• Create Apps from Tally in Qlik Sense Cloud

  Use the CData Connect Server to create an OData API for Tally ERP and build apps from live Tally ERP in Qlik Sense Cloud.

• Automated Continuous Bullhorn CRM Replication to Apache Cassandra

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

• Build Oracle SCM-Connected Apps in Bubble

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

• Integrate with Live MailChimp in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to MailChimp from the MuleSoft Anypoint Platform to integrate live MailChimp into custom reports and dashboards.

• Visualize WooCommerce in TIBCO Spotfire through ODBC

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

• Connect to Azure Synapse in RazorSQL

  Connect to Azure Synapse from wizards and query Azure Synapse from the GUI in the RazorSQL database management tool.

• A PostgreSQL Interface for QuickBooks Time

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

• «
• 205
• 206
• 207
• 208
• 209
• 210
• 211
• 212
• 213
• 214
• »