CA SAM - Connectors/Data Import Jobs

Idea created by Ian_Turner Employee on Nov 23, 2015
    Not planned
    Score3
    • Alexandre_Almeida
    • Debbie_Kuhar
    • Ian_Turner

    CA SAM data import jobs provide the ability to connect to databases (via ODBC data source) to execute a query and select data as part of the import preprocessor, however this output then always has to be saved as a .csv file before it can be loaded into CA SAM. This creates an un-necessary overhead, particularly when the volume of data can be 10,000,000+ rows. CA SAM needs to be improved to make it possible import data direct from a query without having to save it as a .csv file.