CData Software - Knowledge Base

Recent Articles

• «
• 204
• 205
• 206
• 207
• 208
• 209
• 210
• 211
• 212
• 213
• »

• Integrate Real-Time Access to SAP Hybris C4C in SAPUI5 MVC Apps

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

• How to Query MongoDB in MySQL Workbench

  Execute MySQL queries against live MongoDB from MySQL Workbench.

• Analyze ShipStation in Cognos Analytics

  Use CData Connect Cloud to connect to ShipStation from Cognos Analytics and analyze live ShipStation.

• Connect to Microsoft Dataverse in Google Apps Script

  Use CData Connect Cloud to access Microsoft Dataverse (CDS) in Google Apps Script.

• How to connect to NetSuite in DBVisualizer

  Integrate NetSuite CRM & ERP with visual data analysis tools and data connection wizards in DBVisualizer

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

  Provide connectivity to Acumatica ERP through an SAP BusinessObjects universe.

• View Reports on Real-Time Blackbaud FE NXT in Power BI Report Server

  Use the CData ODBC Driver for Blackbaud FE NXT to visualize Blackbaud FE NXT in Power BI Desktop and then publish them to Power BI Report Server.

• Publish IBM Cloud Data Engine-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live IBM Cloud Data Engine.

• Automated Continuous DB2 Replication to Google Cloud SQL

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

• Query, Visualize, and Share live eBay in Redash

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

• Automated Continuous Google Ad Manager Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Snowflake.

• Analyze Reckon Accounts Hosted in R

  Use standard R functions and the development environment of your choice to analyze Reckon Accounts Hosted with the CData JDBC Driver for Reckon Accounts Hosted.

• How to Connect DBeaver to XML via a JDBC Driver

  Manage XML Files with visual tools in DBeaver like the query browser.

• Create Reports with Dropbox in SAP Crystal Reports

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

• Automated Continuous Office 365 Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Office 365 replication to Google BigQuery.

• Create Greenhouse Reports on JasperReports Server

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

• Replicate Certinia for Use in Salesforce Connect

  Replicate Certinia to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Integrate Oracle SCM into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Oracle SCM and integrate live Oracle SCM into your Power Automate tasks.

• Connect to Kintone in RunMyProcess through Connect Cloud

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

• Query FTP in ColdFusion

  Write standard ColdFusion data access code to connect to FTP Servers.

• Import Okta into FileMaker Pro

  Create reports that integrate Okta in Filemaker Pro.

• Integrate Twitter Ads into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Twitter Ads and integrate live Twitter Ads into your Power Automate tasks.

• Import Snapchat Ads into the Power BI Service for Visualizations

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

• How to Import MySQL into SQL Server using SSIS

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

• Build Semantic Layer Views for Facebook in APOS Live Data Gateway

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

• Automated Continuous Smartsheet Replication to MongoDB

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

• Connect to Instagram as a Linked Server

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

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

• Access Harvest from MySQL in PHP

  Connect to Harvest through the standard MySQL libraries in PHP.

• Automated Continuous ShipStation Replication to Snowflake

  Use CData Sync for automated, continuous, customizable ShipStation replication to Snowflake.

• Import and Visualize MongoDB in Power View

  Create data visualizations based on MongoDB in Excel.

• Model, Search, and Visualize Live Azure DevOps in ThoughtSpot

  Use CData Connect Cloud to connect to live Azure DevOps for modeling, searching, and visualizing.

• Automated Continuous ShipStation Replication to Amazon S3

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

• Integrate HDFS with External Services using SnapLogic

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

• Access Live IBM Cloud Object Storage in AWS Lambda (with IntelliJ IDEA)

  Connect to live IBM Cloud Object Storage in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Build Jira Visualizations in Tableau Cloud

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

• Integrate Live MYOB AccountRight into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to MYOB AccountRight and integrate live MYOB AccountRight into apps built in Microsoft Power Apps.

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

• Write a Simple Go Application to work with Monday.com on Linux

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

• Natively Connect to Sage Cloud Accounting in PHP

  Create PHP applications on Linux/UNIX machines with connectivity to Sage Business Cloud Accounting. Leverage the native support for ODBC in PHP.

• Analyze Snapchat Ads in Infragistics Reveal

  Use CData Connect Cloud to create on OData API on top of Snapchat Ads and visualize live Snapchat Ads in Infragistics Reveal.

• How to Query MailChimp in MySQL Workbench

  Execute MySQL queries against live MailChimp from MySQL Workbench.

• Automated Continuous EnterpriseDB Replication to MySQL

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

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

• Automated Continuous GitHub Replication to MongoDB

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

• Integrate Live Power BI XMLA into Amazon SageMaker Canvas with RDS

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

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

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

• Build an OLAP Cube in SSAS from Oracle Service Cloud

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

• Integrate Drift into Automated Tasks with Power Automate

  Use CData Software Connect Server to create a virtual SQL Server database for Drift and integrate live Drift into your Power Automate (Microsoft Flow) tasks.

• Connect to OData Services in NetBeans

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

