SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Reply
New Contributor
Posts: 3

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

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
Super User
Posts: 5,424

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

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
Data never sleeps
New Contributor
Posts: 3

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

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:
SAS Employee
Posts: 75

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

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
New Contributor
Posts: 3

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

Posted in reply to DaveR_SAS
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.
SAS Employee
Posts: 38

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

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.
Ask a Question
Discussion stats
  • 5 replies
  • 217 views
  • 0 likes
  • 4 in conversation