Method, apparatus and computer program to provide access to client records and data resources

A non-transitory computer readable medium storing a software program that, when executed, controls a processor to perform:

• receiving a data file at a server, the file being sent from at least one client and including client requirements;
• storing the received data file locally at the server;
• executing an application that scans the server to determine whether any new data files have been received since a prior scanning operation, wherein the application that scans the server comprises scanning at least one of an FTP server and a SSH server to determine whether any new data files have been received since the prior scanning operation;
• copying the new data files determined to be in the server;
• transmitting the new data files to an export folder under a file cluster in a server file;
• updating a parse queue table stored in a SQL database server to indicate that the new data files have been stored in the export folder under the file cluster;
• deleting the locally stored file from the server;
• and
• moving the new data files from the export folder under the file cluster back to the server so that the at least one client may access the exported files.

A server configured to handle incoming data files, the server comprising:

• a receiver configured to receive a data file, the file being sent from at least one client and including client requirements;
• a memory configured to store the received data file locally at the server;
• and
• a processor configured to
• execute an application that scans the server to determine whether any new data files have been received since a prior scanning operation, wherein the application that scans the server comprises scanning at least one of an FTP server and a SSH server to determine whether any new data files have been received since the prior scanning operation,
• copy the new data files determined to be in the server,
• transmit the new data files to an export folder under a file cluster,
• update a parse queue table stored in a SQL database server to indicate that the new data files have been stored in the export folder under the file cluster, and
• delete the locally stored file from the server, and locate the new data files specified by the client requirements from the export folder under the file cluster so that the at least one client may access the exported files.