Skip to Content
author's profile photo Former Member
Former Member

Create New Instance(Target) option in Teradata datastore - 4.2 SP5

Hi All,

Recently we upgraded our repositories to BODS 4.2 SP5 in our DEV environment. It did not allow me to create a target object on Teradata view.

There is no Create New Instance(Target) option. This is very weird behaviour, where as we are able to create the same target object of teradata view from SAP 4.0.

Can any one help me out on this issue.

Please find the below screen shots.

Have tried all workarounds ( recreating the whole DS , recreating the repo itself ), but nothing has worked.

1.JPG (45.1 kB)
2.JPG (39.2 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 28, 2016 at 03:19 PM

    Hi All,

    workaround was found for the above issue, hope this might be helpful for others.

    step 1 - right click on the view name after importing the view into designer and click on properties

    step 2 -

    Go to the 2nd tab (Attributes) and click on ‘Database_Object_Type’.

    The value would be displayed default as ‘VIEW’.

    Step 3 -

    Now manually edit the value from ‘VIEW’ to ‘TABLE’ and click ok

    Now you would be able to make the VIEW as source or target in your DF.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.