CData Software - Knowledge Base

Recent Sage 300 Articles

Integrate Live Sage 300 into Blue Prism for Intelligent Robotic Process Automation (RPA)

Connect live Sage 300 to Blue Prism using the [product_name] to create automated workflows for repetitive business tasks.

Visualize Sage 300 in TIBCO Spotfire through ADO.NET

Integrate Sage 300 into dashboards in TIBCO Spotfire.

Connect to Sage 300 in Ruby

Connect to Sage 300 in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

How to connect PolyBase to Sage 300

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

How to connect to Sage 300 with Squirrel SQL client

Connect to Sage 300 and execute queries in the Squirrel SQL Client.

ETL Sage 300 in Oracle Data Integrator

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

LINQ to Sage 300

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 Sage 300 Data Provider.

Create Data Visualizations in Cognos BI with Sage 300

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

How to connect SharePoint with Sage 300 through external lists

Provide Sage 300 to SharePoint users as an external list.

Build Data Flows from Sage 300 to SQL Server using SSIS

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

Connect to Sage 300 from PowerBuilder via ODBC

This article demonstrates how to use the CData ODBC Driver for Sage 300 to connect to Sage 300 and execute queries in PowerBuilder.

Work with Sage 300 in FoxPro

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

Publish Sage 300-Connected Dashboards in Tableau Server via JDBC

Use CData JDBC drivers and Tableau Server to visualize live Sage 300.

Import and Visualize Sage 300 in Power View

Create data visualizations based on Sage 300 in Excel.

Visualize Sage 300 in Sisense

Create an ElastiCube in Sisense app with access to Sage 300.

Explore Geographical Relationships in Sage 300 with Power Map

Create data visualizations with Sage 300 in Power Map.

Connect to Sage 300 from a Connection Pool in Jetty

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

Integrate Sage 300 in the Pentaho Report Designer

Publish reports based on Sage 300 in the Pentaho BI tool.

Load Sage 300 to a Database Using Embulk

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

Automate Sage 300 Integration Tasks from PowerShell

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

Connect Sage 300 to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

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

How to create Sage 300 federated tables in MySQL

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

Connect to Sage 300 in SpagoBI

Create reports featuring live Sage 300 in SpagoBI Studio. Host Sage 300 reports on SpagoBI Server.

Connect to Sage 300 from Asprova with CData Software ODBC Driver for Sage 300

This article shows how to connect faster to Sage 300 data from Asprova.

Build AI/ML Models with Live Sage 300 Data using Dataiku

Connect Sage 300 Data with Dataiku using the [product_name].

Visualize Sage 300 in TIBCO Spotfire through ODBC

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

Migrating data from Sage 300 to Databricks using CData SSIS Components.

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

Connect to Sage 300 Using the Script Function in Claris FileMaker Pro

Use the [product_name] and the Script function in FileMaker Pro to connect to Sage 300 and work with Sage 300 in your FileMaker application.

Extend Google Sheets with Sage 300

Make calls to the API Server from Google Apps Script.

Query Sage 300 from Node.js

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

Consume Sage 300 OData Feeds in PowerBuilder

This article demonstrates how to consume Sage 300 as OData feeds from PowerBuilder using the API Server.

Connect to Sage 300 from PowerBuilder via ADO.NET

This article demonstrates how to access Sage 300 from Appeon PowerBuilder using the CData ADO.NET Provider for Sage 300.

Build MVC Applications with Connectivity to Sage 300

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

Use Dash to Build to Web Apps on Sage 300

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

Integrate with Sage 300 in JReport Designer

Create charts and reports based on Sage 300 in JReport Designer.

Connect to Sage 300 in NetBeans

Connect to Sage 300 in NetBeans with the data source configuration wizard.

Access Live Sage 300 in SAS JMP via ODBC

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

Create SSAS Tabular Models from Sage 300

How to build a SQL Server Analysis Service Tabular Model from Sage 300 using CData drivers.

