CData Software - Knowledge Base

Recent Articles

• «
• 88
• 89
• 90
• 91
• 92
• 93
• 94
• 95
• 96
• 97
• »

• Query Snapchat Ads as a SQL Server Database in Node.js

  Execute SQL Server queries against Snapchat Ads from Node.js.

• Build Dashboards with Stripe in Dundas BI

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

• Automated Continuous Splunk Replication to MySQL

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

• Use the CData ODBC Driver for SAP ByDesign from SharePoint Excel Services

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

• Publish Reports with Oracle Service Cloud in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Oracle Service Cloud.

• How to create an RPA flow for Tally in UiPath Studio

  Use the Tally ODBC Driver to create workflows that access real-time Tally ERP without any coding.

• How to connect and process Hive from Azure Databricks

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

• How to Use CData Connect to Access Live Tally in Power Automate

  CData Connect for Tally enables you to integrate Tally ERP into workflows built using Microsoft Power Automate Desktop.

• ETL Neo4J in Oracle Data Integrator

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

• Integrate with OneNote in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Microsoft OneNote in SnapLogic.

• Connect to Zoho Projects as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Zoho Projects.

• Automated Continuous Azure Synapse Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Azure Synapse replication to AlloyDB.

• Connect to Google Contacts in the Denodo Platform

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

• A PostgreSQL Interface for LinkedIn (MySQL Remoting via JDBC)

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

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

  Connect to Apache Spark SQL in MicroStrategy Desktop using the CData Software ODBC Driver for Spark.

• Validate Azure Analysis Services with QuerySurge

  Access and validate Azure Analysis Services in QuerySurge using the CData JDBC Driver.

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

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

• Connect to Greenplum from AWS Glue

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

• Bidirectional Access to HDFS from FileMaker Pro

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

• Visualize Confluence from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Atlassian Confluence.

• Connect to Jira Assets from a Connection Pool in Jetty

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

• Query Sage 300 through ODBC in Node.js

  Use node-odbc to execute SQL queries against Sage 300 from Node.js.

• Build Zoom-Connected Dashboards in Redash

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

• Enable the MariaDB JDBC Driver in KNIME

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

• Build Visualizations of SAP Ariba Procurement in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP Ariba Procurement in Birst.

• DataBind Controls to HBase in C++Builder

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

• Snowflake Reporting and Star Schemas in OBIEE

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

• Use the CData Software JDBC Driver for DB2 in MicroStrategy

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

• How to connect and process Salesforce Data Cloud from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Salesforce Data Cloud

• Integrate MySQL in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live MySQL from Informatica Cloud.

• Access Live Zoho Projects in Coginiti Pro

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

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

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

• Viewing Paylocity in RAD Studio Data Explorer

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

• Automated Continuous Google Sheets Replication to Oracle

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

• Build Dashboards with Couchbase in DBxtra

  Create dynamic dashboards and perform analytics based on Couchbase in DBxtra.

• Import Google Contacts into the Power BI Service for Visualizations

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

• Integrate SingleStore with External Services using SnapLogic

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

• How to connect and process SharePoint from Azure Databricks

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

• Connect to SAP HANA in RapidMiner

  Integrate SAP HANA with standard components and data source configuration wizards in RapidMiner Studio.

• LINQ to Marketo

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

• Automate SAP ByDesign Replication to Azure Data Lake

  Use CData Sync to customize and automate SAP Business ByDesign replication to Azure Data Lake.

• Build Sansan Visualizations in Tableau Cloud

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

• Access Live BigQuery in Google Sheets via Connect Cloud

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

• Build Automated SQL Server-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live Microsoft SQL Server and build automated workflows in Zapier.

• Using the CData Software ODBC Driver for Redshift in PyCharm

  Connect to Redshift as an ODBC data source in PyCharm using the CData Software ODBC Driver for Redshift.

• Analyze MailChimp in Looker

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

• Access Live Avalara AvaTax in AWS Lambda

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

• Connect to Calendly from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Calendly using standard SQL.

• 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 Asana from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Asana using standard SQL.

• Connect to Azure Analysis Services as an External Source in Dremio

  Use the CData JDBC Driver to connect to Azure Analysis Services as an External Source in Dremio.

• Build Excel-Connected Web Apps in Servoy

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

• Connect to Live Azure Active Directory in MicroStrategy through CData Connect Cloud

  Create a live connection to Azure Active Directory in CData Connect Cloud and connect to your Azure Active Directory from MicroStrategy.

• Connect to Raisers Edge NXT in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Raisers Edge NXT in Airbyte.

