1
Views
4
Comments
how to import newly addedcolumn in database table into outsystems
Question
Hi All,

I have added a new column in underline table of sqlservr database.But the newly added column is not visible in outsystems under data tab.I tried to refresh the entities but still not able to see the newly added column of that table.Please help me on this.

Thanks,
Prashanth
2013-04-08 18-39-29
Charles Colaco
Hi Prashanth,

Are you trying to connect to another SQL Server Database or are you modifying the Table generated by the Agile Platform.

If you are making changes to the tables generated by the Platform, then you shouldn't modify them.
Instead you shoud create an attribute for that Entity in Service Studio, It will create the necessary column for you.

Making changes directly to the SQL tables is not recommended.
The Agile Platform handles all the SQL Server related processes and you should not interefere with the Database.

Regards,
Charles J. Colaco.

UserImage.jpg
prashanth cherla
Charles Colaço wrote:
Hi Prashanth,

Are you trying to connect to another SQL Server Database or are you modifying the Table generated by the Agile Platform.

If you are making changes to the tables generated by the Platform, then you shouldn't modify them.
Instead you shoud create an attribute for that Entity in Service Studio, It will create the necessart column for you.

Making changes directly to the SQL tables is not recommended.
The Agile Platform handles all the SQL Server related processes and you should not interefere with the Database.

Regards,
Charles J. Colaco.
 
 Hi,

I am not changing entities in outsystems.DBA added a new column in one of the tables in SQLServer database.
We already imported our database extension in outsystesm with all the tables.But problem here is the newly added column is not appearing in the outstems database extension.


Thanks,
Prashanth
 
UserImage.jpg
prashanth cherla
prashanth cherla wrote:
Charles Colaço wrote:
Hi Prashanth,

Are you trying to connect to another SQL Server Database or are you modifying the Table generated by the Agile Platform.

If you are making changes to the tables generated by the Platform, then you shouldn't modify them.
Instead you shoud create an attribute for that Entity in Service Studio, It will create the necessart column for you.

Making changes directly to the SQL tables is not recommended.
The Agile Platform handles all the SQL Server related processes and you should not interefere with the Database.

Regards,
Charles J. Colaco.
 
 Hi,

I am not changing entities in outsystems.DBA added a new column in one of the tables in SQLServer database.
We already imported our database extension in outsystesm with all the tables.But problem here is the newly added column is not appearing in the outstems database extension.


Thanks,
Prashanth
 
 Hi All,

Can anyone please help me on this.


Thanks,
Prashanth
 
2012-03-16 12-21-09
João Rosado
Staff
Hi Prashanth,

If you used Intergration Studio to import the entities you need to open the extension again in Integration Studio and click "Refresh" on the entity that needs to be updated. Then, after publishing the extension you in Service Studio refresh the references for that extension.

Regards,
João Rosado

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.