Have you ever been working with a data transformation in which you needed access to database tables that are not part of the source or target data of the transformation? If so, you are not alone, a large portion of the EXTOL customers that I work with have been facing this challenge.
The answer to your problem is EBI’s SQL Access type actions. This functionality allows for the execution of an arbitrary SQL statement over any database accessible via a JDBC driver. Users can now execute any SQL statement that they wish from within EBI rulesets and also have the capability to provide as many input and output parameters as they wish. Performing a lookup over a database table that is outside of the source or target metadata within the ruleset in order to retrieve a value based on selection criteria that comes from the source data of the transformation is no longer a challenge.
Don’t yet see a use for SQL Access actions for your daily operations? Keep reading, because there are a variety of uses that you may not be thinking about. Continue reading