• Analyze Live WordPress in SAS Viya

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

• Build Semantic Layer Views for PCA Sales in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for PCA Sales.

• Access Salesloft in PHP through Connect Server

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

• LINQ to Square

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

• Connect to ConstantContact from a Connection Pool in WebLogic

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

• Create Data Visualizations in Cognos BI with AlloyDB

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

• Connect to QuickBooks Time in Jaspersoft Studio

  Execute SQL to remote QuickBooks Time in Jaspersoft Studio.

• Build Smaregi Visualizations in Tableau Cloud

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

• Perform Batch Operations with Azure Synapse in Apache NiFi

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

• How to Visualize Aha Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Aha! in Python.

• DataBind Controls to Blackbaud FE NXT in C++Builder

  DataBind to Blackbaud FE NXT in C++Builder with standard components and controls.

• Create SAP Ariba Source-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to SAP Ariba Source from OutSystems and build custom enterprise apps using live SAP Ariba Source.

• How to integrate Drip with Apache Airflow

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

• Access Live ServiceNow in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate ServiceNow into the statistical analysis tools available in SAS JMP. This article shows how to use ServiceNow in the Graph Builder and Query Builder.

• Analyze Cassandra in R via JDBC

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

• Connect to Twitter Ads in HULFT Integrate

  Connect to Twitter Ads as a JDBC data source in HULFT Integrate

• Visualize Live Snapchat Ads in the Power BI Service

  Use CData Connect Cloud to connect to live Snapchat Ads and create custom reports in the Power BI Service through the On-Premises Gateway.

• Visualize Raisers Edge NXT in Sisense

  Create an ElastiCube in Sisense app with access to Raisers Edge NXT.

• Validate Redshift with QuerySurge

  Access and validate Amazon Redshift in QuerySurge using the CData JDBC Driver.

• Create Amazon Athena-Connected Business Apps in AppSheet

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

• Connect to Facebook Ads from Filemaker Pro (Mac)

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

• How to Connect to & Open Oracle Service Cloud in Microsoft Excel

  This article uses the CData ODBC driver for Oracle Service Cloud to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Automated Continuous Azure Data Lake Storage Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Google BigQuery.

• Connect to Printify in HULFT Integrate

  Connect to Printify as a JDBC data source in HULFT Integrate

• Connect to Azure Data Lake Storage from HeidiSQL

  Use CData Connect Cloud to connect to and query live Azure Data Lake Storage from HeidiSQL.

• Enable the Oracle Financials Cloud JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Oracle Financials Cloud.

• Connect to SAP ByDesign from AWS Glue

  Use CData Connect Cloud to gain access to live SAP Business ByDesign from your AWS Glue jobs.

• Create Dashboards and Visualize Live SingleStore in Geckoboard

  Use CData Connect Cloud to connect to live SingleStore and create dashboards for real-time monitoring and visualization in Geckoboard.

• How to connect to Adobe Commerce with Squirrel SQL client

  Connect to Adobe Commerce and execute queries in the Squirrel SQL Client.

• How to Connect to Google Sheets in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Google Sheets. Leverage the pyodbc module for ODBC in Python.

• How to create Visio diagrams from Google Directory

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

• How to create Excel federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Excel in MySQL .

• Connect to PayPal in the Denodo Platform

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

• Access Live Drift in TIBCO Data Virtualization

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

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

  Connect to Apache Hive from a connection pool in Tomcat.

• Power BI XMLA Reporting in OBIEE with the Power BI XMLA JDBC Driver

  Deploy the Power BI XMLA JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Analyze Azure Data Catalog with Power Pivot

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

• Connect to Google Contacts in RazorSQL

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

• Build Google Analytics Visualizations in Tableau Cloud

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

• Create Acumatica-Connected Dashboards in Grafana

  Connect to Acumatica via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to Acumatica ERP.

• Visualize Live SFTP in Tableau

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

• Enable the SurveyMonkey JDBC Driver in KNIME

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

• Import Sage 300 into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for Sage 300 and create custom reports in the Power BI Service.

• Connect to Live Azure Data Lake Storage in MicroStrategy through CData Connect Cloud

  Create a live connection to Azure Data Lake Storage in CData Connect Cloud and connect to your Azure Data Lake Storage from MicroStrategy.

• Enable the Twitter JDBC Driver in KNIME

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

• Build Visualizations of Amazon S3 in Birst

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

• «
• 88
• 89
• 90
• 91
• 92
• 93
• 94
• 95
• 96
• 97
• »