Most likely yes: SAS Help Center: SAS/ACCESS Interface to PostgreSQL ... View more

I haven't found anything related to SAS Viya unfortunately. Also, I don't think that SAS Viya has any equivalent  options for OLE DB and ODBC connections. You can investigate the use of APIs or use MS SQL Server as intermediary. Or, you can contact SAS Customer Support Site | SAS Support to check if they have other alternatives for you. Please see below some extra information: Solved: SAS Share and Power BI - SAS Support Communities https://developer.sas.com/home.html https://developer.sas.com/guides/rest.html   Regards, ... View more

Hi,   I found a video explaining how create the connection between PowerBI and SAS but its in Portuguese (https://www.youtube.com/watch?v=lFVSSOYQ2X0). I'll try to translate and summarize: - on the 'From OLE DB' window type: source=iom-bridge://<SAS Metadata Server name>:8591 The port may change depending on your config. - create - on Provider, select SAS IOM Data Provider - click next - on Data Source type: source=iom-bridge://<SAS Metadata Server name>:8591 - add the user name and password, try with an internal account like sasdemo - test connection - on the last tab, scroll and find 'SAS Protocol' and change it to 2 - click ok - on the 'From OLE DB' window type, find and remove: mode="Read Write Share Deny None"  - click  Advanced Options and write the sql query to select your data - click ok   Hope this help and works for you.   Regards, ... View more

Hi,   It may be quicker to create your delta on SAS and then apply it to the MS SQL table instead of always dropping and rebuilding the entire table. You can see an example of update/insert code here Solved: SQL Server pass through (merge, update, insert) - SAS Support Communities   Regards ... View more

If you're installing the first node (or a single one) you probably don't need hostsetup.  This link mentions hostsetup as optional following an install: lsfinstall - IBM Documentation You can find more information on LSF installation here: Install or upgrade IBM Spectrum LSF - IBM Documentation ... View more

After editing  lsf.cluster.sas_cluster did you run lsadmin reconfig and badmin reconfig? I believe these are required to recognize the new name defined.  ... View more

Hi,   Doing the migration of SAS DI jobs to SAS Viya manually the way you seem to be doing may not be the best option. Using the SAS  Content Assessment Tool to help manage the migration may save some time and help identify jobs that will migrate easily and jobs that will present difficulties. Here's a demo of a job migration using the Content Assessment Tool: https://youtu.be/IIxyUbdmZoM   Regards, ... View more

@lioradam If you're indeed using SAS Enterprise Guide have a look at this article: Copy an entire process flow in SAS Enterprise Guide - The SAS Dummy ... View more

Hello, Possibly this SAS Tutorial can help? SAS Tutorial | Transferring User Defined Formats to CAS   Regards, ... View more

Hello, Does user="client-id" have enough permissions on schema="catalog.schema" in Databricks? ... View more