CData Software - Knowledge Base

Recent Articles

• «
• 237
• 238
• 239
• 240
• 241
• 242
• 243
• 244
• 245
• 246
• »

• LINQ to Gmail

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

• Create CockroachDB Reports on JasperReports Server

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

• Integrate Outreach.io into Power Automate Desktop using CData Connect

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

• Import Confluence into FileMaker Pro

  Create reports that integrate Atlassian Confluence in Filemaker Pro.

• Working with SAP HANA in LINQPad

  Execute LINQ queries to SAP HANA in LINQPad.

• Analyze SAP BusinessObjects BI in R

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

• Integrate Google Ad Manager in the Pentaho Report Designer

  Publish reports based on Google Ad Manager in the Pentaho BI tool.

• Connect to Typeform from a Connection Pool in JBoss

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

• Create Apps from Marketo in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Marketo and build apps from live Marketo in Qlik Sense Cloud.

• How to Connect DBeaver to Microsoft Teams via a JDBC Driver

  Manage Microsoft Teams with visual tools in DBeaver like the query browser.

• Connect to Teradata as a Linked Server

  Use CData Connect to set up a linked server for Teradata.

• Query, Visualize, and Share live Oracle Sales in Redash

  Use CData Connect Cloud to connect to live Oracle Sales in Redash for querying, visualizing, and sharing.

• Use Biml to Build SSIS Tasks to Replicate Paylocity to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Paylocity to SQL Server.

• Query Trello as a MySQL Database in Node.js

  Execute MySQL queries against Trello from Node.js.

• Write a Simple Go Application to work with Coinbase on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Coinbase.

• Access SAS xpt from MySQL in Amazon QuickSight

  Connect to SAS xpt and build visualizations of SAS XPORT using a MySQL Connection in Amazon QuickSight.

• Build Charts with Oracle Service Cloud in Clear Analytics

  Create dynamic charts and perform analytics based on Oracle Service Cloud in Clear Analytics.

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

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

• Automated Continuous Authorize.Net Replication to Apache Kafka

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

• Bridge Databricks Connectivity with Apache NiFi

  Access and process Databricks in Apache NiFi using the CData JDBC Driver.

• How to load Odoo data into Elasticsearch via Logstash

  Introducing a simple method to load Odoo data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Connect to Drift in JRuby

  Create a simple JRuby app with access to live Drift.

• Create Freshdesk-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Freshdesk from Klipfolio and build custom visualizations using live Freshdesk.

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

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

• Bidirectional Access to Amazon Athena from FileMaker Pro

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

• How to connect to IBM Informix from IntelliJ

  Integrate connectivity to IBM Informix with wizards in IntelliJ.

• Publish Zoom-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Zoom.

• Automated Continuous ConstantContact Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable ConstantContact replication to PostgreSQL.

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

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

• Connect to Amazon Athena in Ruby

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

• Build Charts with MongoDB in Clear Analytics

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

• Visualize Live Microsoft OneDrive in the Power BI Service

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

• Viewing Greenhouse in RAD Studio Data Explorer

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

• Build Automated Excel Online-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live Microsoft Excel Online and build automated workflows in Zapier.

• Create Informatica Mappings From/To an ODBC Data Source for SAP ByDesign

  Create an ODBC connection to SAP ByDesign in Informatica and browse and transfer SAP Business ByDesign.

• Automated IBM Cloud Object Storage Replication to Teradata

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

• Connect to MySQL as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live MySQL.

• Integrate SuiteCRM in Your Informatica Cloud Instance

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

• How to Connect to Zoho Inventory in Using Python: 6 Steps

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

• A PostgreSQL Interface for Dynamics GP

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

• Add xBase to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for xBase with the Informatica Enterprise Data Catalog to classify and organize data.

• Build Dashboards with Zoom in Dundas BI

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

• Create a Data Access Object for Marketo using JDBI

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

• Build Dashboards with JotForm in DBxtra

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

• Automated Continuous Zoho Books Replication to SQLite

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

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

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

• LINQ to SurveyMonkey

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

• Connect to Kintone in NetBeans

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

• DataBind Charts to Jira Assets

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Jira Assets from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• Manage Act-On in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Act-On.

• How to Connect DBeaver to xBase via a JDBC Driver

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

• Connect to Instagram in JRuby

  Create a simple JRuby app with access to live Instagram.

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

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

