Import Data using OLEDB

[Achraf_Ougdal]

Hello,

I would like to ask for some help, I am currently trying to import Data from SSAS Cube to LASR and I am struggling to do it. 

I understand that I need a licenced SAS/ACCESS TO OLE DB Product and we already ordered it.

But I don't know how to do so, I understand that maybe I should write the query manually to connect to it and create the necessary views and the syntax is on the internet. but in the oledb options I don't know what to put for the "PROVIDER" option or how to connect to it in general.

can you please guide me with steps to solve this problem, it would be very very helpful and i'll appreciate it.

Thank you so much for your time,

Best Regards,

[SASKiwi · Accepted solution]

The best way to get OLEDB going is to follow these steps:

• Install SAS/ACCESS TO OLE DB using the SAS Installation Wizard (I'm assuming you have VA 7.5 on SAS 9.4 as you reference the LASR engine - please advise if this is not correct)
• Complete SAS/ACCESS TO OLE DB post-install configuration
• Apply your new SAS licence using the SAS Deployment Manager
• Open a SAS Studio session and test an OLEDB connection using the LIBNAME statement:

libname MyOLEDB OLEDB <Your connection details>;

This is normally a task for a SAS administrator, so I'm assuming that you are.

[Achraf_Ougdal]

Hello,

Thank you for your reply, wouldn't the SAS/ACCESS Interface to OLE DB be installed with the Visual Analytics by default since they are part of the same order and I installed all the products on the order ?

[SASKiwi]

If it was part of your original order, yes. I assumed you had ordered it separately. If you already have it you can confirm it is installed by running this:

proc product_status:
run;

If it is installed, then you can try a LIBNAME statement in SAS Studio.

[Achraf_Ougdal]

It worked ! Thank you so much for your help