Focal Point
Encrypt files to be emailed or FTP'd
June 30, 2008, 11:25 AM
RhondaEncrypt 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
SayedI 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 LeeThat 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
RhondaThanks 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 FlynnHi 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
GerryEncryption 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
WazCan you call a compression program and zip with a password ?
Waz...Prod: | WebFOCUS 7.6.10/8.1.04 | Upgrade: | WebFOCUS 8.2.07 | OS: | Linux |
Outputs: | HTML, PDF, Excel, PPT |
In Focus since 1984 |
Pity the lost knowledge of an old programmer! |
July 02, 2008, 08:38 AM
RhondaThat 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