July 11, 2016 at 5:57 pm
Has anyone use CAWA plus scripts to automate processing of SSAS Tabular tables? How does that worK?
July 15, 2016 at 3:21 pm
CAWA?
July 15, 2016 at 3:34 pm
CA Workload Automation
July 15, 2016 at 3:52 pm
imani_technology (7/15/2016)
CA Workload Automation
I'm unfortunately not familiar with these. Looking very briefly at the documentation though, it looks like you won't be able to do it without a library specifically built in CAWA. Not sure however...hopefully somebody else has seen this before.
July 17, 2016 at 4:08 am
imani_technology (7/15/2016)
CA Workload Automation
According to page 9 of this document: https://support.ca.com/cadocs/0/CA%20Workload%20Automation%20Agent%20for%20Microsoft%20SQL%20Server%20r11%203%201-ENU/Bookshelf_Files/PDF/WA_Agent_for_Microsoft_SQL_Server_Impl_ENU.pdf
You can start SQL Server Agent jobs. So just set up an agent job which processes your cube(s) and then have CAWA kick it off when it's needed.
I've never used CAWA personally but have used other workload automation tools (IBM Robot, Windows Scheduler etc.) to do this and it's always came down to an SQL agent job eventually.
July 20, 2016 at 12:54 pm
Thanks for your help.
I believe the company wants to use CAWA to run Windows batch scripts instead of SQL Agent. It's the same concept as what you're talking about, though.
July 20, 2016 at 1:05 pm
imani_technology (7/20/2016)
Thanks for your help.I believe the company wants to use CAWA to run Windows batch scripts instead of SQL Agent. It's the same concept as what you're talking about, though.
Right. People simply stagger me sometimes. You will need to use the Ascmd utility to do this. See here: https://msdn.microsoft.com/en-us/library/ms365187.aspx
This can fire off XMLA processing scripts, but these will need to be amended if you ever add an object, change the ID of an object etc.
If only there was a simpler way.....:-D
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply