topic Re: Promotion of 3rd party libraries in SAS 9.4 in Administration and Deployment

Promotion of 3rd party libraries in SAS 9.4

SASWayne — Wed, 22 Jun 2022 07:56:40 GMT

Hello Experts,

I'm trying to understand how to promote a library for 3rd party database (be it any DB) from SAS 9.4M5 to SAS9.4M7.

Is it just enough to import them as we do for a Base SAS library, after importing system metadata and their respective database servers (and configurations at OS level)?

are there any additional steps required?

Thanks in advance, hope someone could help me understand this.

Re: Promotion of 3rd party libraries in SAS 9.4

jklaverstijn — Wed, 22 Jun 2022 12:12:50 GMT

I am guessing at what you may want to achieve here. If it is what I think and you are in the process of migrating your SAS deployment from 9.4M5 to M7 then yes: export the library metadata in M5 management console to an SPK file and import that in the M7 server.

NOTE: there can, as you mentioned, be related objects (servers, accounts, authentication domains, users, groups, tables, ACT's etc) that you need to take into account as well before everything will work as expected.

If you have tables registered in your metadata it will usually work better to first export/import the library definitions and after that the tables in a separate step.

Hope this helps,

- Jan.

Re: Promotion of 3rd party libraries in SAS 9.4

LinusH — Wed, 22 Jun 2022 12:40:13 GMT

Just to add, any exteral configuration files needs to be migrated as well, like ODBC DSN definitions, Oracle tsnames etc.

Re: Promotion of 3rd party libraries in SAS 9.4

SASKiwi — Wed, 22 Jun 2022 23:28:19 GMT

Yes, the process is much the same as for SAS libraries. You would need to ensure that your SAS/ACCESS products have been correctly configured and tested on M7 prior to using the migrated library definitions. I find it useful to test each connection using an equivalent LIBNAME statement to ensure it is correctly configured.