CData Software - Knowledge Base

Recent Articles

• «
• 77
• 78
• 79
• 80
• 81
• 82
• 83
• 84
• 85
• 86
• »

• Use the CData Software ODBC Driver for BambooHR in MicroStrategy Web

  Connect to BambooHR in MicroStrategy Web using the CData Software ODBC Driver for BambooHR.

• Import and Visualize SharePoint in Power View

  Create data visualizations based on Microsoft SharePoint in Excel.

• LINQ to Typeform

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

• Connect to Couchbase from a Connection Pool in Jetty

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

• Connect to GitHub in DBArtisan

  Use wizards in DBArtisan to configure GitHub as a data source.

• Connect to LinkedIn in RazorSQL

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

• Integrate with QuickBooks in JReport Designer

  Create charts and reports based on QuickBooks Desktop in JReport Designer.

• Connect to Oracle Eloqua in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for Oracle Eloqua and connect to Oracle Eloqua in Akorbi Digital RunMyProcess.

• LINQ to Veeva

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

• Build Odoo-Connected Apps in Mendix

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

• Viewing Workday in RAD Studio Data Explorer

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

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

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

• Connect to Google Campaign Manager 360 in Google Apps Script

  Use CData Connect Cloud to access Google Campaign Manager 360 in Google Apps Script.

• Access Live QuickBooks Online in AWS Lambda (with IntelliJ IDEA)

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

• Build Acumatica Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live Acumatica ERP and build visualizations in Tableau Cloud.

• Create Data Visualizations Based On IBM Informix in Mode

  Use CData Connect Cloud to connect to IBM Informix from Mode and build visualizations using live

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

• Access SharePoint Excel Services 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 SharePoint Excel Services.

• How to integrate Cloudant with Apache Airflow

  Access and process IBM Cloudant in Apache Airflow using the CData JDBC Driver.

• How to publish and share Veeva dashboards with Tableau Server

  The CData ODBC driver for Veeva enables you integrate Veeva Vault into Tableau dashboards.

• Connect to Epicor Kinetic in Jaspersoft Studio

  Execute SQL to remote Epicor Kinetic in Jaspersoft Studio.

• Integrate Veeva with External Services using SnapLogic

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

• Automated Continuous Invoiced Replication to SQL Server

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

• Natively Connect to MariaDB in PHP

  Create PHP applications on Linux/UNIX machines with connectivity to MariaDB. Leverage the native support for ODBC in PHP.

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

  Provide connectivity to Trello through an SAP BusinessObjects universe.

• Edit and Search External Paylocity Objects in Salesforce Connect

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

• Automate QuickBooks Replication to SAP HANA

  Use CData Sync to customize and automate QuickBooks Desktop replication to SAP HANA.

• Visualize Live Google Cloud Storage in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Google Cloud Storage.

• Model Oracle Sales Using Azure Analysis Services

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

• DataBind Klipfolio to the DevExpress Data Grid

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

• Connect to DocuSign in JRuby

  Create a simple JRuby app with access to live DocuSign.

• Create Data Visualizations Based On Oracle HCM Cloud in Mode

  Use CData Connect Cloud to connect to Oracle HCM Cloud from Mode and build visualizations using live

• Build Salesloft-Connected Dashboards in Redash

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

• Extract, Transform, and Load Harvest in Informatica PowerCenter

  Create a simple Workflow for Harvest in Informatica PowerCenter.

• Analyze Marketo in SAP Analytics Cloud

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

• Build an OLAP Cube in SSAS from Power BI XMLA

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

• Use the CData Software JDBC Driver for HBase in MicroStrategy

  Connect to Apache HBase in MicroStrategy Developer using the CData Software JDBC Driver for HBase.

• Operational Reporting on Presto from Spotfire Server

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

• Connect to Access in JRuby

  Create a simple JRuby app with access to live Microsoft Access.

• Build MVC Applications with Connectivity to Okta

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Okta from an ASP.NET MVC application.

• Replicate HarperDB from PowerShell

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

• Connect to Amazon DynamoDB in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Create Informatica Mappings From/To a JDBC Data Source for Sage 300

  Create Sage 300 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Create Google Spanner Reports on JasperReports Server

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

• Connect to Google Cloud Storage in NetBeans

  Connect to Google Cloud Storage in NetBeans with the data source configuration wizard.

• Enable the SQL Server JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Microsoft SQL Server.

• Visualize Square in Sisense

  Create an ElastiCube in Sisense app with access to Square.

