Data Source Description

This chapter lists important parameters of all types of data sources that the supOS platform supports.

info

HANA data source is only for report elements presently.

Relational data source

Data Source	Parameter	Description
SQL Server	Data Source Version	The database version of the SQL server.
Oracle	Access Mode	Access the database by Server name or SID. Make sure to select the same mode as that of Oracle.

API data source

Data Source	Parameter	Description
Web Service	Address	Interface address of web service. Click Parse after entering the address, and then supOS automatically starts parsing the address.
	HTTP Authorization	Enable HTTP authorization and enter username and password to get authorization.
	Method	Select corresponding methods based on the address parsing results.
	Resolve Path	Data path in response data XML file. For example: Body/OutputParameters/P_OUT_CONTENT/HEADERS/HEADER.
	Input Mode	Displays corresponding input parameters based on the selected mode. List mode: Click New and enter the parameter information under Input Parameter. Xml mode: Configure data interface by entering xml text.
	Output Mode	Displays corresponding output parameters based on the selected mode. Parse means to parse strings to display parameter list, and No parse means to return JSON strings.
RESTful	HTTP Method	Request method of HTTP, which can be GET or POST.
	Response Character Encoding	Select character encoding method.
	Maximum allowable amount of data at one time	Set the maximum data volume returned at one time.
	Headers Parameter	Header parameter of HTTP request.
	Body parameters	Body parameter of HTTP request. FormData: Form submit method. You can select parameter type from Object and List, and click New to add parameters. JSON: JSON submit method. You need to enter input parameters in JSON format. info When setting GET or DELETE as HTTP Method, only Form-data parameter is available.
	Output parameter configuration	The output parameters of the API.
	Output Type	The output type of the API.
	Response Result	Response result of the API.

Object model data source

Parameter	Description
Local Data Source	Enable it to make the current supOS platform to be the data source.
supOS Address	Enter another supOS address and port.
supOS Tenant	Enter tenant name when the supOS is multi-tenant version.
supOS Authentication	When connecting to another supOS platform, the supOS authentication is necessary. You can use the generated AK/SK credential to access the openAPI of supOS. For details, see Managing AK/SK Certificate.

File data source

Data Source	Parameter	Description
Local and server file directories	Type	Only Server file is available.
	Database File Path	Enter the absolute path under /volumes/supfiles/. If the path does not exist, the platform will create it automatically.
HDFS	File Directory Relative Path	Directory relative path on hadoop server, and it stores HDFS files generated during Hive data transferring.
	Server address/port	The IP address and port of hadoop server.

info

• EXCEL and CSV files are supported.
• HDFS must be working with Hive.

Big data storage

Data Source	Parameter	Description
Hive	Data Transfer	Enable it and select an HDFS data source to save data to Hive through HDFS.
HBase	Zookeeper IP/Host	Enter the Zookeeper IP address. When it is under cluster deployment, use English comma to separate addresses.
	Zookeeper Port	Zookeeper port. It is 2181 by default.
	Master IP/Host	Master IP or hostname of cluster Zookeeper. Leave it empty when it is not under cluster deployment.
	Special Authentication	Leave it as default.

info

To connect with HBase data source, you need to cnfigure parameters at the X-ETL backend. For details, see Using X-ETL.