CData Software - Knowledge Base

Recent Articles

• «
• 311
• 312
• 313
• 314
• 315
• 316
• 317
• 318
• 319
• 320
• »

• Connect to SAP SuccessFactors in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for SAP SuccessFactors in Airbyte.

• Design BIRT Reports on Google Drive

  Provide current Google Drive to your embedded analytics.

• Visualize Live Microsoft Exchange in the Power BI Service

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

• Bridge Workday Connectivity with Apache NiFi

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

• Automated Continuous MariaDB Replication to Google Cloud SQL

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

• Asana Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Asana through CData Connect Cloud using different applications and tools.

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

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

• ServiceNow Reporting in OBIEE with the ServiceNow JDBC Driver

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

• Visualize Live Airtable in Tableau

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

• Connect to Snapchat Ads from PowerBuilder

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

• Connect to and Query Microsoft Teams in QlikView over ODBC

  Create data visualizations with Microsoft Teams in QlikView.

• PowerShell Scripting to Replicate Google Search Results to MySQL

  Write a simple PowerShell script to replicate Google Search to a MySQL database.

• ETL Act CRM in Oracle Data Integrator

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

• Create Unbounce-Connected Business Apps in AppSheet

  Use CData Software Connect Server to connect to Unbounce from AppSheet and build custom business apps using live Unbounce.

• Connect to QuickBooks in JRuby

  Create a simple JRuby app with access to live QuickBooks Desktop.

• Bridge HubDB Connectivity with Apache NiFi

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

• Enable the Oracle Service Cloud JDBC Driver in KNIME

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

• Import Epicor Kinetic into the Power BI Service for Visualizations

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

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

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

• Connect to SFTP in the Denodo Platform

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

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

  Create an ODBC connection to Airtable in Informatica and browse and transfer Airtable.

• DataBind Charts to Oracle Financials Cloud

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle Financials Cloud 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 Tableau CRM Analytics from PowerBuilder

  This article demonstrates how to access Tableau CRM Analytics from PowerBuilder using the Tableau CRM Analytics JDBC Driver.

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

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

• Build an OLAP Cube in SSAS from Jira Service Management

  Establish a connection to Atlassian Jira Service Management data from SQL Server Analysis Services, and use the Jira Service Management Data Provider to build OLAP cubes for use in analytics and reporting.

• Create Bing Ads-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Bing Ads from OutSystems and build custom enterprise apps using live Bing Ads.

• Stream Bitbucket into Apache Kafka Topics

  Access and stream Bitbucket in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Use the CData Software ODBC Driver for Azure Synapse in MicroStrategy

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

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

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

• Deploy the ADO.NET Provider for Jira Service Management on an SSRS Report Server

  Connect to Atlassian Jira Service Management 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.

• Access Zoho CRM in PHP through Connect Server

  Connect to Zoho CRM through the standard SQL Server libraries in PHP.

• How to Import SuiteCRM into SQL Server using SSIS

  Easily back up SuiteCRM to SQL Server using the SSIS components for SuiteCRM.

• Connect to and Query SAS xpt in QlikView over ODBC

  Create data visualizations with SAS XPORT in QlikView.

• How to Connect to & Open SAP HANA in Microsoft Excel

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

• Object-Relational Mapping (ORM) with Access 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 Microsoft Access into a Java-based ORM framework, Hibernate.

• Automated Continuous ServiceNow Replication to Apache Cassandra

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

• Use the CData Software JDBC Driver for Authorize.Net in MicroStrategy Desktop

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

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

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

• Visualize Amazon Athena from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Amazon Athena.

• Automated Continuous Dynamics NAV Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable Dynamics NAV replication to Azure SQL.

• Prepare, Blend, and Analyze SAS xpt in Alteryx Designer

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

• Query Asana through ODBC in Node.js

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

• Connect to CockroachDB through External Services in Salesforce

  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.

