CData Software - Knowledge Base

Recent Articles

---

• «
• 348
• 349
• 350
• 351
• 352
• 353
• 354
• 355
• 356
• 357
• »

• Extract, Transform, and Load DB2 in Informatica PowerCenter

  Create a simple Workflow for IBM DB2 in Informatica PowerCenter.

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

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

• Create Dynamic SAS xpt Grids Using the Infragistics XamDataGrid

  Learn how you can connect SAS xpt to Infragistics XamDataGrid to build dynamic grids.

• Access SAP ByDesign 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 SAP Business ByDesign.

• How to Import Data from Confluence into Google Sheets

  Import Atlassian Confluence into a Google spreadsheet that is automatically refreshed.

• Connect to Dynamics 365 as a SQL Server Linked Server

  Use CData Connect AI to create a linked server for live Microsoft Dynamics 365.

• Build Outreach.io-Connected Apps in Bubble

  Use CData Connect AI to create an OData feed for Outreach.io and create custom apps in Bubble.

• Connect to Coinbase in NetBeans

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

• Model, Search, and Visualize Live IBM Informix in ThoughtSpot

  Use CData Connect AI to connect to live IBM Informix for modeling, searching, and visualizing.

• DataBind Controls to Instagram in C++Builder

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

• How to Visualize Microsoft Project Data in Python with pandas

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

• PowerShell Scripting to Replicate Oracle Service Cloud to MySQL

  Write a simple PowerShell script to replicate Oracle Service Cloud to a MySQL database.

• How to connect to Marketo from IntelliJ

  Integrate connectivity to Marketo with wizards in IntelliJ.

• Access Live eBay in Coginiti Pro

  Connect to and query live eBay from the GUI in the Coginiti Pro: SQL Analytics Tool.

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

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

• How to integrate Metabase with Impala

  Use CData Connect AI to connect to live Apache Impala and create an interactive dashboard in Metabase from Apache Impala.

• Analyze WordPress in Infragistics Reveal

  Use the CData API Server to create an OData API on top of WordPress and visualize live WordPress in Infragistics Reveal.

• Integrate SQL Server with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate SQL Server with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Microsoft SQL Server.

• How to create Kintone federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Kintone in MySQL .

• Access Live REST in Coginiti Pro

  Connect to and query live REST from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Automated Continuous WooCommerce Replication to MongoDB

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

• Migrating data from Reckon to Databricks using CData SSIS Components.

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

• Validate Dynamics 365 Business Central with QuerySurge

  Access and validate Dynamics 365 Business Central in QuerySurge using the CData JDBC Driver.

• How to connect PolyBase to MongoDB

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

• How to Query Odoo in MySQL Workbench

  Execute MySQL queries against live Odoo ERP from MySQL Workbench.

• Build GraphQL-Connected Apps in Mendix

  Use CData Connect AI to create an OData feed for GraphQL and create custom apps in Mendix.

• Connect to Microsoft Exchange in Aqua Data Studio

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

• Integrate with Cosmos DB in JReport Designer

  Create charts and reports based on Azure Cosmos DB in JReport Designer.

• How to Connect to SAP HANA in Using Python: 6 Steps

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

• Using the CData Software ODBC Driver for Confluence in PyCharm

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

• How to import DB2 into Apache Solr

  Use the CData Software JDBC Driver for DB2 in Data Import Handler and create an automated import of IBM DB2 to Apache Solr Enterprise Search platform.

• Connect to Google Directory from a Connection Pool in JBoss

  Integrate Google Directory into Java servlets: Use the Management Console in JBoss to install the Google Directory JDBC Driver.

• Automated Continuous FHIR Replication to SQLite

  Use CData Sync for automated, continuous, customizable FHIR replication to SQLite.

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

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

• Create QuickBooks Reports on JasperReports Server

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

• Integrating Gumloop with Smartsheet via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Smartsheet within automated workflows.

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

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