• Connect to SAP HANA XS Advanced in JRuby

  Create a simple JRuby app with access to live SAP HANA XS Advanced.

• Access Act CRM as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Act CRM from your Oracle system.

• Load ClickUp to a Database Using Embulk

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

• Connect to Tableau CRM Analytics in the Denodo Platform

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

• Query Highrise in DataGrip

  Create a Data Source for Highrise in DataGrip and use SQL to query live Highrise CRM.

• Visualize Spark in TIBCO Spotfire through ODBC

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

• Connect to HubDB in the Denodo Platform

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

• Connect to Google Data Catalog in the Denodo Platform

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

• Build Dashboards with Azure Data Lake Storage in Dundas BI

  Create dynamic dashboards and perform analytics based on Azure Data Lake Storage in Dundas BI.

• Automated Continuous Microsoft Teams Replication to MongoDB

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

• Automated Continuous Google Directory Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Google Directory replication to delimited files (CSV/TSV).

• Connect to Jira through External Services in Salesforce

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

• Integrate with YouTube Analytics using Apache Camel2

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

• Use the CData ODBC Driver for MYOB AccountRight from SharePoint Excel Services

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

• How to connect to SAS Data Sets with Squirrel SQL client

  Connect to SAS Data Sets and execute queries in the Squirrel SQL Client.

• A PostgreSQL Interface for Zoho Books

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

• How to connect to Confluence in DBVisualizer

  Integrate Atlassian Confluence with visual data analysis tools and data connection wizards in DBVisualizer

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

  Provide connectivity to Gmail through an SAP BusinessObjects universe.

• Use the CData ODBC Driver for Instagram in SAS JMP

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

• How to connect to Sugar CRM from IntelliJ

  Integrate connectivity to Sugar CRM with wizards in IntelliJ.

• Acumatica Reporting and Star Schemas in OBIEE

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

• Access Redis from MySQL in Amazon QuickSight

  Connect to Redis and build visualizations of Redis using a MySQL Connection in Amazon QuickSight.

• Query LinkedIn Ads in DataGrip

  Create a Data Source for LinkedIn Ads in DataGrip and use SQL to query live LinkedIn Ads.

• Create SSAS Tabular Models from Parquet

  How to build a SQL Server Analysis Service Tabular Model from Apache Parquet using CData drivers.

• How to integrate Okta with Apache Airflow

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

• Connect to WooCommerce in Ruby

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

• Create SSAS Tabular Models from SAS Data Sets

  How to build a SQL Server Analysis Service Tabular Model from SAS Data Sets using CData drivers.

• How to connect to Printify with Squirrel SQL client

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

• Build Pipelines with Live Oracle HCM Cloud in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Oracle HCM Cloud from Google Cloud Data Fusion, enabling the integration of live Oracle HCM Cloud into the building and management of effective data pipelines.

• Connect to Monday.com from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Monday.com from Crystal Reports.

• Query Reckon Accounts Hosted as a MySQL Database in Node.js

  Execute MySQL queries against Reckon Accounts Hosted from Node.js.

• Automated Active Directory Replication to Teradata

  Use CData Sync to Customize and automate Active Directory replication to Teradata.

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

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

• Query Epicor Kinetic in DataGrip

  Create a Data Source for Epicor Kinetic in DataGrip and use SQL to query live Epicor Kinetic.

• Integrate Live Redshift into Amazon SageMaker Canvas with RDS

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

• Connect to Instagram in Ruby

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

• DataBind PostgreSQL to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for PostgreSQL with the DevExpress Windows Forms and Web controls to provide PostgreSQL to a chart.

• Connect to CockroachDB from a Connection Pool in Jetty

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

• Connect to Salesforce Marketing from a Connection Pool in Jetty

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

• PowerShell Scripting to Replicate Facebook to MySQL

  Write a simple PowerShell script to replicate Facebook to a MySQL database.

• Visualize BambooHR in TIBCO Spotfire through ADO.NET

  Integrate BambooHR into dashboards in TIBCO Spotfire.

• A PostgreSQL Interface for Azure Synapse

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

• Access Live HBase in AWS Lambda

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

• Integrating Outreach.io in Talend Cloud Data Management Platform

• «
• 237
• 238
• 239
• 240
• 241
• 242
• 243
• 244
• 245
• 246
• »