CData Power BI Connector for Sage 300
The CData Power BI Connector for Sage 300 offers self-service integration with Microsoft Power BI. The connector facilitates live access to Sage 300 data in Power BI from the Get Data window. The connector also provides direct querying to visualize and analyze Sage 300 data.
See Getting Started for a guide to create the Sage 300 data source and connect from the Get Data window.
See Getting Data to load or edit data from Sage 300.
Advanced Features details additional features supported by the connector, such as defining user defined views, ssl configuration, remoting, firewall/proxy settings, and advanced logging.
Using the Data Connector
See Using the Connector for a walk-through of creating reports that query Sage 300 in real time.
See User Defined Views to construct virtual tables whose contents are determined by a pre-configured query, which will then be discovered among existing table metadata.
See SQL Compliance for a syntax reference and code examples outlining the supported SQL.
See Data Model for information on the available database objects and how to use SQL to work with Sage 300 APIs. This section provides more detailed information on querying specific Sage 300 entities.
The Connection properties describe the various options that can be used to establish a connection.