CData Software - Knowledge Base

Recent Articles

• «
• 603
• 604
• 605
• 606
• 607
• 608
• 609
• 610
• 611
• 612
• »

• How to Access Live Oracle in Visual Studio Code via Cline

  Run the CData MCP Server for Oracle on Windows Subsytem for Linux (WSL) and connect to live Oracle Database from the Cline extension in Visual Studio Code.

• How to Work with Cassandra in AWS Glue Jobs Using JDBC

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

• Automated Facebook Replication to Teradata

  Use CData Sync to Customize and automate Facebook replication to Teradata.

• Connect to SQL Analysis Services in the Denodo Platform

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

• Integrate Live Reckon Accounts Hosted into Amazon SageMaker Canvas with RDS

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

• Query API from Node.js

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

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

  Provide connectivity to MailChimp through an SAP BusinessObjects universe.

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

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

• Validate Certinia with QuerySurge

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

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

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

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

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

• Use JayDeBeApi to access Azure Data Catalog in Python

  Use standard Python scripting and the development environment of your choice to access live Azure Data Catalog.

• PowerShell Scripting to Replicate Confluence to MySQL

  Write a simple PowerShell script to replicate Atlassian Confluence to a MySQL database.

• Design BIRT Reports on Aha

  Provide current Aha! to your embedded analytics.

• Connect to Azure Active Directory from AWS Glue

  Use CData Connect Cloud to gain access to live Azure Active Directory from your AWS Glue jobs.

• Visualize SAP BusinessObjects BI in Tableau

  The CData ODBC driver for SAP BusinessObjects BI enables you integrate SAP BusinessObjects BI into Tableau dashboards.

• Build PCA Sales Visualizations in Tableau Desktop

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

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

• Bridge Klipfolio Connectivity with Apache NiFi

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

• How to connect to EnterpriseDB in DBVisualizer

  Integrate EnterpriseDB with visual data analysis tools and data connection wizards in DBVisualizer

• Analyze Live Raisers Edge NXT in SAS Viya

  Use CData Connect Cloud to connect to Raisers Edge NXT from SAS Viya and deploy self-service analytics using live Raisers Edge NXT.

• Create Google Search-Connected Nintex Workflows

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

• Connect to eBay in Aqua Data Studio

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

• Publish Shopify-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Shopify.

• Provide OData Services of ConstantContact from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for ConstantContact by developing a WCF Service Application.

• Work with Live GraphQL in Power Query

  Use CData Connect Cloud to connect to GraphQL and work with live GraphQL in Microsoft Power Query.

• Integrate with Acumatica in JReport Designer

  Create charts and reports based on Acumatica ERP in JReport Designer.

• DataBind Charts to Printful

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

• Access Live Office 365 in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Microsoft Office 365 from your Excel spreadsheets.

• Automated Act CRM Replication to Teradata

  Use CData Sync to Customize and automate Act CRM replication to Teradata.

• Integrate with live MYOB AccountRight in Jitterbit

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

• Query, Visualize, and Share live MariaDB in Redash

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

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

  Use LlamaIndex to query live SendGrid data in natural language using Python.

• Design BIRT Reports on AlloyDB

  Provide current Google AlloyDB to your embedded analytics.

• How to Import Data from SAP Hybris C4C into Google Sheets

  Import SAP Hybris C4C into a Google spreadsheet that is automatically refreshed.

• Import Real-Time Google Contacts via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Google Contacts in ColdFusion.

• How to connect SharePoint with LDAP Objects through external lists

  Provide LDAP to SharePoint users as an external list.

• Using the CData Software ODBC Driver for Zendesk in PyCharm

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

• Access Live Klaviyo in AWS Lambda

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

• Excel Spreadsheet Automation on EventBrite with the QUERY Formula

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

• How to Build an ETL App for Asana in Python with CData

  Create ETL applications and real-time data pipelines for Asana in Python with petl.

• Working with JotForm in LINQPad

  Execute LINQ queries to JotForm in LINQPad.

• SharePoint Reporting in OBIEE with the SharePoint JDBC Driver

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

• How to Seamlessly Import Oracle HCM Cloud Data into IBM SPSS Modeler

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

• How to connect and process Azure Data Lake Storage from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Azure Data Lake Storage.

• Automate Oracle Service Cloud Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Oracle Service Cloud from PowerShell? This article demonstrates how to utilize the Oracle Service Cloud Cmdlets for tasks like connecting to Oracle Service Cloud, automating operations, downloading data, and more.

• How to connect SharePoint with SFTP through external lists

  Provide SFTP to SharePoint users as an external list.

• Explore Geographical Relationships in Office 365 with Power Map

  Create data visualizations with Microsoft Office 365 in Power Map.

