CData Software - Knowledge Base



Recent Sage 300 Articles

Use the Connect Server to Access Sage 300 in Microsoft Power Pivot

Use the Connect Server to connect to live Sage 300 in the Power Pivot business intelligence tool.

Visualize Sage 300 in TIBCO Spotfire through ADO.NET

Integrate Sage 300 into dashboards in TIBCO Spotfire.

Publish Reports with Sage 300 in SAP Crystal Reports

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

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.

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

Provide connectivity to Sage 300 through an SAP BusinessObjects universe.

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.

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

Connect to Sage 300 from a connection pool in Tomcat.

Connect to Sage 300 in Google Apps Script

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

Connect to and Visualize Live Sage 300 in Tableau Prep

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

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.

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.

Import Sage 300 into FileMaker Pro

Create reports that integrate Sage 300 in Filemaker Pro.

Connect to Sage 300 in NetBeans

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

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.

Visualize Sage 300 in TIBCO Spotfire through OData

Integrate Sage 300 into dashboards in TIBCO Spotfire.

PowerShell Scripting to Replicate Sage 300 to MySQL

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

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.

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

Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Sage 300 into a Java-based ORM framework, Hibernate.

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.

Connect to Sage 300 in RapidMiner

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

Publish Sage 300-Connected Dashboards in Tableau Server

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

Query Sage 300 in ColdFusion

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

Create SSAS Tabular Models from Sage 300

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

Connect to Sage 300 in CloverDX (formerly CloverETL)

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

Feed Sage 300 into FineReport

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

Build Dashboards with Sage 300 in DBxtra

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

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.

Working with Sage 300 in LINQPad

Execute LINQ queries to Sage 300 in LINQPad.

Connect to Sage 300 as a Linked Server

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

How to connect to Sage 300 in DBVisualizer

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

How to Connect DBeaver to Sage 300 via a JDBC Driver

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

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.

Integrate Sage 300 in the Pentaho Report Designer

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

Analyze Sage 300 in Infragistics Reveal

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

Import and Visualize Sage 300 in Power View

Create data visualizations based on Sage 300 in Excel.

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.

Create Reports with Sage 300 in SAP Crystal Reports

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

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.

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.

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.

Design BIRT Reports on Sage 300

Provide current Sage 300 to your embedded analytics.

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.

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 Asprova with CData Software ODBC Driver for Sage 300

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

Build Charts with Sage 300 in Clear Analytics

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

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

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 PowerBuilder

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

Visualize Live Sage 300 in Tableau

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

Visualize Sage 300 from Tableau

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

How to connect to Sage 300 from Google Apps Script

Use CData Software Connect Server to access Sage 300 in Google Apps Script.

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.

Connect to Sage 300 from PowerBuilder

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

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.

Create Apps from Sage 300 in Qlik Sense Cloud

Use the CData Connect Server to create an OData API for Sage 300 and build apps from live Sage 300 in Qlik Sense Cloud.

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.

Integrate with Sage 300 in JReport Designer

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

Connect to Sage 300 in DBArtisan

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

Import Sage 300 into Microsoft Power Query

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

Create Dynamic Sage 300 Grids Using the Infragistics XamDataGrid

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

Using AngularJS to Build Dynamic Web Pages with Sage 300

Use the CData Connect Server to create Sage 300 OData feeds and build single-page applications with live Sage 300.

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.

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.

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.

Manage Sage 300 in DBArtisan as a JDBC Source

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

Connect to Sage 300 from PowerBuilder

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

Use the CData ODBC Driver for Sage 300 in SAS JMP

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.

Connect to Sage 300 in Jaspersoft Studio

Execute SQL to remote Sage 300 in Jaspersoft Studio.

DataBind Wijmo Grid to Sage 300

Provide real-time Sage 300 to interactive controls.

Explore Geographical Relationships in Sage 300 with Power Map

Create data visualizations with Sage 300 in Power Map.

