Automate your BI helpdesk and free your IT staff of repetitive mundane tasks.
Adapt our software to your needs
The MetaManager™ Scripting API has built in support for reading and writing Native Excel files and SQL Server databases as well as the ability to send emails. These extensions allow our customers to script their processes with the IBM Cognos Store and integrate them into other systems and data feeds providing a holistic solution.
Automation, Consistency, Quality
Here’s a couple of repetitive tasks that our customers have automated:
- Synchronize security with a spreadsheet or a database
- Push button to create folder structures for a new project
- Create Report Views with pre-defined prompt
- Allow users to unsubscribe from report schedules
- Enforce naming conventions across a project
Here’s a simple example of how to log onto an IBM Cognos Server and create a security group with 3 members.
// Create an instance of Cognos and logon var url = "http://localhost/ibmcognos/cgi-bin/cognos.cgi"; var server = api.createServer(url); server.logon("Local", "Ari", ""); // Log to the console the current server and user. console.log("Logged onto: " + server.url); console.log("Logged on as: " + server.getCurrentUser().name); // Create a group and set its members console.log("Create group: New Group"); var group = server.createGroup(folder.searchPath, "New Group"); group.securityFns.addMember('CAMID(":Authors") '); group.securityFns.addMember('CAMID(":Consumers") '); group.securityFns.addMember(server.getCurrentUser().searchPath); group.securityFns.saveMembers(); // Log off of the server. server.logoff();Take this example and include some equally simple code to read information from a spreadsheet or a database and you now have an automated system to synchronize security.
MetaManager API vs. IBM Cognos BI SDK
The IBM Cognos BI SDK (Software Development Kit) is a set of programming tools intended to be used by C++, C# or Java to interact with the IBM Cognos Content store. This SDK is a complete offering containing low level programming tools for developing professional software applications that extend any and all supported capabilities of IBM Cognos. Many IBM Business Partners and Customers with a skill set in both Software Engineering and IBM Cognos BI build scalable professional applications for general use and sale.
Benefits of the MetaManager™ API over the IBM Cognos SDK:
- Version Independence: You won’t need to rebuild your project for each new version of IBM Cognos.
- Simplicity: Several common actions which are multi-step and heavy logic algorithms using the IBM SDK have been covered as a simple API call by MetaManager™.
- Reuse: MetaManager™ has solved the complex problems, you get the benefit of many years of seasoned and tested code.
- Change: When a tweak is needed to a script or a process it can generally be done by a person with little to no programming experience.
- Integration: The MetaManager™ API also exposes easy access to Native Microsoft Excel, Email and Accessing Database Tables. All common integration points with custom applications.
- Support: Avnet BSP Support has an A+ reputation for providing helpful support in a timely manner.
- Extend: Using the Server API you can extend the IBM Cognos Portal and Report to provide custom screens to end users.
- Getting Started: Common activities are available as starter templates which can be tweaked to meet your needs.