topic Re: SAS on GCP in SAS Programming

SAS on GCP

navin1984 — Thu, 02 Feb 2023 16:29:10 GMT

Dear All,

Need an expert advice to start:

I have data warehouse application which is running over Mainframe and Use SAS for ETL.

Currently read data from Mainframe file, transform using SAS and load back into Mainframe files.

Is it possible to replace Mainframe with GCP?

Means read data on GCP though SAS, transform the data using SAS and load data back to GCP using SAS.

Any supporting Document link will be helpful.

Regards,
Navin Gupt

Re: SAS on GCP

Reeza — Thu, 02 Feb 2023 17:21:52 GMT

Have you seen the documentation?

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n0bm9s8t6t6rr2n1qgkamlgtb0kk.htm

And a more in depth paper ( a bit old so may be out of date both on SAS and GCP side)

https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2020/4626-2020.pdf

@navin1984 wrote:
Dear All,

Need an expert advice to start:

I have data warehouse application which is running over Mainframe and Use SAS for ETL.

Currently read data from Mainframe file, transform using SAS and load back into Mainframe files.

Is it possible to replace Mainframe with GCP?

Means read data on GCP though SAS, transform the data using SAS and load data back to GCP using SAS.

Any supporting Document link will be helpful.

Regards,
Navin Gupt

Re: SAS on GCP

SASKiwi — Thu, 02 Feb 2023 19:01:03 GMT

@navin1984 - If you are quoting third-party acronyms, it's a good idea to also include the full definition. In your case I assume you mean Google Cloud Platform, but I had to Google that to be sure that is what you are meaning in the context of your question.

For example GCP could equally mean Good Clinical Practice if you were referring to healthcare issues...🙂

Re: SAS on GCP

LinusH — Mon, 06 Feb 2023 10:23:04 GMT

I think we need more context to able to give advice.

So the source data is on a on-premise mainframe, and will continue to be so?

What kind of file format is used by the source?

SAS ETL: what version of SAS? Is it generated from SAS Data Integration Studio, or coded directly using Base SAS syntax?

Target data warehouse - should also move to the cloud I assume. What is your target data layer? Lake/blob storage, or a database engine like BigQuery?