I am using ODI 10.1.3.5. I need to load data from a SQL Server 2005 database.
I have managed to connect to the sql server 2005 using this article.
Now the problem is how can I set up the physical schema? when the physical schema window opened, I see there are (catalogue), (schema), (work catalogue), (work schema) drop boxes, but they are all empty. And When i clicked on them, it reports Action Denied.