Map the datatypes provided by Replication Server to the datatypes used by Event Stream Processor.
Replication Server supports other databases (such as Oracle, Microsoft SQL Server, and IBM DB2 UDB) and the datatypes that they use. It provides data to ESP using the datatypes shown in the mapping table. These datatypes are also used by Adaptive Server Enterprise.
Unsupported datatypes may need to be mapped. For example, when using Oracle datatypes, there are two options for handling Oracle BIGDATETIME and TIMESTAMP values.
ra_config pdb_convert_bigdatetime, trueIn the Replication Server repdef, define the Oracle BIGDATETIME and TIMESTAMP columns using the corresponding SAP datatype (bigdatetime, timestamp)
create replication definition oraBIGDATETIMErep with primary at rao.aeoracle with all tables named 'TESTBIGDATETIME' (ID INTEGER, ORABIGDATETIME bigdatetime, ORATIMESTAMP timestamp) primary key (ID)
ra_config pdb_convert_bigdatetime, falseIn the RS repdef, define the Oracle BIGDATETIME and TIMESTAMP columns using the RAO defined data types (rs_oracle_bigdatetime, rs_oracle_timestamp9) and map them to the corresponding SAP datatype (bigdatetime, timestamp)
create replication definition oraBIGDATETIMErep with primary rao.aeoracle with all tables names 'TESTBIGDATETIME' (ID INTEGER, ORABIGDATETIME rs_oracle_bigdatetime to bigdatetime, ORATIMESTAMP rs_oracle_timestamp9 map to timestamp) primary key (ID)
Replication Server also handles the different character sets used by supported databases. It provides data to the adapter in Unicode. ESP has Unicode (UTF-8) support: it is turned off by default and may be turned on for individual projects. See the Project Configurations topic in the Studio Users Guide for details.
ESP Datatype | Replication Server Datatypes |
---|---|
integer | smallint, tinyint, int, bit |
timestamp | datetime, time |
date | date, smalldatetime |
long | bigint, unsigned bigint, unsigned int, unsigned smallint |
string | binary, char, unichar, nchar, nvarchar, varbinary, univarchar, varchar, timestamp |
float | numeric, float, real |
money | money, smallmoney |
bigdatetime | bigdatetime (ASE15.7 or later) |
boolean | bit |
binary | varbinary |