Skip to main content

DataSource File Types

The appropriate file type should be selected from the Synergy environment according to the type of data source to be externally linked.

  1. A new file is created by right-clicking on the DataSource and selecting New Item.
    • Note: The selected new item object will allow selecting the link according to the selected type.

MSSQL Query is an expression used to query and manipulate data in a Microsoft SQL Server database. A Query is a combination of commands used to perform a specific operation on a database. Oracle Query is an expression used for querying and manipulating data in an Oracle database. A Query is a combination of commands used to perform a specific operation on a database. MySQL Query is an expression used to query and manipulate data in a MySQL database. A Query is a combination of commands used to perform a specific operation on a database. ODBC Query is an expression used to access databases that use the Open Database Connectivity standard. ODBC is a technology that simplifies applications accessing a variety of databases by providing a common interface to different database systems. REST Query is a query expression for web services based on Representational State Transfer (REST) principles. REST is an architectural style used to enable communication between web-based applications.

REST Query is used to access services offered through an API (Application Programming Interface), perform operations such as receiving, sending, updating, or deleting data. These queries send requests to the web service using methods based on the HTTP protocol, such as GET, POST, PUT, DELETE, and receive the responses. SAP Query allows users to access, query, and report on data in the SAP database. A user can select data tables, specify data fields, add conditions, and filter results through SAP Query.