• Creating Elasticsearch-Connected Applications in Unqork

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

• Connect to SharePoint Excel Services as a Linked Server

  Use the SQL Gateway and the ODBC Driver to set up a linked server for SharePoint Excel Services.

• Using AngularJS to Build Dynamic Web Pages with Databricks

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

• Access Twilio as a Remote Oracle Database

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

• Design BIRT Reports on Zendesk

  Provide current Zendesk to your embedded analytics.

• Process & Analyze SAS Data Sets in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live SAS Data Sets .

• Visualize Oracle in Sisense

  Create an ElastiCube in Sisense app with access to Oracle Database.

• Use the Connect Server to Access Kafka in Microsoft Power Pivot

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

• How to connect PolyBase to Neo4J

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

• Import Real-Time Sybase IQ in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Sybase IQ in ColdFusion.

• Import and Visualize SurveyMonkey in Power View

  Create data visualizations based on SurveyMonkey in Excel.

• Automated Continuous Todoist Replication to Azure SQL

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

• Integrate with EnterpriseDB using Apache Camel2

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

• Create Apps from Presto in Qlik Sense Cloud

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

• Create SSAS Tabular Models from Basecamp

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

• Automated Continuous SAP Concur Replication to Snowflake

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

• Visualize Redshift in Tableau

  The CData ODBC driver for Redshift enables you integrate Amazon Redshift into Tableau dashboards.

• Automated Continuous Avalara AvaTax Replication to Snowflake

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

• Build MVC Applications with Connectivity to LDAP Objects

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access LDAP from an ASP.NET MVC application.

• Publish Reports with WordPress in SAP Crystal Reports

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

• Visualize Live Salesloft in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Salesloft.

• Use the CData Software JDBC Driver for Workday in MicroStrategy

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

• Create Dynamic ActiveCampaign Grids Using the Infragistics XamDataGrid

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

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

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

• Visualize Live ActiveCampaign in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live ActiveCampaign.

• How to work with MySQL in Apache Spark using SQL

  Access and process MySQL in Apache Spark using the CData Software JDBC Driver.

• Query Act-On in ColdFusion

  Write standard ColdFusion data access code to connect to Act-On.

• How to connect PolyBase to Zoho Projects

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

• Query Klipfolio as a SQL Server in Node.js

  Execute SQL Server queries against Klipfolio from Node.js.

• Access Live Teradata in AWS Lambda

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

• Create Reports with Teradata in SAP Crystal Reports

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

• View Reports on Real-Time Bing Ads in Power BI Report Server

  Use the CData ODBC Driver for Bing Ads to visualize Bing Ads in Power BI Desktop and then publish them to Power BI Report Server.

• Create Google Campaign Manager 360 Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for Google Campaign Manager 360 to build custom dashboards in Bold BI.

• Use Biml to Build SSIS Tasks to Replicate Zoho Projects to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zoho Projects to SQL Server.

• How to update Snowflake from Excel

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

• Access Live Zoho Projects in TIBCO Data Virtualization

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

• Create Dynamic Dynamics GP Grids Using the Infragistics XamDataGrid

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

• How to Visualize Power BI XMLA Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Power BI XMLA in Python.

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

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

• Bitbucket Reporting and Star Schemas in OBIEE

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

• ETL Clio in Oracle Data Integrator

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

• Provide OData Services of Odoo from a WCF Application

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

• Import Trello into the Power BI Service for Visualizations

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

• Connect to Zoho Projects 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 Zoho Projects.

• Integrate Stripe in the Pentaho Report Designer

  Publish reports based on Stripe in the Pentaho BI tool.

• Create Data Visualizations in Cognos BI with Calendly

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

• Phoenix Reporting and Star Schemas in OBIEE

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

• Automated Continuous JSON Replication to Snowflake

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

• DataBind Controls to Splunk in C++Builder

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

• Connect to HCL Domino in HULFT Integrate

  Connect to HCL Domino as a JDBC data source in HULFT Integrate

• Prepare, Blend, and Analyze Google Sheets in Alteryx Designer

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

• Build Semantic Layer Views for Sugar CRM in APOS Live Data Gateway

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

• How to connect Amazon QuickSight to LinkedIn

  Create a connection to LinkedIn in CData Connect Cloud and insert LinkedIn into Amazon QuickSight SPICE to build interactive dashboards.

• «
• 77
• 78
• 79
• 80
• 81
• 82
• 83
• 84
• 85
• 86
• »