CData Software - Knowledge Base

Recent Articles

• «
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• »

• Create Apps from Jira in Qlik Sense Cloud

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

• How to connect and process JDBC-ODBC Bridge from Azure Databricks

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

• Access Live FHIR in AWS Lambda

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

• Connect to LinkedIn in Google Apps Script

  Use CData Connect Cloud to access LinkedIn in Google Apps Script.

• Connect to Live SFTP in MicroStrategy through CData Software Connect Server

  Create a virtual database for SFTP in CData Software Connect Server and connect to it from MicroStrategy.

• Create Klipfolio Reports on JasperReports Server

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

• Create Data Visualizations in Cognos BI with Twitter

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

• Automate CockroachDB Replication to Azure Synapse

  Use CData Sync to customize and automate CockroachDB replication to Azure Synapse.

• Query Google Search Results as a MySQL Database in Node.js

  Execute MySQL queries against Google Search from Node.js.

• Connect to SharePoint from PowerBuilder

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

• DataBind Charts to ClickUp

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

• How to connect and process Oracle Financials Cloud from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Oracle Financials Cloud

• Connect to Sybase IQ from a Connection Pool in JBoss

  Integrate Sybase IQ into Java servlets: Use the Management Console in JBoss to install the Sybase IQ JDBC Driver.

• How to create Visio diagrams from SAP HANA

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

• Import Sage 50 UK into Microsoft Power Query

  The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access Sage 50 UK. In this article, you will use the OData format to import Sage 50 UK into Microsoft Power Query.

• Object-Relational Mapping (ORM) with Jira Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Atlassian Jira into a Java-based ORM framework, Hibernate.

• Build GitHub-Connected ETL Processes in Google Data Fusion

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

• Operational Reporting on Zoho Books from Spotfire Server

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

• How to connect PolyBase to Typeform

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

• How to Work with Google Campaign Manager 360 in AWS Glue Jobs Using JDBC

  Connect to Google Campaign Manager 360 from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Connect to Twilio as a Linked Server

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

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

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

• Visualize Bitbucket in TIBCO Spotfire through ODBC

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

• Query Outreach.io through ODBC in Node.js

  Use node-odbc to execute SQL queries against Outreach.io from Node.js.

• How to Access Live Act CRM in Power Automate Desktop via ODBC

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

• Connect to Gmail from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Gmail from Crystal Reports.

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

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

• Publish Crystal Reports on Clio

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

• Access Live Instagram in Coginiti Pro

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

• Automate Box Replication to Azure Synapse

  Use CData Sync to customize and automate Box replication to Azure Synapse.

• Connect to Highrise as a Linked Server

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

• Analyze BambooHR in R

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

• Enable the SuiteCRM JDBC Driver in KNIME

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

• Automated Continuous MailChimp Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable MailChimp replication to Amazon S3.

• Connect to Tableau CRM Analytics in as an External Source in Dremio

  Use the CData JDBC Driver to connect to Tableau CRM Analytics as an External Source in Dremio.

• Author and Share Power BI Reports on Real-Time Workday

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

• Connect to DB2 as a Linked Server

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

• Integrate Instagram into Power Automate Desktop using CData Connect

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

• Connect to Paylocity as a Linked Server

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

• Connect to Xero through External Services in Salesforce

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

• Analyze SurveyMonkey in R

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

• ETL Procore in Oracle Data Integrator

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

• Connect to ActiveCampaign in RazorSQL

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

• Connect to HCL Domino from a Connection Pool in Jetty

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

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

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

• Connect to Neo4J in the Denodo Platform

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

• Connect to Spark in Ruby

  Connect to Apache Spark SQL in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Connect to Dynamics 365 as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Microsoft Dynamics 365.

• Connect to Cassandra in Ruby

  Connect to Apache Cassandra in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Build Box-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to Box and build web apps with connectivity to live Box.

• Create Data Visualizations Based On QuickBooks Time in Mode

  Use CData Connect Cloud to connect to QuickBooks Time from Mode and build visualizations using live

• Analyze Xero in R

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

• Integrate with Bing Search Results in SnapLogic

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

• Author and Share Power BI Reports on Real-Time Zoho Books

  Use the CData ODBC Driver for Zoho Books to visualize Zoho Books in Power BI Desktop and then upload to the Power BI service.