Use the CData ODBC Driver for Sage 300 from SharePoint Excel Services

How to use SQLAlchemy ORM to access Sage 300 in Python

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

Connect to and Query Sage 300 in QlikView over ODBC

Create data visualizations with Sage 300 in QlikView.

Working with Sage 300 in LINQPad

Execute LINQ queries to Sage 300 in LINQPad.

Deploy the ADO.NET Provider for Sage 300 on an SSRS Report Server

Connect to Sage 300 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.

Visualize Sage 300 in TIBCO Spotfire through OData

Integrate Sage 300 into dashboards in TIBCO Spotfire.

Using the CData Software ODBC Driver for Sage 300 in PyCharm

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

Connect to Sage 300 in Aqua Data Studio

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

Object-Relational Mapping (ORM) with Sage 300 Entities in Java

Create an SAP BusinessObjects Universe on the CData ODBC Driver for Sage 300

Provide connectivity to Sage 300 through an SAP BusinessObjects universe.

Connect to Sage 300 in Claris FileMaker Pro

Use the [product_name] in FileMaker Pro to connect to Sage 300 and work with Sage 300 in your FileMaker applications.

Query Sage 300 using the OData SDK for PHP

Use the API Server and the OData PHP SDK to easily consume Sage 300 entities in PHP by modeling them as objects.

Bidirectional Access to Sage 300 from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Sage 300 in Filemaker Pro for Mac or Windows.

How to connect to Sage 300 in DBVisualizer

Integrate Sage 300 with visual data analysis tools and data connection wizards in DBVisualizer

Connect to Sage 300 from Blazor Apps

Build ASP.NET Core Blazor C# apps that integrate with real-time Sage 300 using standard SQL.

Build Dashboards with Sage 300 in Dundas BI

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

Connect to Sage 300 from a Connection Pool in JBoss

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

How to Connect to Sage 300 in Using Python: 6 Steps

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

Connect to Sage 300 in Jaspersoft Studio

Execute SQL to remote Sage 300 in Jaspersoft Studio.

Connect to Sage 300 in DBArtisan

Use wizards in DBArtisan to configure Sage 300 as a data source.

How to Visualize Sage 300 Data in Python with pandas

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

Excel Spreadsheet Automation on Sage 300 with the QUERY Formula

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

Create Informatica Mappings From/To an ODBC Data Source for Sage 300

Create an ODBC connection to Sage 300 in Informatica and browse and transfer Sage 300.

Visualize Sage 300 from Tableau

Use the Tableau Desktop business intelligence tool to connect to Sage 300.

Building Dynamic Web Pages with Sage 300 Using AngularJS

Create single-page applications with live connectivity to Sage 300 using the CData API Server.

Connect to Sage 300 from PowerBuilder via JDBC

This article demonstrates how to access Sage 300 from PowerBuilder using the Sage 300 JDBC Driver.

How to Build an ETL App for Sage 300 in Python with CData

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

Connect to Sage 300 from a Connection Pool in WebLogic

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

Connect to Sage 300 in RapidMiner

Integrate Sage 300 with standard components and data source configuration wizards in RapidMiner Studio.

Back Up Sage 300 to SQL Server through SSIS

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

Replicate Sage 300 from PowerShell

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

DataBind Controls to Sage 300 in Delphi

DataBind to Sage 300 in Delphi with standard data access components and controls.

Feed Sage 300 into FineReport

How to set Sage 300 as a JDBC data source in FineReport.

Connect to and Visualize Live Sage 300 in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sage 300.

Create Dynamic Sage 300 Grids Using the Infragistics XamDataGrid

Learn how you can connect Sage 300 to Infragistics XamDataGrid to build dynamic grids.

Consume Sage 300 OData Feeds in SAP Lumira

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

Visualize Sage 300 in Tableau

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

How to Connect DBeaver to Sage 300 via a JDBC Driver

Manage Sage 300 with visual tools in DBeaver like the query browser.

