CData Software - Knowledge Base

Recent Articles

• «
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• »

• Connect to TigerGraph from a Connection Pool in Jetty

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

• Query Dynamics NAV in ColdFusion

  Write standard ColdFusion data access code to connect to Microsoft Dynamics NAV.

• Analyze SAP HANA in SAP Analytics Cloud

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

• Extract, Transform, and Load Microsoft Project in Informatica PowerCenter

  Create a simple Workflow for Microsoft Project in Informatica PowerCenter.

• Visualize ClickUp in TIBCO Spotfire through ODBC

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

• Access JDBC-ODBC Bridge 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 JDBC-ODBC Bridge.

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

  Use CData Power BI Connectors to visualize Epicor Kinetic in Power BI.

• Connect to Square in SpagoBI

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

• DataBind Wijmo Grid to Sage 50 UK

  Provide real-time Sage 50 UK to interactive controls.

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

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

• Provide OData Services of EventBrite from a WCF Application

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

• Automated Todoist Replication to Teradata

  Use CData Sync to Customize and automate Todoist replication to Teradata.

• Connect to Salesforce Pardot in HULFT Integrate

  Connect to Salesforce Pardot as a JDBC data source in HULFT Integrate

• Access Live Trello in AWS Lambda

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

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

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

• Process & Analyze Shippo in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Shippo .

• Connect to MySQL in Jaspersoft Studio

  Execute SQL to remote MySQL in Jaspersoft Studio.

• Build a Simple VCL Application for Azure Data Lake Storage

  How to build a simple VCL Application to view Azure Data Lake Storage in RAD Studio using the CData ODBC Driver for Azure Data Lake Storage.

• Feed Twitter into FineReport

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

• Visualize Live SAP Ariba Source of Power BI Report Builder in Power BI Service

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

• Connect to Microsoft OneDrive from a Connection Pool in Jetty

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

• Query Zoho Inventory in DataGrip

  Create a Data Source for Zoho Inventory in DataGrip and use SQL to query live Zoho Inventory.

• Analyze Snapchat Ads in SAP Analytics Cloud

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

• Query Freshdesk as a MySQL Database in Node.js

  Execute MySQL queries against Freshdesk from Node.js.

• Provide OData Services of FTP from a WCF Application

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

• How to connect Amazon QuickSight to Odoo

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

• Extract, Transform, and Load Instagram in Informatica PowerCenter

  Create a simple Workflow for Instagram in Informatica PowerCenter.

• Visualize Live Zoho Creator in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live Zoho Creator into custom reports in Power BI.

• Integrate with FHIR in JReport Designer

  Create charts and reports based on FHIR in JReport Designer.

• Extract, Transform, and Load Harvest in Informatica PowerCenter

  Create a simple Workflow for Harvest in Informatica PowerCenter.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Create a Data Access Object for Redis using JDBI

  A brief overview of creating a SQL Object API for Redis in JDBI.

• Automate Impala Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Apache Impala from PowerShell? This article demonstrates how to utilize the Impala Cmdlets for tasks like connecting to Apache Impala, automating operations, downloading data, and more.

• Automated Continuous Hive Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Hive replication to SingleStore.

• Analyze Live Google Ads in SAS Viya

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

• Access Live Avro in AWS Lambda

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

• Use the CData Software ODBC Driver for Twilio in SAS for Real-Time Reporting and Analytics

  Connect to real-time Twilio in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Twilio.

• Integrate with Invoiced in JReport Designer

  Create charts and reports based on Invoiced in JReport Designer.

• Connect to Zoho CRM from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Zoho CRM to connect to Zoho CRM from Web applications running on WebLogic.

• Process & Analyze Google Search Results in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Google Search Results.

• Connect to and Query Dynamics 365 in QlikView over ODBC

  Create data visualizations with Microsoft Dynamics 365 in QlikView.

• Back Up Tableau CRM Analytics to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Tableau CRM Analytics. In this article, we will employ an SSIS workflow to populate a database with Tableau CRM Analytics data.

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

  Connect to NetSuite CRM & ERP from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• Provide OData Services of Dynamics 365 Business Central from a WCF Application

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

• Analyze Live Acumatica in SAS Viya

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

