topic Build a library with base sas coding and then register it to meta server in SAS Data Management

Build a library with base sas coding and then register it to meta server

JPSASMAN — Wed, 27 Apr 2011 22:24:25 GMT

Good Evening all,
We have an interesting issue.
We are using Access to OLEDB and want to use BulkLoad capabilities and we want to use windows authentication..
However when defining library in Metadata Server using Management Console it always fails because you cant use BULKLOAD and OLEDB Services.
We have been able to build the library using OLEDB engine with BULKLOAD and windows authentication using good old base SAS code techniques
Now we want to register it with Metadata server since management console cant create it, How is that performed? Is there a better way?
Thanks

Re: Build a library with base sas coding and then register it to meta server

LinusH — Thu, 28 Apr 2011 06:24:13 GMT

Hi,
I'm not aware of any limitations to bulkload and OLEDB. Can you be more specific about "because you cant use BULKLOAD and OLEDB Services".
Any error messages?

/Linus

Re: Build a library with base sas coding and then register it to meta server

JPSASMAN — Thu, 28 Apr 2011 14:30:35 GMT

There are limitations as indicated in the documentation.
It specifically indicates that BULKLOAD is not supported thru OLEDB Services. However if you direct connect to the data source with provider and information BULKLOAD will work, which we have been able to do using base sas coding using Enteprise Guide. THe problem that we have encountered is that when you use Management Console to create the libref defintion despite multiple configurations on properties tabs SAS OLEDB Services are deployed and we cant find a way to perform the direct connection required to enable BULKLOAD:

Re: Build a library with base sas coding and then register it to meta server

DaveR_SAS — Thu, 28 Apr 2011 15:19:01 GMT

Does the "Connecting to Common Data Sources" chapter in the Data Administration Guide have a topic that matches your situation?

http://support.sas.com/documentation/cdl/en/bidsag/61236/HTML/default/a003112367.htm

Re: Build a library with base sas coding and then register it to meta server

JPSASMAN — Thu, 28 Apr 2011 16:08:34 GMT

No.
What we are truly trying to do is establish a libref using sas management console to a SQLServer 2008 database where the bulkload option is enabled.
If order for this to work we need to somehow have sas managment console create a direct connections through the provider to the SQLServer database and not via OLEDB Services.

Re: Build a library with base sas coding and then register it to meta server

nar_sas — Wed, 04 May 2011 16:50:57 GMT

One option is to use the generic library template. In this library, you can type in your own libname statement. It still gets registered in metadata as a library, but the syntax is entirely user written.