CData Software - Knowledge Base

Recent Articles

• «
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• »

• How to connect PolyBase to OData

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

• Work with Live Twilio in Power Query

  Use CData Connect Cloud to connect to Twilio and work with live Twilio in Microsoft Power Query.

• How to Work with Twilio in AWS Glue Jobs Using JDBC

  Connect to Twilio from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Integrate Amazon Athena in the Pentaho Report Designer

  Publish reports based on Amazon Athena in the Pentaho BI tool.

• Build Apps with Live Elasticsearch in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live Elasticsearch into the Adalo platform and build custom mobile and web applications with real-time Elasticsearch.

• Extract, Transform, and Load Reckon Accounts Hosted in Informatica PowerCenter

  Create a simple Workflow for Reckon Accounts Hosted in Informatica PowerCenter.

• Use Dash to Build to Web Apps on Neo4J

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

• Access Live Snapchat Ads in AWS Lambda

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

• Automated Continuous GitHub Replication to Databricks

  Use CData Sync for automated, continuous, customizable GitHub replication to Databricks.

• Build Cvent-Connected Web Apps in Servoy

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

• Bidirectional Access to Outreach.io from FileMaker Pro

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

• Create JotForm-Connected Visualizations in Klipfolio

  Use CData Software Connect Server to connect to JotForm from Klipfolio and build custom visualizations using live JotForm.

• Connect to Dynamics GP in JRuby

  Create a simple JRuby app with access to live Microsoft Dynamics GP.

• Use the CData Software ODBC Driver for Trello in MicroStrategy Desktop

  Connect to Trello in MicroStrategy Desktop using the CData Software ODBC Driver for Trello.

• LINQ to Dynamics GP

  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 Dynamics GP Data Provider.

• Use the CData Software ODBC Driver for Salesforce Marketing in MicroStrategy Web

  Connect to Salesforce Marketing Cloud in MicroStrategy Web using the CData Software ODBC Driver for Salesforce Marketing.

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

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

• Access Oracle SCM 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 Oracle SCM.

• How to connect and process Jira Assets from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Jira Assets

• Operational Reporting on Harvest from Spotfire Server

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

• Access Live WordPress in AWS Lambda

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

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

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

• Analyze Square in R

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

• Publish Neo4J-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Neo4J.

• Access Live Unbounce in AWS Lambda

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

• Use the CData Software JDBC Driver for Amazon S3 in MicroStrategy Web

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

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

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

• Visualize Monday.com from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Monday.com.

• Build Dashboards with ServiceNow in Dundas BI

  Create dynamic dashboards and perform analytics based on ServiceNow in Dundas BI.

• Visualize Redis in TIBCO Spotfire through ADO.NET

  Integrate Redis into dashboards in TIBCO Spotfire.

• Automate Oracle Service Cloud Replication to Azure Data Lake

  Use CData Sync to customize and automate Oracle Service Cloud replication to Azure Data Lake.

• Create Salesloft-Connected Nintex Workflows

  Use CData Software Connect Server to connect to Salesloft from Nintex Workflow Cloud and build custom workflows using live Salesloft.

• Automated Continuous Zoho Books Replication to Microsoft Access

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

• Build an OLAP Cube in SSAS from Workday

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

• Analyze Google Analytics in SAP Analytics Cloud

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

• Access QuickBooks 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 QuickBooks Desktop.

• Prepare, Blend, and Analyze PayPal in Alteryx Designer

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

• Connect to Bing Ads in RazorSQL

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

• Connect to TaxJar from a Connection Pool in JBoss

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

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

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

• Connect to LinkedIn Ads in the Denodo Platform

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

• Access Live Wave Financial in Coginiti Pro

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

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

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

• Analyze ADP with Power Pivot

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

• Import and Visualize Google Drive in Power View

  Create data visualizations based on Google Drive in Excel.

• Integrate Real-Time Access to SAP ByDesign in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP Business ByDesign in real time.

• Access CouchDB as a Remote Oracle Database

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

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

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

• Typeform Reporting in OBIEE with the Typeform JDBC Driver

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

• Build Charts with WordPress in Clear Analytics

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

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

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft SharePoint in real time.