• Connect to Google Sheets in CloverDX (formerly CloverETL)

  Transfer Google Sheets using the visual workflow in the CloverDX data integration tool.

• Connect to Live eBay in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to eBay in CData Connect Cloud and connect to your eBay from PostgreSQL.

• View Reports on Real-Time HubSpot in Power BI Report Server

  Use the CData ODBC Driver for HubSpot to visualize HubSpot in Power BI Desktop and then publish them to Power BI Report Server.

• Create Informatica Mappings From/To an ODBC Data Source for Azure Analysis Services

  Create an ODBC connection to Azure Analysis Services in Informatica and browse and transfer Azure Analysis Services.

• Build BigCommerce Visualizations in Tableau Cloud

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

• Access Live Microsoft Dataverse in AWS Lambda

  Connect to live Microsoft Dataverse (CDS) in AWS Lambda using the CData JDBC Driver.

• Build Dashboards with SAP BusinessObjects BI in DBxtra

  Create dynamic dashboards and perform analytics based on SAP BusinessObjects BI in DBxtra.

• How to use SQLAlchemy ORM to access Bullhorn CRM in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Bullhorn CRM.

• How to Import Cloudant into SQL Server using SSIS

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

• Connect to SharePoint Excel Services as a Linked Server

  Use CData Connect to set up a linked server for SharePoint Excel Services.

• How to Access Live MarkLogic in Power Automate Desktop via ODBC

  The CData ODBC Driver for MarkLogic enables you to integrate MarkLogic into workflows built using Microsoft Power Automate Desktop.

• Connect to and Query Parquet in QlikView over ODBC

  Create data visualizations with Apache Parquet in QlikView.

• Back Up Azure Data Lake Storage to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Azure Data Lake Storage. In this article, we will employ an SSIS workflow to populate a database with Azure Data Lake Storage data.

• Create Apps from Amazon DynamoDB in Qlik Sense Cloud

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

• Create Reports from HCL Domino in Looker Studio

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

• Import CockroachDB Using Azure Data Factory

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

• DataBind Controls to Oracle Service Cloud in Delphi

  DataBind to Oracle Service Cloud in Delphi with standard data access components and controls.

• Create Data Visualizations Based On Facebook Ads in Mode

  Use CData Connect Cloud to connect to Facebook Ads from Mode and build visualizations using live

• Connect to Google Data Catalog in RazorSQL

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

• Manage Dropbox in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Dropbox.

• DataBind Charts to Twilio

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

• Create Datasets from ADP in Domo Workbench and Build Visualizations of ADP in Domo

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

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

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

• Access Snapchat Ads from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Snapchat Ads from HeidiSQL.

• Connect to and Visualize Live ActiveCampaign in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live ActiveCampaign.

• DataBind Charts to Microsoft Project

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

• How to connect to Google Search Results from Spring Boot

  Connect to Google Search in a Spring Boot Application using CData JDBC Google Search Driver

• Create Data Visualizations in Cognos BI with Excel Online

  Access Microsoft Excel Online as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

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

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

• Query WordPress in DataGrip

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

• How to Work with Azure Data Lake Storage in AWS Glue Jobs Using JDBC

  Connect to Azure Data Lake Storage from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Integrate FTP into Automated Tasks with Power Automate

  Use CData Software Connect Server to create a virtual SQL Server database for FTP Servers and integrate live FTP Servers into your Power Automate (Microsoft Flow) tasks.

• Automated Continuous Impala Replication to Amazon Redshift

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

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

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

• Use the Connect Server to Access Box in Microsoft Power Pivot

  Use the Connect Server to connect to live Box in the Power Pivot business intelligence tool.

• Prepare, Blend, and Analyze EnterpriseDB in Alteryx Designer

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

• How to connect to ConstantContact from MS Excel on Mac OS X

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

• Connect to Azure DevOps in Google Apps Script

  Use CData Connect Cloud to access Azure DevOps in Google Apps Script.

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

  Provide connectivity to ActiveCampaign through an SAP BusinessObjects universe.

• Import Real-Time Procore in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Procore in ColdFusion.

• Create Kintone-Connected Enterprise Applications in OutSystems

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

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

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

• Build Oracle Eloqua-Connected ETL Processes in Google Data Fusion

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

• Automate Oracle Service Cloud Replication to Azure Synapse

  Use CData Sync to customize and automate Oracle Service Cloud replication to Azure Synapse.

• Connect to Twilio in Google Apps Script

  Use the ODBC Driver for Twilio and the SQL Gateway to access Twilio from Google Apps Script.

• Automated Continuous Google Sheets Replication to MySQL

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

• Connect to BambooHR as a Linked Server

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

• Analyze Impala with Power Pivot

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

• Use JayDeBeApi to access Amazon S3 in Python

  Use standard Python scripting and the development environment of your choice to access live Amazon S3.

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

  Provide connectivity to HubDB through an SAP BusinessObjects universe.

• «
• 204
• 205
• 206
• 207
• 208
• 209
• 210
• 211
• 212
• 213
• »