locked
Real-time Extraction of Data from Access DB RRS feed

  • Question

  • User1848764503 posted

    Good day all,

    I am about to implement a solution for a Bank, the solution is to read/extract transaction details from an ATM and read same into a database, numbered below is the workflow, I am not just sure of the best architecture to impose.

    1. The Bank has about 1,000 ATMs, connect to each ATM at 30 Minutes interval and move each Journal file from the ATM directory to a specific and centralized location.
    2. The Journal files are in ACCESS DB format.
    3. The file numbering system in the directory grows by size, so its possible to find only one file in a terminal but find up to 3 files in another terminal
    4. Read through each file and extract its record to a Database table
    5. The read/write of these records to the database is meant to be almost real-time (about 30mins delay the least), so its possible that the same file read in the first throughput is read again, however, only unique records should be imported into the database table.

    I can clarify further if there are grey areas, thank you.

    Tuesday, January 24, 2017 12:39 PM

Answers

  • User-821857111 posted

    That's off topic for these forums. They are intended for questions about ASP.NET only.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, January 25, 2017 1:13 PM

All replies

  • User-821857111 posted

    I don't think ASP.NET is a suitable tool for this requirement. It's for developing web sites.

    Wednesday, January 25, 2017 7:53 AM
  • User1848764503 posted

    Thanks Mike.

    I was actually thinking about using Windows Services using the .NET framework.

    Wednesday, January 25, 2017 12:38 PM
  • User-821857111 posted

    That's off topic for these forums. They are intended for questions about ASP.NET only.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, January 25, 2017 1:13 PM