topic SAS VA Importing Data Doubts in SAS Visual Analytics

SAS VA Importing Data Doubts

SAS_Explorer — Tue, 10 May 2016 05:28:55 GMT

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

Re: SAS VA Importing Data Doubts

LinusH — Tue, 10 May 2016 07:43:53 GMT

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?

Re: SAS VA Importing Data Doubts

SAS_Explorer — Tue, 10 May 2016 12:01:19 GMT

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

Re: SAS VA Importing Data Doubts

LinusH — Tue, 10 May 2016 12:07:02 GMT

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.

Re: SAS VA Importing Data Doubts

SAS_Explorer — Tue, 10 May 2016 12:11:30 GMT

Hi @LinusH,

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

Regards

SAS Explorer 🙂

Re: SAS VA Importing Data Doubts

maverickkub — Wed, 11 May 2016 09:42:04 GMT

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.