CData Software - Knowledge Base

Recent Articles

• «
• 313
• 314
• 315
• 316
• 317
• 318
• 319
• 320
• 321
• 322
• »

• Automated Continuous Pipedrive Replication to Microsoft Access

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

• Create Reports with Oracle in SAP Crystal Reports

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

• How to Design LinkedIn Power Apps with Database-Like Connectivity

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

• Create SSAS Tabular Models from Box

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

• Create Apps from SAP ByDesign in Qlik Sense Cloud

  Use CData Connect Cloud to connect to SAP ByDesign and build apps from live SAP Business ByDesign in Qlik Sense Cloud.

• Connect to Tableau CRM Analytics in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for Tableau CRM Analytics and connect to Tableau CRM Analytics in Akorbi Digital RunMyProcess.

• Automated Continuous eBay Analytics Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable eBay Analytics replication to Azure SQL Database.

• Build a PostgreSQL Interface for Oracle Eloqua using the CData JDBC Driver

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

• Build Paylocity-Connected ETL Processes in Google Data Fusion

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

• Automate SAP ByDesign Replication to Azure Synapse

  Use CData Sync to customize and automate SAP Business ByDesign replication to Azure Synapse.

• Model Oracle Eloqua Using Azure Analysis Services

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

• How to create MYOB AccountRight federated tables in MySQL

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

• Query XML through ODBC in Node.js

  Use node-odbc to execute SQL queries against XML Files from Node.js.

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

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

• Connect to Twilio from Blazor Apps

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

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

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

• Access Live IBM Cloud Object Storage in AWS Lambda (with IntelliJ IDEA)

  Connect to live IBM Cloud Object Storage in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

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

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

• Connect to and Query Salesloft in QlikView over ODBC

  Create data visualizations with Salesloft in QlikView.

• Visualize Microsoft Dataverse in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Microsoft Dataverse (CDS) into TIBCO Spotfire.

• Access Live Facebook in Excel (Desktop) via Connect Cloud

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

• Integrate with SharePoint using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft SharePoint to a JSON file on disk.

• Access Live Splunk in SAS JMP via ODBC

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

• Visualize Vault CRM in TIBCO Spotfire through OData

  Integrate Veeva Vault & Vault CRM into dashboards in TIBCO Spotfire.

• Create Amazon S3-Connected Business Apps in AppSheet

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

• Connect to Microsoft OneDrive from PowerBuilder via ODBC

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

• Build Cvent-Connected ETL Processes in Google Data Fusion

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

• Process & Analyze JDBC-ODBC Bridge in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live JDBC-ODBC Bridge .

• Automated Continuous MongoDB Replication to Google Cloud SQL

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

• Import and Visualize MarkLogic in Power View

  Create data visualizations based on MarkLogic in Excel.

• Build an OLAP Cube in SSAS from Excel Online

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

• Excel Spreadsheet Automation on Microsoft Planner with the QUERY Formula

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

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

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

• Twitter Cloud Connectivity

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

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

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

• Publish Zoho Projects-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Zoho Projects.

• Stream Zoho Creator into Apache Kafka Topics

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

• Create MySQL-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to MySQL from Klipfolio and build custom visualizations using live MySQL.

• Integrate with Sage 200 in JReport Designer

  Create charts and reports based on Sage 200 in JReport Designer.

• Build Salesforce Pardot-Connected Apps in Mendix

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

• Creating Zuora-Connected Applications in Unqork

  You can use CData Connect Cloud to feed Zuora to Unqork and build custom business apps.

• Create Datasets from Reckon Accounts Hosted in Domo Workbench and Build Visualizations of Reckon Accounts Hosted in Domo

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

• Use the CData Software JDBC Driver for Dynamics 365 in MicroStrategy Web

  Connect to Microsoft Dynamics 365 in MicroStrategy Web using the CData Software JDBC Driver for Dynamics 365.

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

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

• Connect to Sage 50 UK in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to Pinterest from a Connection Pool in Jetty

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

• Visualize SAP Concur in Sisense

  Create an ElastiCube in Sisense app with access to SAP Concur.

• Create Apps from PayPal in Qlik Sense Cloud

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

• Working with Amazon DynamoDB in LINQPad

  Execute LINQ queries to Amazon DynamoDB in LINQPad.

• How to Connect the Power BI Service to Tableau CRM Analytics: Complete Guide

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

• Rapidly Develop SAS Data Sets-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.

• Seamlessly Bring Jira into Retool Using CData Connect Cloud

  Integrate Jira data into Retool with CData Connect Cloud to build smarter apps and streamline workflows with real-time data access.

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

  Execute SQL Server queries against Twitter from Node.js.

• Build Pipelines with Live Zoho CRM in Google Cloud Data Fusion (via CData Connect Cloud)

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

• Build Sansan-Connected Apps in Mendix

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

