CData Software - Knowledge Base

Recent Articles

• «
• 551
• 552
• 553
• 554
• 555
• 556
• 557
• 558
• 559
• 560
• »

• Connect to Pinterest from a Connection Pool in Jetty

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

• A PostgreSQL Interface for Google Sheets (MySQL Remoting via JDBC)

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

• Create Informatica Mappings From/To an ODBC Data Source for Azure Data Lake Storage

  Create an ODBC connection to Azure Data Lake Storage in Informatica and browse and transfer Azure Data Lake Storage.

• Connect to Oracle Financials Cloud in RazorSQL

  Connect to Oracle Financials Cloud from wizards and query Oracle Financials Cloud from the GUI in the RazorSQL database management tool.

• Automate Phoenix Replication to Azure Data Lake

  Use CData Sync to customize and automate Apache Phoenix replication to Azure Data Lake.

• Build Visualizations of PingOne in Birst

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

• Integrate SAP SuccessFactors into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to SAP SuccessFactors and integrate live SAP SuccessFactors into your Power Automate tasks.

• Analyze SAP Ariba Procurement with Power Pivot

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

• How to Work with Aha in ETL Validator JDBC

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

• Working with Avro in LINQPad

  Execute LINQ queries to Apache Avro in LINQPad.

• Access Calendly from MySQL in Amazon QuickSight

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

• Connect to Live Power BI XMLA in MicroStrategy through CData Connect Cloud

  Create a live connection to Power BI XMLA in CData Connect Cloud and connect to your Power BI XMLA from MicroStrategy.

• Automated Continuous Twitter Replication to PostgreSQL

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

• Connect to Pinterest in SpagoBI

  Create reports featuring live Pinterest in SpagoBI Studio. Host Pinterest reports on SpagoBI Server.

• Operational Reporting on Google Ad Manager from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Google Ad Manager.

• Migrating data from CockroachDB to Snowflake using CData SSIS Components.

  Easily push CockroachDB to Snowflake using the CData SSIS Tasks for CockroachDB and Snowflake.

• Connect to Sage Intacct in Aqua Data Studio

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

• Connect to Microsoft Dataverse in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

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

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

• How to Query ShipStation in MySQL Workbench

  Execute MySQL queries against live ShipStation from MySQL Workbench.

• Edit and Search External Amazon S3 Objects in Salesforce Connect

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

• Manage Redis in DBArtisan as a JDBC Source

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

• Google Campaign Manager 360 Cloud Connectivity

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

• Building Dynamic Web Pages with Google Cloud Storage Using AngularJS

  Create single-page applications with live connectivity to Google Cloud Storage using the CData API Server.

• How to Create Power BI Visual Reports with Real-Time Zoom

  Use CData Power BI Connectors to visualize Zoom in Power BI.

• Operational Reporting on DB2 from Spotfire Server

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

• Access Exact Online as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Exact Online from your Oracle system.

• Automated Continuous Azure Synapse Replication to Amazon Redshift

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

• CData Sync Truncation Errors

  This entry covers the cause of truncation errors as well as various solutions to resolve them.

• SAP SuccessFactors Cloud Connectivity

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

• Replicate Multiple Sybase Accounts

  Replicate multiple Sybase accounts to one or many databases.

• How to Connect the Power BI Service to Google Data Catalog: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• Edit and Search External Adobe Analytics Objects in Salesforce Connect

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

• Create Data Visualizations in Cognos BI with Act-On

  Access Act-On as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• How to create Visio diagrams from Basecamp

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

• ETL Freshdesk in Oracle Data Integrator

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

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

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

• Process & Analyze SendGrid in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live SendGrid .

• Model, Search, and Visualize Live MYOB AccountRight in ThoughtSpot

  Use CData Connect Cloud to connect to live MYOB AccountRight for modeling, searching, and visualizing.

• How to Query Reckon Accounts Hosted in MySQL Workbench

  Execute MySQL queries against live Reckon Accounts Hosted from MySQL Workbench.

• Query SharePoint Excel Services as a MySQL Database in Node.js

  Execute MySQL queries against SharePoint Excel Services from Node.js.

• How to connect to OneNote from IntelliJ

  Integrate connectivity to Microsoft OneNote with wizards in IntelliJ.

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

• How to Query Live SAP ByDesign Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live SAP Business ByDesign data in natural language using Python.

• Create GMO MakeShop-Connected Nintex Workflows

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

• Connect Presto to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Presto using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Connect to SAP Ariba Procurement in RazorSQL

  Connect to SAP Ariba Procurement from wizards and query SAP Ariba Procurement from the GUI in the RazorSQL database management tool.

• How to connect and process Aha from Azure Databricks

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

• Establish a Live Connection with Spark using Tableau Bridge

  The CData ODBC Driver for Spark enables you to integrate live Apache Spark SQL into Tableau Cloud dashboards using the Tableau Bridge.

• How to connect and process CouchDB from Azure Databricks

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

• How to Seamlessly Import Snapchat Ads Data into IBM SPSS Modeler

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

• Azure DevOps Cloud Connectivity

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

