How to Capture Datatypes from application like salesforce/workday

How to Capture datatypes and length for attributes across the different objects in salesforce dynamically so that we create a table definition on target that are not defaulted to String ?