Appian BPM Certification
This Analyst Certification has following.
-50 Questions
-30 Minutes
-Need to get 70% to get certified
Reading appian forum documentation helps.
Appian BPM Certification
This Analyst Certification has following.
-50 Questions
-30 Minutes
-Need to get 70% to get certified
Reading appian forum documentation helps.
a!dynRetrieve( scsExternalSystemKey: cons!DYN_SCS_KEY, usePerUserCredentials: true, endpoint: cons!DYN_ENDPOINT, parameters: _ )
Perceptive Software owned by of Lexmark Inc (as of 2004) has a web based Workflow Designer and easy to use components to route the right information to the right place at the right time.
On Premise and SaaS based product.
Can integrate with almost all MS stack , JD Edwards, SAP , Oracle ERPs.
Has Hardware integration with touch screen based Multifunction Printers (MFP) and scanners and is a reason bought by Lexmark.
Lexmark, Dell, Xerox etc use this.
Business process management automates your daily workflows through a thoughtful combination of software and expertise that
tightly integrates with and extends your enterprise applications without compromising their integrity.
And far from being a one-time exercise, it simply becomes a part of how you do business—a continuous cycle of improvement for any process in your organization.
Process Discovery illuminates the reality of your processes, exposing bottlenecks in both people and technology that disrupt the flow of productivity.
Process Design uses the insight you’ve gained to model your processes for better results.
Perceptive process modeling gives you everything you need to rethink your processes.
Perceptive process documentation provides the tools needed to publish the processes you've designed, to make everyone understand the impact of their work on the work of others and how they add value to organizational goals.
Process Execution delivers the processes you’ve modeled to a desktop or a mobile device as user-ready applications.
Perceptive’s content-based workflow supports your organization in structuring your processes,
maximizing the number of transactions your team is able to process, direct, approve and complete.
With its more flexible and agilecase management approach, Perceptive provides the optimized process support knowledge workers need to get their work done in the most efficient way—while keeping an overview of everything their customers need.
Process Monitoring and Improvement allows you to make quick adjustments and adapt to changes the future may throw your way. Perceptive process analytics provides immediate insight into your current operations with the ability to immediately act on unbalanced workloads or operational disturbances, and to identify and analyze operational problems to find their root cause
See more at:
http://www.perceptivesoftware.com/products/perceptive-process/business-process-management
Rayudu Addagarla
BPM Workflow specialist
Keywords: TOAD, PL/SQL , SQLPLUS, Oracle Java Object, Convert Oracle code to use as Oracle Functions.
You might have seen Java in Oracle TOAD, But wonder how to use Java there?
Yes you can write simple java code in Toad or sqlplus.
Please refer to the below steps and you can write some nice java code to use in PL/SQL.
Examples why you might have to use Java:
Some complex String manipulations or might have to make decision on reading some data from files. You probably could call web services and get some data and return inside pl/sql
I did not try calling WS, but since you can write java code, I don’t think you will be limited to any java extensibility.
Below is a sample Hello World and imagination is only your limit to extend your java skills when using oracle.
-- Step 1 DROP Java Source DROP JAVA SOURCE "HelloRayudu"; |
-- Step 2 Create Java Source and Class and a static method CREATE JAVA SOURCE NAMED "HelloRayudu" AS public class HelloRayudu { public static String hello() { return "Hello Rayudu"; } }; |
-- Step 3 Create equivalent Oracle Package and function CREATE OR REPLACE PACKAGE APPIAN_TMS.JAVATEST AS FUNCTION hello return VARCHAR2 AS LANGUAGE java NAME 'HelloRayudu.hello() return java.lang.String'; end; |
-- Step 4 Execute the function created above SELECT JAVATEST.hello FROM DUAL; |
Once this steps are done, you will be able to see the class in Schema browser as above and details like below.
Rayudu Addagarla
You might have to create VIEWS too get some specific data from Database and call it from your APPIAN BPM Suite.
What is regular expressions?
http://docs.oracle.com/cd/B12037_01/server.101/b10759/conditions018.htm
http://en.wikipedia.org/wiki/Regular_expression
http://www.w3schools.com/jsref/jsref_obj_regexp.asp
functions may vary in each language , sql or java or javascript , but the regular expression ex: ‘\d’ will be same.
\d means digit.
\d+ means digit one or more times
^\d – means start with digit
^\d+$ - means start(^) and end($) with digit and any number of digits
select * from TMS_TASKS;
When you use oracle regular expressions like below
The column TASK_GROUP has numeric and text, but if you want to get only the numbers , we use where clause and use REGEXP_LIKE oracle function
Function to use: REGEXP_LIKE(source_string, pattern, matchparameter)
SELECT * FROM TMS_TASKS WHERE REGEXP_LIKE(TASK_GROUP, '^\d+$', 'i'); |
The 3rd parameter ‘i’ means case insensitive
The result you get is TASK_GROUP data with numeric or digits.
Rayudu Addagarla
In today’s world data is everywhere and xml could be one source and most common source as feed from data vendors etc.
Say suppose you have some xml data to show for business users and a requirement to show in the webpage or parse with XSLT to use in some application.
This below shows how to parse daily averages of Federal Funds available for public.
I just showed to use xsl:for-each and show in tables. You can apply any XSLT rules to filter xsl:if, xsl:choose, xsl:when etc.
Shows how to read elements and attributes and xml which has (:colon) namespaces ex: ff:Series
<ff:Series AVAILABILITY="A" DECIMALS="2" FF_METHOD="D" DISCLAIMER="G" TIME_FORMAT="P1D">
http://www.newyorkfed.org/xml/data/ff/ffd.xml
How would you parse this with XSLT if you want to just display on your page based on some rules etc.
XML (ffd.xml) | XSL |
<?xml version="1.0" encoding="ISO-8859-1"?> <UtilityData> <Header> <ID>FFD</ID> <Test>false</Test> <Name xml:lang="en">Federal Funds daily averages</Name> <Prepared>2013-07-05</Prepared> <Sender id="FRBNY"> <Name xml:lang="en">Federal Reserve Bank of New York</Name> <Contact> <Name xml:lang="en">George Matthes</Name> <Email>george.matthes@ny.frb.org</Email> </Contact> </Sender> </Header> <ff:DataSet> <ff:Series AVAILABILITY="A" DECIMALS="2" FF_METHOD="D" DISCLAIMER="G" TIME_FORMAT="P1D"> <ffbase:Key> <base:FREQ>D</base:FREQ> <base:RATE>FF</base:RATE> <base:MATURITY>O</base:MATURITY> <ffbase:FF_SCOPE>D</ffbase:FF_SCOPE> </ffbase:Key> <ff:Obs OBS_CONF="F" OBS_STATUS="A"> <base:TIME_PERIOD>2013-07-02</base:TIME_PERIOD> <base:OBS_VALUE>0.1</base:OBS_VALUE> </ff:Obs> <ff:Obs OBS_CONF="F" OBS_STATUS="A"> <base:TIME_PERIOD>2013-07-01</base:TIME_PERIOD> <base:OBS_VALUE>0.1</base:OBS_VALUE> </ff:Obs> <ff:Obs OBS_CONF="F" OBS_STATUS="A"> <base:TIME_PERIOD>2013-06-28</base:TIME_PERIOD> <base:OBS_VALUE>0.07</base:OBS_VALUE> </ff:Obs> <ff:Obs OBS_CONF="F" OBS_STATUS="A"> <base:TIME_PERIOD>2013-06-27</base:TIME_PERIOD> <base:OBS_VALUE>0.09</base:OBS_VALUE> </ff:Obs> </ff:Series> </ff:DataSet> </UtilityData> | <?xml version="1.0" encoding="ISO-8859-1"?> <!—Author Rayudu Addagarla, Tested in W3schools Try Yourself Editor --> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/"> <html> <body> <h3>Federal Reserve Bank of New York</h3> <xsl:for-each select="UtilityData/Header"> <b>Name :</b><xsl:value-of select="Name" /> <br/><b>Sender :</b><xsl:value-of select="Sender/@id" /> </xsl:for-each> <br/> <table border="1"> <tr bgcolor="#9acd32"> <th>Name</th> <th>Email</th> </tr> <xsl:for-each select="UtilityData/Header/Sender/Contact"> <tr> <td><xsl:value-of select="Name"/></td> <td><xsl:value-of select="Email"/></td> </tr> </xsl:for-each> </table> <br/> <table border="1"> <caption style="text-align:left"><b>Series</b></caption> <tr bgcolor="#9acd32"> <th>Availability </th> <th>Decimals</th> <th>FF Method</th> <th>Disclaimer</th> <th>Maturity</th> </tr> <xsl:for-each select="//*[local-name() = 'DataSet']"> <tr> <td> <xsl:value-of select="Series/@AVAILABILITY" /> </td> <td> <xsl:value-of select="Series/@DECIMALS" /> </td> <td> <xsl:value-of select="Series/@FF_METHOD" /> </td> <td> <xsl:value-of select="Series/@DISCLAIMER" /> </td> <td> <xsl:value-of select="Series/Key/MATURITY" /> </td> </tr> </xsl:for-each> </table> <br/> <table border="1"> <tr bgcolor="#9acd32"> <th>OBS Conf</th> <th>OBS Status</th> <th>Time Period</th> <th>OBS Value</th> </tr> <xsl:for-each select="//*[local-name() = 'Obs']"> <tr> <td><xsl:value-of select="@OBS_CONF"/></td> <td><xsl:value-of select="@OBS_STATUS"/></td> <td><xsl:value-of select="TIME_PERIOD"/></td> <td><xsl:value-of select="OBS_VALUE"/></td> </tr> </xsl:for-each> </table> </body> </html> </xsl:template> </xsl:stylesheet> |
Rayudu Addagarla
BPM Specialist
Keywords: [Appian BPM, Java, JS, JSON, XML, XSLT, Web Development, JSP, Spring, JBOSS]