• Edit and Search External GitHub Objects in Salesforce Connect

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

• Visualize Slack in Tableau

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

• Perform Batch Operations with Basecamp in Apache NiFi

  Connect to Basecamp and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Connect to SingleStore in NetBeans

  Connect to SingleStore in NetBeans with the data source configuration wizard.

• Connect to Sybase from PowerBuilder

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

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

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

• LINQ to ActiveCampaign

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

• Load SAP HANA XS Advanced to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP HANA XS Advanced to a database.

• Integrate with Google Calendar using Apache Camel2

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

• Access Live Pinterest in TIBCO Data Virtualization

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

• Use the CData Software JDBC Driver for SAP HANA XS Advanced in MicroStrategy

  Connect to SAP HANA XS Advanced in MicroStrategy Developer using the CData Software JDBC Driver for SAP HANA XS Advanced.

• Access Greenhouse from MySQL in HeidiSQL

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

• Integrate Google Calendar with External Services using SnapLogic

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

• How to connect to Google Ads from Spring Boot

  Connect to Google Ads in a Spring Boot Application using CData JDBC Google Ads Driver

• Connect to Live Cloudant in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Cloudant in CData Connect Cloud and connect to your IBM Cloudant from PostgreSQL.

• Integrate with ADP using Apache Camel2

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

• Replicate Azure Active Directory to Multiple Databases

  Replicate Azure Active Directory to disparate databases with a point-and-click configuration.

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

  Use CData JDBC drivers to import and use Amazon Athena in ColdFusion.

• Connect to MailChimp in Jaspersoft Studio

  Execute SQL to remote MailChimp in Jaspersoft Studio.

• Automated Continuous Xero Replication to SQL Server

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

• Replicate Oracle SCM to Multiple Databases

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

• Access Live Outreach.io in AWS Lambda

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

• How to import Redshift into Apache Solr

  Use the CData Software JDBC Driver for Redshift in Data Import Handler and create an automated import of Amazon Redshift to Apache Solr Enterprise Search platform.

• Build a Simple VCL Application for Power BI XMLA

  How to build a simple VCL Application to view Power BI XMLA in RAD Studio using the CData ODBC Driver for Power BI XMLA.

• Connect to Square in Aqua Data Studio

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

• Connect to Splunk from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Splunk from Filemaker Pro on Mac.

• Build Spark-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Apache Spark SQL.

• Automated Continuous Confluence Replication to Databricks

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

• Visualize Live Reckon in the Power BI Service

  Use CData Software Connect Server to create a virtual SQL Server database for Reckon and create custom reports in the Power BI Service.

• How to connect Amazon QuickSight to Microsoft Project

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

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

  Connect to Zenefits from a connection pool in Tomcat.

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

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

• Publish Epicor Kinetic-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Epicor Kinetic.

• Visualize Live Zuora of Power BI Report Builder in Power BI Service

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

• Create Data Visualizations in Cognos BI with Sybase

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

• Connect to SAS xpt from a Connection Pool in JBoss

  Integrate SAS XPORT into Java servlets: Use the Management Console in JBoss to install the SAS xpt JDBC Driver.

• How to connect to Parquet from Google Apps Script

  Use CData Software Connect Server to access Apache Parquet in Google Apps Script.

• A PostgreSQL Interface for Microsoft Planner

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

• Automate Twilio Replication to Couchbase

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

• Create Wave Financial-Connected Business Apps in AppSheet

  Use CData Software Connect Server to connect to Wave Financial from AppSheet and build custom business apps using live Wave Financial.

• DataBind Controls to Access in Delphi

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

• Access HubSpot in PHP through Connect Server

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

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

  Provide connectivity to CSV/TSV Files through an SAP BusinessObjects universe.

• Connect to Access in HULFT Integrate

  Connect to Access as a JDBC data source in HULFT Integrate

• DataBind Controls to Twitter Ads in C++Builder

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

• Provide OData Services of Todoist from a WCF Application

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

• Model, Search, and Visualize Live Bing Search Results in ThoughtSpot

  Use CData Connect Cloud to connect to live Bing Search for modeling, searching, and visualizing.

• Build Apps with Live SAP ByDesign Using the Low-Code Development Platform of Mendix

• «
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• »