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.
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.
The Journal files are in ACCESS DB format.
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
Read through each file and extract its record to a Database table
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.
None
0 Points
2 Posts
Real-time Extraction of Data from Access DB
Jan 24, 2017 12:39 PM|jiborsky|LINK
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.
I can clarify further if there are grey areas, thank you.
All-Star
194428 Points
28074 Posts
Moderator
Re: Real-time Extraction of Data from Access DB
Jan 25, 2017 07:53 AM|Mikesdotnetting|LINK
I don't think ASP.NET is a suitable tool for this requirement. It's for developing web sites.
None
0 Points
2 Posts
Re: Real-time Extraction of Data from Access DB
Jan 25, 2017 12:38 PM|jiborsky|LINK
Thanks Mike.
I was actually thinking about using Windows Services using the .NET framework.
All-Star
194428 Points
28074 Posts
Moderator
Re: Real-time Extraction of Data from Access DB
Jan 25, 2017 01:13 PM|Mikesdotnetting|LINK
That's off topic for these forums. They are intended for questions about ASP.NET only.