Am using CA Agile central database connector for MS SQL to extract the data from CA Agile to SQL.
For entities like 'Task', the Fields (Plan Estimate, Actuals, Task Estimate, ToDo, etc) are getting rounded to the whole number after getting extracted into SQL Server. Originally, these are Decimal point fields, however, are getting converted into 'Numeric'. The Data type for the column in SQL Server is 'Numeric'
E.g. 8.5 is rounded to 9, 8.25 rounded to 8
This is resulting in the incorrect data getting extracted to SQL from CA Agile and does'nt match up.
Any help to mitigate this critical issue will be greatly appreciated.