Creating Platforms to extract data from non-oracle databases and application adapters for ERP's in OWB 11.2 just got easier with release of new documentation\cookbook. The cookbook also contains few examples which shows how to do it. You can read more about it over here.
I got really surprised to see OWB platform definitions can now be created from ODI technology definitions. This is interesting.
Three experts are provided which can be imported using the platform_assistants.mdl file.
Earlier you need to create the platforms using OMB/TCL script which involved some effort of figuring out all the datatypes of the source system then mapping it OWB datatypes.
Now, I will use the expert which creates platform from JDBC driver.
Imported the mdl and added it to the project.
On executing the expert it prompts for few parameters and will be creating a platform for Postgres using it.
Created a module and imported a table and could view the data in the data viewer.
Experts does makes it earsier to create platforms.
Another interesting thing is CMI (Custom Metadata Interface) which can be used to create plaftorms specific to your source system like ERP's , PDF's, etc using JAVA or SQL based approach.
This opens OWB interface to extract data\metadata from various applications.
-
