CData Software - Knowledge Base

Recent Articles

---

• «
• 575
• 576
• 577
• 578
• 579
• 580
• 581
• 582
• 583
• 584
• »

• How to connect to Microsoft Teams Data in DBVisualizer

  Integrate Microsoft Teams with visual data analysis tools and data connection wizards in DBVisualizer

• Model Okta Data Using Azure Analysis Services

  Leverage CData Connect AI to establish a connection between Azure Analysis Services and Okta, enabling the direct import of real-time Okta.

• Visualize Live Parquet Data of Power BI Report Builder in Power BI Service

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

• How to connect Amazon QuickSight to Google Campaign Manager 360 Data

  Create a connection to Google Campaign Manager 360 in CData Connect AI and insert Google Campaign Manager 360 into Amazon QuickSight SPICE to build interactive dashboards.

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

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

• How to Work with Okta Data in AWS Glue Jobs Using JDBC

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

• Integrating Oracle Sales Data in Talend Cloud Data Management Platform

  Connect Oracle Sales Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Oracle Sales.

• Automated Continuous Printful Replication to Apache Kafka

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

• How to integrate Instantly with Apache Airflow

  Access and process Instantly in Apache Airflow using the CData JDBC Driver.

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

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

• SAP HANA Reporting in OBIEE with the SAP HANA JDBC Driver

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

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

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

• Replicate Multiple Microsoft Entra ID Accounts

  Replicate multiple Microsoft Entra ID accounts to one or many databases.

• Publish Reports with Salesforce Marketing Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Salesforce Marketing Cloud.

• Replicate Multiple Sage 200 Accounts

  Replicate multiple Sage 200 accounts to one or many databases.

• Prepare, Blend, and Analyze ActiveCampaign Data in Alteryx Designer (ODBC)

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

• Access Live SparkPost Data in AWS Lambda (with IntelliJ IDEA)

  Connect to live SparkPost in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Access Live Adobe Analytics Data in TIBCO Data Virtualization

  Use the Adobe Analytics Tibco DV Adapter to create a Adobe Analytics data source in TIBCO Data Virtualization Studio and gain access to live Adobe Analytics from your TDV Server.

• How to Access Live SurveyMonkey Data in Visual Studio Code via Cline

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

• Automate PagerDuty Data Replication to Couchbase

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

• ETL Elasticsearch in Oracle Data Integrator

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

• Replicate Multiple HBase Accounts

  Replicate multiple HBase accounts to one or many databases.

• Create Data Visualizations in Cognos BI with AdRoll Data

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

• Load Drift Data to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Drift to a database.

• Automate Office 365 Data Replication to Couchbase

  Use CData Sync to Customize and automate Microsoft Office 365 replication to Couchbase.

• Getting Started with the CData ODBC Driver for HBase

  Complete guide to installing, licensing, and connecting with the CData ODBC Driver for HBase.

• Analyze Pushbullet Data in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Pushbullet in Microsoft R Open.

• Connect to Power BI XMLA from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Power BI XMLA, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Automated Continuous Eventbrite Replication to Oracle

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

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

  Provide connectivity to JotForm through an SAP BusinessObjects universe.

• Build MVC Applications with Connectivity to Perplexity Data

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Perplexity from an ASP.NET MVC application.

• Rapidly Develop Recurly-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Recurly.

• Automated Continuous LeadDesk Replication to Amazon Redshift

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

• Connect to Salesloft from Asprova with CData Software ODBC Driver for Salesloft

  This article shows how to connect faster to Salesloft data from Asprova.

• A PostgreSQL Interface for Helpscout Data using the CData ODBC Driver

  Use the SQL Gateway and Helpscout ODBC Driver to create a PostgreSQL entry-point for data access.

• LINQ to Codat Data

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

• Use the CData Software JDBC Driver for Insightly in MicroStrategy

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

• Access DB2 Data from MySQL in PHP

  Connect to DB2 through the standard MySQL libraries in PHP.

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

• Publish Reports with LinkedIn Data in SAP Crystal Reports

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

• Build Apps with Live Delighted Data Using the Low-Code Development Platform of Mendix

  Connect Delighted with Mendix to build apps using the CData API Driver for JDBC.

• Access Facebook Ads Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Facebook Ads from your Oracle system.

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

  Provide connectivity to Google Directory through an SAP BusinessObjects universe.

• Automated Continuous Discord Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable Discord replication to Azure SQL Database.

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

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

• Access Live HDFS Data in AWS Lambda

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

• Connect to CloudConvert Data in the Denodo Platform

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

• How to Visualize RabbitMQ Data in Python with pandas

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

• Build Semantic Layer Views for LinkedIn Ads Data in APOS Live Data Gateway

  Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for LinkedIn Ads.

• Configure the CData JDBC Driver for Mailjet in a Connection Pool in Tomcat

  Connect to Mailjet from a connection pool in Tomcat.

