Focal Point
Encrypt files to be emailed or FTP'd

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1951039982

June 30, 2008, 11:25 AM
Rhonda
Encrypt files to be emailed or FTP'd
Does anyone have a way of encrypting files that are to be distributed via email or FTP'd?
I found one technigue that involves holding the file to a permanent location and then making a call to the operating system to encrypt. Then the enduser must have a way of decrypting and/or password. Does anyone have a more elegant way of doing this?

Thanks in advance.


WebFOCUS & ReportCaster 8.1.05, 7.7.03 - AIX/LINUX, FOCUS 7.6.13 MVS, Output PDF, XLS-XLSX, DOCX and HTML
June 30, 2008, 12:11 PM
Sayed
I am not sure if this method will work for RCaster or FTP but worth a try. Look up chapter 11 Providing Data Source Security: DBA - Encrypting Data on "Describing Data With WebFOCUS Language".

Thanks,
Sayed


WF 8.x and 7.7.x Win/UNIX/AS400, MRE/Portal/Self-Service, IIS/Tomcat, WebSphere, IWA, Realmdriver, Active Directory, Oracle, SQLServer, DB2, MySQL, JD Edwards, E-BIZ, SAP BW, R/3, ECC, ESSBASE
June 30, 2008, 12:54 PM
Darin Lee
That deals more with encrypting/protecting source data than protecting report output.

I'm not on the latest version of WF, so I don't know if the issues of secure FTP or encrypted email has been addressed yet. If not, they should be immediately (got your ears on IBI?)

We have had to work around both of these issues in our environment. For FTP, the files are sent and/or held in a temporary environment on Linux, and then automated scripts are run periodically to securely FTP these files to specified locations.

For email, we just distribute via an email server that always encrypts unless specifically directed otherwise (by adding a u: to the beginning of the subject line). And, as you mention, the enduser is directed as to how they should log in to a secure site to receive the encrypted email. We actually do very little external email of sensitive data from ReportCaster, so we haven't had much comment or resistance to our methodology. The FTP process has worked quite well.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
June 30, 2008, 01:25 PM
Rhonda
Thanks Darin! I will investigate if we have email servers that will do that. Sounds very clean and elegant with minial amount of coding.


WebFOCUS & ReportCaster 8.1.05, 7.7.03 - AIX/LINUX, FOCUS 7.6.13 MVS, Output PDF, XLS-XLSX, DOCX and HTML
June 30, 2008, 01:33 PM
Tom Flynn
Hi Rhonda,

Don't forget to update your signature!!! At the top of the main Focal Point page is a link..

Where are you working in Atlanta???

Tom


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
July 01, 2008, 07:07 AM
Gerry
Encryption of zip files for both FTP and Email attachments is a new feature scheduled to be delivered in release 7.6.7.


WebFOCUS All Releases
July 01, 2008, 06:16 PM
Waz
Can you call a compression program and zip with a password ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

July 02, 2008, 08:38 AM
Rhonda
That was one of the solutions that I found. However you must place the eamil in a specific location for the encyption to take place.
We would then need to perform clean-up afterwards. as a post procedure. Thanks for the suggestion


WebFOCUS & ReportCaster 8.1.05, 7.7.03 - AIX/LINUX, FOCUS 7.6.13 MVS, Output PDF, XLS-XLSX, DOCX and HTML