Monday, November 23, 2009
- enforce new regulations and policies not built into your application
- create helpful dynamic links to external sources of information
- dramatically expand your ability to track user/application interactions for the purposes of auditing and corrective actions
If you are interested in discussing how Ratchet-X can assist with your compliance program, give us a call. Further, fell free to view the following video which touches on the compliance use case.
Tuesday, October 27, 2009
Ratchet-X For ImageRight Plug-In Video
Ratchet-X for ImageRight is compatible with all version 3.5 and higher of ImageRight and is available from Vertafore. You can contact us or Vertafore for more details.
Tuesday, September 8, 2009
ImageRight User Conference Follow-up
We announced at the conference the official release of Ratchet-X for ImageRight. If you’re an ImageRight user and have been deferring on integrating more of your applications because of the integration costs, I recommend you give us a call and check out the new release. Ratchet-X for ImageRight is compatible ImageRight versions 3.5 and above.
Special thanks to George Weihs for performing a yeoman’s job and pulling double duty in the booth.
Thursday, May 28, 2009
Ratchet-X and ETL
No doubt, modern application development and deployment technologies coupled with “smart” infrastructure are enabling organizations to integrate more-and-more systems in real time. However, despite the advances, ETL is still a reality of life in organizations of all sizes. So the question asked often asked of us at the show was; “Where does Ratchet-X fit within the ETL process?” Glad you asked.
Let me first say that while Ratchet-X does extract, transform and load data between systems, it is not a traditional ETL tool. When I think about ETL, I think of scheduled batch jobs that process and move data between queues and systems. Generally, ETL processes are executed during non-prime time usage or maintenance hours for the purpose synching data across systems. While the term ETL can be used to describe other related processes, I think this is what most folks mean when they refer to ETL.
So, if Ratchet-X extracts, transforms and loads data, why isn’t it an ETL tool? It’s mostly a matter of perspective. Whereas most ETL processes are scheduled to run in batch, work with large data sets and have little end-user interaction, Ratchet-X is an on demand data processing platform that processes a single record set at a time and is often guided by the end-user.
Most of our customers use Ratchet-X to add new features to existing applications without changing those applications in any way. These new features usually involve:
- Acquiring data from an external source (e.g. web services, web site, electronic form, database, API, etc).
- Sending application screen data to an external source.
- Processing application screen data for the purposes of either transforming it in some way or kicking off a down stream process.
In most cases, Ratchet-X is processing one or more application screen’s worth of data that collectively constitutes a single record set (i.e. a composite customer record, an insurance policy, a shipping manifest, etc.). Ratchet-X is not usually used to process thousands of these record sets at a time. Further, Ratchet-X is almost always used under the watchful eye of the end-user. In reality, Ratchet-X is an “assistive” technology that allows an end-user to acquire, push or process data to and from the systems they use without having to rekey data and reducing errors. This doesn’t sound like ETL to me.
So, uh, where is it that Ratchet-X fits into the ETL process? Oh yeah. No ETL process is perfect. In fact most ETL processes have an error handling stage where exceptions and records that fail validation are kicked out to an exceptions queue. Once in the queue, the user then must manually review and rekey the corrected information into the target system or error handling interface. This is precisely where Ratchet-X can be very useful. For example, we have customers that set up Ratchet-X’s task list as the exception handling queue so users can easily review the data, make whatever corrections are necessary and immediately paste the corrected record into the target application.
So while Ratchet-X is not an ETL tool per se, it can serve as an important part of the error handling stage of most ETL implementations. If you have any questions or comments regarding how Ratchet-X can be used to supplement your ETL process, please drop us a line. We’d love to hear from you.
If you'd like to see a video regarding how Ratchet-X can be used as part of your ETL efforts, click here.
Tuesday, January 6, 2009
SOA Dead...Again?
While the media is replete with proclamations about the state of technology movements and buzzwords, discussions such as these are merely academic. Why is this? It has a lot to do with the media’s lack of nuance. To those who opine on such matters, attention spans are short so often something is either in or out, big or small, paramount or irrelevant. Fortunately, that’s not the way the real world works.
I agree with Burton Analyst Anne Thomas Manes’ summation that services is where it’s at. I’ve always held that belief. I was highly suspicious when discussions of web services gave way to SOA because the conversation transitioned from a compact and tangible concept to a much larger and nebulous concept. Read achievable versus hard to achieve.
When companies turned their attention to the broader idea of SOA, the appeal of project-based implementations and small wins went out the window. SOA became a religion that organizations had to strategically adopt from the start otherwise its benefits were not to be had. I strongly disagree. While most organizations would love to strategically embrace SOA from day one and experience “spectacular gains”, in most cases it’s not a practical approach. Small implementations, lessons learned, quick wins and replication is a much more sensible path. Over time, as success builds upon success, services ultimately become the way business functions are exposed by an organization. Along with it come the registries, management and scaling layers required for broader success. Dare I say, these services and the methodologies used to design, develop and deploy them ultimately become strategic? I'll buy that.
So if we’re bidding the term SOA a fond adieu, so be it. What’s in a name? But let’s go easy on the “SOA is Dead” and “…great failed experiment” language. The more these kinds of terms are thrown around, the more they stick with decision makers and are used against those fighting the good fight to implement services.
Monday, October 6, 2008
Quick Copy: Simple Elegance
For example, have you ever used Ratchet-X to move data from one screen to another? While we spend a lot of time talking about integrating existing application screens with external data sources, we tend to down play the simple screen-to-screen copy feature. That’s unfortunate because virtually every Ratchet-X user indentifies this as a need, and yet we tend to demo this feature only after being asked.
So, for all of you who constantly enter data into multiple screens either for data entry purposes or launching queries in other desktop systems, I recommend you give the Quick Copy feature a look. Quick Copy is a simple feature that allows you to link fields on multiple screens so that data can flow between these screens in either direction. Simple, but pretty powerful when it comes to speeind up those pesky repetitive typing tasks.
Check Quick Copy when you get a chance. Better yet, give me a call and I’ll demo it for you.
Wednesday, July 30, 2008
Ratchet-X and Application Rationalization
Ratchet-X can be a very helpful tool during the application rationalization process. Often, applications are kept in production because they provide some functionality that can’t be added to a preferred system. Ratchet-X allows organizations to add or integrate that functionality into the preferred system quickly and easily thus allowing the redundant system to be sunset. Further, the rationalization process uncovers a slew of integration code and cron jobs that shuttles data between systems. Ratchet-X can help alleviate this web of spaghetti code by allowing organizations to deliver information normally moved in batch, to applications in real time at the point of need.
So, if you’re engaged in or considering undertaking an application rationalization project, keep Ratchet-X in mind as you evaluate system consolidation.
Friday, May 30, 2008
Document Enable Any Application With Ratchet-X
One example where Ratchet-X is repeatedly applied beyond the original customer project is in the area of enterprise document management (EDM). Once customers realize that Ratchet-X is actually a piece of desktop middleware that brokers a “conversation” between application screen data and external data sources (and not merely an integration tool purchased to solve a specific problem), integrating applications into the customer’s EDM system is a natural fit.
Ratchet-X is now commonly being used as a way to both submit documents to, and retrieve data from, EDM repositories. On the capture side, Ratchet-X works best with images and forms since the information used for indexing the documents is often available in the integrated application screen. With regard to document retrieval, pretty much every application user can benefit by an onboard ability to instantly link to documents that relate to the entity referenced by the application screen data. Since Ratchet-X enables more applications, and by extension users, to leverage the EDM, the costs associated with purchasing and maintaining the EDM is justified over a much larger pool of users.
Not many products can claim they dramatically impact the ROI of the other products running within the organization. So try integrating Ratchet-X with your EDM back-end and let me know how it goes. Also be on the lookout for the release of Ratchet-X plugins that integrate into the industry’s most popular EDM products. If you’re thinking of doing such an integration, make sure you check with us to see if we have a plug-in for your EDM in the pipeline.
Wednesday, May 7, 2008
Twitter - I Just Don't Get It! Never Did, Never Will.
Does anyone over the age of 18 really need to know at this moment which friend is picking the nuts out of his teeth from the Snickers bar he just ate? The only reason I know it was a Snickers bar is because I received an urgent alert to that fact five minutes prior as he was unwrapping said Snickers bar.
Just because we have the technical ability to transmit every fleeting thought and the undertaking of every mundane task doesn't mean we should. But what do I know, I'm just a cranky old geezer with a little less time on my hands than some.
If you're connected to me via Twitter, you probably know that already.
Monday, May 5, 2008
What's New in Ratchet-X Version 3.5?
Assembles
The most significant change in version 3.5 is the introduction of Assembles. While Ratchet-X has always had the ability to extract, paste and manage datasets that scan multiple applications and application screens, version 3.5 shifts the responsibility of supporting this feature from the plug-in developer to the appspace creator and the platform itself. As part of our ongoing effort to focus the platform on managing desktop data rather than mere application automation, we felt that multiple application and screen support should be something that the plug-in creator inherits rather than have to specifically plan for. This supports the philosophy of loosely coupling applications and data sources.
So now, if a plug-in requires data from an xmodel that spans multiple screens, it’s up to the appspace developer (the only person who really knows this to be the case for a particular application integration), to define that fact by instructing the Commander to create an assemble in the task list when the user executes the associated plug-in. Once the assemble is in the task list, it becomes much easier to be repurposed to other applications and sources. For more on assembles, check out the Ratchet-X documentation.
Macro Throttling
Appspace macros are created by the appspace author. This being the case, defined macro execution speed is usually based on the performance the appspace creator sees on his/her desktop. However, once the appspace is deployed, the macro’s execution speed may need to be altered to accommodate the performance of an end user’s workstation. This is the purpose for macro throttling. Macro throttling allows each individual end user to globally speed up or slow down the performance of macros executed on his or her desktop (five levels of throttling).
AutoSave/AutoBackup
In version 3.5, the Appspace Editor has both an AutoSave and AutoBackup feature. When Appspace Editor saves, it makes a backup of the previous version. Further, once you save an appspace for the first time, Appspace Editor will autosave a copy of your appspace based on a user defined autosave time interval.
In addition, there have been various changes to the the connector API and plug-in API to accommodate changes to the task list and assembles.
If you have any questions or comments regarding the new version, please gives us a call or drop me an email. Good luck with version 3.5 of Ratchet-X!