Migrating data from Sage 300 to Snowflake using CData SSIS Components.

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

Connect to Sage 300 in CloverDX (formerly CloverETL)

Transfer Sage 300 using the visual workflow in the CloverDX data integration tool.

Query Sage 300 in ColdFusion

Write standard ColdFusion data access code to connect to Sage 300.

Analyze Sage 300 in Infragistics Reveal

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

Create Reports with Sage 300 in SAP Crystal Reports

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

Analyze Sage 300 with Power Pivot

Configure the CData JDBC Driver for Sage 300 in a Connection Pool in Tomcat

Connect to Sage 300 from a connection pool in Tomcat.

Visualize Live Sage 300 in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Sage 300.

Access Sage 300 as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sage 300 from your Oracle system.

Build an OLAP Cube in SSAS from Sage 300

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

Migrating data from Sage 300 to Google BigQuery using CData SSIS Components.

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

Manage Sage 300 in DBArtisan as a JDBC Source

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

Enable the Sage 300 JDBC Driver in KNIME

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

How to connect to Sage 300 from IntelliJ

Integrate connectivity to Sage 300 with wizards in IntelliJ.

How to Connect to & Open Sage 300 in Microsoft Excel

This article uses the CData ODBC driver for Sage 300 to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

Publish Sage 300-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Sage 300.

Connect to Sage 300 in Google Apps Script via SQL Gateway

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

Connect to Sage 300 in RazorSQL

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

Create Informatica Mappings From/To a JDBC Data Source for Sage 300

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

Build a Simple VCL Application for Sage 300

How to build a simple VCL Application to view Sage 300 in RAD Studio using the CData ODBC Driver for Sage 300.

How to Import Data from Sage 300 into Google Sheets

Import Sage 300 into a Google spreadsheet that is automatically refreshed.

DataBind Sage 300 to the DevExpress Data Grid

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

Publish Crystal Reports on Sage 300

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Sage 300.

Natively Connect to Sage 300 in PHP

The CData ODBC driver for Sage 300 enables you to create PHP applications with connectivity to Sage 300. Leverage the native support for ODBC in PHP.

Viewing Sage 300 in RAD Studio Data Explorer

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

Natively Connect to Sage 300 in PHP via ODBC (Linux)

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

DataBind Controls to Sage 300 in C++Builder

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

Connect to Sage 300 as a Linked Server via SQL Gateway

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

Provide OData Services of Sage 300 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.

Edit and Search Sage 300 External Objects in Salesforce Connect (API Server)

How to publish and share Sage 300 dashboards with Tableau Server

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

How to Query Live Sage 300 Data in Natural Language in Python using LlamaIndex

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

PowerShell Scripting to Replicate Sage 300 to MySQL

Write a simple PowerShell script to replicate Sage 300 to a MySQL database.

Integrate Sage 300 in Pentaho Data Integration

Build ETL pipelines based on Sage 300 in the Pentaho Data Integration tool.

Build Charts with Sage 300 in Clear Analytics

Create dynamic charts and perform analytics based on Sage 300 in Clear Analytics.

Connect to Sage 300 in JRuby

Create a simple JRuby app with access to live Sage 300.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Sage 300

Provide connectivity to Sage 300 through an SAP BusinessObjects universe.

Integrating Sage 300 in Talend Cloud Data Management Platform

Connect Sage 300 with Talend Cloud Data Management Platform using the [product_name].

Analyze Sage 300 in Slingshot with CData API Server

Use the CData API Server to build an OData API on top of Sage 300 and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

Publish Reports with Sage 300 in SAP Crystal Reports

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

Build Dashboards with Sage 300 in DBxtra

Create dynamic dashboards and perform analytics based on Sage 300 in DBxtra.

Access Sage 300 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 Sage 300.

How to Access Sage 300 Using Entity Framework

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

Design BIRT Reports on Sage 300

Provide current Sage 300 to your embedded analytics.

Extract, Transform, and Load Sage 300 in Informatica PowerCenter

