SAS VA Importing Data Doubts

[SAS_Explorer]

Hi SAS Community,

I'm pretty new to SAS VA and need some clarity on the following questions:

1. Registering DB Tables into ODBC library, will it fetch complete table data and save it in the library?

2. When we Unload and Reload the LASR table will it Query the DB, how the flow would be?

Regards

SAS Explorer

[LinusH · Accepted solution]

1. Registering tables (in metadata) does not copy/move any physical data.

2. If you have defined them like that, yes. The flow would probably be that you query the data, and it loads to the LASR. If you think that's inconvenient, you can store the data in SAS first. and load from there. Do you have any constraints using data from your ODBC source?

[SAS_Explorer]

Hi @LinusH,

The problem I'm facing is, I've registered tables in the ODBC library. When I'm using these tables in the Data Query(using SAS VA Data Builder) it is taking more than 30mins and still running.

Tables contain around 2 GB of data.

I'm unable to understand whether SAS is slow or the way which I followed is wrong.

Kindly Guide me, so that I can overcome this issue

Regards

SAS Explorer

[LinusH]

First, you need to understand where the bottleneck is. 

My guess it is in the data source, or data transport on the network.

Try to execute a similar query in enterprise guide, and then perhaps on another ODBC client connection.

talk to the DBA for some help to evaluate the situation.

If you usually do a full load of data, consider store a local copy in a SAS SPDE libname. Then you need some measure to update this local copy with changes from ODBC - you need some update logic I guess.

[SAS_Explorer]

Hi @LinusH,

I'll check on those parameters which you mentioned and update you soon.

Regards

SAS Explorer 🙂

[maverickkub]

Hi

Asper the messages I guess the amount of data is too small if it is taking that much amount of time.Try to uplaod the table in Lasr thorugh SAS Enterprise gude  by Uplaod to LASR feature.