• Analyze MySQL with Power Pivot

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

• Create Odoo Reports on JasperReports Server

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

• Design BIRT Reports on Act CRM

  Provide current Act CRM to your embedded analytics.

• Build Dashboards with Tableau CRM Analytics in Dundas BI

  Create dynamic dashboards and perform analytics based on Tableau CRM Analytics in Dundas BI.

• Access Live Zendesk in TIBCO Data Virtualization

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

• Query Azure Synapse in ColdFusion

  Write standard ColdFusion data access code to connect to Azure Synapse.

• How to Connect to Excel in Using Python: 6 Steps

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

• Automated Continuous Sybase Replication to SingleStore

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

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

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

• Access Live SAP ByDesign in Excel (Desktop) via Connect Cloud

  Use CData Connect Cloud to gain access to live SAP Business ByDesign from your Excel spreadsheets.

• Visualize REST in Tableau

  The CData ODBC driver for REST enables you integrate REST into Tableau dashboards.

• Query Microsoft Exchange from Node.js

  Use the OData endpoint of the CData API Server to connect to your Microsoft Exchange and perform CRUD operations on Microsoft Exchange from Node.js.

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

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

• Connect to SharePoint in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Automated Continuous GitHub Replication to Google Cloud SQL

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

• How to use SQLAlchemy ORM to access Teradata in Python

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

• Automated Continuous Printful Replication to MySQL

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

• Create a Data Access Object for Todoist using JDBI

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

• Automate Facebook Ads Replication to Azure Data Lake

  Use CData Sync to customize and automate Facebook Ads replication to Azure Data Lake.

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

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

• Extract, Transform, and Load Hive in Informatica PowerCenter

  Create a simple Workflow for Apache Hive in Informatica PowerCenter.

• Integrate Live Bing Ads into Custom Business Apps Built in Power Apps

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

• How to Import Data from LDAP into Google Sheets

  Import LDAP into a Google spreadsheet that is automatically refreshed.

• Connect to Microsoft Exchange as a Linked Server via SQL Gateway

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

• Visualize Jira in Sisense

  Create an ElastiCube in Sisense app with access to Atlassian Jira.

• How to integrate Metabase with ShipStation

  Use CData Connect Cloud to connect to live ShipStation and create an interactive dashboard in Metabase from ShipStation.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed Certinia to Power BI dashboards. Simply drag and drop Certinia into data visuals on the Power BI canvas.

• Import Sybase IQ into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Sybase IQ. In this article, you will use the OData format to import Sybase IQ into Microsoft Power Query.

• Prepare, Blend, and Analyze IBM Cloud Data Engine in Alteryx Designer (ODBC)

  Build workflows to access live IBM Cloud Data Engine for self-service data analytics.

• Add SAP HANA XS Advanced to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for SAP HANA XS Advanced with the Informatica Enterprise Data Catalog to classify and organize data.

• Extend Google Sheets with OneNote

  Make calls to the API Server from Google Apps Script.

• Build Microsoft Project-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Microsoft Project from Zoho Analytics and import live Microsoft Project.

• Excel Spreadsheet Automation on SAP HANA XS Advanced with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Connect to IBM Cloud Object Storage in the Denodo Platform

  Use CData driver technologies to create a virtual data source for IBM Cloud Object Storage in the Denodo Virtual DataPort Administrator.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed MariaDB to Power BI dashboards. Simply drag and drop MariaDB into data visuals on the Power BI canvas.

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

  Create an ODBC connection to XML in Informatica and browse and transfer XML Files.

• Integrate Confluence in Pentaho Data Integration

  Build ETL pipelines based on Atlassian Confluence in the Pentaho Data Integration tool.

• Use the CData Software ODBC Driver for Greenplum in MicroStrategy Web

  Connect to Pivotal GreenPlum in MicroStrategy Web using the CData Software ODBC Driver for Greenplum.

• Visualize Azure Data Catalog in TIBCO Spotfire through OData

  Integrate Azure Data Catalog into dashboards in TIBCO Spotfire.

• Connect to Raisers Edge NXT from PowerBuilder via JDBC

  This article demonstrates how to access Raisers Edge NXT from PowerBuilder using the Raisers Edge NXT JDBC Driver.

• How to Visualize Tally Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Tally ERP in Python.

• Using the CData Software ODBC Driver for Elasticsearch in PyCharm

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

• Build Aha-Connected ETL Processes in Google Data Fusion

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

• Replicate Salesloft to Multiple Databases

  Replicate Salesloft to disparate databases with a point-and-click configuration.

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

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

• DataBind Spark to the DevExpress Data Grid

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

• Create Data Visualizations Based On Oracle HCM Cloud in Mode

  Use CData Connect Cloud to connect to Oracle HCM Cloud from Mode and build visualizations using live

• Use the CData Software JDBC Driver for Amazon DynamoDB in MicroStrategy

  Connect to Amazon DynamoDB in MicroStrategy Developer using the CData Software JDBC Driver for Amazon DynamoDB.

• «
• 551
• 552
• 553
• 554
• 555
• 556
• 557
• 558
• 559
• 560
• »