CData Software - Knowledge Base

Recent Articles

• «
• 279
• 280
• 281
• 282
• 283
• 284
• 285
• 286
• 287
• 288
• »

• Feed HCL Domino into FineReport

  How to set HCL Domino as a JDBC data source in FineReport.

• Access Adobe Analytics 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 Adobe Analytics.

• Connect to Sage Intacct in RunMyProcess through Connect Cloud

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

• Build Clio-Connected Web Apps in Servoy

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

• Build Azure Analysis Services-Connected ETL Processes in Google Data Fusion

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

• How to use SQLAlchemy ORM to access Google Campaign Manager 360 in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Campaign Manager 360.

• Explore Geographical Relationships in Odoo with Power Map

  Create data visualizations with Odoo ERP in Power Map.

• SAP HANA XS Advanced Reporting in OBIEE with the SAP HANA XS Advanced JDBC Driver

  Deploy the SAP HANA XS Advanced JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Visualize NetSuite in TIBCO Spotfire through OData

  Integrate NetSuite CRM & ERP into dashboards in TIBCO Spotfire.

• Deploy the ADO.NET Provider for Avro on an SSRS Report Server

  Connect to Apache Avro from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• How to connect PolyBase to EnterpriseDB

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

• Publish Odoo-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Odoo ERP.

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

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

• Connect to and Query Okta in QlikView over ODBC

  Create data visualizations with Okta in QlikView.

• Connect to AlloyDB in SpagoBI

  Create reports featuring live Google AlloyDB in SpagoBI Studio. Host AlloyDB reports on SpagoBI Server.

• Visualize Couchbase in TIBCO Spotfire through ODBC

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

• Automated Continuous YouTube Analytics Replication to MySQL

  Use CData Sync for automated, continuous, customizable YouTube Analytics replication to MySQL.

• Integrate Live Bing Search Results into Amazon SageMaker Canvas with RDS

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

• Visualize Zenefits in TIBCO Spotfire through OData

  Integrate Zenefits into dashboards in TIBCO Spotfire.

• Process & Analyze IBM Cloud Object Storage in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live IBM Cloud Object Storage .

• Connect to Zuora in RunMyProcess through Connect Cloud

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

• How to create Visio diagrams from MongoDB

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

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

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

• Create ShipStation-Connected Nintex Workflows

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

• Connect to Raisers Edge NXT in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for Raisers Edge NXT and connect to Raisers Edge NXT in Akorbi Digital RunMyProcess.

• Automated Continuous Dynamics GP Replication to Amazon S3

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

• How to connect PolyBase to Pinterest

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

• Connect to Salesforce Pardot in DBArtisan

  Use wizards in DBArtisan to configure Salesforce Pardot as a data source.

• Validate Azure Table with QuerySurge

  Access and validate Azure Table Storage in QuerySurge using the CData JDBC Driver.

• HarperDB Reporting in OBIEE with the HarperDB JDBC Driver

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

• Choosing the Best Method to Connect WooCommerce to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use WooCommerce from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Connect to Okta in Ruby

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

• Access Live SurveyMonkey in TIBCO Data Virtualization

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

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

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

• Automated Continuous Oracle Replication to MySQL

  Use CData Sync for automated, continuous, customizable Oracle replication to MySQL.

• How to Visualize Epicor Kinetic Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Epicor Kinetic in Python.

• How to Build an ETL App for Salesforce Marketing in Python with CData

  Create ETL applications and real-time data pipelines for Salesforce Marketing Cloud in Python with petl.

• Automated Continuous Wave Financial Replication to MySQL

  Use CData Sync for automated, continuous, customizable Wave Financial replication to MySQL.

• Elasticsearch Reporting in OBIEE with the Elasticsearch JDBC Driver

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

• Extract, Transform, and Load Salesloft in Informatica PowerCenter

  Create a simple Workflow for Salesloft in Informatica PowerCenter.

• Replicate Multiple Instagram Accounts

  Replicate multiple Instagram accounts to one or many databases.

• Connect to Basecamp in SpagoBI

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

• How to connect PolyBase to Stripe

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

• Connect to Smartsheet from AWS Glue

  Use CData Connect Cloud to gain access to live Smartsheet from your AWS Glue jobs.

• Integrate with Monday.com in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Monday.com in SnapLogic.

• Bidirectional Access to Splunk from FileMaker Pro

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

• Build Automated Odoo-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live Odoo ERP and build automated workflows in Zapier.

• Use the CData Software ODBC Driver for Cosmos DB in MicroStrategy

  Connect to Azure Cosmos DB in MicroStrategy Developer using the CData Software ODBC Driver for Cosmos DB.

• Automated Continuous Excel Online Replication to SQL Server

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

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

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