• Build Microsoft Exchange-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Microsoft Exchange from Zoho Analytics and import live Microsoft Exchange.

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

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

• How to update Elasticsearch from Excel

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

• Integrate Real-Time Access to NetSuite in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to NetSuite CRM & ERP in real time.

• Build Semantic Layer Views for YouTube Analytics in APOS Live Data Gateway

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

• Create Databricks-Connected Business Apps in AppSheet

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

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

• Connect to Google Search Results in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for Google Search Results and connect to Google Search in Akorbi Digital RunMyProcess.

• Feed Sage Cloud Accounting into FineReport

  How to set Sage Business Cloud Accounting as a JDBC data source in FineReport.

• Dropbox Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Dropbox facts in real time.

• Work with Cloudant in FoxPro

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

• DataBind Charts to Excel

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

• Create Dynamic TaxJar Grids Using the Infragistics XamDataGrid

  Learn how you can connect TaxJar to Infragistics XamDataGrid to build dynamic grids.

• Analyze Act-On in Infragistics Reveal

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

• Connect to SAP Business One in NetBeans

  Connect to SAP Business One in NetBeans with the data source configuration wizard.

• Query Salesforce in ColdFusion

  Write standard ColdFusion data access code to connect to Salesforce & Force.com.

• Import Real-Time Amazon S3 in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Amazon S3 in ColdFusion.

• Access Live WordPress in Excel 365 Online (Excel for the web)

  Connect to WordPress from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• Use JayDeBeApi to access Kintone in Python

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

• Access Sybase as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sybase from your Oracle system.

• Import Google Directory into FileMaker Pro

  Create reports that integrate Google Directory in Filemaker Pro.

• Automated Continuous JSON Replication to Google BigQuery

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

• Query Epicor Kinetic in DataGrip

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

• Connect to IBM Cloud Data Engine from a Connection Pool in WebLogic

  Use the CData JDBC Driver for IBM Cloud Data Engine to connect to IBM Cloud Data Engine from Web applications running on WebLogic.

• Connect to Unbounce in SpagoBI

  Create reports featuring live Unbounce in SpagoBI Studio. Host Unbounce reports on SpagoBI Server.

• Connect to Zoom in the Denodo Platform

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

• Automated Continuous Square Replication to Google Cloud SQL

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

• Use the CData ODBC Driver for Sugar CRM in SAS JMP

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

• Automated Continuous Salesforce Replication to Snowflake

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

• Prepare, Blend, and Analyze Zendesk in Alteryx Designer

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

• Access Live Couchbase in TIBCO Data Virtualization

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

• Access PostgreSQL as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access PostgreSQL from your Oracle system.

• How to pipe SAP HANA to CSV in PowerShell

  Use standard PowerShell cmdlets to access SAP HANA tables.

• Build Charts with Google Data Catalog in Clear Analytics

  Create dynamic charts and perform analytics based on Google Data Catalog in Clear Analytics.

• Replicate Multiple Power BI XMLA Accounts

  Replicate multiple Power BI XMLA accounts to one or many databases.

• Analyze Elasticsearch with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Elasticsearch from Power Pivot. You will use the Table Import Wizard to load Elasticsearch. You can visually build the import query or use any SQL supported by the driver.

• Analyze Monday.com in R

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

• Add Dynamics 365 to Informatica Enterprise Data Catalog

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

• Connect to Bing Search Results in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Bing Search in the Denodo Virtual DataPort Administrator.

• Analyze ServiceNow in R

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

• Integrate Slack in the Pentaho Report Designer

  Publish reports based on Slack in the Pentaho BI tool.

• Create HarperDB Dashboards in Bold BI

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

• Configure the CData JDBC Driver for Epicor Kinetic in a Connection Pool in Tomcat

  Connect to Epicor Kinetic from a connection pool in Tomcat.

• Analyze Microsoft Exchange in SAP Analytics Cloud

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

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

• Build Visualizations of Live SAP HANA XS Advanced in Power BI (through CData Connect)

  Use CData Connect to create a virtual database for SAP HANA XS Advanced and build custom reports in Power BI.

• «
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• »