Data Source Definition

X-UP gathers data in a variety of formats from a variety of data sources and processes them to create new data. This chapter describes the types of data sources supported in X-UP.

The following data sources are supported in X-UP.

An X-UP data source is comprised of information configured to connect to an external data source. The information used for access varies depending on the data source type.

SAP RFC Data Source

Go to [Select X-UP Project > X-UP > New X-UP DataSource] to open a screen for creating a new data source.

To create an SAP RFC data source, select [SapRfc] from the [DataSource Type] drop-down menu and enter the data source information.

Name

Description

Name

Data source name.

Description

Description

charset

Character encoding. (default: UTF-8)

Timeout (msec)

Standby time for failures. (1000 = 1 second)

Id

ID

Password

Password

Client

SAP RFC client information.

Host Name

SAP RFC host name information.

System Number

SAP RFC system number information.

Repository

SAP RFC repository information.

Lang

Language setting. (e.g. “en”)

Parameters

Parameters required for service connection.

DB data source

Go to [Select X-UP Project > X-UP > New X-UP DataSource] to open a screen for creating a new data source. To create a DB data source, select [DB] from the [DataSource Type] drop-down menu and enter the data source information.

Name

Description

Name

Data source name.

Description

Description

DBMS

Select one of the following: Oracle, MSSQL, MySql, DB2

Driver Name

Driver name. (e.g. oracle.jdbc.driver.OracleDriver)

Connection URL

Connection URL. (e.g. jdbc:oracle:thin:@127.0.0.1:1521:dbms)

User ID

ID

User PW

Password

Database

Database name.

Charset

Character encoding. (default : UTF-8)

Timeout (msec)

Standby time for failures. (1000 = 1 second)

ConnectionPool maxActive

Maximum connection pool size.

ConnectionPool maxIdle

Maximum idle pool size.

OpenApi Data Source

Access [Select X-UP Project > X-UP > new X-UP DataSource] to create a new data source. If you want to create an OpenApi data source, select OpenApi for DataSource Type.

Name

Description

Name

Data source name

Description

Description of a data source

HTTP URL

HTTP URL to connect with

Charset

Encoding (default : UTF-8)

Timeout(msec)

Waiting time for an error (1000 indicates 1 second)

Parameters

Parameters necessary for connecting with a service

Auth Type

Select Auth Type

(None or User Key / Basic Authentication / User Define Login Page)

User ID

User ID for HTTP auth (optional)

X-UP data source

Go to [Select X-UP Project > X-UP > New X-UP DataSource] to open a screen for creating a new data source. To create an X-UP data source, select [X-UP] from the [DataSource Type] drop-down menu and enter the data source information.

Name

Description

Name

Data source name.

Description

Description

ServerURL

URL of server to be connected.

Charset

Character encoding. (default: UTF-8)

Timeout (msec)

Standby time for failures. (1000 = 1 second)

Parameters

Parameters required for service connection.

Auth Type

Auth Type selection.

(None or User Key / Basic Authentication / User Define Login Page)

OData data source

Go to [Select X-UP Project > X-UP > New X-UP DataSource] to open a screen for creating a new data source. To create an OData data source, select [OData] from the [DataSource Type] drop-down menu and enter the data source information.

Name

Description

Name

Data source name.

Description

Description

Type

SAP / Non-SAP setting.

Host

Target host for connection.

Port

Connection port.

User ID

User ID.

User PW

User password.

Client

SAP NetWeaver Gateway Client ID

Authentication

Authentication type selection. (Basic, X.509)

Format

Format to be used by default when communicating with an OData source.

Use SSL

SSL usage setting.