Attributes

Description

String Type

Peut prendre les valeurs suivantes :

•         csv: data source is a CSV file. Complete path of the CSV file is filled into Path attribute.

•         oracle: data source from Oracle database

•         mysql: data source from MySQL database

•         postgresql: data source from PostgreSQL database

•         sybase: data source from Sybase database

•         as400db2: data source from IBM DB2 for iSeries database

•         sqlserver: data source from Microsoft SQL Server database

•         saptable: data source from table of SAP system

•         sapbapi: data source from BAPI result table

String SrvAddr

The IPv4 address of the server hosting the database : Oracle, MySQL or PostgreSQL.

Example:

192.168.1.7

String Port

The port number of the server hosting the database : Oracle, MySQL or PostgreSQL.

Example:

1521 for Oracle

3306 for MySQL

6078 for PostgreSQL

String User

Name of the database user.

String Password

Password of the database user.

String DBName

Database name.

Example:

XE for Oracle

test for MySQL

newold for PostgreSQL

String Query

SQL query.

Example:

select * from test.marci where title > 'g'

String Path

Complete path of the CSV file when Type = csv.

Example:

c:\\temp\\source.csv

String ClientSAP

SAP client.

Example:

001

String LangSAP

Language of SAP system.

String AshostSAP

Host name of a specific SAP application server.

Example:

192.168.1.7

String GwhostSAP

SAP gateway host on which the server should be registered

Example:

192.168.1.7

String GwservSAP

SAP gateway port.

Example:

3300

String SysnrSAP

SAP instance number of the server.

Example:

00

String TableNameSAP

Name of SAP system table.

Example:

SBOOK

String RowskipsSAP

Number of records from the SAP table selection, which is not taken into account

Example:

If 50 records are returned from the search in the SAP table, and that RowskipsSAP = 10, then the output CSV file only contains 40 lines. The first 10 records are not taken into account.

String RowcountSAP

Maximum number of potential records returned from a selection in a SAP table.

Example 1:

If RowcountSAP = 100, and 200 records correspond to the selection, then the result CSV file will contain only 100 lines.

Example 2:

If RowcountSAP = 100, and 70 records match the selection, then the CSV file will contain 70 lines.

String FoiSAP

Table fields selected in the query. Corresponds to SELECT within SQL query.

Example:

CITYFROM,CITYTO,DISTANCE,ARRTIME,DEPTIME

String QuerySAP

Selection condition in the query.Correspond to WHERE within SQL query. The value to compare has to be between single ribs.

Example:

CITYFROM = 'ROME'

String BAPIName

BAPI name (Business API (Application Program Interface)) or "RFC enabled functions module."
If BAPIName is entered, the following fields are not taken into account when executing the BAPI: TableNameSAP, RowskipsSAP, RowcountSAP, FoiSAP, QuerySAP.

Example:

BAPI_FLBOOKING_GETLIST

String BAPIResultTable

The result of the execution of the BAPI is in different tables. If BAPIName is specified, it must also be specified BAPIResultTable.

Example:

For the BAPI "BAPI_FLBOOKING_GETLIST", one result table is: BOOKING_LIST.

Map<String, String> ParameterMap

The field is optional. It is a map containing the name and the value of the parameter of the BAPI
Example:

For the BAPI "BAPI_FLBOOKING_GETLIST", one of the parameters is: MAX_ROWS.
In the Java code, a hm map is created and parameters are put into hm. Then this collection is assigned to the ParameterMap parameter.

Map<String,String> hm = new HashMap<String,String>();

hm.put("MAX_ROWS", "70");
myDataSource.setParameterMap(hm);

Attributes

Getters(read)

Setters (write)

String Type

getType()

setType(String)

String SrvAddr

getSrvAddr()

setSrvAddr(String)

String Port

getPort()

setPort(String)

String User

getUser()

setUser(String)

String Password

getPassword()

setPassword(String)

String DBName

getDBName()

setDBName(String)

String Query

getQuery()

setQuery(String)

String Path

getPath()

setPath(String)

String ClientSAP

getClientSAP()

setClientSAP(String)

String LangSAP

getLangSAP()

setLangSAP(String)

String AshostSAP

getAshostSAP()

setAshostSAP(String)

String SysnrSAP

getSysnrSAP()

setSysnrSAP(String)

String TableNameSAP

getTableNameSAP()

setTableNameSAP(String)

String RowskipsSAP

getRowskipsSAP()

setRowskipsSAP(String)

String RowcountSAP

getRowcountSAP()

setRowcountSAP(String)

String FoiSAP

getFoiSAP()

setFoiSAP(String)

String QuerySAP

getQuerySAP()

setQuerySAP(String)

String BAPIName

getBAPIName()

setBAPIName(String)

String BAPIResultTable

getBAPIResultTable()

setBAPIResultTable(String)

Map<String, String> ParameterMap

getParameterMap()

setParamterMap(Map<String, String>)