It is currently 25 Nov 2017 10:37


Post new topic  Reply to topic  [ 4 posts ] 
Author Message
PostPosted: 01 Sep 2011 4:54 
Offline
Nouveau
Nouveau
User avatar

Joined: 01 Sep 2011 12:00
Posts: 1
Hello,

I'm new to the foum but is already somewhat familiar with the tool above Control-M system running on UNIX and SAP.

We have a new application on Windows 2008 running on the SAPBPC software and a database Microsoft SQL Server.

Data integration is done through SSIS packages.

It seems that we may, with Controlm, schedule these packages.

Do you know the mechanics?
Is there a documentation?

Should an agent "SSIS" on the Windows server to interface with the server ControlM as a SAP module to interface SAP with ControlM?

Thanks


Top
   
 Post subject:
PostPosted: 08 Sep 2011 7:01 
Offline
Nouveau
Nouveau
User avatar

Joined: 25 Sep 2008 12:00
Posts: 32
You can use Control-M's CM for Databases to schedule SSIS packages.

You only have to install the CM on an agent that can connect to the SQL Server (or on the agent where the SQL server resides), ensure that the SQL Integration Service is running on the server(s) involved, and attribute the required Windows and SQL permissions to the configured user.

This is described on the Control-M for Databases Admin Guide.

Regards


Top
   
 Post subject:
PostPosted: 29 Nov 2011 6:41 
This was interesting.

Access Control System


Top
   
 Post subject:
PostPosted: 26 Jul 2013 12:27 
Offline
Nouveau
Nouveau
User avatar

Joined: 16 Nov 2012 12:00
Posts: 1
I have used PowerShell remoting + dtexec.exe to invoke SSIS packages and return an exit code to Control-M jobs.


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 4 posts ] 

All times are UTC+01:00


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by Scheduler-Usage.com. All Rights Reserved