• Query Oracle HCM Cloud in MySQL Workbench

  Create a virtual MySQL database for Oracle HCM Cloud in CData Software Connect (or Connect Server) and work with live Oracle HCM Cloud in MySQL Workbench.

• Connect to Active Directory from PowerBuilder

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

• Natively Connect to Printful in PHP

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

• How to Work with Amazon Marketplace in AWS Glue Jobs Using JDBC

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

• Visualize Dropbox in TIBCO Spotfire through ADO.NET

  Integrate Dropbox into dashboards in TIBCO Spotfire.

• Prepare, Blend, and Analyze Google Directory in Alteryx Designer

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

• Connect to Avro in CloverDX (formerly CloverETL)

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

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

  Provide connectivity to Eventbrite through an SAP BusinessObjects universe.

• How to connect to Twitter Ads from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for Twitter Ads and work with Twitter Ads in Microsoft Excel on Mac OS X.

• Connect to Blackbaud FE NXT in Google Apps Script

  Use CData Connect Cloud to access Blackbaud FE NXT in Google Apps Script.

• Object-Relational Mapping (ORM) with Power BI XMLA 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 Power BI XMLA into a Java-based ORM framework, Hibernate.

• Connect to EventBrite in RapidMiner

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

• Visualize Oracle in TIBCO Spotfire through ODBC

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

• Integrate MongoDB in Your Informatica Cloud Instance

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

• Integrate Tableau CRM Analytics into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Tableau CRM Analytics and integrate live Tableau CRM Analytics into your Power Automate tasks.

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

  Connect to NetSuite CRM & ERP 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 to Zoho CRM in Using Python: 6 Steps

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

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

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

• Publish Avro-Connected Dashboards in Tableau Server

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

• Access Live Google Search Results in Google Sheets

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

• Integrate with Google Calendar in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Google Calendar in SnapLogic.

• Natively Connect to Oracle SCM in PHP

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

• Query Sugar CRM in ColdFusion

  Write standard ColdFusion data access code to connect to Sugar CRM.

• Automated Continuous Clio Replication to SingleStore

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

• Export Data from SQL Server to Zendesk through SSIS

  Easily push SQL Server data to Zendesk using the CData SSIS Tasks for Zendesk.

• Access Live Asana in AWS Lambda

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

• Working with SAP SuccessFactors in LINQPad

  Execute LINQ queries to SAP SuccessFactors in LINQPad.

• Import and Visualize Phoenix in Power View

  Create data visualizations based on Apache Phoenix in Excel.

• Import and Visualize QuickBooks in Power View

  Create data visualizations based on QuickBooks Desktop in Excel.

• Analyze OneNote in R

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

• How to publish and share Sage 50 UK dashboards with Tableau Server

  The CData ODBC driver for Sage 50 UK enables you integrate Sage 50 UK into Tableau dashboards.

• Replicate Multiple Act-On Accounts

  Replicate multiple Act-On accounts to one or many databases.

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

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

• Connect to Okta in RazorSQL

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

• Import SAP Ariba Procurement into FileMaker Pro

  Create reports that integrate SAP Ariba Procurement in Filemaker Pro.

• Visualize Live Shippo in Tableau

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

• DataBind Controls to Invoiced in C++Builder

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

• Build REST-Connected ETL Processes in Google Data Fusion

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

• Automated Continuous Power BI XMLA Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Snowflake.

• Create SSAS Tabular Models from LinkedIn

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

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

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

• Publish Reports with SharePoint Excel Services in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date SharePoint Excel Services.

• Validate TigerGraph with QuerySurge

  Access and validate TigerGraph in QuerySurge using the CData JDBC Driver.

• Access LinkedIn from MySQL in Amazon QuickSight

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

• Integrating SharePoint in Talend Cloud Data Management Platform

• «
• 311
• 312
• 313
• 314
• 315
• 316
• 317
• 318
• 319
• 320
• »