topic Re: Data projet in SAS Studio

Data projet

Merka — Tue, 09 Nov 2021 20:57:42 GMT

Hi, I'm working on project that I have a multiple sources of data (csv, Json, excel files from API sources and mongo database my goal is to define the ETL that I need to use in order to automate my data and consolidate all data in one big data datawarehouse so I'm thinking about the data base management system I can use to solve my problem then how can I move these data to SAS for analyze and export the data

Which SAS modules that I need to install or buy to centralize all data and do the ETL process then analyze data can SAS solve this problem ? I look forward to reading your suggestions...

Re: Data projet

SASKiwi — Tue, 09 Nov 2021 21:08:14 GMT

SAS usually sells products in bundles these days and it would be cheaper than buying individual products. You should discuss your requirements with your SAS account manager to come up with an optimal solution. You will need SAS/ACCESS to PC File Formats for Excel and SAS/ACCESS to ODBC for the databases.

Re: Data projet

Reeza — Tue, 09 Nov 2021 21:09:02 GMT

Data Studio/Data Integration Studio but you can do it in Base SAS or EG if you want.
Depends on how much automation you need/scheduling and how robust it needs to be - ie handle fall back/issues with loading, error checking, data quality checks...