• PowerShell Scripting to Replicate QuickBooks Online to MySQL

  Write a simple PowerShell script to replicate QuickBooks Online to a MySQL database.

• Integrating Boomi Agentstudio with Raisers Edge NXT via CData Connect AI

  Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Raisers Edge NXT, enabling AI agents to act on live enterprise data within your integration and automation workflows.

• How to connect to Power BI XMLA in DBVisualizer

  Integrate Power BI XMLA with visual data analysis tools and data connection wizards in DBVisualizer

• Connect to Marketo in Aqua Data Studio

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

• DataBind Controls to Procore in C++Builder

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

• Query SAP SuccessFactors as a MySQL Database in Node.js

  Execute MySQL queries against SAP SuccessFactors from Node.js.

• Work with HubDB in FoxPro

  Load HubDB into a FoxPro database. This article includes full code and a walk-through of the process.

• Publish Reports with Salesforce Pardot in SAP Crystal Reports

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

• Query Confluence through ODBC in Node.js

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

• Connect to Oracle Eloqua from Filemaker Pro (Mac)

  Use CData Connect AI to connect to and query live Oracle Eloqua from Filemaker Pro on Mac.

• Create Datasets from Zoho Inventory in Domo Workbench and Build Visualizations of Zoho Inventory in Domo

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

• Build XML-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to XML Files and build web apps with connectivity to live XML Files.

• Explore Geographical Relationships in Azure Analysis Services with Power Map

  Create data visualizations with Azure Analysis Services in Power Map.

• Replicate Multiple Hive Accounts via the CData Sync CLI

  Replicate multiple Hive accounts to one or many databases.

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

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

• Automate Printful Replication to Couchbase

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

• Visualize Google Ad Manager from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Google Ad Manager.

• Getting Started with the CData JDBC Driver for Zuora

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

• Use Dash to Build to Web Apps on Tally

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

• Replicate Odoo from PowerShell

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

• Working with Adobe Commerce in LINQPad

  Execute LINQ queries to Adobe Commerce in LINQPad.

• Replicate Pinterest to Multiple Databases via the CData Sync CLI

  Replicate Pinterest to disparate databases with a single configuration.

• Automated Continuous BigCommerce Replication to Vertica

  Use CData Sync for automated, continuous, customizable BigCommerce replication to Vertica.

• Connect to Outreach.io in JRuby

  Create a simple JRuby app with access to live Outreach.io.

• Use the CData Software JDBC Driver for SAP BusinessObjects BI in MicroStrategy

  Connect to SAP BusinessObjects BI in MicroStrategy Developer using the CData Software JDBC Driver for SAP BusinessObjects BI.

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

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

• Integrate with Typeform in JReport Designer

  Create charts and reports based on Typeform in JReport Designer.

• How to connect Amazon QuickSight to Cosmos DB

  Create a connection to Azure Cosmos DB in CData Connect AI and insert Azure Cosmos DB into Amazon QuickSight SPICE to build interactive dashboards.

• Connect Access to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Microsoft Access using the CData Python MCP Server.

• Access YouTube Analytics from MySQL in HeidiSQL

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

• Use Databricks Agent Bricks to Talk to Your Azure Data Lake Storage via CData Connect AI

  Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Azure Data Lake Storage for you.

• Integrating LangChain with Vault CRM via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Veeva Vault & Vault CRM within automated workflows.

• Connect to Sugar CRM in HULFT Integrate

  Connect to Sugar CRM as a JDBC data source in HULFT Integrate

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

  Build workflows to access live Salesforce & Force.com for self-service data analytics.

• How to Connect to Live Greenplum in n8n Workflows and Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Pivotal GreenPlum for you.

• Automate Google Ad Manager Replication to Couchbase

  Use CData Sync to Customize and automate Google Ad Manager replication to Couchbase.

• Connect to SQL Analysis Services from a Connection Pool in Jetty

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

• Access Live Neo4J in TIBCO Data Virtualization

• «
• 348
• 349
• 350
• 351
• 352
• 353
• 354
• 355
• 356
• 357
• »