Forum Stats

  • 3,816,408 Users
  • 2,259,185 Discussions


Is it possible to reverse the attributes of a datastore with dynamic resource name?

User_2ANY9 Member Posts: 9 Green Ribbon

I've used this functionality when setting the model for loading files, but now I need to do it for a table in an Oracle DB. The resource name must be dynamic, I'm using a variable for the name, but when I try to reverse engineer the attributes of the datastore from the table in the DB, it doesn't work.

I tried also through the reverse engineer tab of the model, but it doesn't work there too.

I searched a lot on this topic, there've been some discussions and advise about using variables for dynamically setting the resource name of a datastore, but nothing about reversing the columns. Any suggestions why it might not work would be much helpful.