Gone through blogs to view if we can connect to the notepad data from OBIEE. And of course, many blogs threw light on the procedure. I would like to elaborate more on the concept here in this blog. Data loading from notepad is very rare but good to know the process of importing the data and its configuration settings.
I am having the below shown data in the notepad. And rememeber it is tab indented. So you need to be careful while entering your data.
You need to click on the 'Define Format'.
Once all the above steps are complete then click on OK and close the connection settings.