CData Software - Knowledge Base

Recent Articles

• «
• 128
• 129
• 130
• 131
• 132
• 133
• 134
• 135
• 136
• 137
• »

• Build Amazon Athena-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Amazon Athena from Zoho Analytics and import live Amazon Athena.

• Create Reports with Microsoft Project in SAP Crystal Reports

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

• Access Live Amazon DynamoDB in AWS Lambda (with IntelliJ IDEA)

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

• Automated Continuous WooCommerce Replication to Apache Cassandra

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

• Connect to PostgreSQL through External Services in Salesforce

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

• Using AngularJS to Build Dynamic Web Pages with SurveyMonkey

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

• Create Odoo Dataflows on PowerBI.com

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

• Access Google Campaign Manager 360 from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Google Campaign Manager 360 from HeidiSQL.

• Prepare, Blend, and Analyze Salesloft in Alteryx Designer

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

• Import Real-Time Google Contacts in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Google Contacts in ColdFusion.

• Analyze AlloyDB in Looker

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

• Build Google Analytics-Connected ETL Processes in Google Data Fusion

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

• Import Oracle Using Azure Data Factory

  Use CData Connect Cloud to connect to Oracle from Azure Data Factory and import live Oracle Database.

• Model, Search, and Visualize Live Microsoft Exchange in ThoughtSpot

  Use CData Connect Cloud to connect to live Microsoft Exchange for modeling, searching, and visualizing.

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

• Connect to Google Contacts in Ruby

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

• Publish Microsoft Planner-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Microsoft Planner.

• Build Sage 200-Connected Apps in Bubble

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

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

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

• How to connect to Dynamics 365 Business Central in DBVisualizer

  Integrate Dynamics 365 Business Central with visual data analysis tools and data connection wizards in DBVisualizer

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for SurveyMonkey

  Provide connectivity to SurveyMonkey through an SAP BusinessObjects universe.

• Use Dash to Build to Web Apps on BambooHR

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

• How to integrate Azure Analysis Services with Apache Airflow

  Access and process Azure Analysis Services in Apache Airflow using the CData JDBC Driver.

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

  Use CData Connect to create a virtual database for SAP ERP/NetWeaver and build custom reports in Power BI.

• Bidirectional Access to Basecamp from FileMaker Pro

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

• How to Build an ETL App for Facebook Ads in Python with CData

  Create ETL applications and real-time data pipelines for Facebook Ads in Python with petl.

• Build a Simple VCL Application for Zoho Projects

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

• JotForm Reporting and Star Schemas in OBIEE

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

• Automated Continuous CockroachDB Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable CockroachDB replication to Apache Kafka.

• Automate IBM Cloud Object Storage Replication to Couchbase

  Use CData Sync to Customize and automate IBM Cloud Object Storage replication to Couchbase.

• Query REST as a SQL Server in Node.js

  Execute SQL Server queries against REST from Node.js.

• Model Salesforce Pardot Using Azure Analysis Services

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

• Use the CData SSIS Components to Insert New or Update Existing Zoho Creator Records from SQL Server

  Easily push SQL Server data to Zoho Creator using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Zoho Creator or update existing records with data from a SQL Server database.

• How to Build Dynamic React Apps with JSON Services

  Use the CData Connect and React to Build Dynamic Web Apps with Live JSON Services.

• How to Connect the Power BI Service to eBay: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• Connect to and Query Pinterest in QlikView over ODBC

  Create data visualizations with Pinterest in QlikView.

• Connect to xBase in CloverDX (formerly CloverETL)

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

• How to Visualize Sage 50 UK Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Sage 50 UK in Python.

• Access Todoist in PHP through Connect Server

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

• Create CockroachDB-Connected Business Apps in AppSheet

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

• ETL Oracle Eloqua in Oracle Data Integrator

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

• Work with Live Office 365 in Power Query

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

• Query Oracle Financials Cloud through ODBC in Node.js

  Use node-odbc to execute SQL queries against Oracle Financials Cloud from Node.js.

• How to Create Power BI Visual Reports with Real-Time Google Ad Manager

  Use CData Power BI Connectors to visualize Google Ad Manager in Power BI.

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

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

• LINQ to Todoist

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

• Publish Crystal Reports on Azure Analysis Services

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

• Work with CockroachDB in FoxPro

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

• Connect to Active Directory in Jaspersoft Studio

  Execute SQL to remote Active Directory in Jaspersoft Studio.

• How to import MariaDB into Apache Solr

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