DataBind Controls to Sage 300 in Delphi

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

Integrating Sage 300 in Talend Cloud Data Management Platform

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

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.

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 in Sisense

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

Edit and Search External Sage 300 Objects in Salesforce Connect

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

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.

How to Import Sage 300 into SQL Server using SSIS

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

Analyze Sage 300 with Power Pivot

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

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

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

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.

Natively Connect to Sage 300 in PHP

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

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.

Publish Sage 300-Connected Dashboards in Tableau Server

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

Connect to Sage 300 in JRuby

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

Extract, Transform, and Load Sage 300 in Informatica PowerCenter

Create a simple Workflow for Sage 300 in Informatica PowerCenter.

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.

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

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 Build Dynamic React Apps with Sage 300

Use the CData Connect and React to Build Dynamic Web Apps with Live Sage 300 .

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.

Analyze Sage 300 in SAP Analytics Cloud

Use the CData Connect Server to create an OData API on top of Sage 300 and visualize Sage 300 in SAP Analytics Cloud.

How to Visualize Sage 300 Data in Python with pandas

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

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.

ETL Sage 300 in Oracle Data Integrator

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

Connect to Sage 300 in RunMyProcess through Connect Server

Use CData Connect Server to create an OData API for Sage 300 and connect to Sage 300 in Akorbi Digital RunMyProcess.

How to connect to Sage 300 from IntelliJ

Integrate connectivity to Sage 300 with wizards in IntelliJ.

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.

DataBind Controls to Sage 300 in C++Builder

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

Connect to Sage 300 in Ruby

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

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.

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.

How to connect to Sage 300 with Squirrel SQL client

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

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.

Connect to and Query Sage 300 in QlikView over ODBC

Create data visualizations with Sage 300 in QlikView.

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.

Connect to Sage 300 as a Linked Server

Use CData Connect to set up a linked server for Sage 300.

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

Provide connectivity to Sage 300 through an SAP BusinessObjects universe.

Excel Spreadsheet Automation with the QUERY Formula

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

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 .

Visualize Sage 300 in Tableau

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

Use the Connect Server to Access Sage 300 in Microsoft Power Pivot

Use the Connect Server to connect to live Sage 300 in the Power Pivot business intelligence tool.

Visualize Sage 300 in TIBCO Spotfire through ADO.NET

Integrate Sage 300 into dashboards in TIBCO Spotfire.

Publish Reports with Sage 300 in SAP Crystal Reports

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

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.

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

Provide connectivity to Sage 300 through an SAP BusinessObjects universe.

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.

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

Connect to Sage 300 from a connection pool in Tomcat.

Connect to Sage 300 in Google Apps Script

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

Connect to and Visualize Live Sage 300 in Tableau Prep

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

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.

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.

Import Sage 300 into FileMaker Pro

Create reports that integrate Sage 300 in Filemaker Pro.

Connect to Sage 300 in NetBeans

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

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.

Visualize Sage 300 in TIBCO Spotfire through OData

Integrate Sage 300 into dashboards in TIBCO Spotfire.

PowerShell Scripting to Replicate Sage 300 to MySQL

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

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.

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

Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Sage 300 into a Java-based ORM framework, Hibernate.

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.

Connect to Sage 300 in RapidMiner

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

Publish Sage 300-Connected Dashboards in Tableau Server

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

Query Sage 300 in ColdFusion

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

Create SSAS Tabular Models from Sage 300

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

Connect to Sage 300 in CloverDX (formerly CloverETL)

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

Feed Sage 300 into FineReport

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

Build Dashboards with Sage 300 in DBxtra

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

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.

Working with Sage 300 in LINQPad

Execute LINQ queries to Sage 300 in LINQPad.

Connect to Sage 300 as a Linked Server

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

How to connect to Sage 300 in DBVisualizer

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

How to Connect DBeaver to Sage 300 via a JDBC Driver

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

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.

