Which FlexConnector to use?
I have following queries regarding Flex connector:
1) I need to collect audit logs from Oracle 11g. Is there default connector available or I need to develop Flex connector?
2) We have one ERP application which writes logs into Oracle database, which is supposed to be send to Logger. There are multiple tables and it doesn't have primary key. Only NOT NULL is a restriction in tables. Which Flex connector can I use for such type of logs?
1) It depends on OS which Oracle runs on. There is connector 'SmartConnector for Oracle Audit Syslog' for syslog or 'SmartConnector for Microsoft Windows Event Log – Native: Oracle Audit' for Windows. So tell what OS your Oracle runs on and I'll tell you what guide you should use.
ERP writes the logs in the Oracle but in different tables so smartconnector for audit logs of oracle can not be used to collect ERP logs. In my case, ERP admin made a script and put the logs in tables every one hour and I created time based DB to collect those logs.
ya, that becomes problem if table does not have a primary key. There is no guarantee of log collection in order of older to newer. I am yet to figure out any way for this. Let me know, if you find.
Time based doesn't required a primary key it requires a datetime or timestamp and some combination of fields to differentiate between rows with duplicate timestamps, ID based requires a unique (incrementing) identifier though this doesn't necessarily need to be a Primary Key. Is there a timestamp in the log table?