CData Software - Knowledge Base

Recent Articles

• «
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• »

• Connect to Zoho CRM from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Zoho CRM to connect to Zoho CRM and execute queries in PowerBuilder.

• Integrate with Oracle SCM using Apache Camel2

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

• Analyze SAP HANA XS Advanced with Power Pivot

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

• How to Visualize Avro Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Apache Avro in Python.

• Use the CData ODBC Driver for Greenhouse in Microsoft Power Query

  You can use the CData Greenhouse ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Greenhouse into Microsoft Power Query.

• Natively Connect to HarperDB in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to HarperDB. Leverage the native support for ODBC in PHP.

• Operational Reporting on xBase from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote xBase.

• Build Data Flows from SharePoint Excel Services to SQL Server using SSIS

  Easily back up SharePoint Excel Services to SQL Server using the SSIS components for SharePoint Excel Services.

• How to Seamlessly Import DB2 Data into IBM SPSS Modeler

  Integrate DB2 data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Connect to MongoDB in Aqua Data Studio

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

• Create Reports from Asana in Looker Studio

  Use CData Connect Cloud to gain access to live Asana and create custom reports in Looker Studio.

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

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

• Automated Continuous EventBrite Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable EventBrite replication to Microsoft Access.

• Integrate Real-Time Access to Active Directory in SAPUI5 MVC Apps

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

• Connect to Sage 50 UK in DBArtisan

  Use wizards in DBArtisan to configure Sage 50 UK as a data source.

• Create Gmail-Connected Dashboards in Grafana

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

• Connect to CSV as a Linked Server via CData Connect

  Use CData Connect to set up a linked server for CSV/TSV Files.

• ETL DocuSign in Oracle Data Integrator

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

• How to connect PolyBase to Marketo

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

• Automated Continuous Phoenix Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Phoenix replication to Google Cloud SQL.

• Visualize Live SAP Business One in the Power BI Service

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

• Easily Integrate SAP BusinessObjects BI in Lazarus Pascal IDE

  Learn how to easily integrate live SAP BusinessObjects BI in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

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

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

• DataBind Charts to EnterpriseDB

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to EnterpriseDB 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.

• Connect to Procore in JRuby

  Create a simple JRuby app with access to live Procore.

• Connect to xBase in Aqua Data Studio

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

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

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

• Connect to Paylocity in Ruby

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

• Connect to CockroachDB in DBArtisan

  Use wizards in DBArtisan to configure CockroachDB as a data source.

• Build Interactive Dashboards from Sybase in Amazon QuickSight

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

• How to Build Dynamic React Apps with Gmail

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

• LINQ to OneNote

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

• Use the CData Software JDBC Driver for Sage 200 in MicroStrategy

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

• Connect to Google Ad Manager in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Create Stripe-Connected Nintex Workflows

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

• Connect to NetSuite in RapidMiner

  Integrate NetSuite CRM & ERP with standard components and data source configuration wizards in RapidMiner Studio.

• How to Query QuickBooks Online in MySQL Workbench

  Execute MySQL queries against live QuickBooks Online from MySQL Workbench.

• Edit and Search External CockroachDB Objects in Salesforce Connect

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

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

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

• Prepare, Blend, and Analyze Google Cloud Storage in Alteryx Designer (ODBC)

  Build workflows to access live Google Cloud Storage for self-service data analytics.

• Object-Relational Mapping (ORM) with Adobe Commerce Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Adobe Commerce into a Java-based ORM framework, Hibernate.

• Build a Simple VCL Application for Veeva Vault

  How to build a simple VCL Application to view Veeva Vault & Vault CRM in RAD Studio using the CData ODBC Driver for Veeva Vault.

• Build DocuSign-Connected Apps in Bubble

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

• Create a Data Access Object for Act-On using JDBI

  A brief overview of creating a SQL Object API for Act-On in JDBI.

• Access Live Power BI XMLA in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Power BI XMLA from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Use the CData Software ODBC Driver for SAP Ariba Procurement in MicroStrategy

  Connect to SAP Ariba Procurement in MicroStrategy Developer using the CData Software ODBC Driver for SAP Ariba Procurement.

• Build Dashboards with ServiceNow in DBxtra

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

• Connect to Greenplum in RazorSQL

  Connect to Greenplum from wizards and query Pivotal GreenPlum from the GUI in the RazorSQL database management tool.

• Connect to Bitbucket from PowerBuilder via ADO.NET

  This article demonstrates how to access Bitbucket from Appeon PowerBuilder using the CData ADO.NET Provider for Bitbucket.

• Connect to GraphQL from PowerBuilder via JDBC

  This article demonstrates how to access GraphQL from PowerBuilder using the GraphQL JDBC Driver.

• Connect to Email as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Email.

• Edit and Search External AlloyDB Objects in Salesforce Connect

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

