Tool that comes to mind to run the sql query
Use Cases and Deployment Scope
We use Data Central to run queries & fetch data. It's an amazing tools where we create multiple profiles with Query & then create multiple job id's for each profile. & then we run the query for the jobs. Its so customizable as we can fetch the data through query for a particular, day, week, month, year.
Pros
- We use Data Central to run queries & fetch data.
- It's an amazing tools where we create multiple profiles with Query & then create multiple job id's for each profile. & then we run the query for the jobs
- Its so customizable as we can fetch the data through query for a particular, day, week, month, year.
Cons
- Its very complicated for new users
- Data integration with multiple tables is a challenging during any launches
- Implementation is very time consuming since it involves large amount of data
- The output from the query is stored for maximum of 1 year & can't be retained for more than a year
Return on Investment
- We use Data Central to run queries & fetch data.
- It's an amazing tools where we create multiple profiles with Query & then create multiple job id's for each profile. & then we run the query for the jobs
- Its so customizable as we can fetch the data through query for a particular, day, week, month, year.
- Data integration with multiple tables is a challenging during any launches
- The output from the query is stored for maximum of 1 year & can't be retained for more than a year
Other Software Used
Slack, Shareworks, by Morgan Stanley, Quip, SAP Concur, Jira Work Management, Touchstone, Amazon WorkDocs