Integrate Sage 300 in the Pentaho Report Designer

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

Analyze Sage 300 in Infragistics Reveal

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

Import and Visualize Sage 300 in Power View

Create data visualizations based on Sage 300 in Excel.

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.

Create Reports with Sage 300 in SAP Crystal Reports

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

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.

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.

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.

Design BIRT Reports on Sage 300

Provide current Sage 300 to your embedded analytics.

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.

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 Asprova with CData Software ODBC Driver for Sage 300

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

Build Charts with Sage 300 in Clear Analytics

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

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

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 PowerBuilder

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

Visualize Live Sage 300 in Tableau

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

Visualize Sage 300 from Tableau

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

How to connect to Sage 300 from Google Apps Script

Use CData Software Connect Server to access Sage 300 in Google Apps Script.

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.

Connect to Sage 300 from PowerBuilder

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

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.

Create Apps from Sage 300 in Qlik Sense Cloud

Use the CData Connect Server to create an OData API for Sage 300 and build apps from live Sage 300 in Qlik Sense Cloud.

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.

Integrate with Sage 300 in JReport Designer

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

Connect to Sage 300 in DBArtisan

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

Import Sage 300 into Microsoft Power Query

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

Create Dynamic Sage 300 Grids Using the Infragistics XamDataGrid

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

Using AngularJS to Build Dynamic Web Pages with Sage 300

Use the CData Connect Server to create Sage 300 OData feeds and build single-page applications with live Sage 300.

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.

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.

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.

Manage Sage 300 in DBArtisan as a JDBC Source

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

Connect to Sage 300 from PowerBuilder

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

Use the CData ODBC Driver for Sage 300 in SAS JMP

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.

Connect to Sage 300 in Jaspersoft Studio

Execute SQL to remote Sage 300 in Jaspersoft Studio.

DataBind Wijmo Grid to Sage 300

Provide real-time Sage 300 to interactive controls.

Explore Geographical Relationships in Sage 300 with Power Map

Create data visualizations with Sage 300 in Power Map.

DataBind Controls to Sage 300 in Delphi

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

Integrating Sage 300 in Talend Cloud Data Management Platform

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

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.

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 in Sisense

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

Edit and Search External Sage 300 Objects in Salesforce Connect

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

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.

How to Import Sage 300 into SQL Server using SSIS

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

Analyze Sage 300 with Power Pivot

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

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

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

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.

Natively Connect to Sage 300 in PHP

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

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.

Publish Sage 300-Connected Dashboards in Tableau Server

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

Connect to Sage 300 in JRuby

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

Extract, Transform, and Load Sage 300 in Informatica PowerCenter

Create a simple Workflow for Sage 300 in Informatica PowerCenter.

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.

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

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 Build Dynamic React Apps with Sage 300

Use the CData Connect and React to Build Dynamic Web Apps with Live Sage 300 .

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.

Analyze Sage 300 in SAP Analytics Cloud

Use the CData Connect Server to create an OData API on top of Sage 300 and visualize Sage 300 in SAP Analytics Cloud.

How to Visualize Sage 300 Data in Python with pandas

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

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.

ETL Sage 300 in Oracle Data Integrator

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

Connect to Sage 300 in RunMyProcess through Connect Server

Use CData Connect Server to create an OData API for Sage 300 and connect to Sage 300 in Akorbi Digital RunMyProcess.

How to connect to Sage 300 from IntelliJ

Integrate connectivity to Sage 300 with wizards in IntelliJ.

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.

DataBind Controls to Sage 300 in C++Builder

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

Connect to Sage 300 in Ruby

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

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.

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.

How to connect to Sage 300 with Squirrel SQL client

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

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.

Connect to and Query Sage 300 in QlikView over ODBC

Create data visualizations with Sage 300 in QlikView.

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.

Connect to Sage 300 as a Linked Server

Use CData Connect to set up a linked server for Sage 300.