Sesame Software: going against the flow

What, no drag and drop?


Comment Is the accepted way of doing things always the best way to do things? Intuitively, one would have to answer 'no' to that question. One company that certainly thinks so is Sesame Software.

Sesame offers two products: 'Relational Junction for Salesforce' and 'Relational Junction ETL Manager'. Neither of these products fits the common mould but both are worth serious consideration.

To start with the ETL (extract, transform and load) product first, the most immediate and obvious difference between this product and every other offering you have seen for a very long time is that it does not have a drag-and-drop, palette-based environment.

Why not? Because the product is targeted at experienced SQL programmers. Do such people need drag-and-drop? Or is a tabular, automated environment enough? There is certainly a good argument to be made in favour of the latter, particularly given the relative price point of Relational Junction ETL Manager. Of course, it means that the interface is not much use for sharing information with end users but then, how many data movement projects actually require such interaction? Certainly some do but many do not. And even where such collaboration is required, is it actually necessary to have that functionality built in to the system, or could you do it just as easily with Visio?

Probably the best way to describe Relational Junction ETL Manager is as a lean, mean machine. It doesn't have all the sorts of bells and whistles that some other tools do (and which you hardly ever use) it just focuses on doing the basics as well as possible. Put simply, the idea behind the product is that if you can do it in SQL then you can do it in Relational Junction ETL Manager.

From an architectural perspective, metadata is stored in XML files so no database is required and you can execute transforms on the source, target or an intermediate platform, as required. Source and target support, however, is relatively limited, to Oracle, DB2, SQL Server, MySQL, Sybase and XML files (for input); though the company says that it can deliver a new integration within a week. It is currently planning support for Foxpro (for a customer) and CSV files. It is also planning to add further validation functions to the software as these are relatively limited at present.

Relational Junction for Salesforce is a tool designed to support the population and use of Salesforce.com. Again, Sesame has not taken the conventional approach. Rather than provide a spreadsheet-based solution which will have limited scalability, in this case it creates a database (it works with Oracle, SQLServer, MySQL, and Sybase) that mirrors your Salesforce.com data and then provides replication to keep the two synchronised.

There is a case of contrarianism in a wide variety of fields, not least when investing in the stock market. When it comes to software tools, sticking to what you believe (not being seduced by hype) and targeting your products at specific users has a lot to commend it.

Copyright © 2005, IT-Analysis.com


Other stories you might like

  • Prisons transcribe private phone calls with inmates using speech-to-text AI

    Plus: A drug designed by machine learning algorithms to treat liver disease reaches human clinical trials and more

    In brief Prisons around the US are installing AI speech-to-text models to automatically transcribe conversations with inmates during their phone calls.

    A series of contracts and emails from eight different states revealed how Verus, an AI application developed by LEO Technologies and based on a speech-to-text system offered by Amazon, was used to eavesdrop on prisoners’ phone calls.

    In a sales pitch, LEO’s CEO James Sexton told officials working for a jail in Cook County, Illinois, that one of its customers in Calhoun County, Alabama, uses the software to protect prisons from getting sued, according to an investigation by the Thomson Reuters Foundation.

    Continue reading
  • Battlefield 2042: Please don't be the death knell of the franchise, please don't be the death knell of the franchise

    Another terrible launch, but DICE is already working on improvements

    The RPG Greetings, traveller, and welcome back to The Register Plays Games, our monthly gaming column. Since the last edition on New World, we hit level cap and the "endgame". Around this time, item duping exploits became rife and every attempt Amazon Games made to fix it just broke something else. The post-level 60 "watermark" system for gear drops is also infuriating and tedious, but not something we were able to address in the column. So bear these things in mind if you were ever tempted. On that note, it's time to look at another newly released shit show – Battlefield 2042.

    I wanted to love Battlefield 2042, I really did. After the bum note of the first-person shooter (FPS) franchise's return to Second World War theatres with Battlefield V (2018), I stupidly assumed the next entry from EA-owned Swedish developer DICE would be a return to form. I was wrong.

    The multiplayer military FPS market is dominated by two forces: Activision's Call of Duty (COD) series and EA's Battlefield. Fans of each franchise are loyal to the point of zealotry with little crossover between player bases. Here's where I stand: COD jumped the shark with Modern Warfare 2 in 2009. It's flip-flopped from WW2 to present-day combat and back again, tried sci-fi, and even the Battle Royale trend with the free-to-play Call of Duty: Warzone (2020), which has been thoroughly ruined by hackers and developer inaction.

    Continue reading
  • American diplomats' iPhones reportedly compromised by NSO Group intrusion software

    Reuters claims nine State Department employees outside the US had their devices hacked

    The Apple iPhones of at least nine US State Department officials were compromised by an unidentified entity using NSO Group's Pegasus spyware, according to a report published Friday by Reuters.

    NSO Group in an email to The Register said it has blocked an unnamed customers' access to its system upon receiving an inquiry about the incident but has yet to confirm whether its software was involved.

    "Once the inquiry was received, and before any investigation under our compliance policy, we have decided to immediately terminate relevant customers’ access to the system, due to the severity of the allegations," an NSO spokesperson told The Register in an email. "To this point, we haven’t received any information nor the phone numbers, nor any indication that NSO’s tools were used in this case."

    Continue reading

Biting the hand that feeds IT © 1998–2021