Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

SAS VA Importing Data Doubts

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 16
Accepted Solution

SAS VA Importing Data Doubts

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


Accepted Solutions
Solution
‎05-16-2016 12:33 AM
Super User
Posts: 5,386

Re: SAS VA Importing Data Doubts

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?

Data never sleeps

View solution in original post


All Replies
Solution
‎05-16-2016 12:33 AM
Super User
Posts: 5,386

Re: SAS VA Importing Data Doubts

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?

Data never sleeps
Occasional Contributor
Posts: 16

Re: SAS VA Importing Data Doubts

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

Super User
Posts: 5,386

Re: SAS VA Importing Data Doubts

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.

Data never sleeps
Occasional Contributor
Posts: 16

Re: SAS VA Importing Data Doubts

Hi @LinusH,

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

 

Regards

SAS Explorer Smiley Happy

Contributor
Posts: 21

Re: SAS VA Importing Data Doubts

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 422 views
  • 2 likes
  • 3 in conversation