• Query SAP HANA XS Advanced in MySQL Workbench

  Create a virtual MySQL database for SAP HANA XS Advanced in CData Software Connect (or Connect Server) and work with live SAP HANA XS Advanced in MySQL Workbench.

• Automated Continuous Couchbase Replication to Vertica

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

• Query Act CRM as a MySQL Database in Node.js

  Execute MySQL queries against Act CRM from Node.js.

• Connect to and Visualize Live Azure Data Lake Storage in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Azure Data Lake Storage.

• Access JotForm in PHP through Connect Server

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

• Create Invoiced-Connected Visualizations in Klipfolio

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

• Access Live Backlog in Excel (Desktop) via Connect Cloud

  Use CData Connect Cloud to gain access to live Backlog from your Excel spreadsheets.

• Access Oracle SCM from MySQL in PHP

  Connect to Oracle SCM through the standard MySQL libraries in PHP.

• Printify Reporting in OBIEE with the Printify JDBC Driver

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

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

  Execute SQL Server queries against DocuSign from Node.js.

• Connect to Tableau CRM Analytics in Jaspersoft Studio

  Execute SQL to remote Tableau CRM Analytics in Jaspersoft Studio.

• Connect to Google Ads from AWS Glue

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

• How to Work with Microsoft Dataverse in ETL Validator JDBC

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

• Access Live Monday.com in AWS Lambda

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

• Establish a Live Connection with BigQuery using Tableau Bridge

  The CData ODBC Driver for BigQuery enables you to integrate live Google BigQuery into Tableau Cloud dashboards using the Tableau Bridge.

• Integrate with GitHub using Apache Camel2

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

• Automate ServiceNow Replication to Couchbase

  Use CData Sync to Customize and automate ServiceNow replication to Couchbase.

• Connect to XML in DBArtisan

  Use wizards in DBArtisan to configure XML Files as a data source.

• Integrate with live ShipStation in Jitterbit

  Use CData Connect Cloud to connect to and integrate live ShipStation in Jitterbit.

• Connect to Bing Ads in RazorSQL

  Connect to Bing Ads from wizards and query Bing Ads from the GUI in the RazorSQL database management tool.

• Import and Visualize Avalara AvaTax in Power View

  Create data visualizations based on Avalara AvaTax in Excel.

• Analyze Azure Table in Cognos Analytics

  Use CData Connect Cloud to connect to Azure Table from Cognos Analytics and analyze live Azure Table Storage.

• How to Seamlessly Import SAP SuccessFactors Data into IBM SPSS Modeler

  Integrate SAP SuccessFactors data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Build Apps with Live Backlog in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live Backlog into the Adalo platform and build custom mobile and web applications with real-time Backlog.

• Publish SAS Data Sets-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live SAS Data Sets.

• Extract, Transform, and Load Calendly in Informatica PowerCenter

  Create a simple Workflow for Calendly in Informatica PowerCenter.

• How to create Amazon DynamoDB federated tables in MySQL

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

• How to pipe Azure DevOps to CSV in PowerShell

  Use standard PowerShell cmdlets to access Azure DevOps tables.

• Connect to ClickUp in the Denodo Platform

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

• Import Real-Time Greenhouse via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Greenhouse in ColdFusion.

• Edit and Search External Instagram Objects in Salesforce Connect

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

• Explore Geographical Relationships in Sage 50 UK with Power Map

  Create data visualizations with Sage 50 UK in Power Map.

• Build Confluence Visualizations in Tableau Desktop

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

• Connect to Microsoft OneDrive in NetBeans

  Connect to Microsoft OneDrive in NetBeans with the data source configuration wizard.

• Creating Oracle Financials Cloud-Connected Applications in Unqork

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

• Create Freshdesk-Connected Visualizations in Klipfolio

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

• Automated Continuous CockroachDB Replication to SQLite

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

• Connect to Live Oracle in MicroStrategy through CData Connect Cloud

  Create a live connection to Oracle in CData Connect Cloud and connect to your Oracle Database from MicroStrategy.

• Automated Continuous Oracle SCM Replication to Amazon S3

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

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

  Provide connectivity to CockroachDB through an SAP BusinessObjects universe.

• Connect to Facebook as an External Source in Dremio

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

• Create Amazon S3-Connected Dashboards in Grafana

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

• Query WooCommerce in ColdFusion

  Write standard ColdFusion data access code to connect to WooCommerce.

• Automate SAP Replication to Couchbase

  Use CData Sync to Customize and automate SAP ERP/NetWeaver replication to Couchbase.

• Connect to Google Calendar in RunMyProcess through Connect Cloud

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

• Integrate SFTP with External Services using SnapLogic

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

• Integrate Live Amazon DynamoDB into Amazon SageMaker Canvas with RDS

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

• Query Wave Financial as a SQL Server in Node.js

  Execute SQL Server queries against Wave Financial from Node.js.

• «
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• »