• Getting Started with the CData Excel Add-In for LinkedIn Ads

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for LinkedIn Ads.

• How to connect PolyBase to ServiceNow

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

• Automated Continuous Shortcut Replication to Oracle

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

• Replicate Planio Data from PowerShell

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

• Connect to ShipStation Data in RazorSQL

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

• Getting Started with the CData JDBC Driver for Invoiced

  Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Invoiced.

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

  Connect to Accelo 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.

• Design BIRT Reports on Couchbase Data

  Provide current Couchbase to your embedded analytics.

• Visualize Live Avalara AvaTax Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Avalara AvaTax.

• Connect to Zoho Books in SpagoBI

  Create reports featuring live Zoho Books in SpagoBI Studio. Host Zoho Books reports on SpagoBI Server.

• Integrate Goose with Live Sybase IQ Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Sybase IQ from within the local AI agent.

• Migrating data from Slack to Google BigQuery using CData SSIS Components.

  Easily push Slack to Google BigQuery using the CData SSIS Tasks for Slack and Google BigQuery.

• Connect to Salesforce Data in RazorSQL

  Connect to Salesforce from wizards and query Salesforce & Force.com from the GUI in the RazorSQL database management tool.

• Connect to Spark Data through External Services in Salesforce

  Use CData Connect AI to securely connect Salesforce External Services with Spark Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Build SAP Hybris C4C-Connected Apps in Choreo

  Use CData Connect AI to connect to SAP Hybris C4C Data from Choreo and build custom apps using live SAP Hybris C4C.

• Prepare, Blend, and Analyze Printful Data in Alteryx Designer (ODBC)

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

• Migrating data from Avalara AvaTax to Databricks using CData SSIS Components.

  Easily push Avalara AvaTax to Databricks using the CData SSIS Tasks for Avalara AvaTax and Databricks.

• Natively Connect to BenchmarkEmail Data in PHP via ODBC (Linux)

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

• How to Access Azure Data Catalog Data Using Entity Framework

  This article shows how to access Azure Data Catalog using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• Connect to Klipfolio Data in NetBeans

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

• Build SAS xpt Visualizations in Tableau Cloud

  Use CData Connect AI to connect to live SAS XPORT and build visualizations in Tableau Cloud.

• Provide OData Services of Sage 300 Data from a WCF Application

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

• Greenplum Data Cloud Connectivity

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

• Connect to XML Data in Ruby

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

• Enable the Mode JDBC Driver in KNIME

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

• Manage QuickBooks Time Data in DBArtisan as a JDBC Source

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

• Query Okta Data through ODBC in Node.js

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

• Integrate SAP Ariba Procurement with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate SAP Ariba Procurement with External Services.

• Integrating Kiro CLI with Rootly Data via CData CLI

  CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.

• Automated Continuous Zoho Books Replication to AlloyDB

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

• Access Live Vault CRM Data in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Veeva Vault & Vault CRM into the statistical analysis tools available in SAS JMP. This article shows how to use Veeva Vault & Vault CRM in the Graph Builder and Query Builder.

• Visualize Live ZendeskSell Data of Power BI Report Builder in Power BI Service

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

• Create Dashboards and Visualize Live Marketo Data in Geckoboard

  Use CData Connect AI to connect to live Marketo and create dashboards for real-time monitoring and visualization in Geckoboard.

• Build a Simple VCL Application for SAS Data Sets Data

  How to build a simple VCL Application to view SAS Data Sets in RAD Studio using the CData ODBC Driver for SAS Data Sets.

• Automated Continuous Shortcut Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable Shortcut replication to Azure SQL Database.

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

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

• Use the CData Software JDBC Driver for MariaDB in MicroStrategy

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

• Automated Continuous Tickspot Replication to Amazon Redshift

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

• Use the CData API Server to Access Cvent Data in Microsoft PowerPivot

  Use the CData API Server to connect to live Cvent in the Power Pivot business intelligence tool.

• Integrate Cursor with Live Certinia Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Certinia from within the editor.

• How to Seamlessly Import PivotalTracker Data into IBM SPSS Modeler

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

• Viewing Productboard Data in RAD Studio Data Explorer

  How to view Productboard in RAD Studio Data Explorer using the CData ODBC Driver for Productboard.

• How to connect to JobNimbus Data in DBVisualizer

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

• Add LightSpeedRetail Data to Informatica Enterprise Data Catalog

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

• Visualize Oracle Data 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.

• Connect to BambooHR from Asprova with CData Software ODBC Driver for BambooHR

  This article shows how to connect faster to BambooHR data from Asprova.

• Connect to SAP SuccessFactors Data in Google Apps Script via SQL Gateway

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

• Access Live Instagram Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live Instagram data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• DataBind Charts to Discourse Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Discourse 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 Informatica Mappings From/To a JDBC Data Source for Zoho Projects

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

• «
• 575
• 576
• 577
• 578
• 579
• 580
• 581
• 582
• 583
• 584
• »