Introducing
Your new presentation assistant.
Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.
Trending searches
Questions?
What are Remote Objects?
Answer: Remote Objects are refer to Objects/Tables located in OLTP Database. Records in these objects are prepared to ship into ODS database.
Remote Objects are:-
DataStoreInserts1Mast
DataStoreInserts1
DataStoreInserts2Mast
DataStoreInserts2
DataStoreUpdatesMast
DataStoreUpdates
What additional jobs will done from Camstar Web Server site if found out DataStore is presents?
Answer: Camstar Web Server will perform additional job in generating records in OLTP Remote Objects.
Example
Creating a new factory will have Web Server generate the following DML statements.
Insert into factory (factoryid, factoryname, changecount) values('4000000fd23','SGP', 1)
Insert into ChangeStatus (changestatusid) values ('48000000ds31') and etc
An Addtional records will be generate into Remote Objects, such as below.
Insert into Remote_DataStoreInserts1Mast (ID,TXNID,Status,RecordDate,Server,CDOID,ERROR) values (1,'400000ds01', 'P', '20150208','MyPC',...)
Insert into Remote_DataStoreInserts1 (TXNID,Sequence,TXNType, SQLSTMT)
Values ('400000ds01',1,'P',' All DML Statement in Normal Transaction within 8KB');
End Of OLTP Jobs
INSITESITEINFO.TVALUE = 'Y'
How Camstar know which objects should propagate to ODS?
Camstar Management Studio
Answer: In Camstar Insite Designer, User can configure which tables records shall be propagate to ODS.
Upon Datastore database being created and assigned.
Single click on
[Create New Database Tables...]
or
[Update Database...]
in Camstar Management Studio will automatically populate necessary Database objects into OLTP and ODS.
Is Camstar Datastore Enable?
YES Action:
Perform Normal Transaction and Create ODS Transactions into Remote Objects.
Camstar ODS Database
Camstar OLTP Database
Camstar Platform Application
Camstar Application Server
No Action:
Perform Normal
Transactions into
Camstar Objects.
Camstar Web Application & Portal Connect to
Web Application Server
Web Applications
Portal Applications