Archive for April, 2010

SQL Field Procedures in IBM i 7.1

Posted by on Tuesday, 20 April, 2010

Field Encryption on the IBM i just got easier.

SQL Field Procedures are a new DB2 feature in version 7.1 that allows a user-specified “exit” program to be called whenever data is read from, inserted into, or updated in a field (column).   This is somewhat similar to database column triggers; however there are two distinct advantages:

  1. Field Procedures allow data to be modified on a Read operation, which allows the exit program to automatically decrypt the field value before it is returned to the customer’s application.
  2. Field Procedures provide a separate internal space to store the encrypted version of the field value.  This allows organizations to encrypt numeric fields such as packed decimal, signed decimal and integer data types without having to store the encrypted values in a separate file.

While IBM provided the hooks into the database with Field Procedures, they rely on 3rd party vendors like us to provide the encryption functions and key management. Linoma worked closely with IBM to test the new Field Procedures and provide feedback to their development team during the early release beta program for 7.1.  This also allowed Linoma sufficient time to fully integrate Field Procedures into Crypto Complete for readiness when i 7.1 ships.

We’re excited about Field Procedures since it will allow customers to implement column-level encryption on the IBM i without modifying their applications.  This is especially important if a customer is running a canned application and/or does not want to modify their source code.

Massachusetts Has Set the Bar for Securing Personal Data; Is Your Company Compliant?

Posted by on Friday, 16 April, 2010

Personal data privacy is one of the greatest concerns individuals have when doing business over the web and in person.  It seems it is commonplace for a company to notify their customers that their personal and/or account information has been compromised by a hacker or a disgruntled employee (e.g. TJ Maxx, Wells Fargo, Bank of America).  While you’d think businesses would do everything they can to protect their customers’ personal information, they will weigh the risks and likelihood of a data breach happening versus the cost and time to implement such security measures.  Knowing this, the payment card industry (PCI), government agencies and many states have put together a list of requirements that businesses must follow in order to do business with them or in their state.  The problem is they often don’t enforce these regulations and fines are only imposed after a data breach happens.

I just returned from Framingham, Massachusetts where we exhibited at the Northeast User Group conference.  Massachusetts has a very strict data privacy law.  Not only do businesses in Massachusetts need to protect their customers’ personal information but so do businesses who have in their database the personal identifiable information of people from Massachusetts.  One of the requirements says organizations must:

“Encrypt all transmitted records and files containing personal information that will travel across public networks.”

Several of our customers mentioned our products have helped them meet the Massachusetts’ data privacy requirements.  They have implemented field encryption using Crypto Complete and are using our GoAnywhere Director to encrypt file transfers.  They have minimized the risk of a data breach happening at their company by using both solutions.  Unfortunately, I also had many other individuals stop by Linoma’s Booth who said their management does not want to allocate any resources (time or money) towards securing personal and confidential data.  They know they should do it and are required to do so, but it’s just not high on their priority list right now.  I’m afraid this mindset may be more popular than we think, which is concerning.

Is the company you work for securing personal data?  Is your company looking for a solution to secure data?  Find out today how we can help your company avoid sending the inevitable letter that your confidential information has been breached. Not only can we help you avoid facing public humiliation, our products can help save you time and money by streamlining the secure data transfer process.

If you are interested in seeing how Linoma’s solutions can encrypt your data at rest and when it’s transferred, don’t hesitate to contact us at 800-949-4696.

Brian Pick

Sales Manager

Tested my new iPad with GoAnywhere – It works!

Posted by on Tuesday, 6 April, 2010

Picked up my new iPad last night from the local Apple store.  It was busy in there, but they had plenty of employees to help the eager customers!  They had just received a shipment of iPads a few hours earlier, so I was in and out of the store with the little iPad box in just a few minutes.

I had been reading all the hype on the internet and thought it would be fun to try out this slick new device.

Both my kids have iTouches and love them, but I always thought the  screens were too small to be useful for internet browsing, watching videos, etc.  From what I had read from critics, the iPad was nothing more than a supersized iTouch… which I found is mostly true… but that big touch screen on the iPad is awesome!

First thing I did when I unboxed my iPad was to fire up Safari (the built-in browser) and  see how well it rendered web pages.  It did a nice job for web surfing.  The pages rendered very well.  It was easy to click on hyperlinks (using my finger instead of a mouse was a little weird at first, but it works great with that big screen.  I only “fat fingered” a couple links.).  Only thing I found it doesn’t support is Flash content, but hopefully Apple will get enough flack and will eventually support it.

Next I tried to connect to our GoAnywhere Director product through the iPad’s Safari.  It took me right to the login screen.  I keyed in the GoAnywhere user/password (using the touch screen keypad) and hit submit.  Login Failed!  Found out that I mistyped the user id, which is easy to do until you get used to typing on this thing.  Once I corrected it, I hit submit again and it took me right to the GoAnywhere dashboard.

GoAnywhere’s screens were rendered perfectly!  All of the graphics were lined up nicely.  The font styles and colors looked very sharp.  The drop down menus worked.  I was able to create a couple projects in GoAnywhere and execute.  No problem.  The performance was very good.   GoAnywhere’s client interface does not use applets, ActiveX controls or Flash… just HTML and JavaScript.  So I suspect that is why iPad’s Safari did not have any problems with it.  So when you are on the road with your iPad, you too will be able to work with your copy of GoAnywhere!

Besides using the browser, iPad is great for watching videos too.  It has a NetFlix app that lets you watch movies real time, which is great.    Eventually I hope most NetFlix movies are available to watch online so I don’t have to goto my mailbox for DVDs any more.

At first I was thinking about giving away this iPad at the next trade show as a prize, but now I think I will keep this one for myself.. and buy another one for the giveaway :)

The iPad is addictive.

~ Bob

1.800.949.4696  |  sales@linomasoftware.com  |  privacy policy
Copyright ©1994 - 2012 Linoma Software  |  All rights reserved