Home

Invantive Composition User Manual

Contents

1. Providers Configuration B P IChuunjbrj eem enu C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Composition User Manual 3 8 2 COnDnDOeCtlOFis een cs cena aria an 6o Ea SERE FR A Yao voc Ya naden Pa Pa SU RSYRYRRRNR T E ERR GER h cV S ETa ao Ra gan dus P RR E NND 61 3 9 VerslOnS stansen smerende Td ead awe rw ERR REN OVENE RAN DRRED leens FREEDRECE E E EE EDIE YR CIXYIR E 61 3 9 1 Release 2014 RA Ansen enn arden u unten nd lallen 61 4 Contact Information 61 Index 63 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved rA Invantive Composition 1 1 Invantive Composition Many organizations experience problems with the optimization of the information supply chain An often occurring optimization problem is the automatic generation of complex docu ments with structured data from a database or application Because of the multitude of com plex information and deviating rules per jurisdiction employees spend a lot of time in the composing of documents This manual and repetitive activity causes more erroneous com posed documents and brings with it unnecessary employee costs For organizations that are dealing with different laws and regulations such as insurers lawyers and health care in stitutions th
2. The significance of the field in the Preferences tab Language This lists the languages that are available in Invantive Composition The language shift is im mediately processed after closing the screen C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 10 Invantive Composition User Manual B I Preferences Invantive Composition of x Date First Logon 23 5 2011 10 48 Date Last Logon 20 6 2013 23 24 Last Failed Login 4 4 2013 15 53 Number of Consecutive Failed Logons 0 The meaning of the field in the tab Statistics is First login date The time on w hich you logged in succesfully for the first time Last login date The time on w hich you login succesfully for the last time Last failed login try The time on w hich someone w ith your login code failed to login for the last time Number of Subsequent Failed The number of subsequent login attempts that have failed Login Attempts 1 5 6 Help The button Help displays the help function of Invantive Composition C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Mo Invantive Composition EIN l Es Invantive Vision e 8 n Hide Back Forward Refresh Home Print Options Contents index Search Favorites Navigation invantive Composition gt Invantive Vision J Invantive Producer e Invantive Query Tool invantive Control Invantive Composition wor
3. If you start an Invantive based application product for the first time the settings xml file is searched for at multiple locations in succession e the installation folder containing setup exe e from the installation folder a folder upwards e from the installation folder a folder up and the file folder in it e from the installation folder two folders up e from the installation folder two folders up and the file folder under it e from the installation folder three folders up e from the installation folder three folders up and the file folder under it e in the folder c ws If the settings xml file can not be found the user will be asked where the settings xml file is located The chosen location of the settings xml file is remembered and used from that mo ment In the text below it is described how it works lt xml version 1 0 encoding utf 8 lt C 2004 2013 Invantive BV the Netherlands www invantive com SHeader http svn invantive com repos pl04 trunk help nl manual Topics verbin dingsconfiguratie xml 23549 2013 11 01 14 21 272 smoke Purpose Configuration of the Invantive Webservice and direct database connections available to client and the Invantive Webservice acting as a database client Explanation Connections are used to retrieve data from a database and to update the contents of databases This settings file can accommodate all settings for database and web service connections that a
4. e Variable value the value of a cell out of a SQL statement e Environment variables the value of information concerning the environment e Resource variable the translation of a translateable resource in the currently chosen lan guage e Text all the remaining 1 6 3 1 Parameter value The value of a parameter does not change during the processing of a template A parameter value has the following notation method SP name Example the value of the parameter complaint number would be requested with SP complaint number 1 6 3 2 Variable value The value of a variable changes during the processing of a template depending on the fo reach where it is filled The value of a variable has the following notation method SV name Example the value of the variable project can be requested with SV project Multiple foreach can be combined and the same name variable can be retrieved in multiple You can explicitly request from which foreach you would like to retrieve the value of a varia ble by explicitly referring to the label of that foreach with the following notation method SV label name Example the value of the variable project in the foreach with the label head can be re quested with SV hoofd project 1 6 3 3 Environment value The value of an environment variable does not change during the processing of a template The value of an environment variable has the following notation method SE groep naa
5. need to specify the exact field name 1 6 6 Example series letter The following example shows you how to compose a series letter that can be sent to all em ployees of the company with an overview of their used leave hours Perform the following steps e Start Microsoft Word e Log in to Invantive Composition as described in Connectl 6 Make a new file for example on the basis of the prescribed layout for letters within the company The end result might be for example r wid Oly Document3 Microsoft Word EX 4 Gusansmrprougnt mn YA EE FE yA a BI U aex x 5 3228 8 mE Snelle Stijl Plakken m GS h A Ac Nx AG T Dr Fir AR D MT stijten gt wijzigen Klembord iz Lettertype Alinea Stijlen 5 AANHEF TEKST OVER MEERDERE REGELS VERSPREID DIE BESTAAT UIT DE VOLGENDE ONDERDELEN POSITIE NLEIDING PRORLEEM POSSIXNILTIES EN PROPOS ACT Met mendefijke groeten invantive 3 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 16 Invantive Composition User Manual Mo e Set the fixed texst in the letter In this example we assume that we are giving an employee an overview of his recorded leave hours of the last year Be careful not to use any unnecessary line breaks or any double spaces Use styles e The final template without information from the database is VOORLETTERS TUSSENVOEGSEL ACHTERNAAM STRAAT EN HUISNUMMER POSTCODE PLAATS EVENTUEEL LAND
6. Betreft Opgenomen verlofuren JAAR door NAAM Bijlage n 0 On Referentie REFERENTIE Datum Harderwijk DATUM AANHEF Voor uw werkzaamheden t opneemt dan komt dit ten laste van de opgebouwde verlo nen JURIDISCHE ENTITEIT bouwt u het recht op verlof op Als u verlof furen Met deze brief geven wij u een overzicht van de opgenomen verlofuren in de afgelopen zes maanden TABEL Met vriendelijke groeten WERKGEVER AFZENDER VOORNAAM ACHTERNAAM FUNCTIE e Click on Install Database in the Modeller ribbon This changes the document in a template for Invantive Composition With the button Design Modus you shift between being able to edit or not being able to edit the model using Edit Model e Click on Edit Model and adjust the model as follows C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved B Invantive Composition ttodelbewerker Invantive Compasitien El xj Bestand Help led Opslaan Toevoegen model Verwijder Model jj Archiveer Model Code brief verlofuren u Naam Overzicht verlofuren ud Versie 1 Auteur Guido Leenders k Bedrijf Invantive Software B V w Omschrijving Deze brief geeft de medewerker een overzicht van de opgenomen verofuren 2004 2013 Invantive Software B V Commentaar Demonstratie gebruik Invantive Composition Statistieken Laatst bijgewerkt door INVANTIVE gle3
7. Invantive Composition Manual d Solutions for Real invantive Estate a ance nd Fin Copyright C Copyright 2004 2013 Invantive Softw are B V the Netherlands All rights reserved Alle rechten voorbehouden Niets uit deze uitgave mag w orden verveelvoudigd opgeslagen in een geautomatiseerd gegevensbestand of openbaar gemaakt in enige vorm of op enige w ijze hetzij elektronisch mechanisch door fotokopieen opnamen of enig andere manier zonder voorafgaande schriftelijke toestemming van de uitgever Ondanks alle aan de samenstelling van deze tekst bestede zorg kan noch de schrijver noch de uitgever aansprakelijkheid aanvaarden voor eventuele schade die zou kunnen voortvloeien uit enige fout die in deze uitgave zou kunnen voorkomen Deze handleiding is een naslagw erk bedoeld om het gebruik te verduidelijken Indien gegevens in de voorbeeldafbeeldingen overeenkomen met gegevens in uw systeem dan is de overeenkomst toevallig Auteurs Jan van Engelen Michiel de Brieder Mathijs Terhaag Tanja Middelkoop Guido Leenders Tatjana Daka The JasperReports License Version 1 0 Copyright C 2001 2004 Teodor Danciu teodord users sourceforge net All rights reserved Redistribution and use in source and binary forms w ith or w ithout modification are permitted provided that the follow ing conditions are met 1 Redistributions of source code must retain the above copyrightnotice this list of conditions and the foll
8. Redundance 38 Register 57 Resource value 13 Route 61 Routing 38 sS Security model 37 Select 28 Series letter 15 Service svc 39 Settings xml 3 43 SQL 23 zT Template developer 1 user 1 Tns admin 57 Tnsnames ora 57 Tnsping 57 Update 28 UpperCase 13 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved V Variable value 12 W Web Service 36 37 tunneling 39 Work process 36 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved tive Solutions for EY 2 5 Real Estate and Finance 224 Invantive Software B V Stephensonstraat 3b 3846 AK Harderwijk the Netherlands Tel 31 88 00 26 500 Fax 31 84 22 58 178 info invantive com www invantive com IBAN NLI RABO 0123 5297 02 Chamber of Industry and Commerce 08194155 VAT NL820681 131B01 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved RSIN 820681131 Pol E A Managing Director Guido Leenders Registered office Hierden
9. after the provider detected a connection loss The elements of this level can consist of two types physical connection either an Invantive Webservice or direct database connec tion failovers All physical connections listed will be brought online during application use Attributes name The name of the logical connection The webservice element This element defines a connection using the Invantive Providers Webservice pro vider This provider is capable of proxying database connections over HTTP HTTPS A client can connect to a database directly through a webservice but a webservice can route this request also to another Invantive Webservice and so on Attributes url the url of the Invantive Webservice encoding the encoding to use This will be passed as header on the request Allowed values are binary or text Default binary Use text for debug ging purposes or with poor CPU compression the compression method to use This will be passed as header on the request Allowed values are auto true or false Default auto will set compression enabled Within a fast LAN network and or with slow servers we recommend no compressi on In all other situations we recommend compression to be enabled The database element This element defines a connection to a database using a provider Specific for that type of database C Copyright 2004 2013 Invantive Software B V the N
10. the Netherlands All rights reserved s Invantive Composition User Manual 2 Oracle Universal Installer Welcome ORACLE 1 DATABASE Welcome The Oracle Universal Oracle prodi Deinstall Products About Oracle Universal Installer L4 e We recommend to install the most comprehensive version within the license agreement so that all devices are readily available if they should be needed later C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 2 Invantive Webservice EN Ne 3 Oracle Universal Installer Select Installation Type ORACLE 9418 DATABASE Select Installation Type Oracle Client11 1 06 0 Product et Languages LA b Hep Installed Products e Select the required languages via Product Languages Here we recommend to choose all languages C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved x Invantive Composition User Manual Mo w Language Selection Language Selection Oracle Client 11 1 0 6 0 Please select the languages in which your product Oracle Client 11 1 0 6 0 will run Available Languages Selected Languages Thai Traditional Chinese d Turkish Oracle Universal Installer Specify Home Details ORACLE 11 g DATABASE Install Location Specify a base location for storing all gace sotene and sonnouraton relatad f fi ls gle locaton is ihe Oracle Bas
11. Improved security of company information Real time database with historical information With Invantive Composition you will have a complete solution for the automatic generation of complex documents in Microsoft Word Invantive Composition easily allows you to automati cally retrieve and edit unstructured data from a database or application By automatically fil ling precomposed templates with data you will easily compose complex documents that meet the laws and regulations This way Invantive Composition optimizes your information supply and yields you a cost reduction Invantive Composition is standard supplied along with Invantive Vision Invantive Estate and Invantive Producer For a personal presentation of Invantive Composition please contact us 1 1 Functioning The image displays the global working of Invantive Composition The developer of the tem plate develops the template and an accompanying model in Invantive Composition and sa ves it as a Word or Powerpoint file This can be stored in Invantive Estate Invantive Vision or a different Invantive Producer based application But the developer of the templace can also store the template on the file system The user of the template subsequently opens the template and combines the template with C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Composition User Manual data from the database The final result is a Word or Po
12. BBC Country Profiles Some examples of simple warsz statements WHERE SELECT GROUP BY SELECT JON see SELECT INSERT VALUES 2 2 Functioning This paragraph describes the functioning of the Query Tool The Query Tool consists of two parts e The editor section e The output section In the following paragraph there are several examples of what you can do with the Invantive Query Tool 2 2 1 Query Tool Examples e The figure below shows the request by means of a SQL query of persons grouped by or ganization C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Mo Invantive Query Tool m Fa Invantive Estate Query programma OF XI Bestand Bewerken Verbinding Editor Database Venster Help 4 Uitvoeren id Exporteren select gbr gbr_naam persoo gbr gbr_functie functie lvr lvr naam organisatienaam lvr lvr plaats plaats bubs gebruikers v gbr bubs leveranciers v lvr gbr lvr id lvr lvr id ab 2 3 E 5 6 a 8 9 Resultaten DBMS Uitvoer Uitleggen Plan Spoor Historie lvr lvr naam persoon EY functie EV organisatienaam Food and more 1 item 1 Bomvande Accommamge meo 0 organisatienaam Janssen Uitgeversorganisatie 3 items 1 Hoef van der Engineer Amersfoort 2 Aeilkema Regiomanager Amersfoort 3 Dom Consultant Exact Amersfoort organisatienaam Piet Van Den Herck bna 1 item organisatienaam QT Design 2
13. D m organisatienaam Food and more 1 item E n 12 3 persoon functie plaats 4 Born van der Accountmanager Amersfoort 5 G organisatienaam Janssen Uitgeversorganisatie 3 items 7 8 persoon functie plaats 189 Hoef van der Engineer Amersfoort 1 Aeilkema Regiomanager Amersfoort e 144 Dorn Consultant Exact Amersfoort 12 13 organisatienaam Mekra 1 item 17 18 organisatienaam Piet Van Den Herck bna 1 tan 22 23 organisatienaam OT Design 2 items M 4 F Pl Sheets PJ IIML u Ui Ready RII HJ 10096 1J e The image shows the result of the SQL query in Adobe Acrobat File Edit View Document Comments Forms Tools Advanced Window Help x mc Ries 2 f g AE S Boole a m 5 Find y functie Food and more 1 item Accountmanager Janssen Uitgeversorganisatie 3 items Engineer Regiomanager Consultant Exact Mekra 1 item Communicatie Piet Van Den Herck bna 1 item Sr Channel Manager General Business Sales Amsterdam QT Design 2 items Helpdesk Teamleider Amersfoort Account Manager Amersfoort i260x926in a C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved E Invantive Composition User Manual o 2 2 2 Editor In the editor you can execute queries There are five types of SQL statements possible e Select e Insert e Update Delete e PL SQL Begin End without line breaks and blank lines A possibl
14. Database database User Id us ername Password password provider System Data SqlClient gt lt connection gt lt connection name MySQL gt database connectionString Server localhost Database database Uid userna me Pwd password provider MySql Data MySqlClient gt lt connection gt lt connection name Oracle gt database connectionString Data Source localhost User Id username Pass word password provider Oracle DataAccess Client lt connection gt lt group gt lt connections gt gt connections default Customer A Production forceDefault false gt lt group name Customer A connection name Production database connectionString Data Source authenticationServer User Id user name Password thepublicpassword Pooling false provider Invantive CustomerA Acti veDirectory failover database connectionString Data Source localhost User Id username Pass word thepublicpassword Pooling false provider Oracle DataAccess Client webservice url http www customer a com ws encoding binary compression true gt lt webservice url http failover customer a com ws encoding binary compression true gt lt failover gt lt connection gt lt group gt lt connections gt 3 7 4 Providers Configuration In the providers configuration file providers xml you configure which requests are processed by which providers and how the requests are routed within the
15. EA Oracle Universal installer Install ORACLE T1 p DATABASE Install Ideal Platform for Grid Computing Low cost servers and storage Highest availability Best scalability Installed Products B Next e Afterwards a configuration program for the network configuration is started Choose Can cel we advise you to use the configuration file tnsnames ora as described in the next part of the instructions C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 56 Invantive Composition User Manual Oracle Net Configuration Assistant Welcome Y Welcome to the Oracle Net Configuration Assistant To access a database service or other type of service you use a connect identifier The Assistant has determined that your client can use the easy connect naming method for identifying the database you wantto access With easy connect naming you use the host port optional and service name ofthe database as the connect identifier Click Help for more information about connecting to a database using easy connect Annuleren Help J Terug Volgende gt e Select Next Ww Oracle Universal Installer Configuration Assistants ORACLE 4 1 g DATABASE Configuration Assistants The following configuration assistants will configure and start the components you selected earlier Tool Name Status Type Oracle Client Oracle Net Con
16. Invantive Composition X Invantive Composition Fim C Copyright 2004 2013 Invantive Software BV the Netherlands Belesdey gor All rights reserved Real Estate and Finance In lew te det 9Oftwa eee OF the computer vA m x documentatia 4 M A L4 2 Ecc 4 1 to 4 ratin actions AND devices R T ips COMU v l pred d ions tor changing the m ecomputage amp haring fas EASIE trien The meaning of the entry fields is Username The username used for connecting to the server Passw ord The passw ord of the user Connection Here you enter the server w ith w hich you w ant to connect Store passw ord The passw ord will be stored encrypted w hen checked Connect Automatically The application automatically connects to the server and the connection screen does not appear w hen checked 1 5 5 Preferences In this screen you can set the preferences for Invantive Composition and other Invantive Pro ducer based products C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 20 06 2013 23 24 07 E The meaning of the fields in the tab Filter is Your name _ Report date The name of the user within Invantive Producer Here you can enter the reporting date for which the information on the reports should be show n This data is activated w hen checked C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Composition
17. Invantive Webservice The possibilities are described in the sample file providers xml sample lt xml version 1 0 encoding utf 8 a gt C 2004 2013 Invantive BV the Netherlands www invantive com Header http svn invantive com repos pl04 trunk help nl manual Topics bubs Providers Configuratie xml 23549 2013 11 01 14 21 27Z smoke Configuration of providers for Invantive Webservice Purpose You can configure providers here sorted by order Providers are tried to handle a request in decreasing order So the provider with order 500 is offered the request before the provider with order 400 is offered the request Providers with order 70 80 90 100 and 200 are reserved for Invantive internal use see the table below Explanation Providers are used to provide functionality that is not part of the webservice A provider knows how to handle a specific action on a specific platform Some providers are included in the installation such as providers for database or webservice connectivity or a file logging provider The default providers are included in the software so they are not listed here between the providers tag A provider does in general NOT define WHERE the action will be executed That is normally specified by the settings xml C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved A Invantive Webservice But specific providers may contain the location WHERE the ac
18. Microsoft SQL Server Client The Microsoft SQL Ser ver Client is supplied with every NET installation Configuration Microsoft SQL Server Client There are no configuration settings for the Microsoft SQL Server Client 3 7 5 3 MySQL Provider for Invantive Webservice In this chapter the configuration of the provider is described In addition some suggestions are provided to execute the installation of the MySQL pro gramming However this is no replacement of the knowledge and experience with the local situation and trainings that an administrator or DBA has from his role and the results of the installation are therefore not guaranteed Installation MySQL Client The MySQL Connector Net client is available at http dev mysql com downloads connector net The installation of the MySQL client MySQL Connector Net proceeds as follows Double click the MSI installation file from the zip at above mentioned website e Choose the button Next e Choose the button Typical e Choose the button Install e Choose the button Finish Configuration MySQL Client Specific settings for the MySQL Connector Net client can be found at http dev mysal com doc refman 5 6 en connector net connection options html 3 7 5 4 IBM DB2 Provider for Invantive Webservice In this chapter the configuration of the provider is described Furthermore some suggestions are given to execute the installation of the IBM DB2 pro gramming However
19. older than 2 years e Drivers for the supported databases or own specific drivers for business applications 3 4 Concept With the Invantive Webservice Invantive applications and applications based on Invantive Producer can exchange data with databases and other services using the internet or the company network It is also possible to use these applications without Invantive Webservice but for installations with more than one user this is strongly discouraged With the Invantive Webservice it will ta ke no time outside of the client installation to allow an extra user or PC to make use of a da tabase without the Invantive Webservice this will take considerably more time for each PC and or user The exchange of data happens through webservices that use the so called http and or https protocol Depending on the chosen security model you can exchange data with databases in the company network using the Invantive webservice both within the company network as well as on the internet from Invantive applications and applications based on Invantive Produ cer You can also if authorized exchange data with databases at various companies With this you can easily collaborate with multiple clients and or relations in an efficient manner where ver you are and whenever you feel the need to Every client and or relation also has an own installation of the Invantive Webservice The Invantive Webservice works as follows e A user starts an applica
20. platforms can be added by a system developer or ordered with Invantive Requests are routed to providers as soon as requests for data or actions arrive to the web server In the configuration file you can adjust in which order this happens see image See also Providers Configuration 48 Invantive Webservice Routing Service or data requested A W Provider BS von name a Invantive Loy Invantive om Producer 3 6 Redundance For a higher availablity you can install multiple installations of the Invantive Webservice pro gramming These installations can be located on ne server or on multiple servers With C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 2 Invantive Webservice KEN multiple servers you ensure a better availability even if a server breaks then the users can still keep on working see image Invantive Webservice Failover Invantive Webservice st q Invantive gt Webservice Invantive Webservice The redundance can be set in the settings xml file See also Connection configuration a3 As soon as a connection is no longer available the programming of your user will try to use a dif ferent available connection 3 7 Installation This element describes the installation of the Invantive Webservice and its components 3 7 1 Invantive Webservice Programming Execute following steps to make the Invantive Webservice available to the user
21. the SID dv C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 58 Invantive Composition User Manual Mo t11r2 and the global name dvt11r2 invantive com e Full instructions on creating tnsnames ora can be found in the Oracle documentation e Make sure that the tnsnames ora file is located on the same place on all PC s preferably in way to make it easy to add services from a central location For fixed workplaces often a network drive is used for example as follows B Zoekresultaten Bestand Bewerken Beeld Favorieten Extra Help Qi DD Pader rmm E weg Naam In map O Finance Andere locaties Bureaublad Deze computer E Min documenten Min netwerklocaties Details Zoekresultaten Systeemmap e Open the register with regedit and go to the key HKLM SOFTWARE Oracle KEY_OraC lient11g_home1 5 Register editor Bestand Bewerken Beeld Favorieten Help a Hewlett Packard Naam Gegevens CD Hitman Pro ab Standaard geen waarde ingesteld d Eg HP ab MSHELP_TOOLS c orade product 11 1 0 dient_1 MSHELP 2 i ab NLS_LANG DUTCH THE NETHERLANDS WEBMSWIN1252 ud UE abJoLEps c prade product 11 1 0 dient 1loledb mesg i i Logitech ab oo40 c oracle product 11 1 0 dient_1 0040 mesg ab ORACLE_BUNDLE Enterprise CA Macromedia H E Microsoft abjoracte_GROUP Oracle OraClient11g_home1 m MozillaPlugins ab ORACLE_HOME c orace product 1
22. this is no replacement of the knowledge and experience with the local situation and trainings that an administrator or DBA has from his role and the results of the installation are therefore not guaranteed Installation IBM DB2 Client Install the IBM DB2 Data Server Driver as described on http pic dhe ibm com infocenter db2luw v9r7 index jsp topic 2Fcom ibm swg im dbclient install doc 2Fdoc 2Ft0007315 html C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Webservice Configuration IBM DB2 Client There are no configuration settings for the IBM DB2 Client 3 8 Terminology Hieronder beschreven we de gebruikte termen 3 8 1 Channel A channel is the medium on which data and requests are exchanged between an Invantive Producer client application and an Invantive Webservice server 3 8 2 Connection A connection is the definition of possibilities to establish a channell e between an Invantive Producer client application and an Invantive Webservice server 3 9 Versions This chapter describes the changes in the application per version 3 9 1 Release 2014 R1 Released XX XX 2014 Invantive Producer bXX and c fixes Sk DB2 data ne TU D Rc support 23456 ER IBM DB2 ook via ODBC ER __ IBMDB2 ook via ODBC mogelijk maken maken 22594 ER Ondersteuning voor redundante verbindingen failover 23279 PR Onder specifieke condities treedt een Byte e
23. vanaf werkstation ws35 invantive local op 21 6 2013 11 41 41 Nooit bi ki e You wish to be able to print out the letter just for one specific employee which you enter at the start e That is why you need to enter a parameter as follows in the model Modelbewerker Invantive Composition ioj xj Bestand Help led Opslaan ToevoegenParameter X Verwijder Parameter Archiveer Model j p naam medewerker patroon w n medewerker gebruik als wildcard w Jan Janssen u Then finally choose Save and close the model editor You can now leave the design modus by clicking on the button Design Modus one more time Next we will add instructions to add data to the letter when the template is opened Be careful Microsoft Word depending on your settings changes the straight double quote in open or close quotes If this happens press Ctrl Z undo immediately you will then regain the originally entered straight double quote We will now add the following query lines and parameters to the document With these ru les Invantive Composition will allow you to automatically fill your document with dynamic texts C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Composition User Manual e Foreach query rule To ensure that the same information layout returns on every document we add the query li ne foreach This indicates that you want the same inform
24. your information supply and yields you a cost reduction Invantive Composition is standard supplied along with Invantive Vision Invantive Estate and Invantive Producer C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved rA Invantive Composition 3 1 3 System Requirements To use Invantive Composition on your PC or terminal server you will need the following soft ware including licenses Microsoft Word 2010 or Microsoft Word 2013 only on Microsoft Windows Microsoft NET 4 5 Minimum 2 GB of internal memory e Screen resolution of 1280 x 1024 or higher User license for used databases and or business applications e Invantive Webservice or local drivers Use on Mac tablet or smartphone is not possible 1 4 Installation Invantive Composition is installed on the Windows computers by executing the following steps e Run the installation file setup exe then click on the Install button The file is in the folder of Invantive Composition for Word and in the folder of Invantive Composition for PowerPoint You need to do a separate installation for every product These installation folders are sup plied by Invantive Microsoft Office Customization Installer Installing Office customization i Please waitas this could take several minutes ss Name Invantive Composition for Word Eom file Z prd invantive compositionfor word Invantive Producer Composition Wo
25. 03 H gt tnsping acci1ir2 invantive local INS Ping Utility for 32 bit Windows Version 11 1 0 6 0 Production on 07 SEP 2009 14 37 26 Copyright lt c 1997 2887 Oracle All rights reserved Used parameter files iC app Administrator product 11 1 c lient_1 network admin sqlnet ora Used TNSNAMES adapter to resolve the alias Attempting to contact lt description lt address list address Cprotocol tepdChost 192 168 172 16 gt Cport 1521 gt gt gt lt connect data sid acciir2 gt lt global_name acciir2 inyvantive local gt gt gt OK B msec HEN Dn e t is still not certain if the user password are correct but it is certain that a network connec tion to the Oracle service can be built C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 60 Invantive Composition User Manual o Finally check the connection by logging in with SQL Plus 3 7 5 2 Microsoft SQL Server Provider for Invantive Webservice In this chapter the configuration of the provider is described In addition some suggestions are provided to execute the installation of the Microsoft pro gramming However this is no replacement of the knowledge and experience with the local situation and trainings that an administrator or DBA has from his role and the results of the installation are therefore not guaranteed Installation Microsoft SQL Server Client There are no installation steps for the
26. 1 1 0 dient_1 a opc ab ORACLE HOME SOFTWAREYORACLE EY OraClientiig homei a ORACLE _ BBJORACLE_HOME_ OraClient11g_home1 ex KEY_OraClient1ig_home ab sQLPATH c pracle product 11 1 0 dient_1 dbs 5 OLEDB lab stmtCacheSize 0040 H ODP NET H Policies CJ Program Groups H E Realtek e Add a string with the name TNS ADMIN and make it point to the network location C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Webservice Register editor Bestand Bewerken Beeld Favorieten Help Hewlett Packard Gegevens CD Hitman Pro geen waarde ingesteld HP OLS t c orade product 11 1 0 dient_1 MSHELP a s ab nLs LANG is DUTCH THE NETHERLANDS WE8MSWIN 1252 CI JavaSoft ab OLEDB xd e 1n nt 1 oledb mesg Z3 Logitech labjoo40 Int 110040 mesg 53 Microsoft abJORACLE GROUP REG SZ Binaire waarde a MozillaPlugins ab ORACLE HOME REG SZ DWORD waarde ht 1 opc abJORACLE HOME REG SZ Waarde met meerdere tekenreeksen aClientiig homei ORACLE abJORACLE HOME REG SZ Waarde met uitbreidbare tekenreeks B S KEY_OraClient11g_home1 ab sQLPATH REG SZ Crrade producti T U Ydient ildbs oB ab stmtcacheSize REG_SZ 0 0040 H ODP NET H E Policies Program Groups Realtek m ee FE RE RE REI REI E Deze computer HKEY_LOCAL_MACHINE SOFTWARE ORACLE KEY_OraClient11g_home1 e Change also the NLS_LANG to DUTCH THE NETHERLANDS AL
27. 32UTF8 to make sure that messages appear in dutch and the Unicode character set is used If you use Oracle Instant Client then there is no NLS_LANG in the Windows registry that s why you need to define the NLS_LANG environment variable in Windows Register editor Bestand Bewerken Beeld Favorieten Help CJ Hewlett Packard A Naam Gegevens c1 Hitman Pro ab Standaard geen waarde ingesteld ante ab MSHELP_TOOLS c oracle product 11 1 0 dient_1 MSHELP C HPQ Intel eh ab OLEDB c oradeproductM 1 1 0 dient_1 oledb mesg Logitech ab oo40 c rade productM 1 1 0 dient_1 0040 mesg Z3 Macromedia ab ORACLE_BUNDLE Enterprise CD Microsoft abJORACLE GROUP Oracle OraClient11g_home1 Z3 MozillaPlugins ab ORACLE_HOME c orade product 11 1 0 dient_1 zy opsc ab ORACLE_HOME_ SOFTWAREYORACLEWEY OraClientiig homei ORACLE abJORACLE HOME OraClientiig homei AN KEY OraClientiig homei ab soLPATH c oradeproductM 1 1 0 dient_1 dbs zy OLEDB ab StmtCacheSize 0 0040 o finance a ODP NET CQ Policies Program Groups CJ Realtek m A EE EE RE E De Deze computer HKEY_LOCAL_MACHINE SOFTWARE ORACLE KEY_OraClient11g_home1 e If you use Oracle Instant Client then there is no NLS LANG in the Windows registry that s why you need to define the NLS LANG environment variable in Windows e Test the connection from a command prompt with tnsping ro t Windows Ve Copyright 1985 20
28. ANY THEORY OF LIABILITY WHETHER IN CONTRACT STRICT LIABILITY OR TORT INCLUDING NEGLIGENCE OR OTHERWISE ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE Contents 1 1 1 2 1 3 1 4 1 5 1 5 1 1 5 2 1 5 3 1 5 4 1 5 5 1 5 6 1 6 1 6 1 1 6 2 1 6 3 1 6 4 1 6 5 1 6 6 1 6 7 1 7 1 7 1 2 1 2 2 2 2 1 2 2 2 2 2 3 2 3 2 4 2 5 2 6 2 6 1 3 3 1 3 2 3 3 3 4 3 5 3 6 3 7 3 7 1 3 7 2 3 7 3 3 7 4 3 7 5 3 8 3 8 1 Invantive Composition 1 FUN CUONING t R 1 Advantag s ener ipei iiti itiartiepelikearP iarPR ws DS RIIR ia Pee 2 System Requirements orna o ener co NEon cc sva an e cc a epa ne sc ae aR orco ae ka ncc s ERR Eas 3 c cEuDd m EE X CEE 3 USAGE 4 Document Management nussssrerssaven stere oco eere eo trae va x en Ek ees ea EE e eR Y aen E Ya EDEN eT en eR Ya EE e Ng ET a eS sa Xin ERE iaaa 4 Publish 5 Parameter values Connect Ime TETTE IE DTE 7 FOND Lore el c r Modeller ribbon PossibleinSrOCHONS EH EXPRESSIONS eser reae civ tent rig eBay ex Ete suc ankeren ien taat teen ante
29. E m m VE a sE OF Edit Validate Install Upgrade Remove Query Invantive Show Model Model Database Database Database Tool Studio Trace Madel Tools Debug and analysis Controleren Beeld Invantive Composition Modeller 4 1 6 1 Modeller ribbon This paragraph shows you an explanation of the tab Invantive Composition in the ribbon Mo deller in Microsoft Word and PowerPoint The template designer can build templates with the accompanying model The following image shows the tab Modeller rr wid 1 7 Bestand Start Invoegen Pagina indeling Verwijzingen Verzendlijsten Controleren Beeld Invantive Composition Modeller Gr AaB x 3 GO Edit Validate nsta ograde Remove Query Invantive Show Show Model Model Database Database Database Tool Studio Repository Trace Model Tools Debug and analysis C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved dar Invantive Composition User Manual Me 1 6 2 Possible instructions The following types of instructions are possible e lt invantive value of gt Print value of an expression or cell from a SQL statement e lt invantive foreach gt lt invantive foreach gt Run through all rows of a SQL statement for the intermediate piece of text 1 6 3 Expressions An expression can use multiple types of data e Parameter value the value that the user has entered for a parameter as described in the model
30. Software B V the Netherlands All rights reserved Invantive Webservice EN w Enable default content Neeeeeee nnn nnn nnn nnne nnn nnn nnne L1 d Service svc e You can now test the web service by opening the page You will receive output such as t23522 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 4 Invantive Composition User Manual E c Qo ws ita pbubs Service Service You have created a service To test this service you will need to create a client and use it to call the service You can do this using the svcutil exe tool from the command lir svcutil exe http local ws ita pbubs Service svc wsdl This will generate a configuration file and a code file that contains the client class Add the two files to your client application and use the genera ce class Test Static void Main ServiceClient client new ServiceClient Use the client variable to call operations on the service Always close the client client Close Visual Basic Class Test Shared Sub Main Dim client As ServiceClient New ServiceClient Use the client variable to call operations on the service Always close the client client Close End Sub End Class 3 7 2 Certificate If you make use of https then you need to submit a certificate see also http www iis net learn manage configuring security e Start MMC with Run e Go to the File menu a
31. Tool KEN Pa Invantive Vision Query programma ioi xi Bestand Bewerken Editor Database Venster Help ae Uitvoeren ipd Exporteren al select from bubs taken v Resultaten DBMS Uitvoer Uitleggen Plan Spoor Historie Sleep een kolom hierheen om te groeperen op die kolom tak_nk XY tak bedrag vaste pis X V tak code 5 7 tak datum bijgewerkt omlaag 5 V tak datum dfi 10 8 2007 8 20 29 d 15 6 2009 18 27 18 7 8 2007 15 42 53 4 10 2007 14 23 50 6 704 Betrokken Rijen Also the number of rows and the execution time will be displayed 2 2 3 2 DBMS output This tab includes the output of dbms output put line statements only in combination with Oracle RDBMS 2 2 3 3 Explain Plan The Explain Plan can be executed using the menu item Explain Plan or using the key com bination Ctrl E Pa Invantive Estate Query programma Bestand Bewerken Database Venster Help Mi Uitvoeren g Expoi Uitvoeren F9 1 Select Uitleggen Plan Ctrl E 2 from bubs telefoon contacten r 3 where vda ref sleutel 58 The executing of Explain Plan ensures the filling of the tab Explain Plan with the rows which are completed by the Explain Plan of Oracle C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 32 Invantive Composition User Manual Mo Fg Invantive Estate Query programma iO xi Bestand Bewerken Editor Database Venster Help gg Uitvoeren ed E
32. Webservice In this chapter the configuration of the provider is described In addition some suggestions are provided to execute the installation of the Oracle program ming However this is no replacement of the knowledge and experience with the local situa tion and trainings that an administrator or DBA has from his role and the results of the instal C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved IF Invantive Webservice EMI lation are therefore not guaranteed Oracle Client Installation The installation of the Oracle client can be done following the next steps Navigate to the folder containing the setup program for example Bestand Bewerken Beeld Favorieten Extra Help Q ee Bp zoeken j gt Mappen Tr O Finance Wwin32 119R1 dientldient Type Bestands en maptaken Bestandsmap 5 3 2009 10 49 mj Dit bestand een andere naam Bestandsmap 5 3 2009 10 48 geven Bestandsmap 5 3 2009 10 49 gy Dit bestand verplaatsen Bestandsmap 5 3 2009 10 51 A Dit bestand kopi ren Toepassing 12 2 2009 13 21 Configuratie instellingen 12 2 2009 13 21 Dit bestand op het web e publiceren HTML Document 12 2 2009 13 21 Dit bestand per e mail verzenden XK Dit bestand verwijderen Andere locaties c N32 ligR1 dient C Min documenten d Deze computer Mijn netwerklocaties e The Oracle installation program appears C Copyright 2004 2013 Invantive Software B V
33. ame Password thepublicpassword Pooling false provider Invantive CustomerA Acti veDirectory lt failover gt database connectionString Data Source localhost User Id username Pass word thepublicpassword Pooling false provider Oracle DataAccess Client gt lt webservice url http www customer a com ws encoding binary compression true gt lt webservice url http failover customer a com ws encoding binary compression true gt lt failover gt lt connection gt lt group gt lt connections gt This example illustrates connections to different database platforms The soft ware will try to Connect to the IBM DB2 UDB database when connection DB2 is selected Connect to the Microsoft SQL Server database when connection SQLServer is selected Connect to the Oracle MySQL server when connection MySQL is selected Connect to the Oracle RDBMS server when connection Oracle is selected connections default Customer A Production forceDefault false gt lt group name Customer A lt connection name DB2 gt database connectionString Server localhost Database THE DATABASE UID us ername PWD password CurrentSchema schema provider IBM Data DB2 gt lt connection gt lt connection name SQLServer C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved EI Invantive Composition User Manual o database connectionString Server localhost
34. and databases The advantage of this is that existing applications and applications based on Invantive Producer can easily exchange data This means that partners can use ne application for the planning of pro jects execution of complex calculation models and the registration of work hours Using the Invantive Webservices the data can depending on the security model be retrieved and processed in the own administration This makes it possible to provide multiple clients and or relations quick and safe access to the company network with the Invantive Webser vice With the Invantive Webservice work processes can be organized even smarter and be op timized The result is the more effective and efficient work on a project 3 3 System Requirements Client C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved IF Invantive Webservice To use Invantive Webservice on your PC or terminal server you will need the following soft ware including licenses Microsoft NET 4 5 Minimum 2 GB of internal memory e Screen resolution of 1280 x 1024 or higher On Premises For the use of Invantive Webservice as server within the private network you will need so called on premises use Operating system Windows 2008 R1 Service Pack 2 Windows 2008 R2 or Windows 2012 Minimum of 4 Gb internal memory e Screen resolution of 1280 x 1024 or higher Minimal 1 central processing unit for server use not
35. are B V the Netherlands All rights reserved Invantive Composition naam you accrue leave entitlement If you make use of leave time then this will be atthe expense of accrued leave hours With this letter we present you with an overview of the recored leave hours in the recent six months e Now thatthe dynamic texts are automatically added within the serial letter we add the parameters for the leave hours Because you want to have the same layout for each let ter you again add a foreach query line With this query you retrieve all leave hours from the database and process these by Invantive Composition in the text The query then looks as follows invantive foreach query select to char uur uren inspanning FM90D00 uur uren inspanning c to char uur datum start dd mm yyyy uur datum start c uur commentaar from bubs uren v where gbr id S F gbr id and pjt code like IVAC and uur da tum start add months sysdate 6 order by uur datum start lt invantive value of expression F uur datum start c invantive value of expression F uur uren inspanning c gt uur lt invantive foreach gt Now thatthe leave hours are automatically entered we close the serial letter with the sen der Here we also make use of parameters to automatically fill in the name and function of the sender We enter the following parameters invantive value of expression F gb
36. ation to be applied on every docu ment with the same layout Within the foreach query line you enter all information that you wish to have on the employee The foreach query line looks like this invantive foreach query select gbr voornaam case when gbr tussenvoegsel is not null then gbr tussenvoegsel end gbr achternaam gbr volledige naam case when gbr ge slacht ind M then heer else mevrouw end gbr aanhef ge slacht gbr adres regel 1 gbr postcode gbr plaats gbr land to char sysdate dd mm yyyy vandaag lvr naam gbr baas func tie gbr baas naam to char add months sysdate 6 dd mm yyyy to char sysdate dd mm yyyy periode gbr id from bubs gebruikers v where gbr naam like P p naam medewer ker patroon and lvr code 13031406 and gbr tijd schrijver vlag Y order by gbr naam gt Now that we have entered the foreach query for the document the different parameters for the dynamic filling of the letter need to be added The first parameter that we add is the addressing This is because this differs for each letter To automatically add addres sing by Invantive Compositions you add the following parameters to the document lt invantive value of expression S F gbr volledige naam gt lt invantive value of expression SF gbr adres regel 1 gt lt invantive value of expression SF gbr postcode gt lt invanti ve valu
37. cx 559 KB Invantive Rapport v19 dotx 3 1 MB business case xxx nl docx 108 KB Invantive Brief non estate v21 dotx 566 KB Invantive Brief v21 dotx 2 3 4 n 6 7 8 H i Audit Cr History Ci Refresh gl Export amp Help Once you have chosen the template then it will be published immediately Read more in Pu blishing s 1 5 2 Publish The publishing of a template document combines the template with data from the database so that you receive a pre filled document If there are no parameters then there is nothing else that needs to be done If there are para meters then Microsoft Word will first ask which values you wish to use like for example C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved KR Invantive Composition User Manual o I Enter parameter values Invantive Composition Ed Days remaining for final notice If possible the values will immediately be filled with a useful value 1 5 3 Parameter values The standard parameter values that you enter at Publishing s can also be requested through this button 1 5 4 Connect Click on the tab Invantive Composition in the ribbon and subsequently click on the button Connect to connect to the server Enter user name password and connection and click on OK C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Jr Invantive Composition I Connect
38. d upper case InitCaps replace the first letter of every word by an upper case letter and replace the rest with lower case letters Meaning in Header and Footer The value in a header or footer is equal to the first filled value that the expression has at the beginning of the current section 1 6 5 invantive foreach invantive foreach With invantive foreach invantive foreach you can repeat a sequence every time again with different values for the variables An example of lt invantive foreach gt lt invantive foreach gt e lt invantive foreach query select gbr naam from bubs gebruikers v gt provides successively each person s name from the system 4 invantive foreach query select gbr naam from bubs gebruikers v where gbr naam P p naam order by gbr naam gt provides successive ly every person s name from the system which is equal to the value of the parameter p_ naam sorted by name e lt invantive foreach label gbr query select gbr naam from bubs gebruikers v gt provides successively each person s name from the system The se data are available through invantive value of with the use of the attribute querylabel The queries you can use to retrieve all fields With lt invantive value of gt you still C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved zo Invantive Composition EIN
39. dt geinstalleerd op de Windows computer door de volgende stappen Invantive Composition uit te voeren Fundioning Run the installation file setup exe then click on the Install button Het bestand staat in de vua Hedge map van Invantive Composition This installation directory is supplied by Invantive i2 Usage Microsoft Office Customization Installer Development P Publisher has been verified e Installation i o 7 amp Versions Are you sure you want to install this customization d Contact Information Name Invantive Control From File 2 prdfinvantive_control Invantive Producer Contral vsto Publisher Invantive B V While Office customizations From the Internet can be useful they can potentially harm your computer If you do not trust the source do not install this software More mand pen ere When the installation is finished the screen below is displayed Microsoft Office Customization Installer The Microsoft Office customization was successfully installed g al 1 6 Modeller A template consists of pieces of text with in the middle instructions for Invantive Compositi on For the development of a template for Invantive Composition you use instructions in the text and data in a model For the development you use the resources in the lint Model r wj id Ul brass doc Microsoft Word EE e Invoegen Pagina indeling Verwijzingen Verzendlijsten
40. e creation of complex documents is a costly and time consuming task The au tomatic generation and creation of documents that meet the laws and regulations is a huge challenge for most With Invantive Composition you will have a complete solution for the automatic generation of complex documents that meets the laws and regulations Invantive Composition allows you to easily retrieve information from your database and process it in Microsoft Word This way Invantive Composition makes it easy for you to automatically fill in previously created templa tes with data from your database For you this means that you can merge data from your ad ministration system such as budget consumption contract pieces licenses prices and other structured data into a personal document The advantage of this is that with Invantive Composition you can manage and dynamically create documents from the document mana gement system Which results in an optimized information and communication process The automation of your information supply chain with Invantive Composition will bring you ad vantages such as Optimization of the documenting and communication process Automatically fill precomposed templates in Word Merge unstructured texts in a document Directly open documents in Word that were stored as BLOB or BFILE Internal search engine to search documents on their classification Reduction of erroneously prepared documents and production costs
41. e directory Create c an configuration files let OraClient11g home1 cAoracleiproducti1 1 1 0iclient 1 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved B Invantive Webservice os e Subsequently a number of checks will be performed If problems are found solve them first Oracle Universal Installer Product Specific Prerequisite Checks ORACLE 11 DATABASE ATABASE Product Specific Prerequisite Checks Checking Oracle Home path for spaces Automatic 4 Succeeded Checking for Oracle Home incompatibilities Help Installed Products Install Cancel e Check the settings Check if ODP Net is listed between the products to be installed e Execute the installation by choosing Install C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 54 Invantive Composition User Manual Mo wi Oracle Universal Installer Summary Summary Oracle Client 11 1 0 6 0 Global Settings Source O Financeiwin32_11gR1_clienticlientistageiproducts xml Oracle Base c oracle Oracle Home cAoracleiproducti 1 1 0 client 1 OraClient11g home Installation Type Administrator Product Languages Arabic Bengali Brazilian Portuguese Bulgarian Canadian French Catalan Croatian Ome als P M e The progress is displayed C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved B Invantive Webservice
42. e disappearing Employees work at home more often or make use of travel time work time Work processes like the making of financial reports or the start up of a new project take place more and more outside of the office For companies this means that work processes are assigned differently and should be optimized To allow for the work pro cesses to run as efficient and effective as possible it is required to have quick and safe ac cess to the company network through the Internet Webservices make it possible for companies to organize work processes through the Inter net even smarter By providing access to the company network and applications using web services it is possible to coordinate and optimize processes from each location 3 2 Advantages The Invantive Webservice offers various advantages e The Invantive Webservice makes it easy to quickly and safely exchange data through the internet between various databases and services For companies this means that the exe cution of financial calculations and the manufacturing and recording of contracts is availa ble from every location the Invantive Webservice allows different companies to work to gether more effective and more efficient within a project That is because the Invantive Webservice simplifies the exchange of information between different parties within a project The Invantive Webserive makes it possible to give part ners through http s authorized access to applications
43. e of expression F gbr plaats gt lt invantive value of expression S F gbr land gt The next step is the adding of the parameters for the salutation and content information of the serial letter Here you are also dealing with dynamic texts The parameters that you wish to add automatically you place between the continuous text of your document The implementation then looks as follows Subject Recorded leave during the period lt invantive value of expression F periode gt by invantive value of expression F gbr volledige naam gt Appendix es 0 Our Reference lt invantive value of expressi on P p_referentie gt Date Harderwijk lt invantive value of expressi on SF vandaag gt Now that we have added the parameters for the salutation we continue with the remain der of the serial letter The next parameters that we add are part of the core of the serial letter With these parameters you ensure the proper mention of the personal data within the letter By adding the following parameters within the ongoing text you allow Invantive Composition to automatically fill the text Dear lt invantive value of expression F gbr aanhef ge slacht gt lt invantive value of expression SF gbr volledige naam gt For your work activities within lt invantive value of expression F lvr_ C Copyright 2004 2013 Invantive Softw
44. e transaction is immediately recorded at the end of the execution of the statement Menu File Pa Invantive Vision Query programma Bewerken Editor Database Venster Help Ctri o Bestand Open Opslaan Ctri 5 Bewaren Als Ctri amp Shift S Afdrukken Ctrl P Afsluiten Col w Here queries can be opened saved saved under a different name and printed In addition via Exit the Query Tool can be closed Menu Editor C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved P Invantive Query Tool KEN Va Invantive Vision Query programma Bestand Bewerken Editor Database Venster Help i Mii uitvoe Teruadraaien Ctrl Z Opnieuw Ctrl V Krippen Chri4 X Kopi ren Ckrl4 C Plakken Ctrl V Selecteer Alles Ctr A Zoeken Ctrl F Vind Volgende F3 Vervangen Ctrl R Ga naar Regel Ctrl G Commentaar Ctrl B Ontcommentaneren Blok CrrH Shift B Hoofdletters Ctrl U Kleine Letters Ctrl L Eerste Letter Hoofdletter Ctrl I Beschrijven F4 The Editor menu contains all items with which you can edit the query text Menu Editor v Invantive Vision Query programma Bestand Bewerken Editor Database Venster Help E ga Uitvoeren gj Expoi W Uitvoeren F9 Via Run you can run the query The results of the query are displayed in the Query Results tab in Query Output Menu Database Pa Invantive ision Query programma Bestand Bewerken Editor Database Vens
45. ery tool Version 50 0 1 1 Publisher Invantive B V The following prerequisites are required e Windows Installer 3 1 Microsoft NET Framework 4 x86 and x64 If these components are already installed you can launch the application now Otherwise click the button below to install the prerequisites and run the application Click on the button Install to install the Invantive Query Tool on the computer C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 3 Invantive Composition User Manual z Application Install Security Warning Ed e Do you want to install this application Invantive Producer Query tool From Hover over the string below to see the full domain webservice invantive com Publisher Invantive B V Install Don t Install While applications from the Internet can be useful they can potentially harm your computer If you do nottrust the source do not install this software More Information e After installation the following window will be shown In this screen you need to enter the location of the connection file See Connections Settings 43 for an explanation of the con nection file Select OK to save your changes H Invantive Configuration lel E3 Advanced Retrieve settings from Z ofile settings xml m Number of available connections 23 C Copyright 2004 2013 Invantive Software B V the Netherlands All right
46. esults or export them to Adobe PDF Microsoft Excel or Microsoft XPS e Automate processes with assistance from Oracle PL SQL only in combination with Ora cle RDBMS e Retrieve old queries from a file or from the list in the tab History e Connect directly through a native connection for the concerned type database for example Oracle SQL Net for Oracle or connect through the Invantive Webservice so that you do not have to install database specific software on a work location e Supply the database user with a connection or connect to an already installed Invantive product with associated user codes e Retrieve the structure of a table or view e Request the output of dbms output itgen output and itgen log of an Oracle PL SQL block only in combination with Oracle RDBMS e Retrieve an execution plan query plan or explain plan of an Oracle SQL query only in combination with Oracle RDBMS Request the trajectory Oracle Trace of a SQL statement only in combination with Ora cle RDBMS 2 1 Learn SQL More information on what SQL is and how it can be used can be found at http en wikipe dia org wiki SQL The manual at http sqlzoo net also provides a good insight and in addition allows for inter C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 24 Invantive Composition User Manual Mo active learning of how bs can use SQL to retrieve edit and create data
47. etherlands All rights reserved Invantive Webservice EM Attributes ConnectionString the ADO NET connection string for the specified provider You can specify Data Source User Id and other settings provider the name of the ADO NET connection provider For example Oracle DataAccess Client The failover level The failover level can define a list of database or webservice settings It supplements the webservice database element Connection settings defined in a failover can be used to have a failover connection when one connection cannot be established This can be useful when relying on a internet connection or presence of a VPN tunnel Settings defined in this section will be evaluated one after another starting top down When any of the failovers can be established no other failovers will be tried Attributes none Examples This example illustrates a single connection The software will sequentially try Eos Connect to the authenticationServer Active Directory server Connect to one of the connections in the failover First the database connection when connection from the internal network or VPN The first webservice connection The second or failover webservice connection connections default Customer A Production forceDefault false gt lt group name Customer A connection name Production database connectionString Data Source authenticationServer User Id user n
48. figuration Assistant Cancelled Recommended Configuration assistant Oracle Net Configuration Assistant was canceled Installed Products C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved ed Invantive Webservice e Close the error message about the failure of the Oracle Net Configuration Assistant e Select Exit wf Oracle Universal Installer End of Installation Siel E3 X cnc g DATABASE End of Installation The installation of Oracle Client was successful but some configuration assistants failed were cancelled or skipped Help Installed Products Back Next Install Oracle Client Configuration Follow these steps to configure the Oracle client e Construct if not available yet a tnsnames ora configuration file n a tnsnames ora file tns is the abbreviation for Transparant Network Substrate all Oracle based databases services and the route via the network to get there are descri bed e An example of a description of the service 1 dvtiirZ invantive local 82 description 83 address list 84 address protocol tcp host 192 168 172 16 port 1521 85 86 97 connect data 88 sid dvtiir2 59 global name dvtiirZ invantive local 90 i 91 e This one describes that on the server with IP address 192 168 172 16 on port 1521 a pro gram runs that knows how to make a connection with an Oracle database with
49. h invantive value of you can request the value of an expression Several examples of invantive value of e lt invantive value of expression P p pgp code gt delivers the value of the parameter p pgp code C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved EN Invantive Composition User Manual Mo e lt invantive value of expression S F pjt pjt_code gt supplies the cur rent value of the cell in the column pjt code of the SQL statement with label pj t The use of F is only useful it it happens within a lt invantive foreach gt 4 e lt invantive value of expression Hello world supplies the mentioned text e The use of query label is optional if it is not used then the last determined value is used This is comparable with variable scoping in programming languages Layout Parameters The layout of the expression can be influences with the following parameters casing use capitalization Use Casing With casing you can change the capitalization of an expression This can be used to dis play the same fields with capitals in parts of the document and in other places with lower ca se Of course you can also do this by adjusting the SQL query The possible values of casing are e Normal replace nothing to the letters LowerCase replace all letters with the associated smaller case UpperCase replace all letters by the associate
50. items 8 Betrokken Rijen e Displaying the description of an object using the F4 key This corresponds to the Oracle function Describe The figure below shows the data in the business object persons bub S gebruikers v Pa Invantive Estate Beschrijven bubs gebruikers v DE x Kolom Sleep een kolom hierheen om te groeperen op die kolom gbr_nk Xv gbr aanmeld code X v gbr_accordeur_uen vlag X Y gbr_achternaam 5 v gbr administrateur vlag X Y abr Heunen Heunen Heunen Heuvelman Heuvelman Heuvelman Hoef van der Hoef van der Hoef van der Hoekstra Hoekstra Hoekstra Hoof van Hoof van Hoof van Houben Houben Houben Jalkema Jalkema Jalkema Of oo uone CI ro Marcel Janssen Janssen Janssen Jassen Jassen Jassen Jong de Jong de Jong de Jongen Jongen Jongen Ketelaars Ketelaars Ketelaars Klaassen Klaassen Klaassen Kooman Kooman Kooman Koopman Krekelmans Koopman Koopman Krekelmans Krekelmans Kuypers Kuypers Kuypers N N Y N N N Y N N N Y N Y N N N N N Z zZz Z Z Z Z Z Z lt lt z z z z z z lt z Lange de Lange de Lange de C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Ea Invantive Composition User Manual BUA e The result of the SQL query can be exported to Microsoft Excel Adobe PDF Microsoft XPS and can be printed on a printer P Invantive Estate Query programma Pije XI Bestand Bewerken Verbinding Editor Database Ve
51. m There are a limited number of environment variables you can use C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved P Invantive Composition o Group Variable Meaning Example system Date of the work stati 31 12 2013 on displayed in the re gional settings short Time of the work stati on displayed in the re gional settings short Date and time of the 31 12 2013 23 59 work station display ed in the regional set tings short date and time format Login code of the user john doe on the work station document Name of the docu Document1 docx ment Location in the file sy c temp Docu stem of the document ment1 docx including the name of the document Path in the file system c temp of the document ex cluding the name of the document database user Login code of the user u373984 on the database 1 6 3 4 Resource value All Invantive products are multilingual You can therefore request a text with a resource that displays the message in the current language You can also define big text blocks in advan ce with resources and replace them in one single go The value of a resource variable does not change during the processing of a template A re source has the following notation method SR resource Example the value of the resource itgen composition can be requested with SR itgen composition 1 6 4 lt invantive value of gt Wit
52. nd select Add Remove Snap in e Click on Certifcates and click on Add e Select Computer Account and click on Next e Select Local Computer and click on Finish e Select OK Click on Certificates Local Computer in the middle part of the window e Click on the right on Personal e Select All tasks and then Import e Set up the filter for Personal Information Exchange pfx e Select the pfx bestand as Personal Certificate e Enter the password e lf desired you select the check box Mark this key as exportable e Allow automatic placement in the storage for the certificate based on the type e Select Finish Close the MMC e t is not necessary to save the settings of MMC C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved A Invantive Webservice EMI e Start Microsoft IIS through inetmgr Click right on the website usually Default Website e Go to Edit bindings e Add a https binding and choose the Friendly Name of the certificate that you have just imported 3 7 3 Connection Configuration To make a connection with an Invantive application or an application based on Invantive Pro ducer there needs to be a file settings xml with included within the configuration of the con nection settings This has to be an XML file with the same design as the example The file can contain the configuration to connect with one or more servers
53. nnen aaneen nde eenma AE invantive value of eese lt invantive foreach gt lt invantive foreach gt Example series letter esee meg 1t oleo ele m P FED IM Release 2OT4IRG Invantive Query Tool a tlEle Mr FUMCUONING e Query Tool Examples Editor cess Query output Availability System Requirements tine naaen akut uuu Ran n RR RR DAR ERR RRRRRYRRRRPAR deasa aaa 33 l sta llation EEEN 33 Versions ission aia ra aaea re EOE EAEra r aea a aa da E Aaria 35 IRCI CLIMAM aue 35 Invantive Webservice 36 Web Servi S isse e iter i a ee ienkeRilcRik AR Aeara ara Sna aaria Esaa na MARS araa D rprbpIrI System Requirements tiii aa etas tacens aai nu RRRAR NR RRRRAR RES DAR SRRRRIRRR RARE ARS CONGO EEEN Database platforms onere arn sae repo y ux sene Rok DR ARRA E Rua co EwRR REN sen RREGUMGANCO T handen Installation 1 n 1irixei ierra suu suuni u aea innu ance cniin ina OX R ARR ARR SAR SARSIAR RR RR Invantive Webservice Programming Certificate 1 etie tercie Connection Configuration
54. nster Help n Exporteer naar Microsoft Excel 7 Exporteer naar Adobe PDF 4 Exporteer naar Microsoft ma from Afdrukken Join nas reveranc rcr v INI on gbr lvr id lvr lvr id order by lvr lvr naam al 2 3 B 5 6 3 8 9 Resultaten DBMS Uitvoer Uitleggen Plan Spoor Historie Sleep een kolom hierheen om te groeperen op die kolom persoon EY organisatienaam SV functie plaats EV Born van der Food and more Accountmanager Amersfoort Hoef van der Janssen Uitgeversorganisatie Engineer Amersfoort Aeilkema Janssen Llitgeversorganisatie Regiomanager Amersfoort Dom Janssen Llitgeversorganisatie Consultant Exact Amersfoort Breukhoven Mekra Communicatie Amersfoort Brouns Piet Van Den Herck bna Sr Channel Manager General Business Amsterdam Fasen QT Design Account Manager Amersfoort 8 Betrokken Rijen e The image shows the result of the SQL query in Microsoft Excel C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved IF Invantive Query Tool x id Or Wee Personen per organisatie Microsoft Excel El zs Home Insert Page Layout Formulas Data Review View Team a e cs gH X General geImset Le A d rv 3 Dete Gr d Styles 7a Sort amp Find amp 60 0 E Format A gt Filter Select r Clipboard 5 Font Alignment Number z Cells Editing Al id f organisatienaam Food and more 1 item g 1 2 i B C
55. ntract 22 D Data 37 Database combine 1 Database platform 38 Dbms export 31 Delete 28 Document management 4 Document Management System A Environment value 12 Error 404 39 405 39 Exchange 36 Explanation of the plan 31 Expression 12 13 SB Failover 38 File format 30 H Harderwijk 61 Help 10 http 37 https 37 IBM DB2 60 IBM DB2 for Windows 38 InitCaps 13 Insert 28 Installation 39 Invantive Composition 3 oracle client 49 tunneling web service 39 Instruction 12 Invantive Composition 1 4 e Invantive Composition User Manual Invantive Composition 1 connect automatically 6 connection 6 help 10 installation 3 password 6 preferences 7 store password 6 system requirement 3 username 6 Invantive Query Tool 23 Invantive Webservice 36 system requirement 36 2L Label 12 Leave hour 15 Letter 15 Link 36 LowerCase 13 Microsoft net framework 4 5 39 Microsoft iis 39 Microsoft SQL Server 38 60 Microsoft Word 1 Modeller 11 MySQL 38 MySQL Connector Net 60 N NIs lang 57 Normal 13 0 Optimization documentation process 2 Oracle 38 client 49 57 explain plan 31 trace 32 Output 30 ipis Parameter value 12 Processing in order 31 Provider 38 Providers 46 Publish 5 Ox Query execution time 30 result 30 row 30 Query Tool editor section 24 history of executed queryies 32 output section 24 Query Tool examples 24 Querylabel 13 a R
56. oleren Beeld Invantive Composition Modeller te Invantive sample 1 E us 9 Y k w o Guido Leenders Invantive So Open Template Publish Parameter Guido Leenders Preferences Help from DMS Values Invantive Production 7 Document Management Publishing Model Information Connection Help EE 07 7 JNEERVEERZEEEINERIEERINETIEERINETINEKINEYIEEPFIUNEFUNEIIEEFINEZIEER 50000 1 5 1 Document Management Open Sjabloon vanuit DMS Document Management The group Document Management includes a Open Template from within DMS This al C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved rA Invantive Composition 5 lows you to open a pop up to open documents from within DMS in Invantive Compisition You can of course also open documents in your file system The advantage of a central DMS is that everyone always has the correct versions independent of whether the user has access to the disks on his work In this screen you will see template documents dependent on your rights Select the desired template S Open template from DMS Invantive Composition m x Status Ev VeriZv Origin Type Sjabloon 9 items 1 42 KB DOOOX Standaard Onderhoudsovereenkomst 48 KB tXXXXX Standaard Borgstelling voor XXX v10 303 KB OOOK Standaard Definitieve Offerte voor XX 45 KB DOOOX Standaard Financiering voor XXX v10 42 KB DOOOK Standaard Licentie voor XXX v10 do
57. ow ing disclaimer 2 Redistributions in binary form must reproduce the above copyrightnotice this list of conditions and the follow ing disclaimer in the cumentationand or other materials provided w ith the distribution 3 The end user documentation included w ith the redistribution if any must include the follow ing acknow ledgment This product includes softw are developed by Teodor Danciu http jasperreports sourceforge net Alternately this acknow ledgment may appear in the softw are itself if and w herever such third party acknow ledgments normally appear 4 The name JasperReports must not be used to endorse or promote products derived from this softw are w ithout prior written permission Forw ritten permission please contact teodord users sourceforge net 5 Products derived fromthis softw are may not be called JasperReports nor may JasperReports appear in their name w ithout prior w rittenpermission of Teodor Danciu THIS SOFTWARE IS PROVIDED AS IS AND ANY EXPRESSED OR IMPLIED WARRANTIES INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED IN NO EVENT SHALLTHE APACHE SOFTWARE FOUNDATION OR ITS CONTRIBUTORS BELIABLE FOR ANY DIRECT INDIRECT INCIDENTAL SPECIAL EXEMPLARY OR CONSEQUENTIAL DAMAGES INCLUDING BUT NOT LIMITED TO PROCUREMENT OF SUBSTITUTE GOODS OR SERV ICES LOSS OF USE DATA OR PROFITS OR BUSINESS INTERRUPTION HOWEVER CAUSED ANDON
58. r 1 6 7 For example contract The following example shows you how to compile a contract on the basis of data from a pro cess Notice that the document that is filled with data from the database can still be edited after wards This way Invantive Composition offers totally different possibilities compared to the standard reporting help resources 1 7 Versions This chapter describes the changes in the application per version 1 7 1 Release 2014 R1 Released XX XX 2014 Invantive Producer bXX C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Composition 2145 PR Composition Invantive Composition niet meer bruikbaar doordat Connect knop ook beveiligd is bij eerste keer 2 gebruiken Installation e No specialties Implementation e No specialties 2 Invantive Query Tool With the Invantive Query Tool working with your data via SQL becomes easy Invantive Pro ducer makes it possible to edit a real time data warehouse using SQL Maintaining integrity and maintaining information security according to ISO 27002 The Invantive Query Tool is an addition to Invantive Producer and derived products such as products iv products ie Invantive Control and Invantive Composition With the Invantive Query Tool you can e Execute SQL queries and request the results in a table e Immediately group filter and sort the results in the table on the screen e Print the r
59. r F iz e To request the leave per employee replace the in Value for the name of the employ ee Do you want a reference Fill these in as well then Subsequently click on ok to pu blish the model C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved P Invantive Composition KEN C Enter parameter values Invantive Composition e Invantive Composition now asks you under which name and on which disc you want to save the document Choose a name and drive and save the document e Now open the document with the requested leave hours Your document will look as fol lows C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved E Invantive Composition User Manual Mo Guido Leenders Stephensonstrtaat 3b 3846 AK Harderwijk Betreft Opgenomen verlofuren in de periode 24 1 2 201 2 24 06 201 3 door Guido Leenders Bijlage n 0 Onze Referentie geen Datum Harderwijk 24 06 20 3 Geachte heer Guido Leenders Voor uw werkzaamheden binnen Invantive BY bouwt u het recht op verlofop Asu verlofopneemt dan komt dit ten laste van de opgebouwde verlofuren Met deze brief geven wij u een overzicht van de opgenomen verlofuren in de afgelopen zes maanden 18 02 20 3 8 00 uur 19 02 20 3 8 00 uur 20 02 20 3 8 00 uur 21 02 20 3 8 00 uur 06 05 20 3 8 00 uur 07 05 20 3 8 00 uur 08 05 20 3 8 00 uur Met vriendelijke groeten Guido Leenders rect eu
60. r baas naam gt invantive value of expression S F gbr baas functie gt Now that all parameters have been added we close the document with the following line lt invantive foreach gt The template for the requesting of the leave hours is now finished and looks as follows gas BES sw ZZ inv ntive ERA 4 dada C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 20 Invantive Composition User Manual A e Now save the template For this example will save the template as voorbeeld verlofu ren seriebrief in Word e Now the model is saved Invantive Composition will allow you to publish this with a single Click By publishing the template Invantive Composition will retrieve the data from your da tabase and the parameters will automatically be filled e To requestthe leave hours of an employee you will proceed as follows e Click on Publish and let Invantive Composition use the template to fetch the recorded leave e Now you see a window appear with parameters Y ou will see here the parameters na me employee and reference letter This is currently on the setting wildcard which means that Invantice Composition does not add reference this is different per letter and re quests all leave hours of the employees E Enter parameter values Invantive Composition Description Value Naam medewerker gebruik als wildcard FW ESES
61. r of the provider The higher the value the sooner it is called file The file name of the provider This can be a path relative to the Pro viders directory or an absolute path Fully specify the path or use a path relative to the Invantive Webservice in stallation folder Do not use the ASP NET IIS prefix to indicate the current folder Class Optional Full class name of the provider You can specify the class name to increase startup performance since it reduces the time needed querying the file You need to specify the class if you want to load a single provider in a file that contains multiple providers The elements of the provider tag All you can specify elements within the provider tag See for instance the lt templatesfolder gt element in the example below Their names and values will be passed as attributes to the provider during in stantiation Example lt providers gt lt provider order 998 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved EN Invantive Composition User Manual o file C ws distribute invantive sdk Invantive XXX Provider dll class Invantive XXX Provider Provider gt lt templatesfolder gt C temp templates lt templatesfolder gt lt serviceurl gt http localhost ThisIsAnExmaple Service svc lt serviceurl gt lt provider gt lt providers gt gt lt providers gt lt Custom logging gt SF lt provider o
62. rd vsto Downloading customization files 40 56 of 139 37 MB When the installation is finished the screen below is displayed Microsoft Office Customization Installer The Microsoft Office customization was successfully installed Name Invantive Composition for Word From _ file Z prd invantive compositionfor word Invantive Producer Composition Word vsto Then you start Microsoft Word or Microsoft PowerPoint to use Invantive Composition Af ter launching the Office program this screen is displayed In this screen you need to enter the location of the connection file See Connection configuration 43 for the explanation of the connection file Then click on OK to save the change C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 4 Invantive Composition User Manual B I Configuration Invantive Composition lel x General Advanced Development mode lv Retrieve settings from o mu Number of available connections 19 Z pfile settings xml Available Bandwidth MB s 0 Calculate 1 5 Usage This paragraph displays an explanation the tab Invantive Composition in the ribbon in Micro soft Word and PowerPoint The model user can open documents set values to parameters and compose a document The following image displays the tab Invantive Composition r wi id 2 801 Documenti Microsoft Word Start Invoegen Pagina indeling Verwijzingen Verzendlijsten Contr
63. rder 999 file C ws distribute invantive sdk Invantive Data Providers Logging dll class Invantive Data LoggingProvider gt lt log gt C temp invantive logging log lt log gt lt provider gt gt lt Most preferred provider due to order 400 Data access provider for Invantive Estate and or Invantive Vision Generates an Oracle SQL execute request Invantive Estate and Invantive Vision currently only support the Oracle RDBMS gt T Xprovider order 400 file Invantive Estate Data Provider dll class Invantive Estate Data InvantiveEstateDataProvider gt gt lt Less preferred provider due to order 300 Data access provider for Invantive Producer products The following Invantive Producer products require the use of Oracle RDBMS Invantive Studio Invantive Query Tool The following Invantive Producer products run with all supported database platforms although this specific provider does not yet support it Use a database specific provider instead Invantive Composition Invantive Control gt Sez lt provider order 300 file Invantive Producer Data Provider dll class Invantive Producer Data InvantiveProducerDataProvider F gt lt providers gt 3 7 5 Providers The Invantive Webservice can make use of various providers that record and retrieve data but also offer other services Here are the standard available providers 3 7 5 1 Oracle Provider for Invantive
64. re used by Invantive products This file contains a number of structured elements explained further on Top level the connection groups This is the root level of the settings file It only contains connections groups C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved E Invantive Composition User Manual o Attributes default The default connection The format is group connection the first connection with the given name will be used when the group element is omitted forceDefault If true only the default connection can be used No other connection is eligible for selection based upon this settings xml file You can use for in stance when you add a new default connection and you want to make sure everyone switches to the new connection irrespective of what connection is currently used as default The group level This level defines a set of connections logically grouped together You are free to choose the way of grouping Examples of logical manner of grouping by customer by environment production test Attributes name The name of the group The connection level This level defines an actual logical connection For example Production environment Acme site Under this level the actual transport mechanism and its settings can be defi ned The connection and associated failovers are tried when initially establishing the connection and when reconnecting
65. rror op bij gebruik van de webservice Installation e No specialties Implementation e No specialties 4 Contact Information Invantive Software BV Location Harderwijk Stephensonstraat 3b 3846 AK Harderwijk the Netherlands Phone 31 88 0026500 Fax 31 84 2258178 E mail info invantive com C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 62 Invantive Composition User Manual Tum Web www invantive com Route Follow the instructions of your navigation system The offices are located above Carglass Parking spots are on the right side Parking spots are indicated with a sign with Invantive C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Index E T E database user 12 E document location 12 E document name 12 E document path 12 E groep naam 12 E system date 12 E system datetime 12 E system time 12 E system user 12 P name 12 R resource 13 V label name 12 V name 12 NET 60 lt invantive foreach gt 12 lt invantive foreach gt 12 14 lt invantive value of gt 12 13 4 404 39 405 39 A Advantages 2 C Casing 13 Certificate 42 Channel 37 61 Company network 36 Connection 61 Connection Configuration Invantive Producer 43 Contact Information C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Software BV 61 Co
66. s e Install Microsoft IIS 7 or 8 including ASP NET support e Install Microsoft NET Framework version 4 5 or newer In the Control Panel among the installed programs there will then be listed Microsoft NET Framework 4 5 Copy invantive webservice in the distribution to the folder that is known within Microsoft IIS preferably webservice within the folder of the application or alternatively c inetpub wwwroot invantive webservice c inetpub wwwroot lt OMGEVING gt ws or preferably ENVIRONMENTDIR webservice Adjust settings xml in this folder as described in settings xml sample C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 40 Invantive Composition User Manual Tum e Start Microsoft IIS with inetmgr or through Control Panel e Select Properties from the folder e Convert the folder to application with an own application pool Site name Default Web Site Path Alias Application pool MEE Perata set Example sales Physical path Ci inetpub wwwroot qbubs ws eti Pass through authentication Connect as Test Settings e Set the application in for use of the application pool ASP NET v4 0 Edit Application Pool 21 x NET Framework version NET Framework v4 0 30319 m Managed pipeline mode Integrated m IV Start application pool immediately cm e Set the standard page Service ashx C Copyright 2004 2013 Invantive
67. s reserved AN 2 Invantive Query Tool ow Next comes the login screen Next enter the username password and connection and se lect OK C Copyright 2004 2011 Invantive Software BV the Netherlands All rights Gebruikersnaam system ss SSOSCSCSCS Wachtwoord pess Verbinding Jinvantive Production LAN of htt f Bewaar wachtwoord Vv Automatisch verbinden o Amten e n order to change the settings of Invantive Query Tool after installation press Crtl when starting up Invantive Query Tool 2 6 Versions This chapter describes the changes in the application per version 2 6 1 Release 2014 R1 Released XX XX 2014 Invantive Producer bXX Changes and bug fixes Invantive Qu dbms output en explain plan in Query Tool ery Tool 2171 PR Invantive Qu Describe werkt niet in Query Tool ondanks rechten op de functie itgen querytool describe 8 ery Tool 1994 B Invantive Qu E meest recente documenten stuk of 10 tonen in Bestandsmenu C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 39 Invantive Composition User Manual e B ery Tool Installation No specialties Implementation No specialties 3 Invantive Webservice This chapter describes the possibilities of the Invantive Webservice 3 1 Web services Because of the technological changes and the mobility of employees more and more traditi onal work spaces ar
68. ter tal Uitvoeren gd Exporteren SQL gebied Sessies Databasesessies Help C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved EN Invantive Composition User Manual Mo This menu consists of three specific database menu items SQL area This menu item places the following query in the editor select from itgen db sglarea r where 1 71 order by elapsed time desc Sessions Database session Menu Help Va Invantive Vision Query programma Bestand Bewerken Editor Database Venster Help Ma Uitvoeren gd Exporteren Inhoud _ Shift F1 1 Using this menu the Help for the Query Tool can be requested as part of the Invantive Vision Help Export Menu Pa Invantive Vision Query programma Bestand Bewerken Editor Database Venster Help i Uitvoeren l Exporteren Exporteer naar Microsoft Excel Exporteer naar Adobe PDF Exporteer naar Microsoft XPS Afdrukken be pre Using the Export tab you can print the output of queries or export it to different formats 2 2 3 Query output The query output can be started with the function key F9 If the editor contains a valid query this will lead to output in different tabs under the tab Out put 2 2 3 1 Query results Executing a query results in filling the tab Output with the records delivered by the query C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved A Invantive Query
69. tion based on Invantive technology e The application will know automatically or hear from the user which connection is to be used with which user name and password e The connection are is retrieved in a list with available connections and the related possible redundant channels e On the basis of the retrieved preferences and availability a channel is chosen for commu nication e Through this channel a connection is established with the service provided by the webser vice C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved EN Invantive Composition User Manual P e Data and requests are exchanged If the connection drops then the connection is automatically established again A possible al ternative channel for the connection is used if the desired channel is not available 3 5 Database platforms An installation of the Invantive Webservice consists of one or multiple installations of the In vantive Webservice programming In addition to the programming you also need to indicate the connections to databases that can be used through this installation These can at least be the following database platforms Microsoft SQL Server Oracle RDBMS MySQL e IBM DB2 UDB Linux Unix Windows The actual choice of the database platform depends on which application you will be using Some company applications only work on a portion of the database platforms The support of extra database
70. tion will be execu ted as default value or specified as attributes with the provider s configuration Default providers The default providers are always available A list of the default providers and there order which cannot be used again Order Name Comments 70 Oracle MySQL Provider supporting the execution of actions on Oracle MySQL Built and tested with Connector Net 6 7 4 See http dev mysql com doc refman 5 6 en connector net html File Invantive Data Providers MySql dll 80 Microsoft SQL Server Provider supporting the execution of actions onMicrosoft SQL server 7 0 and later See http msdn microsoft com en us library kb9s9ks0 aspx File Invantive Data Providers SqlServer dll 90 IBM DB2 UDB Provider supporting the execution of actions onIBM DB2 UDB 9 7 for Windows Not tested on any other version File Invantive Data Providers IbmDb2 dll 100 Oracle RDBMS Provider supporting the execution of actions onOracle RDBMS 9i 12c Needs ODP NET and OCI to be installed File Invantive Data Providers Oracle dll 200 Invantive Webservice Provider that is executing action by forwarding it to another Invantive Webservice over HTTP HTTPS File Invantive Data Providers Webservice dll Order 200 ensures that forwaring is preferred instead of a database connection by default The providers tag contains a list of providers available each one consisting of the provider tag Attributes of the provider tag order Sorting orde
71. trokkenRgen SV Startuitvoerng Ev SQL tekst 28 911 s 5 704 172 2011 13 48 select from bubs taken v 15 551 s 6 617 172 2011 13 47 select from bubs_leveranciers_y 385 ms 1722011 13 47 select from bubs_units_v 3 301 s 172201 1345 select from bubs projecten v 5 704 Betrokken Rijen As long as the Query Tool is open a record is added after each output 2 3 Availability The following Invantive products provide a user license of Invantive Query Tool e products iv products ola C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Baa Invantive Query Tool EN e nvantive Control nvantive Composition The Invantive Query Tool is also separately available and can be downloaded via the link http webservice invantive com qt publish htm 2 4 System Requirements To use Invantive Query Tool on your PC or terminal server you will need the following soft ware including licenses Microsoft NET 4 5 Minimum 2 GB of internal memory e Screen resolution of 1280 x 1024 or higher e Invantive Webservice or local drivers Use on Mac tablet or smartphone is not possible 2 5 Installation Perform the next steps to install Invantive Query Tool e Use an Internet browser to go to the link http webservice invantive com qt publish htm Then click Install next save the file and execute it Invantive B V Invantive Producer Query tool Name Invantive Producer Qu
72. werPoint document with pre filled da ta from the database Develop model and template Combine template with data from the database into a prefilled document NM Customize document to your own taste 1 2 Advantages The automation of your information supply chain with Invantive Composition will bring you ad vantages such as Optimization of the documenting and communication process Automatically fill precomposed templates in Word Focus on your business operations not on the technology without programming and without software developers Lower time to market for the editing of your business operations by decreasing the effort of your IT department Add unstructured texts in a document together with structured data Open documents from Word that were stored in a database document manage ment system or the file system Internal search engine to search documents on their classification Reduction of erroneously prepared documents and production costs Improved security of company information With Invantive Composition you will have a complete solution for the automatic generation of complex documents in Microsoft Word Invantive Composition easily allows you to automati cally retrieve and edit unstructured data from a database or application By automatically fil ling precomposed templates with data you will easily compose complex documents that meet the laws and regulations This way Invantive Composition optimizes
73. xporteren Select from bubs gesprekken where id 68 Resultaten DBMS Uitvoer Uitleggen Plan Spoor Historie E Id 0 Parent 1 Depth 0 Operation SELECT STATEMENT ALL_ROWS Cost 1 CPU Cost 9241 10 Cost 1 Cardinality 1 Bytes 509 E Idi Parent Depth 1 Operation TABLE ACCESS BY INDEX ROWID TABLE USR_JDZ_BUBS BUBS_GESPREKKEN gt ANALYZED Cost 1 CPU Cost 9241 10 Cost 1 Cardinality 1 Bytes 509 Id 2 Parent 1 Depth 2 Operation Index UNIQUE SCAN INDEX UNIQUE USR_JDZ BUBS BUBS_GSK_PK gt ANALYZED Cost 0 CPU Cost 1050 10 Cost 0 Cardinality 1 Bytes 0 44 Betrokken Rijen In the tab the way the query will be executed by Oracle is shown in tree form With this the to be executed actions are in order of the ID so from a branch with the deepest level back to the parent level and back to a related level this is called Processing in Order 2 2 3 4 Trace This tab contains the result of an Oracle trace only in combination with Oracle RDBMS 2 2 3 5 History executed queries Executing a query ensures the filling of the tab history because the data of the last executed query is added Va Invantive Vision Query programma Fei fan Ea Bestand Bewerken Editor Database Venster Help it Uitvoeren ed Exporteren 1 select from bubs taken v Resultaten DBMS Uitvoer Uitleggen Plan Spoor Historie Bleep een kolom hierheen om te groeperen op die kolom Uitvoeringstid EV Be

Download Pdf Manuals

Related Search

Related Contents

mardi 22 - La maison de l`image  Epson 3D Glasses (RF) - ELPGS03    Amer Networks SS3GR50I-C1 networking cable  Universal WiFi Range Extender WN3000RP Installation  UPSilon for Unix - User`s Manual  Samsung RE-C400 User Manual  

Copyright © All rights reserved. Failed to retrieve file