Connection to an Oracle database system

Archive Server -> Evacuating to SQL database -> Connection to an Oracle database system
Previous chapterNext chapter Show allShow all    Hide allHide all

It is possible to outsource data into an Oracle data base, but under certain conditions.

 

attention Attention

If the table should be created directly from zenon in the SQL Server, the logged user has to have the authorization for CREATE Table. If the user does not have this authorization, tables cannot be created automatically.

 

attention Attention

In the Cross Refernece Table the user must be authorized to executet the statements INSERT, DELETE and SELECCT. (UPDATE ist not used, DELETE only used if a variable is added or removed.

 

attention Attention

Oracle must have an ODBC Oracle Client. It is an advantage, if the version number on the oracle server and on the client do not differ too much, because that could lead to unwished format-effects.

 

attention Attention

The time format of zenon is in GMT starting 1970 (DWORD). Oracle uses a differtent time stamp that has to be changed at oracle side with a trigger.