topic Re: Import Data using OLEDB in SAS Visual Analytics

Import Data using OLEDB

Achraf_Ougdal — Sat, 13 May 2023 12:11:18 GMT

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,

Re: Import Data using OLEDB

SASKiwi — Sat, 13 May 2023 23:11:57 GMT

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.

Re: Import Data using OLEDB

Achraf_Ougdal — Sun, 14 May 2023 11:06:07 GMT

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 ?

Re: Import Data using OLEDB

SASKiwi — Sun, 14 May 2023 20:16:16 GMT

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.

Re: Import Data using OLEDB

Achraf_Ougdal — Mon, 15 May 2023 13:35:10 GMT

It worked ! Thank you so much for your help