• Connect to Salesforce Pardot from Asprova with CData Software ODBC Driver for Salesforce Pardot

  This article shows how to connect faster to Salesforce Pardot data from Asprova.

• How to create SuiteCRM federated tables in MySQL

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

• Build a Singer.io Tap for IBM Informix With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live IBM Informix data using

• Publish Google Directory-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Google Directory.

• Build Charts with eBay in Clear Analytics

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

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

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

• Feed Phoenix into FineReport

  How to set Apache Phoenix as a JDBC data source in FineReport.

• Design BIRT Reports on Google Contacts

  Provide current Google Contacts to your embedded analytics.

• Integrate Authorize.Net in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Authorize.Net from Informatica Cloud.

• Automated Continuous Microsoft Exchange Replication to Local Delimited Files

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

• Analyze GraphQL in Infragistics Reveal

  Use CData Connect Cloud to create on OData API on top of GraphQL and visualize live GraphQL in Infragistics Reveal.

• Provide OData Services of XML from a WCF Application

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

• Publish Tableau CRM Analytics-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Tableau CRM Analytics.

• Use the CData API Server to Access Bullhorn CRM in Microsoft PowerPivot

  Use the CData API Server to connect to live Bullhorn CRM in the Power Pivot business intelligence tool.

• Add CouchDB to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for CouchDB with the Informatica Enterprise Data Catalog to classify and organize data.

• DataBind Controls to Gmail in C++Builder

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

• Connect and Visualize Live Raisers Edge NXT Data in Databricks Lakehouse Federation with CData Connect Cloud

  Use CData Connect Cloud to integrate live Raisers Edge NXT into the Databricks platform and create visualization dashboards with real-time Raisers Edge NXT.

• Connect to Impala in ACL Analytics

  Connect to Apache Impala via CData Connect Cloud in ACL Analytics to run your data analysis workflows with real-time access to Apache Impala.

• ETL SAP Business One in Oracle Data Integrator

  This article shows how to transfer SAP Business One into a data warehouse using Oracle Data Integrator.

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

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

• Analyze Gmail in Looker

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

• Build Dashboards with Pinterest in DBxtra

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

• How to Query Bullhorn CRM in MySQL Workbench

  Execute MySQL queries against live Bullhorn CRM from MySQL Workbench.

• Bidirectional Access to Excel from FileMaker Pro

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

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

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

• Automated Continuous Active Directory Replication to SQLite

  Use CData Sync for automated, continuous, customizable Active Directory replication to SQLite.

• Automated Continuous XML Replication to SQLite

  Use CData Sync for automated, continuous, customizable XML replication to SQLite.

• Extract, Transform, and Load Jira Service Management in Informatica PowerCenter

  Create a simple Workflow for Atlassian Jira Service Management in Informatica PowerCenter.

• Connect to Zendesk in Jaspersoft Studio

  Execute SQL to remote Zendesk in Jaspersoft Studio.

• Visualize MarkLogic in Sisense

  Create an ElastiCube in Sisense app with access to MarkLogic.

• How to Query Databricks in MySQL Workbench

  Execute MySQL queries against live Databricks from MySQL Workbench.

• Write a Simple Go Application to work with Smartsheet on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Smartsheet.

• Connect to Twilio through External Services in Salesforce

  Use CData Connect Cloud to securely connect Salesforce External Services with Twilio using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

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

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

• How to create Visio diagrams from EnterpriseDB

  Automatically update EnterpriseDB with the changes you make to Visio master shapes.

• Automated Continuous Jira Replication to Snowflake

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

• How to Import Data from Basecamp into Google Sheets

  Import Basecamp into a Google spreadsheet that is automatically refreshed.

• Integrate Amazon S3 into Power Automate Desktop using CData Connect

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

• Query AlloyDB in ColdFusion

  Write standard ColdFusion data access code to connect to Google AlloyDB.

• Analyze QuickBooks Online in Infragistics Reveal

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

• Query SAP Ariba Source as a MySQL Database in Node.js

  Execute MySQL queries against SAP Ariba Source from Node.js.

• Building Dynamic Web Pages with SAP Netweaver Gateway Using AngularJS

  Create single-page applications with live connectivity to SAP Netweaver Gateway using the CData API Server.

• Connect to Epicor Kinetic in ACL Analytics

  Connect to Epicor Kinetic via CData Connect Cloud in ACL Analytics to run your data analysis workflows with real-time access to Epicor Kinetic.

• Access Live LinkedIn in TIBCO Data Virtualization

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

• How to publish and share Epicor Kinetic dashboards with Tableau Server

  The CData ODBC driver for Epicor Kinetic enables you integrate Epicor Kinetic into Tableau dashboards.

• «
• 313
• 314
• 315
• 316
• 317
• 318
• 319
• 320
• 321
• 322
• »