Oracle as External data

Data Source Name

    External data's name.

Server or Data File

    Net name in Oracle.

Database Name

    Null

Note:

1.If there exist following data types in oracle table:

BLOB, CLOB, NCLOB, BFILE

when tables are registed, error will occur.

Suggestion:

New a view to exclude these fields, and then register them in excel server.

2. Write and Mapping can be set only on non-view tables.

3. If ExcelServerRCID and ExcelServerRN are added in non-view table, mapping can be set in this table only.

ExcelServerRCID and ExcelServerRN are case-sensitive. ExcelServerRCID is 20 varchar. ExcelServerRN is INT.