Create a simple Workflow for Sage 300 in Informatica PowerCenter.

Establish a Live Connection with Sage 300 using Tableau Bridge

The CData ODBC Driver for Sage 300 enables you to integrate live Sage 300 into Tableau Cloud dashboards using the Tableau Bridge.

Integrate Live Sage 300 into Blue Prism for Intelligent Robotic Process Automation (RPA)

Connect live Sage 300 to Blue Prism using the [product_name] to create automated workflows for repetitive business tasks.

Visualize Sage 300 in TIBCO Spotfire through ADO.NET

Integrate Sage 300 into dashboards in TIBCO Spotfire.

Connect to Sage 300 in Ruby

Connect to Sage 300 in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

How to connect PolyBase to Sage 300

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

How to connect to Sage 300 with Squirrel SQL client

Connect to Sage 300 and execute queries in the Squirrel SQL Client.

ETL Sage 300 in Oracle Data Integrator

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

LINQ to Sage 300

Create Data Visualizations in Cognos BI with Sage 300

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

How to connect SharePoint with Sage 300 through external lists

Provide Sage 300 to SharePoint users as an external list.

Build Data Flows from Sage 300 to SQL Server using SSIS

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

Connect to Sage 300 from PowerBuilder via ODBC

This article demonstrates how to use the CData ODBC Driver for Sage 300 to connect to Sage 300 and execute queries in PowerBuilder.

Work with Sage 300 in FoxPro

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

Publish Sage 300-Connected Dashboards in Tableau Server via JDBC

Use CData JDBC drivers and Tableau Server to visualize live Sage 300.

Import and Visualize Sage 300 in Power View

Create data visualizations based on Sage 300 in Excel.

Visualize Sage 300 in Sisense

Create an ElastiCube in Sisense app with access to Sage 300.

Explore Geographical Relationships in Sage 300 with Power Map

Create data visualizations with Sage 300 in Power Map.

Connect to Sage 300 from a Connection Pool in Jetty

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

Integrate Sage 300 in the Pentaho Report Designer

Publish reports based on Sage 300 in the Pentaho BI tool.

Load Sage 300 to a Database Using Embulk

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

Automate Sage 300 Integration Tasks from PowerShell

Connect Sage 300 to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

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

How to create Sage 300 federated tables in MySQL

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

Connect to Sage 300 in SpagoBI

Create reports featuring live Sage 300 in SpagoBI Studio. Host Sage 300 reports on SpagoBI Server.

Connect to Sage 300 from Asprova with CData Software ODBC Driver for Sage 300

This article shows how to connect faster to Sage 300 data from Asprova.

Build AI/ML Models with Live Sage 300 Data using Dataiku

Connect Sage 300 Data with Dataiku using the [product_name].

Visualize Sage 300 in TIBCO Spotfire through ODBC

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

Migrating data from Sage 300 to Databricks using CData SSIS Components.

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

Connect to Sage 300 Using the Script Function in Claris FileMaker Pro

Use the [product_name] and the Script function in FileMaker Pro to connect to Sage 300 and work with Sage 300 in your FileMaker application.

Extend Google Sheets with Sage 300

Make calls to the API Server from Google Apps Script.

Query Sage 300 from Node.js

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

Consume Sage 300 OData Feeds in PowerBuilder

This article demonstrates how to consume Sage 300 as OData feeds from PowerBuilder using the API Server.

Connect to Sage 300 from PowerBuilder via ADO.NET

This article demonstrates how to access Sage 300 from Appeon PowerBuilder using the CData ADO.NET Provider for Sage 300.

Build MVC Applications with Connectivity to Sage 300

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

Use Dash to Build to Web Apps on Sage 300

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

Integrate with Sage 300 in JReport Designer

Create charts and reports based on Sage 300 in JReport Designer.

Connect to Sage 300 in NetBeans

Connect to Sage 300 in NetBeans with the data source configuration wizard.

Access Live Sage 300 in SAS JMP via ODBC

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