• Automated Continuous GitHub Replication to Apache Cassandra

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

• Automated Continuous DocuSign Replication to MongoDB

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

• Access Live Bullhorn CRM in AWS Lambda

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

• Access SuiteCRM in PHP through Connect Server

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

• Replicate Multiple Zenefits Accounts

  Replicate multiple Zenefits accounts to one or many databases.

• Edit and Search External CSV Objects in Salesforce Connect

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

• Automated Continuous Databricks Replication to Amazon S3

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

• Build Visualizations of Microsoft Planner in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft Planner in Birst.

• Visualize xBase in Sisense

  Create an ElastiCube in Sisense app with access to xBase.

• Explore Geographical Relationships in Certinia with Power Map

  Create data visualizations with Certinia in Power Map.

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

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

• How to import Elasticsearch into Apache Solr

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

• Create SuiteCRM-Connected Visualizations in Klipfolio

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

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

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

• Import SAS Data Sets into FileMaker Pro

  Create reports that integrate SAS Data Sets in Filemaker Pro.

• Design BIRT Reports on SQL Analysis Services

  Provide current SQL Analysis Services to your embedded analytics.

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP HANA XS Advanced

  Provide connectivity to SAP HANA XS Advanced through an SAP BusinessObjects universe.

• Create LDAP-Connected Visualizations in Klipfolio

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

• Creating Stripe-Connected Applications in Unqork

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

• Acumatica Reporting in OBIEE with the Acumatica JDBC Driver

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

• Use the CData Software JDBC Driver for Square in MicroStrategy

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

• Connect to Zendesk in Aqua Data Studio

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

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

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

• Visualize FHIR in TIBCO Spotfire through ODBC

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

• Automated Continuous Vertica Replication to Apache Cassandra

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

• Replicate Multiple SAP Ariba Source Accounts

  Replicate multiple SAP Ariba Source accounts to one or many databases.

• Automate Zuora Replication to SAP HANA

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

• Access Live Google Ad Manager in TIBCO Data Virtualization

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

• Analyze Facebook in Looker

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

• A PostgreSQL Interface for Cassandra

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

• Integrate Live PayPal into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to PayPal from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live PayPal.

• Build Interactive Dashboards from Sage 50 UK in Amazon QuickSight

  Create a virtual SQL Server database for Sage 50 UK in CData Software Connect Server and import Sage 50 UK into Amazon QuickSight SPICE to build interactive dashboards.

• Automated Continuous Google Ads Replication to SQLite

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

• Build a Simple VCL Application for Drift

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

• Replicate Spark from PowerShell

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

• Automated Continuous Dynamics 365 Business Central Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Google Cloud SQL.

• A PostgreSQL Interface for IBM Informix

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

• Automate Power BI XMLA Replication to SAP HANA

  Use CData Sync to customize and automate Power BI XMLA replication to SAP HANA.

• How to connect to CockroachDB from Spring Boot

  Connect to CockroachDB in a Spring Boot Application using CData JDBC CockroachDB Driver

• Publish Crystal Reports on Zoom

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

• Connect to Google Sheets in Jaspersoft Studio

  Execute SQL to remote Google Sheets in Jaspersoft Studio.

• Replicate Multiple Acumatica Accounts

  Replicate multiple Acumatica accounts to one or many databases.

• Build Exact Online-Connected Apps in Bubble

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

• Create Data Visualizations in Cognos BI with Acumatica

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

• Connect to Amazon S3 in Google Apps Script

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

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

  Execute SQL Server queries against Square from Node.js.

• How to work with Amazon DynamoDB in Apache Spark using SQL

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

• Viewing MariaDB in RAD Studio Data Explorer

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

• Work with Live Dynamics CRM in Power Query

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

• DataBind Controls to GraphQL in Delphi

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

• Integrate Kintone into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Kintone and integrate live Kintone into your Power Automate tasks.

• Build Semantic Layer Views for Azure Data Lake Storage in APOS Live Data Gateway

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

• Create Apps from Authorize.Net in Qlik Sense Cloud

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

• Create Google Search Dashboards in Bold BI

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

• Publish Crystal Reports on Google Ad Manager

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

• «
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• »