Hi Sachin,
It can be real time or near real time, but not late :(. It can be either way - push or pull. But users will not request - It should automatically happen. whenever a record is created in geodatabase from GIS application, it should be automatically notified to X application in any way (on creation of record in GIS, automatically storing in other database/table that 'X' application is consuming or X application will monitor either the geodatabase or its own table continuously for new record). you could suggest us any options or other, it would be great. Please let me know for any other information required.
Thanks for your response.