Administration Tools User Manual in PDF format
Contents
1. e Provision of an exact string value for some properties Elixir Administration Tools e Reference to target constants e Definition of parameters in some properties if they should be provided by end users For example the parameter in property filename can be defined as file report _ date End users should provide values for those parameters when invoking targets e Output Types for Report Rendering A target provides various output types such as CSV HTML PDF Microsoft formats and so on After the properties are set the Target Wizard enables you to choose among different output types for report rendering purpose You can choose multiple types at a time for convenience You can also print the report directly Table 1 1 Output Types for Report Rendering Postscript Rich Text Format Zipped Wbmp fr Create New Target When you create a new target using the Target Wizard you should fill in values for example parameters into the property fields Nested parameters are not supported For example you cannot specify a parameter like file reportname JDBC Target A JDBC Target allows reports to be written directly into a database This is useful if you have some subsequent program to pick them up or otherwise act on them for example a document management system Each report is written as a record into a specific table in the database The report data itself is stored as a BLOB Before you can use the JDBC ta2. desired users groups from the list 4 Click OK The access rights are successfully assigned Only users who can read or write the Universe file can open it to view and edit the contents However those users in the Access list can only use the Universe without being able to open or edit the Universe file The Universe service will access the file for those users 13 Elixir Administration Tools Users amp Groups Users The Users amp Groups interface is designed for administrators to create and modify users and groups Figure 1 11 Users amp Groups lt d Y e E EI E Administration Tools 52 40 Monitor Scheduler Users amp Groups Users 34 Name Email Groups Enabled Administrator E admin groupl anon B x test groupe E gt Groups D Name Users 5 groupl admin group test x Administrators can create enable and disable user accounts assign administration privileges specify user groups as well as set anyone s password and email address The users without administration privileges can change only their own password and email address Groups Administrators can create new groups and assign group members 14
3. removed in each task There are three options available e Clean temporary files now After specifying the time period between 2 and 14 days that the temporary files have not been accessed you can manually clean those unused temporary files by clicking this button e Clean log files now After specifying the time period between 2 and 14 days that the log files have not been accessed you can manually clean those unused log files by clicking this button e Clean sessions now After specifying the time period between 1 and 48 hours that the sessions have been inactive you can manually clean those sessions by clicking this button Figure 1 4 Monitor lt j ef E 4 administration Tools Monitor Scheduler Users amp Groups Unused Files Clean temporary files after f 7 days Clean job log files after a 7 days Save changes Clean log files now Unused Sessions Clean sessions after m FOUTS Clean sessions now 10 Elixir Administration Tools Scheduler Through the Scheduler interface Calendars and Triggers can be created and modified Calendars Calendar is used to mark daily weekly monthly events Specific dates and CRON expressions can also be used When the Calendar file is added to a Trigger the Trigger will not run on those marked dates For more information refer to Elixir Scheduler User Manual Triggers Trigger i
4. Elixir Administration Tools Release 2 5 0 2 9 12T Ambience Elixir Technology Pte Ltd Elixir Administration Tools Release 2 5 0 Elixir Technology Pte Ltd Published 2013 Copyright 2013 Elixir Technology Pte Ltd All rights reserved Solaris Java and all Java based trademarks and logos are trademarks or registered trademarks of Sun Microsystems Inc Microsoft and Windows are trademarks of Microsoft Corporation Table of Contents Ve XI AG Stallone OOIS 26 it ta dai 1 O a tenes A A tee eas 1 SA E R TE EA A R eters tn ieee A E R eee E ETE l OC WSS EN T crete cca cea EO iv eas A O E sas E ess 1 VOD Ence qedar laa lts a iaa 2 CONAS Re EET 2 ETS EEEE EE E STEE T E A TREO 2 ELETE AVC Spee em I E TA N I E O E R S E E AI T N Slee 8 Connorin JDBC DAVES ur tai a emia 9 NOTO dodne 10 caa T THT 1 ASIN T S955 as 1 A A iat doa cesetiettctes 11 T 1 Universe Map TET 12 PIV O H E 13 Users e aero AR A Ns 14 1 N TTT TT 14 OUDS scada int doi io ideada gees a 1 14 111 List of Figures TL ADV A AE l Pee e A e e PO e E E IA 9 o A A A E 10 I IO A A A Aa 10 Le SOCHCCUICD OPE A ON o Oo A E 11 IR RA TETE 12 Ved ASOD MU LOU wonicte PERO EE E OO ties eegn tant et ram Cah endevd ag taunt G een lant acces Gat addi AOE 12 128 Publish Template Dashbord seis aa 13 1 9 Publishi Template Reporta atadas 13 LA MINE SAUCE ud is cad A A io E 13 NR a O A AEA 14 1V List of Tables Le Output Ivpesitor Report e e eh eiii ti
5. Inthe Universe Mapping pane click the Add Universe button 3 Inthe Add Universe window enter a name and select the desired universe from the File list 4 Click OK The Universe name and path are successfully mapped Note Unwanted Universe s can be easily removed from the Universe Mapping pane by a mouse click For a Repository Universe once its name and path have been mapped the name will display as an option within Ad hoc Dashboard After setting the Primary Key you can view the Ad hoc Dashboard via the following URL Fill in your domain host machine and dashboard names to proceed http lt host gt 8080 elx do lt domain gt ei accolades dashboard Sample Demo Ad 20Hoc Dashboard lt dashboard gt dashboard mode file You also have the option to publish template dashboard or report as shown in the figures below 12 Elixir Administration Tools Figure 1 8 Publish Template Dashboard Publish Template Dashboard Cancel Figure 1 9 Publish Template Report Publish Template Report Ok Cancel Universe Access Complete the following steps to control the access to the Universe Figure 1 10 Universe Access Universe Access D Allowed Users Groups E x Access Groups h Ff anon groupl test group Ok Cancel 1 Inthe Administration Tools click the Universe tab 2 Inthe Universe Access pane click the Add Access button 3 Inthe Access window select the
6. Pet_Store_User_Accounts_Report SFTP Target A SFTP Target allows the report to be transferred to a user s secured FTP Server The available parameters are user password host port dir and filename The port is optional and will default to 22 which is the default SFTP port if not specified The parameter in dir property must be an existing directory found in the target ftp server Table 1 8 SFTP Target Configurations Socket Target A Socket Target sends the report to a program which is listening typically on another machine For example a program can be written that listens on a company com port 6000 and writes any data it receives to a database or to a fax etc It is up to the receiving program what it does with the data The server Opens a connection to the listening program using the host and port information required by the socket target and streams the data across the network to the listening socket Table 1 9 Socket Target Configurations Unzip Target This target enables you to specify a file name for unzipping purpose You can enable disable this target and set this target available unavailable to anonymous users User Home Target A Repository User Home Target writes the report to the invoking user s folder in the repository Users can share jobs and they can keep separate output without overwriting one another In the example once the user Jon signs in to the repository and runs the job the report will
7. This parameter holds a boolean value t rue if the key password is encrypted and false if otherwise Sign page This parameter is to specify the page that the signature is placed sign no page will mean that the signature will not be visible sign first page and sign last page implies that the signature will be placed on the first and last page of the PDF file respectively If you wish to place the signature on a specific page enter the page number as the value for the parameter For example sign page 5 for placing the signature on the 5th page of the PDF document Sign width and Sign height These two parameters are for user to specify the height and width of the signature rectangle size Sign image The directory of the image that is to be used with the signature When no value is entered for this parameter there will still be a PDF Signature self signed automatically generated Info reason and Info location The reason for placing a signature in the PDF document and the position of the reason Certification level certificate not has no visible signature in the PDF document The document is digitally counter signed certificate no changes displays the signature in the PDF document and no changes can be made to the document certificate form filling also displays the signature in the PDF document but only the filling in of forms signing and page adding is allowed for the document certificate form filling annotation displays the
8. bc FBJ jdbc FrontBase lt host false HypersonicSQL In Proce org hsqldb jdbcDriver jdbc hsqldb file testdb false HypersonicsQL Server L org hsqldb jdbcDriver jdbc hsqldb hsal lt host false HypersonicsQL WebSerw org hsqldb jdbcDriver jdbe hsqldb http lt host gt false IBM AS 400 COMibm db2 jdbc app jdbc as400 lt host gt na false IBM DB2 COM ibm db2 jdbc app jdbc db2 Sample false IBM DB2 Universal driver com ibm db2 jcc DB2Dri jdbc db2 lt host gt 5000 false Informix Informix JDBC D com informix jdbe lfxDriver jdbc informix sqgli lt hos false InstantDb jdbc idbDriver jdbc idb sample prp false InterSystems Cach Driv com intersys jdbe Cach jdbe Cache lt host gt 19 false Interclient Interbase dr interbase interclient Dri dbc interbase lt host gt false JDBC ODBC Bridge Sun sun jdbc odbc Jdbc Odbc jdbc odbc Sample true JDataStore com borland datastore j jdbc borland dslocal file false JNetDirect DataSource com NetDirect Jdbe JDat jdbc JDataConnect ch false JNetDirect Pooling Data com NetDirect Jdbc JPoo jdbc JDataConnect lt h false MaxDB com sap dbtech jdbec Dr jdbc sapdb lt host gt 72 false McKoi com mckoi JDBCDriver jdbe mckoi lt host gt false Mimer com mimer jdbc Driver jdbe mimer lt host gt po false MySQL com mysql com mysql jdbc Driver jdbc mysql lt host gt db true MySQL qweMysqlDriver exqwe sql gweMy
9. be written to User Jon Pet_Store Elixir Administration Tools Table 1 10 Repository User Home Target Configurations folder Pet_Store Filename filename Pet_Store_User_Accounts_Report Libraries Libraries include configuration information for a full range of JDBC drivers Repertoire 9 enables you to configure JDBC drivers more easily Any JDBC drivers that require native components will usually require the Ambience system to be stopped and restarted Currently most drivers are JOBC Net pure Java drivers or native protocol pure Java drivers If there is no native code then you can transfer the JAR files to the job engine machines by putting them in Public lib in the Repository Tree and clicking the Refresh Job Engine Jars button This will cause the job engines to stop at the end of their current task The Process Managers will then start them up again with the updated classpath including any new JDBC drivers Elixir Administration Tools Figure 1 2 Libraries A PPZ ministration Tools Monitor Scheduler Universe Users amp Groups Name Class URL Enabled Cloudscape RMI Rmijdbc RjDriver jdbe rmi lt chost gt 1099 false DaffodilDB in co daffodil db rmi Rmi jdbc daffodilDB lt host false Derby Server org apache derby jdbc jdbe derby lt host gt 15 true Derby Server DB2 Driver COM ibm db2 jdbc net D jdbc derby lt host gt 15 false FrontBase com frontbase jd
10. ess Alive default first job en true default second job en true Queues The Queues page shows the history of tasks run by Job Engines Elixir Administration Tools Job Engines The Job Engines page is designed for controlling the job engines on the pre defined set of hosts You have the option to add and remove job engines as well as set the host engine name and process If you have multiple hosts configured you can add and remove the engines across all the hosts Configuration This allows you to perform common configurations that will apply across all Ambience modules For example you can set the uniform formats for date datepicker time timepicker and timestamp When a date is displayed by Java it will use the Configuration format date settings When JavaScript is used it will use the Configuration format datepicker settings by default unless there is a local override Web based modules will reflect the changes quickly while other modules may show the changes after they are restarted Right click Configuration gt format gt date datepicker time timepicker or timestamp the following menu option will display e Edit contents This enables you to edit the contents of the current node You can also validate the XML Targets After a job finishes a target may pick up the result Different targets may be chained for further processing Target processing is also a task run by the Job Engine Tar
11. get Constants If you find yourself typing a string repetitively when configuring targets you can define that string as a constant Then you can refer to that constant in target property values like constant name Target constants can be enabled disabled Only enabled constants can be used in target configurations You can define multiple constants with the same name but only one of them can be enabled at any time Target List s Target Creation Update Deletion All manipulations can be done in the Target Wizard For most of the targets configuration is simple You need to provide a name enable the target and provide values for required target properties e Status Targets can also be enabled disabled Only enabled targets can be used in RenderReport task You can define multiple targets with the same name but only one of them can be enabled If you make one target enabled the rest targets with the same name will be disabled automatically Targets can be be available unavailable to anonymous users When the Available to anonymous users check box is selected the target is accessible in anonymous mode By default only the browser target is available e Target Properties and Parameters A target requires certain properties such as file name folder name port number and so on When editing a target the Target Wizard lists all required properties for the target An administrator has several options when configuring those property values
12. ls button on the workspace toolbar Click the Libraries tab The JDBC drivers display 2 Find and select the desired driver from the list Click the Edit button The JDBC Driver dialog displays Fill in the host machine name to replace lt host gt in the URL field Leave the class information as it is 3 If the desired driver cannot be found in the list click the Add button in the Libraries tab page Fill in JDBC driver name class and URL information 4 Select the Enabled checkbox and click OK Elixir Administration Tools 5 If there is no native code for the driver download the driver s JAR file from the vendor s Web site Copy the driver s JAR file into the Public lib folder in the Repository Tree Click the Refresh Job Engine Jars button A message may pop up as shown in Figure 1 3 Refresh Job Engine Jars Figure 1 3 Refresh Job Engine Jars Refresh Job Engine Jars This action will notify each host to use the current set of jars from Public lib and if there is any change will require each job engine to restart after completing any current task This may temporarily slow the system response until the updated job engines are back up to speed Do you want to proceed Monitor The Monitor interface is used to control the regularly scheduled cleanup and other monitoring tasks Set the slider to the appropriate position to specify the time frame These time frame values will control which files should be
13. rget you need to set up a database with a table that has the correct schema to accept a report file An example as shown T ATEOS RETA id INTEGER NOT NULL GENERATED ALWAYS AS DNA ET INDI Sale NIE Nr MBE o name VARCHAR 256 NOT NULL TastModitrreo BYrGINE NOt NULES Convent BLOB NOT NULG CONSTRAINT JOBOUTPUT_PK PRIMARY KEY id Once the database is setup configuration will write into a table called JobOutput in the Derby database that is built into the Elixir Repertoire Server Elixir Administration Tools Table 1 2 JDBC Target Configurations JMS Target A JMS Target can be used for asynchronous messaging JMS applications can use job messages as a form of managed request response processing to give remote feedback to the users on the outcome of their send operations and the fate of their messages Examples of job messages are Exception Expiration Confirm on arrival COA Confirm on delivery COD etc Table 1 3 JMS Target Configurations Mail Target A Mail Target allows the output to be sent by email There are a number of parameters to specify but remember that you can use substitutions to avoid hard coding those that you decide need to be flexible The report will be sent as an attachment by email so you can choose the render format you prefer Table 1 4 Mail Target Configurations to sam elixirtech com from susan elixirtech com cc bob elixirtech com subject Pet Store User Accounts Repor
14. s used to set the configurations to decide when a job is invoked For more information refer to Elixir Scheduler User Manual Figure 1 5 Scheduler dl oe amp E EI E Administration Tools Y 52 Lil Libraries Monitor Scheduler Users amp Groups Triggers ry User Name Prev Next Enabled a admin Daily 2013 09 13 00 15 00 J admin Hourly 2013 09 12 11 00 00 Y KN admin Weekly 2013 09 13 03 15 00 Y Calendars ka Ell Name x Universe Through the Universe interface you can map a Universe name with its path publish template dashboard or report and define which users and groups will be able to access the Universe 11 Elixir Administration Tools Figure 1 6 Universe lt od amp FY amp Administration Tools v Scheduler Universe Mapping Universe Access ga D Universe Name Universe File A Allowed Users Groups example Elixirsamples Universe x A Publish Template Dashboard Publish Template Report Universe Mapping A Universe can exist anywhere in the Repository but are only accessible if its path is mapped to a Universe name Only administrators can set or alter the Universe mapping Complete the following steps to map a Universe Figure 1 7 Add Universe Add Universe File ElixirSamples Universe ExampleUniverse universe Cancel 1 Inthe Administration Tools click the Universe tab 2
15. saqlDriver jdbc mysqgl lt host gt db false Oracle OCI_driver oracle jdbc driver Oracl jdbc oracle oci8 false Oracle Thin_driver oracle jdbc driver Oracl jdbc oracle thin lt host false Other JDBC Driver Please enterthe produ Please enterthe produ true P Spy com p spy engine spy P lt depends onrealdriver false Pervasive com pervasive jdbe v2 D jdbc pervasive lt host gt false PointBase Embedded com pointbase jdbc jdb jdbc pointbase embedd false PointBase Server com pointbase jdbc jdb jdbc pointbase lt host false Postgres org postgresql Driver jdbc postgresal lt host false SQL Server DataDirect com ddtek jdbc sglserv jdbc datadirect sqlserve false SOL Server Microsoft 2 com microsoft jdbc sqls jdbc microsoft sqlserver false SOL Server Microsoft 2 com microsoft sqlserver jdbc sqlserver lt host false SOL Server TDS net sourceforge jtds jdb jdbc jtds sqlserver lt ho false Sybase ASA com sybase jdbc3 jdbc dbc sybase Tds lt host gt false Sybase ASE com sybase jdbc3 jdbc jdbc sybase Tds lt host gt false Vertica com vertica Driver jdbe vertica lt host gt 54 false TDS driver for Databas met sourceforge jtds jdb jdbc jtds lt server type false Refresh Job Engine Jars Configuring JDBC Drivers To illustrate the JDBC driver configuration procedure here are the steps 1 Click the Administration Too
16. signature in the PDF document but only commenting form fill in signing and page adding is allowed Print Target A Print Target allows you to send a report to a named printer The only option is the name of the printer If you have multiple alternate printers you could use a separate target for each printer so that you could control access by different groups In most cases the printer names will be fixed and not include substitutions You can also leave the printer name blank as it will route automatically to the default printer defined on the server Table 1 6 Print Target Configurations Canon iR C3220 PCL5c Repository Target A Repository Target writes the report to the filesystems You can identify a target folder in the repository and provided it is writable files will be written there This works regardless of whether the target filesystem is of type local secure or dbfs You should use Repository Targets when you want to allow users to view the reports through their browser as the repository will automatically update to show the latest files Elixir Administration Tools During the configuration the folder property must refer the dir parameter to an existing target filesystem in the repository The folder parameter need not as it will create a new folder after its name if it is not found in the repository Table 1 7 Repository Target Configurations dir ElixirSamples folder repository filename
17. t From Elixir Server message Your report is attached filename Pet_Store_User_Accounts_Report Elixir Administration Tools PDF Signer Target PDF Signer Target is used when a PDF output needs to be signed digitally It prints a signature in a PDF file when the file is rendered Table 1 5 PDF Signer Target Configuration PDF Signer Target Properties Signer appearance There are two types of signing mode They are self sign and wincer sign self sign signer can be generated using Java key generator keytool exe An example of a signature command is as follows keytool genkey keyalg RSA alias QAkey keypass mypassword keystore keystore ks dname cn My Key Name c SG wincer sign is recommended if higher security is required Certificate obtained is installed to the web browser and needs to be exported to be used in PDF signing Keystore type For self sign no keystore type is required For wincer sign the keystore type will depend on the respective vendor For example a VeriSign keystore type will be pks12 Keystore The directory of the keystore is entered here repository is prohibited for this parameter Key alias This parameter is optional It is to define the alias used by the keystore file Store password key password 19 the password entered when creating the keystore file The password can either be in encrypted or unencrypted form Elixir Administration Tools Store encrypted password
18. ti cil LZ JDBC Taree C Onno urd HON decida collado I dM S Var cet Confor aa a selec cotas tA Mak Tarot Omi ULA A Ce as Be ho ades Seay nest a LS PDE Sgier Taro Conn ourauon Vasa da dai Miata tatu tadas 130 Nt Ilar et CORMeUrALLONS adidas 7 Repository Target ONMCUTALIONS erica dit telecinco Oo EP Taret Onl SUratlOns TE LO SOCKEL Tal el Conti OUTAlIONS li A a aro t cias 1 10 Repository User Home Target Configurations a eee ee Chapter 1 Elixir Administration Tools Overview On clicking the Admin Tools button on the Action Bar you will see the Administration Tools panel These tools include Anonymous System Libraries Monitor Scheduler and Users amp Groups System The System page is used to create job engines monitor job queues set targets and configure date and time formats Jobs are run by many Job Engines according to their sequence in the queue Each Job Engine takes a task from the queue sends the result and writes the log into the Repository Each Job Engine only processes one task at a time Unwanted jobs can be deleted Figure 1 1 System lt q Hee e SY amp Administration Tools System Monitor Scheduler Users amp Groups Queues be x Name Type Enabled browser Unzip true mail Mail true outputl UserHome true output UserHome true printer Print true support Mail true userhome UserHome true Waiting Jobs Engine Proc
Download Pdf Manuals
Related Search