• Visualize Amazon Marketplace in Sisense

  Create an ElastiCube in Sisense app with access to Amazon Marketplace.

• Analyze Live Square in SAS Viya

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

• Create a Data Access Object for Azure Table using JDBI

  A brief overview of creating a SQL Object API for Azure Table Storage in JDBI.

• Analyze Freshdesk in SAP Analytics Cloud

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

• Working with Klaviyo in LINQPad

  Execute LINQ queries to Klaviyo in LINQPad.

• Automated Continuous Salesforce Marketing Replication to Apache Cassandra

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

• Design BIRT Reports on WooCommerce

  Provide current WooCommerce to your embedded analytics.

• Bridge Dynamics 365 Connectivity with Apache NiFi

  Access and process Microsoft Dynamics 365 in Apache NiFi using the CData JDBC Driver.

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

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

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

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

• How to connect and process Redshift from Azure Databricks

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

• How to publish and share NetSuite dashboards with Tableau Server

  The CData ODBC driver for NetSuite enables you integrate NetSuite CRM & ERP into Tableau dashboards.

• Access XML 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 XML Files.

• How to connect to SharePoint from Spring Boot

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

• Create Snowflake-Connected Nintex Workflows

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

• DataBind Wijmo Grid to Kafka

  Provide real-time Apache Kafka to interactive controls.

• Automate IBM Cloud Data Engine Replication to Azure Synapse

  Use CData Sync to customize and automate IBM Cloud Data Engine replication to Azure Synapse.

• Analyze Sage 300 in SAP Analytics Cloud

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

• Connect to Authorize.Net from a Connection Pool in JBoss

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

• Analyze Coinbase in Infragistics Reveal

  Use the CData Connect Server to create an OData API on top of Coinbase and visualize live Coinbase in Ingragistics Reveal.

• Build Elasticsearch Visualizations in Tableau Desktop

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

• Automated Continuous Google Campaign Manager 360 Replication to MySQL

  Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to MySQL.

• How to Work with Shopify in ETL Validator JDBC

  Connect to Shopify from ETL Validator jobs using the CData Software JDBC Driver.

• Perform Batch Operations with Amazon Athena in Apache NiFi

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

• Build Google Analytics-Connected Dashboards Using Zoho Analytics

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

• Create Datasets from Amazon S3 in Domo Workbench and Build Visualizations of Amazon S3 in Domo

  Use the CData Software ODBC Driver for Amazon S3 to create datasets from Amazon S3 in Domo Workbench and then build visualizations in the Domo service.

• Automated Continuous Greenplum Replication to IBM DB2

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

• Load Google Analytics to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Analytics to a database.

• Publish Reports with Active Directory in SAP Crystal Reports

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

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

  Connect to PayPal from a connection pool in Tomcat.

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

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

• Connect to NetSuite from PowerBuilder

  This article demonstrates how to access NetSuite CRM & ERP from PowerBuilder using the NetSuite JDBC Driver.

• Automated Continuous DocuSign Replication to Amazon Redshift

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

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

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

• DataBind Controls to Odoo in Delphi

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

• Access SQL Analysis 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 SQL Analysis Services.

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

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

• Connect to Reckon Accounts Hosted in the Denodo Platform

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

• Visualize eBay in TIBCO Spotfire through OData

  Integrate eBay into dashboards in TIBCO Spotfire.

• Automated Continuous Microsoft Project Replication to SingleStore

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

• Connect to HubDB in SpagoBI

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

• Automated Continuous Oracle SCM Replication to Databricks

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

• Build Charts with Microsoft Exchange in Clear Analytics

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

• Viewing Dynamics 365 Business Central in RAD Studio Data Explorer

  How to view Dynamics 365 Business Central in RAD Studio Data Explorer using the CData ODBC Driver for Dynamics 365 Business Central.

• Enable the Bing Search JDBC Driver in KNIME

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

• Use the CData Software ODBC Driver for SuiteCRM in MicroStrategy

  Connect to SuiteCRM in MicroStrategy Developer using the CData Software ODBC Driver for SuiteCRM.

• Replicate Multiple Parquet Accounts

  Replicate multiple Parquet accounts to one or many databases.

• Automated Continuous Twitter Replication to Databricks

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

• How to Query Redis in MySQL Workbench

  Execute MySQL queries against live Redis from MySQL Workbench.

• How to Connect DBeaver to CockroachDB via a JDBC Driver

  Manage CockroachDB with visual tools in DBeaver like the query browser.

• «
• 128
• 129
• 130
• 131
• 132
• 133
• 134
• 135
• 136
• 137
• »