• Model, Search, and Visualize Live Oracle SCM in ThoughtSpot

  Use CData Connect Cloud to connect to live Oracle SCM for modeling, searching, and visualizing.

• Automate EnterpriseDB Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live EnterpriseDB and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

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

  Create an ODBC connection to DB2 in Informatica and browse and transfer IBM DB2.

• Automated Continuous Sybase Replication to Oracle

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

• Connect to Adobe Analytics in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access Adobe Analytics in Google Apps Script.

• Visualize Couchbase in TIBCO Spotfire through ODBC

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

• Use the CData API Server in Microsoft Power BI

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

• How to Connect to Oracle Eloqua in Using Python: 6 Steps

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

• Consume LDAP OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on LDAP feeds that reflect any changes in SAP Lumira.

• Automated Continuous Avro Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Avro replication to AlloyDB.

• Integrate with Live eBay in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to eBay from the MuleSoft Anypoint Platform to integrate live eBay into custom reports and dashboards.

• Automated Continuous Zoom Replication to Google BigQuery

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

• How to create Visio diagrams from Act-On

  Automatically update Act-On with the changes you make to Visio master shapes.

• Connect to Oracle in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access Oracle Database in Google Apps Script.

• Automated Continuous Sybase Replication to Local Delimited Files

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

• How to Visualize Basecamp Data in Python with pandas

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

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

• Use Dash to Build to Web Apps on Zuora

  Create Python applications that use pandas and Dash to build Zuora-connected web apps.

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

  Use LlamaIndex to query live SurveyMonkey data in natural language using Python.

• Visualize Live Microsoft Project of Power BI Report Builder in Power BI Service

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

• Replicate Greenhouse from PowerShell

  Write a quick PowerShell script to query Greenhouse. Use connectivity to the live data to replicate Greenhouse to SQL Server.

• Build Semantic Layer Views for Microsoft Teams in APOS Live Data Gateway

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

• Build Parquet-Connected ETL Processes in Google Data Fusion

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

• Add GraphQL to Informatica Enterprise Data Catalog

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

• Connect to Trello from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Trello to connect to Trello from Web applications running on WebLogic.

• Access MongoDB from MySQL in HeidiSQL

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

• Design BIRT Reports on Typeform

  Provide current Typeform to your embedded analytics.

• Build Dashboards with Asana in Dundas BI

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

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

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

• Use the CData Software ODBC Driver for Zoho Creator in SAS for Real-Time Reporting and Analytics

  Connect to real-time Zoho Creator in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Zoho Creator.

• Automated Continuous Google Ads Replication to Amazon Redshift

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

• Access Bing Ads from MySQL in HeidiSQL

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

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

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

• Work with Live WooCommerce in Power Query

  Use CData Connect Cloud to connect to WooCommerce and work with live WooCommerce in Microsoft Power Query.

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

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

• Connect to and Visualize Live Exact Online in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Exact Online.

• How to connect and process Oracle Financials Cloud from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Oracle Financials Cloud.

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

  Execute SQL Server queries against Sansan from Node.js.

• How to Access Live HCL Domino in Power Automate Desktop via ODBC

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

• Connect to and Visualize Live Excel in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Excel.

• How to work with Paylocity in Apache Spark using SQL

  Access and process Paylocity in Apache Spark using the CData Software JDBC Driver.

• Automated SAP HANA XS Advanced Replication to Teradata

  Use CData Sync to Customize and automate SAP HANA XS Advanced replication to Teradata.

• Visualize Sybase in TIBCO Spotfire through ADO.NET

  Integrate Sybase into dashboards in TIBCO Spotfire.

• Replicate MailChimp in Heroku for Use in Salesforce Connect

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

• Connect to XML in DBeaver

  Use the CData ODBC Driver to connect to XML Files in DBeaver.

• Use the CData Software ODBC Driver for Asana in MicroStrategy Desktop

  Connect to Asana in MicroStrategy Desktop using the CData Software ODBC Driver for Asana.

• How to connect to Jira Service Management from IntelliJ

  Integrate connectivity to Atlassian Jira Service Management with wizards in IntelliJ.

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

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

• How to load Parquet data into Elasticsearch via Logstash

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

• Connect to Pinterest in DBeaver

  Use the CData ODBC Driver to connect to Pinterest in DBeaver.

• Connect to HBase in SpagoBI

  Create reports featuring live Apache HBase in SpagoBI Studio. Host HBase reports on SpagoBI Server.

• Enable the Printify JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Printify.

• «
• 603
• 604
• 605
• 606
• 607
• 608
• 609
• 610
• 611
• 612
• »