• Explore Geographical Relationships in HarperDB with Power Map

  Create data visualizations with HarperDB in Power Map.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Integrate Redis in the Pentaho Report Designer

  Publish reports based on Redis in the Pentaho BI tool.

• How to use SQLAlchemy ORM to access Google Analytics in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Analytics.

• How to integrate Splunk with Apache Airflow

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

• Create Cosmos DB Reports on JasperReports Server

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

• Visualize Email from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Email.

• Connect to Kafka in as an External Source in Dremio

  Use the CData JDBC Driver to connect to Kafka as an External Source in Dremio.

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

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

• Integrate with Workday using Apache Camel2

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

• Replicate SharePoint to Multiple Databases

  Replicate Microsoft SharePoint to disparate databases with a point-and-click configuration.

• Rapidly Develop Azure Analysis Services-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 Google Ads-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Google Ads from Choreo and build custom apps using live Google Ads.

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

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

• Replicate Multiple Google Contacts Accounts

  Replicate multiple Google Contacts accounts to one or many databases.

• Connect to MailChimp in CloverDX (formerly CloverETL)

  Transfer MailChimp using the visual workflow in the CloverDX data integration tool.

• Publish CouchDB-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Apache CouchDB.

• Integrate with Google Cloud Storage in JReport Designer

  Create charts and reports based on Google Cloud Storage in JReport Designer.

• Import Parquet into Microsoft Power Query

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

• Access Sage Intacct as a Remote Oracle Database

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

• Automated Continuous IBM Informix Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable IBM Informix replication to Amazon Redshift.

• Query Bitbucket as a MySQL Database in Node.js

  Execute MySQL queries against Bitbucket from Node.js.

• Connect to Phoenix in CloverDX (formerly CloverETL)

  Transfer Apache Phoenix using the visual workflow in the CloverDX data integration tool.

• How to Connect DBeaver to Amazon S3 via a JDBC Driver

  Manage Amazon S3 with visual tools in DBeaver like the query browser.

• Integrate Live Twitter Ads into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to Twitter Ads and integrate live Twitter Ads into apps built in Microsoft Power Apps.

• Viewing WooCommerce in RAD Studio Data Explorer

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

• A PostgreSQL Interface for Cvent

  Use the Remoting features of the Cvent ODBC Driver to create a PostgreSQL entry-point for data access.

• DataBind Controls to SAP Ariba Source in C++Builder

  DataBind to SAP Ariba Source in C++Builder with standard components and controls.

• Prepare, Blend, and Analyze SAP BusinessObjects BI in Alteryx Designer

  Build workflows to access live SAP BusinessObjects BI for self-service data analytics.

• LINQ to Active Directory

  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 Active Directory Data Provider.

• Build SendGrid-Connected Web Apps in Servoy

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

• Access Live GitHub in Google Sheets

  Use CData Connect Cloud to gain access to live GitHub from your Google Sheets.

• Analyze Live SAP Hybris C4C in SAS Viya

  Use CData Connect Cloud to connect to SAP Hybris C4C from SAS Viya and deploy self-service analytics using live SAP Hybris C4C.

• Amazon Athena Reporting in OBIEE with the Amazon Athena JDBC Driver

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

• Build a Simple VCL Application for SAP HANA

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

• Edit and Search External Adobe Analytics Objects in Salesforce Connect

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

• Connect to SAP Netweaver Gateway in the Denodo Platform

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

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

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

• Analyze Zoom in R

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

• Connect to HDFS in DBArtisan

  Use wizards in DBArtisan to configure Apache HDFS as a data source.

• How to connect to PostgreSQL with Squirrel SQL client

  Connect to PostgreSQL and execute queries in the Squirrel SQL Client.

• Connect to SAS Data Sets in RunMyProcess through Connect Server

  Use CData Connect Server to create an OData API for SAS Data Sets and connect to SAS Data Sets in Akorbi Digital RunMyProcess.

• Connect to EventBrite in CloverDX (formerly CloverETL)

  Transfer Eventbrite using the visual workflow in the CloverDX data integration tool.

• Create Freshdesk-Connected Nintex Workflows

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

• Connect to Zoho Creator in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Zoho Creator in Airbyte.

• Model, Search, and Visualize Live Google Contacts in ThoughtSpot

  Use CData Connect Cloud to connect to live Google Contacts for modeling, searching, and visualizing.

• Build DocuSign-Connected Apps in Mendix

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

• Analyze Phoenix in SAP Analytics Cloud

  Use the CData Connect Server to create an OData API on top of Apache Phoenix and visualize Apache Phoenix in SAP Analytics Cloud.

• Automated Continuous Databricks Replication to IBM DB2

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

• Create Greenplum Dataflows on PowerBI.com

  Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

• «
• 279
• 280
• 281
• 282
• 283
• 284
• 285
• 286
• 287
• 288
• »