i need to extract huge data from various SQL databases.
As we write our sas extraction code sequentially the data gets extracted by that sequence into respective datasets.
so to speed up the extraction can we extract data parallely. How can it be done?
is there some thing like threading here?
will your dbms operate multiple queries in parallel? if so,your simple answer is to run multiple SAS jobs at the same time.
alternatively, look to see what options are available to your SAS/ACCESS module. it may be able to use your dbms's bulk loader/unloader.
Since you don't indicate your dbms, we can only recommend you do more research on those dbms specific areas.
i don't know that whether SQL server support multiple queries. Here in my case even servers are different for few queries. so even if server does not support multiple queries still queries can run parallely on diff servers.