From mail to database (on the server), from database reports to mail + Web. Everything must be encrypted. What is better to do?

Question

Programming

Dear People!
I haven't programmed for almost 10 years, but now I have a task. So I'm asking for advice.
Problem essence: At the client the Program on the server (with basis SQL) is twisted. From time to time, it is necessary to take part of the information to a third-party server. At the same time, in connection with the client's security policy, communication is possible only through mail (and preferably only through outgoing mail). Further, on this third-party server, either daily or once a month, you need to generate a report and send it to the client. In addition, the Web is needed so that everything that has been collected can be viewed and printed, etc.
To do this, we set up sending data on the server (for starters, through SQL scripts). Next, you need to get everything on the mail server, add it to the database, generate and send reports, and make Web.
In a good way, all information must be encrypted. Perhaps this is a separate issue, or perhaps it needs to be addressed immediately and in a complex.
How and what is the best way to do this?
General considerations: the budget is not great. Therefore, I ask you to clarify the cost (estimated) of licenses for the entire arsenal of tools for the development and operation of this system.
Thanks in advance to everyone who will respond.

Answer 1

What kind of security policy is this, via mail? In my opinion, the crutch is the wildest.
Persuading a client to make a web face on his server that gives the necessary data (read api) will definitely not work? Then everything would become simple: with a script, we knock on the crown with the required frequency, take the data, do everything we need with it, and add everything to our database.
And for the client we make web pages with the necessary information and, if necessary, send reports to the mail with the same crown.
For security reasons, on the client server, only process requests from the ip of your server.
The cash costs for such an architecture are zero, unless the server is rented, if it does not already exist.