Home

Invantive Control User Manual

1. Position This indicates the position of the column in the block in Excel List Source The list which includes the pick list for the list List code DB Value field List Descrip Label tion This window shows the columns of the business object In this window it is possible specify how the block will be displayed C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved B Invantive Control 25 E Invantive Producer Modelbewerker File Help ld Opslaan _ Toevoegen Blok X Verwijder Blok 2 71 Model Algemeen Feiten Velden Weergave PF organisatienaam Opmaak bereik layout lA1 A4 Ato nan ba Label Enkelvoud Organisatie EAN Personen Label Meervoud Organisaties EK Openstaande Wijziging Gekoppeld The meaning of the entry fields is Style range Specify the range of the style sheet the formatting of these cells are applied to the block The convention of the range is worksheet cellrange for example layout A1 A4 Label singu Provide a name in singular for the layout lar Label Plural Provide a name in plural for the label Start position e Absolute e Linked Beperk Border width C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 26 Invantive Control User Manual hie Extensions A n extensions is an embedded script in the execution flow of the Model An extension e
2. e Click on the tab Invantive Control in the banner then click on the button ki Connect to make a connection to the server Enter user name password and connection then click OK see Connection 12 for detailed explanation C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved E Invantive Control i K Invantive Producer C Copyright 2004 2070 Irwantwe Software BY the Netherlands All rights reserved Gebruikersnaam Wachtwoord 6666666606064640 4 Werbinding Development pse el Bewaar wachtwoord le Automatisch verbinder R UK Annuleren 1 2 3 User Interface Model User This paragraph gives an explanation of the tab Invantive Control in the banner in Microsoft Excel The model user can enter and delete data and set parameter values The tab Invanti ve Control The following image shows that the tab Invantive Control is split into the groups Document Management Synchronizing Publishing Model Information Block Actions Field Actions Connection and Help Following each button there is an explanation Zl id d LL AJL Organisaties 2012 xlsx Microsoft Excel o Sl amp file Home Insert Page Layout Formulas Data Reviews View Developer Invantive Control Modeller QE 2 E en E C Projecten 1 F zE ER lt T t Pieter Schouten Invantive 50 Open Sjabloon Sync Openstaande Publiceer Parameterwaarden Toevoegen Verwijder Kies een System User
3. f OX ORACLE 148 DATABASE Install Location Specify a base location for est all lace SEN and commu ral On related files This location is the Oracle Base directory Cre ne Oracle Bas ach oper system t By Saui potus re and configuration files are in d OraClienti 1g_homet gt cloraclelproduct 1 1 0elient 1 Installed Products C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved ECI Invantive Control User Manual ie e Subsequently a number of checks will be performed If problems are found solve them first 4 Oracle Universal Installer Product Specific Prerequisite Checks ORACLE 11 g DATABASE Product Specific Prerequisite Checks The USL Ee T G environment meets all of the vibe MERE for heal and Checking Oracle Home path for spaces Automatic M Succeeded Checking for Oracle Home incompatibilities Automatic Ej Installed Products e Check the settings e 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 we Invantive Webservice mn Oracle Universal Installer Summary Ed ORACLE 1 1 Z DATABASE Summary Oracle Client 11 1 0 6 0 Global Settings Source QF inancelwins 11gR1_clienticlientistagelproducts xml Oracle Base coracle Oracle Home cloraclelproduct 1 1 0icli
4. 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 oa Invantive Control User Manual E Pa Invantive ision Query programma Bestand Bewerken Editor Database Wenster Help Jie Uitvoeren gd Exporteren 1 select from hubs taken tak_nk ir cari a a tt ME 10 8 2007 8 20 29 1157 j 15 6 2009 1827 18 1158 7 8 2007 15 42 53 1160 4 10 2007 14 23 50 6 704 Betrokken Rijen 128 910 gt 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 Editor Uitvoeren aj Expor W Uitvoeren F9 1 Select Uitleggen Plan Ctri E Z T EO hubs telefoon contacten r E where wda ret sleutel S Database Wenster Help 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 Jr Invantive Query Tool B l 7 Invantive Estate Query p
5. 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 results 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
6. Fi gt 7 A EL 6 Blok Organisaties Eee o yi T Broncode Organisaties bubs_teveranciers_v Bewerk Valideer Installeer Bijwerken Verwijder Repository Toon Markeer Rij 1 Query programma T Model Model Database Database Database Sta bewerken toe Ja loaz lvr_naam Werkbladen spoor als Nieuw Madel Tools Blokinformatie Rij informatie Foutopsporing en Analyse The tab Modeller is divided into the groups Synchronize Publish Model Information Blok Actions Connections and Help This tab is only visible if the development mode is enabled in Settings 13 Model 90291 Bewerk Valideer Installeer Bijwerken Verwijder Model Model Database Database Database Model The group Model contains the following buttons e k Design Mode Enables or disables the design mode of the worksheet The model can C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 18 Invantive Control User Manual E be changed in the design mode When enabling the program will ask for a password if set A Edit Model change the model of this workbook The screen shows the parameters blocks extensions and pending changes See Model Editor 19 Validate Model validates the designed model If validation fails an error message will be shown 4 Install Database installs the model database in this worksbook e 4 Database Upgr
7. VAT NL820681 131 BOI C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved RSIN 820681131 20132 0 13305 7301 11 1 2013 7 20 PM Managing Director Guido Leenders Registered office Hierden
8. the Netherlands All rights reserved B Invantive Control a Da X d 9 1 CRM Excel W0 1 xlsx Microsoft Excel een wat ee i Home Insert Page Layout Formulas Data Review View Add Ins Invantive Producer Modeller Acrobat Team 9 Ed le Blok Organisaties ABE Ow A c Z Status Rand Broncode Organisaties bubs_leveranciers_v Bewerk Valideer Installeer Bijwerken Verwijder Quen programma Model Model Database Database Database Model Al N Invantive Producer Toon Markeer Rij ni spoor als Nieuw Rij informatie Foutopsporing en Analyse Sta bewerken toe Ja Tools Blokinformatie Invantive Producer C Copyright 2004 2010 Invantive Software BV the Netherlands All rights reserved Repository version Reporting model 2 lt xml versian 1 0 gt lt RepositoryDatabase xmins xsi http www w3 org 2001 XMLSchema instance xmins xsd http www w3 org 2001 XMLSchema gt lt models gt model lt mdl_id gt 1 lt mdl_id gt lt mdl_code gt x lt mdl_code gt lt mdl_name gt CRM lt mdl_name gt lt mdl_version 0 2 lt mdl_version gt lt mdl_description This is atest model lt mdl_description lt mdl_copyright gt 2004 2010 Invantive Software B lt mdl_copyright lt mdl_comment gt Demonstrates use of the Invantive Producer Excel Add in lt mdl_comment gt lt mdl_company Invantive Software BM lt mdl_company lt mdl_author Pieter Schouten mdl_author lt mdl_passwor
9. Spoor Historie Sleep een kolori hierheen om te groeperen op die kolom Uitwoeringstgd ET Betrokken Rien Ev Start uitvoenng Ev SQOL tekst 28 911 s 6 704 172 2001 15 48 select from bubs_taken_y 15 551 lt 6 617 17 2 2011 13 47 select from bubz leveranciers v 309 ms 17 2 2011 13 47 select from bubs_units_v 3 301 gt 12 2 2017 1245 select from bubs projecten v 6 704 Betrokken Rijen 78 910 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 r N e M Invantive Control User Manual e Invantive Control i e Invantive 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 e Microsoft NET 4 5 e 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 Th
10. eJ eJ 9 9 SSS EZ Lange de C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Jr Invantive Query Tool e The result of the SQL query can be exported to Microsoft Excel Adobe PDF Microsoft XPS and can be printed on a printer Pa Invantive Estate Query programma OO Ea Bestand Bewerken verbinding Editor Database Venster Help gt RZ Uitvoeren la Exporteren gbr lvr id 7 lvr lvr_id lwr 1lyvr naam persoon K organisatienaam T functie plaats Born van der Food and more Accountmanager Amersfoort Hoet van der Janssen Witgewerzorganizatie Engineer Amersfoort Aeilkema Janssen Uitgeversorganisatie Regiomanager Amersfoort Dorr Janssen Uitgeversorganisatie Consultant Exact Amersfoort Breukhoven Mekra Communicatie Amersfoort Brouns Piet Wan Den Herck bra Sr Channel Manager General Business UT Design Account Manager Amersfoort 8 Betrokken Rijen 39 ms 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 Invantive Control User Manual Je at al RI lt mM 3 Personen per ofganisatie Microsoft Excel co l Ss Home Insert Page Layout Formulas Data Rewiew Yie Team A 2 G fe T i Microsoft San B General e Ay a Insert K P 5 i ar Biru jAe ES Sw Sh Styles af Peete wl sake kp J R aa Ar IE E Per io C d EE Format A Filter Select Clipboard a F
11. 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 gt a C 2004 2013 Invantive BV the Netherlands www invantive com Header http svn invantive com repos p104 trunk help nl manual Topics verbin dingsconfiguratie xml 23549 2013 11 01 14 21 27Z smoke 2 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 are 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 con
12. 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 60 Invantive Control User Manual ie lation are therefore not guaranteed Oracle Client Installation The installation of the Oracle client can be done following the next steps e Navigate to the folder containing the setup program for example client Bestand Bewerken Beeld Favorieten Extra Help Wari Ea S Vorige id K E Zoeken TE Mappen Adres O Finance win32_11aR1_dient dient Al Naam Type Gewijzigd op Bestands en maptaken doc Bestandsmap 5 3 2009 10 49 install Bestandsm 5 3 2009 10 49 mij Dit bestand een andere naam Lins estandsmap geven response Bestandsmap 5 3 2009 10 49 ay Dit bestand verplaatsen stage Bestandsmap 5 3 2009 10 51 TN Dit bestand kopi ren 32kB Toepassing 12 2 2009 13 21 setup Configuratienstellingen 12 2 2009 13 21 Dit bestand op het web BE welcome HTML Document 12 2 2009 13 21 publiceren EJ Dit bestand per e mail verzenden XC Dit bestand verwijderen Andere locaties 3 Wn32_ 1198 1 dient IS Mijn documenten Sd Deze computer RJ Mijn netwerklocaties e The Oracle installation program appears C Copyright 2004 2013 Invantive Software B V
13. on the Windows computer by performing the following steps e Run the installation file setup exe then click on the Install button The file is located in the folder of Invantive Control This installation directory is supplied by Invantive Microsoft Office Customization Installer Publisher has been verified Are vou sure vou want to install this customization Mame Invantive Control From File NE fordfinvantive coantrolInvantive Producer Control ysto Publisher Invantive B W harm our computer IF you do not trust the source do not install this software More Information Install Don t Install e When the installation is finished the screen below is displayed D While Office customizations From the Internet can be useful they can potentially Microsoft Office Customization Installer The Microsoft Office customization was successfully installed Td Mame Invantive Control l From _Fle ijZ iprd invantive_cantralfinwantive ProducersControl vsto e Next start Microsoft Excel to uselnvantive Control After starting Excel this window will be displayed In this screen you need to enter the location of the connection file See Connec tion Configuration 54 for an explanation of the connection file Next click OK to save the C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved p Invantive Control User Manual E changes pal Invantive Producer Configuratie
14. or explain plan of an Oracle SQL query only in combination with Oracle RDBMS e 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 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved We Invantive Query Tool 5 The manual at http sqlzoo net also provides a good insight and in addition allows for inter active learning of how you can use SQL to retrieve edit and create data el En D SOL Azure Backup Back tg a database bos SQL Arme to SOL Server Free wel vm ae 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 36 Invantive Control User Manual Ye Pa Invantive Estate Query programma iel E Bestand Bewerken Verbinding Editor Database Venster Help gt Uitvoeren la Exporteren select ghr ghr naam person ghr gbr functie functie Ivr lvr naam organisat ienaatm lyr ilvr plaats plaa
15. w hen checked Control gt Edit it is possible to edit data and subsequently synchronize w ith the know ledgebase w hen checked gt Delete it is possible to delete data and subsequently synchronize w ith the know ledgebase w hen checked Comments Give a description of the block Orientation and size e Columns e Rows In this window you can enter the source material of the block C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved E Invantive Control 99 _naam gbr_cp_naam lvr_werk_tel lvr_adres_regel_1 lvr_postcode lvr_plaats lvr_klant_vlag lvr_opdrachtnemer_vlag lvr_project_entiteit_vlag lt 2500 and Ivr_naam LIKE P organisatienaam The meaning of the entry fields is Business Ob The name of the business object as registered in the know ledgebase This is often the name a database ject view Primary key The column used as the primary key for the business object Optional w hen this block is read only Transaction The transaction column of the business object This field is optional if the access controls add edit and dele column te are turned off Download The download sequence of the company object this can be one or more numbers and or letters It provides Order the dow nload order of the blocks to the database An example is that A001 comes before B001 Upload Order Gives the upload sequence the business object this can be a combination of one or more numb
16. 13 Invantive BV the Netherlands www invantive com Header http svn invantive com repos p104 trunk help nl manual Topics bubs Providers Comtiguratie 2ml 23549 20I3 11 0L 14321 272 smoke s 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 lt providers gt 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 se Invantive Control User Manual k But specific providers may contain the location WHERE the action will be execu ted as default value or specified as attributes with the provider s configuration Default providers The defaul
17. 13 Invantive Software B V the Netherlands All rights reserved de Invantive Control oa double click to edit ee Select elements to publish to a new Excel workbook O All KM Values K Formats L Comments O Validation L Document Properties O Formulas 1 2 3 4 Parameter Values The button Parameter Values show the parameters that have been configured in the Mo del Editorl 191 The current value can be edited to show another part of the data in the model The image shows all of the organizations beginning with the letter A Invantive Producer Bewerk Parameters Code Omschrijving nent k S UK Annuleren be 1 2 3 5 Choose a Value C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 19 Invantive Control User Manual Je Kies een waarde Invantive Control A Code Omschrijving A 100 Four Arcadis UK Annuleren E 1 2 3 6 Connection The image shows the window where the connection to the database is specified I Invantive Producer IC Copyright 2004 2010 Inwantwe Software B the Netherlands All rights leserved Gebruikersnaam Wachtwoord 6666666606064640 4 Verbinding Development pse sl Bewaar wachtwoord m Automatisch verbinder E UK Annuleren The meaning of the entry fields is C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Ny Invantive Co
18. 3 Invantive Query Tool 34 Invantive Webservice 47 system requirement 47 Microsoft net framework 4 5 50 Microsoft iis 50 Microsoft SQL Server 49 71 Model developer 17 Model User 7 MySQL 49 MySQL Connector Net 71 NIS lang 68 Oracle 49 client 60 68 explain plan 42 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Control User Manual Oracle 49 trace 43 Output 41 B Parameter value 11 Processing in order 42 Provider 49 Providers 57 Q Query execution time 41 result 41 row 41 Query Tool editor section 35 history of executed queryies output section 35 Query Tool examples 35 R Redundance 49 Register 68 Route 72 Routing 49 ot Scope of Invantive Control calculation model 3 management 3 working offline 3 Security model 48 Select 39 Service svc 50 Settings xml 54 SQL 34 T Ins admin 68 Tnsnames ora 68 Insping 68 Update 39 Web Service 4 7 48 tunneling 50 Work process 47 43 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved aE eee Invantive Software B V P Sane eS o E 4 K S S Stephensonstraat 3b Wet a Sn EN mo a A 3846 AK Harderwijk on RE a ed C E 24 the Netherlands nr At 7 a ee Tel 31 88 00 26 500 seg ag ae a B o oo ae i aa ann za Fax 31 84 22 58 178 info invantive com www invantive com IBAN NLI RABO 0123 5297 02 Chamber of Industry and Commerce 08194155
19. 6 51 735 Shifting range Sheet 1 C32 E52 up 12 11 2010 17 45 36 53496 Shifting range Sheet 1 1C1048535 E1048555 down 12 11 2010 17 45 36 65 736 Shifting range Sheet 1ICT WA right 12 11 2010 17 45 37 18936 Sync Download Blocks Protect area Protecting range Sheet 1B2 W3 from black Proj 12 11 2010 17 45 37 20336 Sync_Download Blocks _ Protect_area Protecting range Sheet T B2 W3 has result False 12 11 2010 17 45 37 34136 Parameters Replaced query select from itgen_tables_v where apn_code itgen and ro 12 11 2010 17 45 37 36536 EXCEL EXE Information 0 12 11 2010 17 45 37 37936 Execute statement using database connection select from itgen_tables_v where apn GC 12 11 2010 17 45 37 40036 E EXE Information 0 12 11 2010 1 7 45 37 T Statement select from itgen_tables_v where apn_code togen and rownum lt 10 order 12 11 2010 17 45 37 R Shifting range Sheet 11C33 E39 down 12 11 2010 17 45 37 22838 Sync Download Blocks Protect area Protecting range Sheet 1X9 CA12 trom block T 12 11 4010 17 45 37 642735 Sync_Download_ Blocks Protect area Protecting range Sheet 1 X9 CA1 amp has result Fal 12 11 2010 17 45 37 97440 Sync_Download_Remove_backups Deleting backup worksheet IP_BACKUP layout fror 12 11 2010 17 45 37 99240 Sync _Download_Remove_backups Deleting backup worksheet IP_BACKUP Sheet 1 fn 12 11 2010 17 45 38 00740 Sync_Download_Remove_backups Deleting backu
20. ABILITY 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 1 1 1 1 2 1 1 3 1 2 1 2 1 1 2 2 1 2 3 1 2 4 1 3 1 3 1 1 3 2 1 3 3 1 4 1 4 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 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 3 8 2 3 9 3 9 1 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Control 1 Re 0 soiree sister grease ee cee ee cd on ees se ease ae eneen 1 NG DE ae eagerness egg ee mes see 1 SRI aa s a EE 2 IE E ry en ee ene ee re eee ree eee 3 9 ONE soeren E A E EA 5 System FRO CUIP uT C 5 Installation of Ses e T 5 US er mer ace ea LHB 0 7 User Interface Model Developer annen enn nnnenennenneneenennenennennenennennenennennenennennenennnnnenenennnenennnnnenenennenn 17 ETIE R E needed A R aRtae E 32 leU ab ee nennen ee ee ee eee ntne ee 32 UST TRR e n Been 33 DAAN E E a 33 WOU SHON S aaa E O N 33 KEES OTE Terr 33 Invantive Query Tool 34 Kearns QE oneness dmt 9 NEE aa eten 34 ales Cl ONINO saris cece seeds cetaceans E comenssewatecedencesesesee acues 35 USR Kolo a E metre erst rer ee neee enen et 35 SION TTT 39 Dn 41 AVA MIE eenstaart E E eenhendel 43 System Require MENS sessirnar aE T tenen 44 Installation eenen neee heen ennen neee eee 44 Ui SIONS se
21. E HOME _ REG_SZ SOFTWARE ORACLEKEY_OraClient119_home1 Z ORACLE BbJoRACLE_HOME_ REG_SZ CraClient11g_home1 KEY_OraClient11g_home1 S ab SOLPATH REG 57 c orade product 11 1 0 dient_1 dbs J OLEDE ab StmtCacheSize REG_SZ 0 J 0040 S REG_SZ o finance 0 1 ODP NET Policies L Program Groups H i Realtek EI E H H D H Deze computer HKEY LOCAL MACHINE SOFTWARE ORACLE KEY OraClient11g home 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 c C WINDOWS system32 cmd exe Microsoft Windows Version 5 2 3790 lt C gt Copyright 1985 2003 Microsoft Corp H gt tnsping acciir2 invantive local TNS Ping Utility for 32 bit Windows Version 11 1 0 6 6 Production on SEP 20669 14 37 26 Copyright lt c gt 1997 2007 Oracle All rights reserved Used parameter files C app Administrator product i1 1 B client 1 network admin sgyinet ora Used TNSNAMES adapter to resolve the alias Attempting to contact lt description lt address _list lt address Cprotocol tcp gt host 192 168 172 16 gt Cport 152122 lt connect data C sid acciir2 gt global name acciir2 invantive local gt gt gt OK lt A msec 1 FS e t is still not certain if the user password are correct but it is certain that a network conn
22. L S E i Invantive Control Manual Solutions for Real Estate and Finance 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 wijze 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 aans prakelijkheid 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 with or without 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 follow ing disclaime
23. Panel among the installed programs there will then be listed Microsoft NET Framework 4 5 e Copy invantive webservice in the distribution to the folder that is known within Microsoft IS 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 e 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 Fr Invantive Webservice EEN 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 Add Application Xx Site name Default Web Site Path l Example sales Physical path C netpub wwwroottobubs ws Pass through authentication Connect as e Set the application in for use of the application pool ASP NET v4 0 Edit Application Pool Y Name MET Framework version MET Framework 4 0 30319 M Managed pipeline mode Integrated Start application pool immediately Cancel e Set the standard page Service ashx C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 52 Invantive Control User Manual Jr SEVICE SWL e You can now test the web service by opening the p
24. Pro lab Standaard REG 57 geen waarde ingesteld ab MSHELP_TOOLS REG SZ c lprade product 11 1 0 dient_1 MSHELP ee dek abjnLs LANG REG SZ DUTCH THE NETHERLANDS WESMSWIN1252 aa Fe REG_S c oracde product 11 1 0 dient_1 oledb mesq Gi ia Logitech REG SZ c orade product 11 1 0 dient_1 oo040 mesg Ga Macromedia laBJORACLE_BUNDLE REG SZ Enterprise ee CA Microsoft aB ORACLE_GROUP REG BZ Orade GraClient11g_home1 E MozillaPlugins ab ORACLE_HOME REG_SZ c oracle product 11 1 0 dient_1 9 29 ope ab ORACLE HOME_ REG SZ SOETWAREWORACLEWEY OraClient11a_home1 Big ORACLE ab ORACLE_HOME_ REG SZ Oratlient11g_home1 MEER Ie OraClientiig_home1 Sam REG SZ c oracle product 11 1 0 dient_1 dbs Poi ab StmtCachesize REG SZ Gl Policies LO Program Groups HL 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 Control User Manual Po m Register editor ME Bestand Bewerken Beeld Favorieten Help E Hewlett Packard Naam Type Gegevens 0 Hitman Pro REG SZ geen waarde ingesteld JHP ab MSHELP TOOLS REG 52 c oracle product 11 1 0 cient_1 MSHELP a lab NLS_LANG REG 52 DUTCH_THE NETHERLANDS WESMSWIN1252 ab OLEDE meen Ie attent 1 oledbnesg 71 JavaSoft Ni A Sleutel Logitech 2b oo40 es int_1 po4o mesg 9 Macromedia lab ORACLE BUNDLE Reca Gal Microsoft laBJORACLE GRO
25. UP REG SZ Binaire waarde i E MozillaPlugins ab ORACLE HOME REG_54 DWORD waarde mt obec ab ORACLE _HOME REG 52 Waarde met meerdere tekenreeksen faClient11g_home1 ORACLE ab ORACLE_HOME_ a REG_5 Waarde met uitbreidbare tekenreeks J KEY_OraClient11g_home1 j ab SOLPATH REG SZ Eprade producti T Odient_1 dbs E OLEDB ab StmtCachesize REG SZ 0 E 0040 H E ODP NET H E Policies za Program Groups E Realtek ES ES Deze computer HKEY LOCAL MACHINE SOFTWARE ORACLE KEY OraClientlig_homel e Change also the NLS LANG to DUTCH THE NETHERLANDS AL32UTF8 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 m Register editor Sele Bestand Bewerken Beeld Favorieten Help H Hewlett Packard Naam Type Gegevens CA Hitman Pro lab Standaard BEG 52 geen waarde ingesteld el HP ab MSHELP TOOLS REG SZ orad t 11 1 0 dient_1 MSHEL dac REG SZ saat A ab OLEDE REG_SZ cr orade product 11 1 0 dient_1 oledb mesg Ga Logitech lab oo4a REG SZ c orade product 11 LO dient_1 o040 mesg Ca nn ab ORACLE BUNDLE REG 5 Enterprise Cy Microsoft ab ORACLE_GROUP REG SZ Oracle OraClient1lig_home1 Ed MozilaPlugins laB ORACLE HOME REG_SZ c oracle product 11 1 0 dient_1 E opec labJoRACL
26. Voorkeursinstellingen Help vanuit DMS Y Wijziging 0 Rij Rij Waarde Development jdz Dacument Management Synchroniseren Publiceren Modelinformatie Blokacties Weldacties Verbinding Help Document Management C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 8 Invantive Control User Manual ie Open Sjablaan vanuit ORAS Document Management The group Document Management contains the following button e Open the Template from DMS Open a pop up to open documents from DMS of Invanti ve Producer see Open Template from DMS 10 Synchronize a Te Projec Kl Pieter Openstaande Publiceer Wijziging 0 Alleen Uploaden Alleen Downloaden Publiceer naar Nieuw Model The group Synchronize contains the following buttons e amp Sync Synchronize the model workbook with the knowledgebase Download alle nieuwe feiten en upload de wijzigingen naar de feitendatabase The button Sync contains the fol lowing functions e Alleen Uploaden Upload de wijzigingen van het huidige modelwerkblad naar de feitendatabase e Download Only Download all new articles from the knowledgebase in the cur rent model e W Publish to New Model Publish the model without articles to a new file e A Pending Changes Show the pending changes that have not yet been synchronized with the knowledgebase The number between brackets shows the number of changes that have not yet been synchr
27. ade upgrades the model database of this workbook to the latest version Supported by Invantive Control The button works only if an update is available 4 Clear Database removes the database model from this workbook This action cannot be undone and synchronizing changes is not possible anymore Tools B Query programma Tools The group Tools contains the following button e v Query Tool opens the Query Tool to run a SQL query on the database see Invantive Producer Query tooll 34 Block Information Blok Organisaties Broncode Organisaties bubs_leveranciers_v Sta bewerken toe Ja Blakinf ormatie The group Block Information contains the following button e Block Information here you can find information about the selected block like its source code or if it is allowed to edit the block Row Information Uniek ID 76 Status Ongewijzigd Veld Nr naam Kij inf ormatie The group Row Information contains the following button e Row Information here you can find information about the selected row like its unique ID status and field from the knowledgebase Debug and Analysis bit i id i d Repository Toon Markeer Rij Werkbladen spoor als Nieuw Foutopsporing en Analyse The group Debug and Analysis is only visible when the debug mode is turned on and it con C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved E Invanti
28. age You will receive output such as 23522 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved ben a S x Ef Invantive Webservice CO Jws_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 wadl 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 C Class Test Static void Maint ServiceClient client new ServiceClient J Use the client variable to call operations on the service f f Always close the client eclient Close Visual Basic Class Test Shared Sub Maint Dim client As ServiceClient New ServiceClient 1 Use the client variable to call operations on the service T 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 and 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 e Click on Ce
29. ant S Alignment Number L Gell Editing Je organisatienaam Food and more litem onganizatienaam Food and more 1 item 2 3 persoon functie plaats E Born van der Accountmanager Amersfoort E 5 organisatenaam Janssen Uitgeversorganisatie 3 items 7 S persoon functie plaat q Hoef wan der Engineer Amerstoort 7 10 Aeilkema Hegiomanager Amersfoort 11 Dorr Consultant Exact Amersfoort 12 13 organizatienaam Mekra 1 item 17 18 organizatienaam Piet Wan Den Herck bna 1 kar tat 23 organitatienaam OT Design 2 items M a F Sheeti PA l T E fx Ready l ER Anna lt K K L C e The image shows the result of the SQL query in Adobe Acrobat File Edit View Document Comments Forms Tools Advanced Window Help N K jam PaL dl a e A Ef B P K a i rel ef Find 9 persoon functie organisatienaam Food and more 1 item Born van der Accountmanager organisatenaam Janssen Uitgeversorganisate 3 items Hoef vander Engineer Aeilkema Regiomanager Dorn Consultant Exact organisatienaam Mekra 1 item 7 Breukhoven Communicatie organisatienaam Piet Van Den Herck bna 1 item i Brouns Sr Channel Manager General Business Sales Amsterdam organisatenaam QT Design 2 items Engel Helpdesk Teamleider Amersfoort Fasen Account Manager Amersfoort 1 60 x 0 26 in al C Copyright 2004 2013 Invantive Software B V the Net
30. ation file you can adjust in which order this happens see image See also Providers Configuration 57 Invantive Webservice Routing Service or data requested Ay _ Provider LAN lt Your name gt Invantive Vision Invantive 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 50 Invantive Control User Manual E 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 T u l Invantive N Invantive Webservice Webservice O Invantive gt Webservice 9 Invantive Webservice The redundance can be set in the settings xml file See also Connection configuration 54 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 users e Install Microsoft IIS 7 or 8 including ASP NET support e Install Microsoft NET Framework version 4 5 or newer In the Control
31. ch the information on the reports should be shown This data is activated w hen checked C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved S Invantive Producer Yoorkeuren Filter Voorkeuren Taal fri rez bubs_dutch E The significance of the field in the Preferences tab Language Here you will find the languages w hich are available for Invantive Control The language w ill change immediately after you close the window 1 2 3 9 Help The button amp Help show the help function from Invantive Control including those from Invan tive Control C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved B Invantive Control EP HTML Help Bis G E E TANTE um Hide Back Forward Refresh Horne Print Options Contents Index Search Fad Havigation Mo topics above this level 2 Inleiding Inleiding C5 Web Gebruikersinterfac en MS Outlook Gebruikersi i Koppeling KING Koppeling Asterisk WOII C Koppeling Exact Online Koppeling Exact Globe Koppeling ENIAC gh Koppeling Eigen Gebrui C Processen Ke Server Installatie Prestaties ontwikkeling aJ Invantive Producer amp Versies C Terminologie gb Veelgestelde vragen Contactgegevens Welkom bij de Invantive Estate handleiding Invantive Estate is een projectmanagement oplossing voor projecten in de vastgoed sector Invanti
32. ction 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 Jr Invantive Webservice 49 e Data and requests are exchanged lf 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 e Microsoft SQL Server e Oracle RDBMS e 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 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 configur
33. ctory 13 usage 13 Invantive Control connection connect automatically 12 connection 12 password 12 store password 12 username 12 Invantive control data management 33 block 4 crm data 4 update data 4 Invantive control example 32 Invantive control extension active 26 code 26 comments 26 definition 26 description 26 File Location 26 language 26 load order 26 Invantive control functionality installation 5 system requirement 5 user Interface 5 Invantive Control functioning functioning 2 model developer 2 model user 2 Invantive control help 16 Invantive control installation 5 Invantive control model editor 19 Invantive control orientation and size business object 21 download order 21 filter 21 order 21 primary key 21 select 21 transaction column 21 upload order 21 Invantive control parameter filter 20 Invantive control parameter value model editor 11 Invantive control pending change knowledgebase 10 synchronization 10 Invantive control pending changes 26 Invantive control preferences 14 Invantive control publish 10 Invantive control repository worksheet empty worksheet 30 xml code 30 Invantive control show trace log 31 Invantive control user interface model developer analyses 17 block information 17 debug 17 model 17 row information 17 tool 17 Invantive control user interface model user block action 7 connection 7 help 7 model information 7 publish 7 synchronize 7 Invantive control working offline 4 3
34. d_access gt locked lt mdl_password_access gt lt mdl_password_edit_model gt secret lt mdl_password_edit_model gt lt mdl_allow_changes_ outside_blocks_flag false lt mdl_allow_changes outside blocks flag lt mdl_date last downloaded gt 2010 09 30T13 20 10 1752431 02 00 lt mdl_date last _downloaded lt mdl_date last uploaded 2010 09 08T14 41 55 7957994 02 00 lt mdl_date last uploaded lt mdl_last opened by psc lt mdl_last opened _by lt mdl_last opened _on WS23 lt mdl_last opened _on lt mdl_date last opened 2010 09 30T11 48 32 1810905 02 00 lt mdl_date last opened ld 4 gt KN ip repos IP EMPTY layout Organisaties Personen verkoopkansen Ready Ee 1 2 4 4 Show Trace The function You can use Show Trace to analyze errors in Invantive Control The window is only displayed if the Show Trace button is on see User Interface Model Designer 171 In vantive can request that Show Trace be enabled and the log file sent in order to determine why there is a problem with synchronizing the model C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved ER Invantive Control User Manual E El Invantive Producer Foutopsporing en analyse ll Opslaan Leeg maken 12 11 2010 17 45 36 18132 Statement select pjt_codepjt_volledige_naam pjt_idpjt_transactie_bijgewerkt from bubs 12 11 2010 17 45 36 48635 Shifting range Sheet TTC E ZT down 12 11 2010 17 45 3
35. ducer Modelbewerker A Verwijder Blok Sleep een kolom hierheen om te groeperen op die kolom rn P P p oort h J In this window you can add modify or delete a block C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 22 Invantive Control User Manual ie E Invantive Producer Modelbewerker File Help a Opslaan Toevoegen Blok gt Verwijder Blok El Parameters fr gt organisatienaam Code Organisaties Actief Iw Bif Organisaties E CEE Benoemd bereik gegevens Jorganisaties_data Benoemd bereik rand Jorganisaties_border Zg Openstaande Wijziging Toegangscontrole IZ Toevoegen IZ Bijwerken IZ Verwijderen Optellen langs X as Optellen langs Y as The meaning of the entry fields is Code The unique name of this block Active f checked this block is active and it is possible to synchronize it w ith the know ledgebase Name data The data range as a unique name This name is used as a name range in Excel to identify the data of the enti range re block including borders It is possible to use this name in an Excel formula Name border The border of the named data range as a unique name This name is used as a name range in Excel to identi range fy the data of the entire block including the borders It is possible to use this name in an Excel formula Access Add it is possible to add data and subsequently synchronize w ith the know ledgebase
36. e 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 e 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 E Invantive Control User Manual ie To use Invantive Webservice on your PC or terminal server you will need the following soft ware including licenses e Microsoft NET 4 5 e 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 e Operating system Windows 2008 R1 Service Pack 2 Windows 2008 R2 or Windows 2012 e Minimum of 4 Gb internal memory e Screen resolution of 1280 x 1024 or higher e Minimal 1 central processing unit for server use not 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 a
37. ec tion to the Oracle service can be built C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved E Invantive Webservice e 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 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 ava
38. een 9 1621 CV 31 700 8400 Kastanjelaan 1 2665 GA NIEUW Telefoon van der Mijleweg16 1901 KD 31 191 189400 General Maczeklaan 3 5111 XA 3133 43 46631 Grotestraat 12 6129 CP Keizersgracht 12 5611 GD 030 6717 888 Draadbaan 21 2352 BM 31 8800 62100 Nieuwezijds Voorburg 1012 SP 2e Schuytstraat 290 2517 TT 31932419100 Gelreweg 2 3843 AN Dorpsstraat 13 6021 HA Ruimtevaart 2 3824 MX Changed fields a Export Pending Changes ed Export Drag a column here to group by that column ions BR G D E F G Klantgegevens Vertegenwoordiger Piet Janssen Plaats Rotterdam Haarlem Hoorn Bleiswijk Castricum Baarle Nassau Urmond Eindhoven Leiderdorp Amsterdam Den Haag Harderwijk Budel Amersfoort New Yalue This chapter describes the changes in the application per version 1 4 1 Release 2014 R1 Released XX XX 2014 Invantive Producer bXX Changes and bug fixes C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Leverancier 2 Z Z gt Z ZZ Z ZZZ 2 Klant nO nO Oe ISIS III Invantive Control User Manual Pe wae PR Invantive Kan Waarderingsmodel niet publiceren naar nieuw model ivm resizen blokken en Excel tabel Control aaas a Invantive Verbergen repository sheets geeft error Control A 53 IER Invantive Nieuw plaatje in Invantive Control voor weergave x y z Control Installation e No specialties Implementation e No specialties
39. en click Install next save the file and execute it Invantive B V Invantive Producer Query tool Name Invantive Producer Query tool Version 0 0 1 1 Publisher Invantive B W The following prerequisites are required 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 Install e 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 Invantive Query Tool Application Install Security Warning Do you want to install this application Invantive Producer Query tool webservice invantive com Publisher Invantve BM 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 54 for an explanation of the con nection file Select OK to save your changes 0 Invantive Configuration 23 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved E Invantive Control User Manual Je e Next com
40. ent1 OraClient 1g home installation Type Administrator Product Languages Arabic Bengali Brazilian Portuguese Bulgarian Canadian French Catalan Croatian emme Le Help Installed Products Back N LT i TEEM e The progress is displayed C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved m Invantive Control User Manual E Oracle Universal installer install ORACLE 14 3 DATABASE Install _ Ideal Platform for Grid Computing Low cost servers and storage Highest availability Best scalability Installed Products VEE leefden A C 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 de Invantive Webservice Oracle Net Configuration Assistant Welcome Welcome to the Oracle Met 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 identitving the database WOU Want Tn access With easy connect naming you use the host Hortfoptianall and service name ofthe database as the connect identifier Click Help for more information about connec
41. eps tees veteatce stares sn ntt neen menens Eteone 46 Release ZO a verekenen eE a A EEan A EEE ninani ee AEE 46 Invantive Webservice 47 MED SeEIVICES dicirian a a a 47 Advantage S resination ada 47 System ReOUIEe MENS sr iere eee ee eee eee eee 47 GONCEPE enone at ne een ne eee ret er ene een eee ee renee eee en rene nee a ee ern eee rrr 48 Database platforms aannamen eee ee eee 49 Ks TRT Te igjen omissie ernea ere aie deel eset en oa re eee eee 49 ASA NANON eneen nenten ae nnee 50 Invantive Webservice Programming s sssss sss sss sees esse esse eee esse esse ees seene ennenen nenen ee 50 GERCO TH 53 Rere elke orgie lg dog 54 Providers CORT UPAUOIN asses onee seramenkendersienentetdnandensedendel SNET enscieseadauauccetetaiesmsneaueuncetentieceessaisabesdeeses 57 POVOS ania tne seeceaeeucsaeuncantowsdsusswevde cos iiscue te E senieeeamecesdesteeae 59 LK rake hese T oessa e a E E En 72 Rn e iA EE 72 CO O T 72 i Lea 72 aE Pe a TTT 72 Contact Information 72 i Invantive Control User Manual Index 14 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved FA Invantive Control 1 Invantive Control The manual Invantive Control is written for developers and users of a calculation model The advantages of Invantive Control are e Use of frequently used Microsoft Excel e Use of Invantive Producer applications like Invantive Control e Synergy between Microsoft Excel and Invantive Control by simply re
42. ers and or letters This provides the upload sequence of blocks to the database An example is that A001 comes before B001 Select The columns of the business object The columns have to be separated by a comma Filter Definieer een filter om een gedeelte van een blok te selecteren in SQL syntax Volgorde The list of columns to determine the order of data in SQL syntax This window shows the columns of the business object and is automatically filled C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved a Invantive Control User Manual E Invantive Producer Modelbewerker The meaning of the fields are is Name The name of the column Data Type The column data type Sync Back If checked changes in the column will be registered in the pending changes When you synchronize only the changes are send to the know ledgebase Formula When checked you can use an Excel formula in this column Only the result of the formula w ill be send back to the know ledgebase w ith synchronization When checked you can use an Excel formula in this column Read only When checked the model user can not edit the values of the column How ever the column value can be edi ted by lt PRODUCT_ECA gt Default Va lue The value will only be entered after synchronization w ith the know ledgebase e Constant value e Parameter P name of the parameter e Excel formula for example E formule
43. es the login screen Next enter the username password and connection and se lect OK Q Connect C Copyright 2004 2011 Invantive Software BV the Netherlands All rights essees linvantive Production LAN of http m m e In 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 ery Tool 2171 PR Invantive Qu ery Tool 1994 IER Invantive Qu Describe werkt niet in Query Tool ondanks rechten op de functie itgen_querytool describe Lijst meest recente documenten stuk of 10 tonen in Bestandsmenu C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Jr Invantive Query Tool E 3 leyta ery Tool Installation e No specialties Implementation e 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 are 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 m
44. f the service o 1 dwtlire invantive local oe description Od address list Gd address protocol tep host 1924 166 172 16 port 1521 oo 1 BG 1 or connect data oc Sid dytlire LU LO Global name dvtilrd invantive local LD oO LO e his 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 the SID dv C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved E Invantive Webservice m t11r2 and the global name dvt11r2 invantive com e Full instructions on creating thsnames 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 Zoekresultaten Bestand Bewerken Beeld Favorieten Extra Help K ps Zoeken j Mappen Hak Naam In map insnames ora O Finance 1kB ORA bestand Andere locaties IE Bureaublad 4 Deze computer Mijn documenten Mijn netwerklocaties Details Zoekresultaten aysteemmap e Open the register with regedit and go to the key HKLM SOFTWARE Oracle KEY OraC lient11g home m Register editor Bestand Bewerken Beeld Favorieten Help Y O Hewlett Packard Naam Type Gegevens 2 Hitman
45. ference A cell reference refers to a cell or cell range on a worksheet and can be used in a formula So values or data that you want to calculate can be sought for in Microsoft Office Excel You can use a Cell reference in one or more formulas to refer to the following e Data from a cell on the worksheet e Data located in other area s of the worksheet e Data in cells of other worksheets in the same workbook Example C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved E Invantive Control User Manual he This formula Refers to And shows as aresult C2 Cell C2 The value in dell C2 Assets Liabilities The cells called Assets and Liabilities The value in the cell liabilities subtracted from the value in the cell Assets Week1 Week2 The range of cells named Week1 and The sum of the values of the cell range with the name and Week2 Week1 Week 2 as an array formula Blad2 B2 Cell B2 on Sheet2 The value in cell B2 on Sheet2 source Microsoft Office 2011 Recalled on July 28 2011 Create or change a cell referen ce http office microsoft com nl be excel help een celverwijzing maken of wijzigen HP010342370 aspx Target The purpose of a cell reference expression is to easily make cross references in a model It does not matter whether the link between two cells are in the same block between multiple blocks or even beyond Advantages of cell reference expression in relation to Excel fo
46. formation 1 1 2 Functioning The figure shows the global functioning of Invantive Control The developer develops the mo del in Invantive Control and saves it in an Excel worksheet The model user opens the Excel file and then loads the data from the database The changes of the user and recorded and when synchronizing the changed data will be uploaded to the database and new data will be downloaded C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Jr Invantive Control 8 LL oo UU F P Ontwikkel model Laden vanuit database Template optioneel Vullen met data Wijzigingen bijhouden Opslaan naar database 1 1 3 Scope This section describes the scope of Invantive Control The scope consists of support for cal culation models offline working and data managemernt 1 1 3 1 Calculation model A mathematical model is used for calculations An example of a mathematical model is a cost benefit analysis which can be used to compare expected costs against expected bene fits The analysis is used to determine profitability of for example a product project or servi ce Example of a calculation model in Invantive Control The figure shows an example of a cost benefit analysis for developing a product which is ba sed on three different approaches Each approach uses different cost prices and selling pri ces and the bar graph shows that Approach 3 is actually the m
47. g gt C temp invantive logging log lt leg 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 a pan lt provider 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 glee lt provider order 300 file Invantive Producer Data Provider dll class Invantive Producer Data InvantiveProducerDataProvider gt lt providers gt 3 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 Webservice In this chapter the configuration of the provider is described In addition some suggestions are provided to execute the installation
48. herlands All rights reserved E Invantive Query Tool a 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 e Delete e PL SQL Begin End without line breaks and blank lines A possible transaction is immediately recorded at the end of the execution of the statement Menu File Pa Invantive ision Query programma Bewerken Editor Database Venster Help Ctrl Bestand Open Opslaan Ctri 5 Bewaren Als Ctrl Shitt 5 Afdrukken Chri P Afsluiten CHAM 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 ow Invantive Control User Manual Pa Invantive ision Query programma Bestand R Uitvoe Bewerken Terugdr aaien DDS ne Kmppen Kopi ren Flakken Selecteer Alles Zoeken Vind Volgende Vervangen Yenster Ctrl Z Ctrl CELLS CEC Ctrl Ctrl Ctrl F F3 CER Ga naar Regel Ctrl G Commentaar Ctrl F Ontcommentaneren Biok Ckr Shift B Hoofdletters Ctrl U Kleine Letters Ckrl L Eerste Letter Hoghietter Ctrl I Beschrijven a The Editor menu contains all items with which you can edit the query text Menu Editor Fa Invantive ision Query programma Bestand Bewerken Editor Databa
49. ilable at http dev mysql com downloads connector net The installation of the MySQL client MySQL Connector Net proceeds as follows e 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 mysql 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 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 Control User Manual BLA 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 Cha
50. ing to a database If again there is a connection available to the database you can upload and download changes sync from the database 1 1 3 3 Data management Another example of using lt PRODUCT ECA gt is for managing data input and updating lar ge blocks of data An example of this is to modify CRM data such as organizations and per sons as shown the image It is possible to modify multiple organizations and individuals and then synchronize them with the database S Mr F BookiLxlsx Mic En d ai ici k Home Insert Page Layout Formulas Data Review View Developer Add Ins Invantive Producer Modeller Acrobat Team alt P Invantive test model 1 K4 HH X ht W Y ma Patrick Hofman Invantive So a Sync Pending Publish Parameter Add Remove System User Preferences Help z Changes 1 Value Row Row bubs ws25 v7 Synchronization Publishing Model Information Block Actions Connection Help D9 v fe NIEUW Telefoon Al B 2 D E G H al Eza ae Klantgegevens _3 Vertegenwoordiger Piet Janssen _4 Primair Contactpersoon Telefoonwerk Adres Postcode Plaats Leverancier Klant 5 Aarde consult 088 6647111 Bergselaan 3 3037BA Rotterdam N 6 Acme BY 31 32 16 61 144 Schagchelstraat 19 2011 HW Haarlem Y Y 7 Agency Entertainment h 0900 ROXTEC Rode Steen 8 1621 CV Hoorn Y Y 8 ANWB 31 7008400 Kastanjelaan 1 2665 GA Bleiswijk N Y 9 Arcadis 7 NIEUW Telefoon van der Mij
51. leweg16 1901 KD Castricum N 10 AXA 7 31 191 189400 General Maczeklaan 35111XA Baarle Nassau WN Y 11 AYA h 31 33 43 46631 Grotestraat 12 6129 CP Urmond N Y 12 A73lnfocentrum 7 Keizersgracht 12 5611 GD Eindhoven N Y 13 Balance 030 6717 888 Draadbaan 21 2352 BM Leiderdorp N Y 14 Beaufort installatietechniek 7 31 88 00 62 100 Nieuwezijds Voorbur 10125P Amsterdam N Y 15 Bloembinderij Bloemen Piet 2e Schuytstraat 290 2517TT Den Haag Y Y 16 Borchhuis systemen h 31932419100 Gelreweg 2 3843 AN Harderwijk N 17 Bouw international h Dorpsstraat 13 6021 HA Budel N Y 18 BOVAP Simons Ruimtevaart 2 3824 MX Amersfoort N L C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved hi 4 Invantive Control i 1 2 Functionality This section describes the system requirements de steps you have to perform for installati on and an explanation of the user interface of Invantive Control 1 2 1 System Requirements To use Invantive Control on your PC or terminal server you will need the following software e Microsoft Office 2010 or Microsoft Office 2013 only on Microsoft Windows e Microsoft NET 4 5 e Minimum 2 GB of internal memory e Screen resolution of 1280 x 1024 or higher e 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 2 2 Installation of Excel Add in Invantive Control will be installed
52. llowing buttons e ki Connect Connect to a knowledgebase The button shows the username and server If there is a connection to the database see Connection 121 The button Connect contains the following function e Settings Set de configuration of Invantive Control see Settings 131 e Preferences Set your personal preferences for Invantive Control see Preferences 141 Help C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 40 Invantive Control User Manual Sie Help Help The group Help contains the following button e U Help Get support for the use of Invantive Control see Help 161 1 2 3 1 Open Template from within DMS Enter text here 1 2 3 2 Pending Changes The button amp Pending Changes shows all modifications that have been made in Excel and not yet synchronized with the knowledgebase Uitstaande Wijzigingen Gewijzigde velden led Exporteren f Openstaande wijziging m Exporteren Statistieken Feiten voor het laatst gedownload op 30 4 2010 13 20 10 Feiten laatst geupload op 6 9 2010 14 41 55 Sleep een kolom hierheen om te groeperen op die kolom Nummer Vv Blok K dn nm iraa nnen Nieuwe Waarde 1 2 3 3 Publish The function Publish makes a new Excel Worksheet with a copy of the data from the ori ginal Excel file In the window you select the elements that are to be carried over to a new worksheet C Copyright 2004 20
53. lumn Row 2 IR Currentrow Example of the use of cell reference expression Component Example Explanation example Pivot method D The first cell and the first row E As indicated in the current block Block The current block Projects The projects block Sheet The current sheet Sheet 1 The sheet Sheet 1 The second sheet The penultimate sheet Column 1 The current column minus one Project Code The column Project Code 2 The third column of the block The last column of the block Row 1 The current row plus one Column 2 l Current Column Project code 2 Two further than the column Project code AFS The fourth column 2 The second from the last column Row 2 2 The current row plus two In the sections Worksheet Column 1 2 and Row 1 2 it is also possible in the extra options to give a natural number using or The extra option allows you to subtract or add a number to the option Properties cell reference expression e Case sensitive e Also works with SQL functies such as SUM COUNT AVG etc In Invantive Control A cell reference expression is defined in the select of one Block 21 in the Model Editor 171 The picture below shows some examples of the use of cell reference in the select expressi on C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved EEN Invantive Control User Manual ie Invantive Control Modelbewerker File Help E la Opslaan __ T
54. lumn row or worksheet See Blocks 21 for an example Parameter A parameter is a filter that can be set to retrieve a part of the data from a block from the knowledgebase By specifying a parameter you ensure that only data from the database is retrieved which are set in the filter set See Parameter Values 11 for setting parameters Extension An extension is an integrated script in the output process of the model An extension enri ches a model with the functionality that is not standard available in Invantive Control An example of an extension is to use a button that adds automatically data to the worksheet See Extensions 26 for more information A Pending change These are modifications in the local data of the model user and are ready to be sent to the knowledgebase The knowledgebase contains the centralized storage of facts outside an Excel worksheet An example of a pending change can be a modification of a cell value in Excel and this change still has to be sent to the knowledgebase See Pending Changes 10 for more information Synchronize You use Synchronization to send pending changes to the knowledgebase and to retrieve new data from the knowledgebase Via the option With upload the pending changes not yet sent are sent to the knowledgebase Via the option With download the last data is re trieved from the knowledgebase and processed in the data block See User Interface Model User 71 for more in
55. n riches a Model with functionality that is not by default specified inlnvantive Control An example of an extension by means of a button to automatically add data in the worksheet Invantive Producer Modelbewerker File Help el Opslaan _ Toevoegen haak X Verwijder Haak HA ws p307 dotret Libraries invantive Windows Forms dl Eg A The meaning of the entry fields is Code Provide a unique name of the extension Load Order Provide a number for the order of loading extensions in Invantive Control Active This field indicates if this extension is active or not Language Provide the programming language of the extension Description Provide a description of the extension File Location Provide a the location of the extension The field File Location or Definition must contain respectively an ex tension location or code Definition Provide the programming code of the extension The field File Location or Definition must contain respective ly an extension location or code Comments Provide comments of the extension Pending Changes Pending changes are changes in the local data of the model user and are ready to be send to the knowledgebase The knowledgebase contains the centralized storage of facts outside an Excel worksheet An example of a pending change can be a modification of a cell value in Excel and this change still has to be sent to the knowledgebase This screen shows
56. nd 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 application 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 conne
57. ng a block seeBlocks 21 The figure show that the parameter is set to A This means that only organizations that begin with the letter A are retrieved withInvantive Control 15 Inventive Producer Modelbewerker De Help led Opslaan Toevoegen Parameter Verwijder Parameter See areca Sleep een kolom hierheen om te groeperen op die kolom Mt ae Code EY _ Omschrijving XY StandaardWEY HuidigeWaarde EV Pant a x F i DEE TON dd pear menten aten nin In this part of model editor you can add modify and delete parameters C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Control 9 Invantwe Producer Modelbewerker File Help la Opslaan Toevoegen Parameter Verwijder Parameter Pd SD EE ae The meaning of the entry fields is Code The unique name of the parameter Description The description of the parameter Default Va The default value of the parameter lue Current Va The current value of the parameter lue Block A n block is a contiguous area in an Excel workbook A block contains data of a database retrieved by a query at the last synchronization and contains data that needs to be saved du ring the next synchronization A block uses one of the dimensions cell column row or worksheet The figure shows the current blocks in this example are the blocks Organisati ons and People Invantive Pro
58. nnel 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 72 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 Changes and bug fixes 22414 ER IBM DB2 data provider support 23456 ER IBM DB2 ook via ODBC mogelijk maken 22594 ER Ondersteuning voor redundante verbindingen failover 23279 PR Onder specifieke condities treedt een Byte error op bij gebruik van de w ebservice 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 E Contact Information 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 righ
59. ntrol Username The username used for connecting to the server Passw ord The passw ord of the user Connection Here you enter the server with w hich you w ant to connect Store passw ord The password will be stored encrypted when checked Connect Automatically The application automatically connects to the server and the connection screen does not appear when checked 1 2 3 7 Configuration In this window you set the configuration in from Invantive Control 2 Invantive Producer Configuratie Gebruik Excel add in Ontwikkelmodus Haal instellingen op uit ara T IRH IRR ite settings xml Aantal beschikbare verbindingen E ei The meaning of the fields in the General tab is Use Invantive Control When checked it is possible to activate Invantive Control Development Mode When checked the tab Modeller w ill be visible in the ribbon This function is specifically for model developers Get settings from This is the file location of the XML file w ith the connection settings Number of available connecti This field indicates the number of available connections to databases ons C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Installatielocatie ae Mende ecel _ addin Doelmap installatie Cg nt ae Apps Data IDE FAD EDEN NS DDP ZUR inva velo bSebU01 485730247 0001 DOOD 6274061 fd07d999 0 at es Configuratiebestand Cg atte L
60. ocal Appsh2 0 Data OEE 730 20R JEYASODP 205 inva veto b5ebO01 495750247 0001 0000 6274087 FdO d999c4 0 at an 0 6555 50024 user contig Enable debug mode Iw le The meaning of the fields in the Advanced tab is Installation location This is the location of the installation file of Invantive Control When you start Excel on this location it w ill be checked if anew version of Invantive Controlis available If a new er ver sion is available the program w ill ask you if you w ould like to install it Target directory The target directory show s the local file location of Invantive Control w here the porgramm is stored This is the file location of the local configuration file containing the settings When checked the tabs Modeller w ill be available seeUser Interface Model Developer 174 This option should only be checked at the request of Invantive Configuration File Enable debug mode 1 2 3 8 Preferences In this window you set the preferences ofInvantive Control in C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Ny Invantive Control S Invantive Producer Yoorkeuren Filter Woorkeuren Jouw naan System User 30 09 2010 14 43 30 Happortagedaturn te The meaning of the fields in the tab Filter is Your name The name of the user within Invantive Producer Oo Report date Here you can enter the reporting date for whi
61. oevoegen Blok X Verwijder Blok B C Model Algemeen Feiten Velden Weergave P Parameters S 2 75 Blokken Bedrijfsobject fitgen_table_columns_v t R ane Primaire Sleutel w ier Bloc P Uitbreidingen Transactiekolom NE fy Openstaande Wijzigi ee Downloadvolgorde a002 w Uploadvolgorde a002 w Select apn_code tbe code C D Black 1 ten_name expression C D Block 1 S H expression SUM C D Block 1 ar bT UT expressiong Filter rownum lt 10 Volgorde Kopieer query naar klembo Toon Feiten C Starting point Block Worksheet Column Row Column1 Column2 With target cell reference Excel control image Formula Expression on in the field and sync back off An example of cell reference expression is in a column is C D Block 1 tcn_name expression1 This example U gt This formula Refers to And shows as aresult C2 Cell C2 The value in dell C2 Assets Liabilities The cells called Assets and Liabilities The value in the cell liabilities subtracted from the value in the cell Assets 1 2 4 3 Repository Worksheets Thed repository worksheets contain an empty worksheet and a worksheet with the XML co de that describes the model This tab is only visible if you click on the Repository Works heet button seeUser Interface Model Designer 171 C Copyright 2004 2013 Invantive Software B V
62. onized seePending Changes 40 Publish Ke Publiceer Publiceren The group Publish contains the following button e Publish Publishes the contents of the Exce workbook to a new workbook You can ex clude confidential parts of the original workbook from the new workbook see Publishl 1d Model Information C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved E Invantive Control 9 Projecten 1 k 4 Pieter Schouten Inwantive 50 Parameterwaarden Modelinformatie The group Model Information contains the following buttons e Model Information The first line shows the name and version of the model and the second line the author and the company e Parameter Values Open the parameters screen to configure a filter for retrieving data in the workbookParameter Values 111 Blok Actions Toevoegen Verwijder Rij Rij Blokacties The group Block Actions contains the following buttons e 4 Add Row Add a new row after the current row in the selected block e Delete Row Delete the selected row from the current block Field Actions E kies een Waarde Weldacties The group Field Actions contains the following button e EE Choose a Value Open a pop up which seeChoose a Valuel 17 Connection wy Woorkeursinstellingen it l evel i nj DT ent jaz gt 19 j E Instellingen The group Connection contains the fo
63. ore 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 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 th
64. ost profitable The calculati ons of the model are are stored in the database which makes that the results will be display ed after synchronization througinvantive Control in Excel The advantage is that the user can not accidentally change the calculations and another advantage is that the computations can be managed C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 4 Invantive Control User Manual 5 de ee lr an er r Loe J m ostenbatenmetscenarios xls Compatibility Mode Mineo Excel Developer Preferences Help Add Remove Choose Row Row aValue Development pse Black Actions Field Actions Page Layout Formulas Data X e h 4 Parameter Values Review Add Ins Invantive Producer Modeller kf System User View Vom V v ay dx d Invantive test model 1 S A i Patrick Hofman Invantive So Sync Pending Publish Changes Synchronization Publishing esses 6 Variabele kosten 7 Loonkosten per uur 8 Materiaalkosten 3 Otale winst 13 Materiaal per eenheid 14 Kostprijs 15 Verkoopprijs 16 Winst per eenheid 17 Geproduceerde eenheden 18 Totale winst per model Aanpak 2 Aanpak 3 1 1 3 2 Working Offline You can use Invantive Control for editing data in Excel offline With working offline you can enter change and delete data from the workbook without connect
65. p worksheet IP_BACKUP Sheet fn 12 11 2010 17 45 38 02040 Sync_Download_Remove_backups Deleting backup worksheet 1P BACKUP Sheet3 fn 12 11 2010 17 45 38 03841 Utility ProtectWorkbook Protecting worksheet Sheet 1 12 11 2010 17 45 38 05041 Utility Protect Workbook Protecting worksheet Sheet 12 11 2010 17 45 36 06241 Utility Protect Workbook Protecting worksheet Sheet 12 11 2010 17 45 38 78246 Post operation worksheet order CORRECT 1 1P REPOS 12 11 2010 17 45 38 79346 Post operation worksheet order CORRECT 2 IP_EMPTY 12 11 2010 17 45 38 80546 Post operation worksheet order CORRECT 3 layout 12 11 2010 17 45 38 cie Post operation worksheet order CORRECT 4 Sheet 1 SL ES Mai operatio worksheet LALARNI LEME 5 Sheet 1 3 Examples 1 3 1 Calculation model Development of a model Oa Xd gG ostenbatenmetscenarios xls Compatibility Mode Microsoft Excel aE T abe Home Insert Page Layout Formulas Data Review View Developer Add Ins Invantive Producer Modeller Patrick Hofman Invantive 50 Sync P ndin ng Liblis Paramete Add emove Choose System User Preferences Help Change Values ow ow a Value Development psc 7 itiwana Publishing ___ Model Information BlockActions F ions _ Connection x Invantive test model 1 KS A ines mary 2 be W wy k Variabele kosten Loonkosten per uur Materiaalkosten 13 Materiaal per eenheid 14 Kostp
66. r 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 wherever 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 w ritten permission Forw ritten permission please contact teodord users sourceforge net 5 Products derived from this 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 MERCHANTABILITYAND FITNESS FORA PARTICULAR PURPOSE ARE DISCLAIMED INNO EVENT SHALLTHE APACHE SOFTWARE FOUNDATION OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT INDIRECT INCIDENTAL SPECIAL EXEMPLARY OR CONSEQUENTIAL DAMAGES INCLUDING BUT NOT LIMITED TO PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES LOSS OF USE DATA OR PROFITS OR BUSINESS INTERRUPTION HOWEVER CAUSED ANDON ANY THEORY OF LI
67. r localhost Database database Uid userna me Pwd password provider MySgql Data MySglClient gt lt connection gt lt connection name Oracle gt lt database connectionString Data Source localhost User Id username Pass word password provider Oracle DataAccess Client gt lt connection gt lt group gt lt connections gt gt lt connections default Customer A Production forceDefault false gt lt group name Customer A gt lt connection name Production gt lt database connectionString Data Source authenticationServer User Id user name Password thepublicpassword Pooling false provider Invantive CustomerA Acti veDirectory gt lt failover gt lt 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 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 Invantive Webservice The possibilities are described in the sample file providers xml sample lt xml version 1 0 encoding utf 8 gt nn C 2004 20
68. re B V Demonstrates use of the Invantive Producer Excel Addin Statistieken Feiten voor het laatst gedownload op 28 9 2010 15 25 01 Feiten laatst geupload op 8 9 2010 14 41 55 Laatst geopend door psc op WS23 Laatst bijgewerkt door psc op WS23 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved EEN Invantive Control User Manual The meaning of the entry fields is Name The name of this model Version Author The author s of the model Password The password for the security of the Excel w orkbook access Edit pass The passw ord to edit the model editor or to see the model editor w ord Allow chan When checked it is allow ed to make changes outside of the blocks ges outside blocks Description The description of the model Copyright The copyright of the model Comments Explanation of the model The meaning of the other fields Statistics This field show s the follow ing statistics e Date at which the facts were last dow nloaded e Date at which the facts were last uploaded e Server and username w ith which the model w as opened the last time e Server and username with which the model w as edited the last time Parameters In the you can specify a filter for the model with parameters By specifying and using a fil ter you ensure that only data from the database is retrieved which comply with the settings of the filter You can use a parameter for filteri
69. rijs 15 Verkoopprijs 795 1295 2 195 Aanpak 2 Aanpak 3 16 Winst per eenheid 17 Geproduceerde eenheden 18 Totale winst per model Add an ERD diagram C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 1 3 2 Working Offline 1 3 3 Data management Another example to uselnvantive Control for managing data CRM data e Organizations e Persons Data entry and updating large blocks of data Ca a Mr Invantive Control U 7 Gad Home Insert Page Layout Formulas Data Review View Developer Add Ins S ms e Invantive test model 1 F d X be 7 A Patrick Hofman Invantive So Sync Pending Publish Parameter Add Remove System User Preferences Help v Changes 1 Values Row Row bubs wis25 v Synchronization Publishing Model Information Block Actions Connection Help Invantive Producer D3 ele lele ie BEE Sale K jw C 1 4 Vers lt Gal Madeller Acrobat Team NIEUW Telefoon Aarde consult Acme BY Agency Entertainment ANWB Arcadis AXA AYA A73 Infocentrum Balance Beaufort installatietechniek Bloembinderij Bloemen Piet Borchhuis systemen Bouw international BOVAP Pending Changes Primair Contactpersoon K Simons Telefoonwerk Adres Postcode 088 6647111 Bergselaan 3 3037 BA 31 321661144 Schagchelstraat19 2011 HW 0900 ROXTEC Rode St
70. rmulas that dynamically decide which other cells should use it e High processing speed with larger amounts of cell references in Excel e Increased integrity of data due to simpler formulas e Develop advanced models fast and easier Functioning The syntax of a cell reference is C Pivot method Block Worksheet Column 1 Row 1 Co lumn 2 Row 2 Component Required Description Pivot method Yes L starts w here de range begins Block Yes The block where the values are copied from and those are configured in Blocks 24 Sheet The sheet w here the reference refers to Colum 1 __ Yes Row 1 Yes The row where the expression refers to Column 2 The range of the column can be indicated w ith the second column Row 2 No The range of the row can be indicated with the second row Where the following possibilities are available Component Options Additional Op Explanation tion E As in the block indicated Block The current block Block Name Name of the block Sheet n Current sheet sheet Name Name of the sheet A First sheet Last sheet Column 1 l Current Column Column Name 1 Name of the column as shown in the block First column of the block Last column of the block Row 1 In Current row Column 2 Current Column Column Name 2 A Name of the column First column C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved JL Invantive Control E Last co
71. rogramma Eila EJ Bestand Bewerken Editor Database venster Help 5 Uitvoeren ed Exporteren Select from bubs gesprekken where id 68 Resultaten DBMS Uitvoer Uitleggen Plan Spoor Historie E ld 0 Parent 1 Depth 0 Operation SELECT STATEMENT ALL ROWS Cost CPU Cost 9241 10 Cost 1 Cardinality 1 Bytes 509 E Id 1 Parent 0 Depth 1 Operation TABLE ACCESS BY INDEX ROWID lt TABLE USR_JDZ_BUBS BUBS_GESPREKKEN gt ANALYZED Cost 1 CPU Cost 9241 10 Cost 1 Cardinality 1 Bytes 509 ld 2 Parent 1 Depth 2 Operation Indes UNIQUE SCAN lt 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 Pa Invantive ision Query programma isl E Bestand Bewerken Editor Database Wenster Help 1 select from bubs taken v ia Uitvoeren el Exporteren lt Resultaten DBMS Uitvoer Uitleggen Plan
72. rtificates 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 f 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 e 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 n Invantive Control User Manual ie e Start Microsoft IIS through inetmgr e 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 lf 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
73. se venster Help M Uitvoeren pfExpol 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 M Uitvoeren gd Exporteren SQL gebied Sessies Venster Help Databasesessies C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Jr Invantive Query Tool REN 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 sqlarea_r where 1 1 order by elapsed time desc Sessions Database session Menu Help Pa Invantive Vision Query programma Bewerken Editor Database Venster Help Bestand ka Uitvoeren ed Exporteren lt 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 ision Query programma Bestand Bewerken Editor Database Venster Help Exporteer naar Microsoft Excel Exporteer naar Adobe PDF Exportee 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 lf the editor contains a valid query this will lead to output in different tabs under the tab Out put
74. 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 to Connect to the authenticationServer Active Directory server x 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 lt connections default Customer A Production forceDefault false gt lt group name Customer A gt lt connection name Production gt lt database connectionString Data Source authenticationServer User Id user name Password thepublicpassword Pooling false provider Invantive CustomerA Acti veDirectory gt lt failover gt lt database connectionString Data Source localhost User Id username Pa
75. sical 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 Netherlands All rights reserved se Invantive Control User Manual k Attributes MconnectionString the ADO NET connection string for the specified provider You can specify Data Source User Id and other
76. ss 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 SOL Server database when connection SOLServer is selected Connect to the Oracle MySQL server when connection MySQL is selected x Connect to the Oracle RDBMS server when connection Oracle is selected lt connections default Customer A Production forceDefault false gt lt group name Customer A gt lt connection name DB2 gt lt database CONNECTIONS LPING server local host Database ThE DATABASE ULD us ername PWD password CurrentSchema schema provider IBM Data DB2 gt lt connection gt lt connection name SQLServer gt C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Ze Invantive Webservice lt database connectionString Server localhost Database database User Id us ername Password password provider System Data SqlClient gt lt connection gt lt connection name MySQL gt lt database connectionString Serve
77. t 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 mysagl 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 kb9s9ksO aspx File Invantive Data Providers SglServer 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 lt provider gt tag order Sorting order of the provider The higher the value the sooner it is called x file The file name of the provider This can be a path rela
78. tains connections groups C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Webservice Attributes X 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 x 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 x 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 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 phy
79. the Netherlands All rights reserved Invantive Webservice ECE i Oracle Universal Installer Welcome f Ed ORACLE 1 1 g DATABASE A T A BASE Welcome The Oracle Unive rsal Instal iller guides y rou through the Gracie pr roducts a Deinstall Products installed Products 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 62 Invantive Control User Manual a Oracle Universal Installer Select Installation Type gt ORACLE 1 T DATABASE A T A B A 5 E Select Installation Type a a Installed Products f Bac Next Install Cancel 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 ae Invantive Webservice 6 9 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 Slovenian Spanish Swedish 2 Thai Traditional Chinese aj Q i OK Cancel e Select OK and then Next We recommend to install the software under c oracle 4 Oracle Universal Installer Specify Home Details
80. the changes that are not yet synchronized with the database C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved JL Invantive Control Invantive Producer Modelbewerker File Help ed Opslaan Toevoegen Uitstaande Wijziging Verwijder Uitstaande Wijziging AR Eai SID P gh OO a a Vat ne In this screen you can delete pending changes Select a pending change and then delete it by selecting the button Delete Pending Change E Invantive Producer Modelbewerker Bijwerken Datum eerste wijziging 28 9 2010 15 41 50 Eerst gewijzigd op WS23 Datum laatste wijziging 28 9 2010 15 41 50 pen PM ed PDP 6b aa P Do 1 2 4 2 Cel reference Expression The goal of the function cell reference expression is to be able to save normal cell referen ces dynamically in the model in Microsoft Office Excel A cell reference refers to a cell or cell range on a worksheet and can be used in a formula so values or data that you want to cal culate can be sought for in Microsoft Office Excel Invantive Control Excel automatically con verts the predefined cell reference expression to the cell reference that Excel works with The block allows you to specify in a column a cell reference expression to another column After synchronizing a reference to the location in the cells of the column with a cell referen ce expression in Excel where the expression refers Microsoft Office Excel cell re
81. ting to a database using easy connect e Select Next Oracle Universal Installer Configuration Assistants a Eg ORACLE 1 1 DATABASE Configuration Assistants The following configuration assistants will configure and start the components you selected earlier Tool Mame Type Oracle Client B Oracle Net Configuration Assistant Cancellec Recommended 4 J Bety sor ml ae l l d atails CP ranr entor 1 33 33P log an _ Configuration assistant Oracle Met Configuration Assistant was canceled C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 6 Invantive Control User Manual e Close the error message about the failure of the Oracle Net Configuration Assistant e Select Exit pen Oracle Universal Installer End of Installation ORACLE 1 1 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 N Gx Install Oracle Client Configuration Follow these steps to configure the Oracle client e Construct if not available yet a tnsnames ora configuration file e In 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 o
82. tive 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 ina file that contains multiple providers The elements of the lt provider gt 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 Jr Invantive Webservice 59 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 en lt provider order 999 file C ws distribute invantive sdk Invantive Data Providers Logging dll class Invantive Data LoggingProvider gt lt lo
83. trieve data and edit in formation e Compliance with ISO 27002 with Excel 1 1 Description This chapter describes the concept the functioning and the scope of the applicationinvanti ve Control 1 1 1 Concept Invantive Control has the following concepts e i Model e E Block e Parameter e Extension e APending Change e amp Synchronize The figure shows an overview of the concepts and the relationships between concepts Invantive Producer Excel Add in Invantive Estates tam Invantive Producer _ O Model A model is an representation of an formula in the format of Invantive Control The formula uses input parameters in the form of data of a database Subsequently these input parame ters are processed by Excel expressions and the result will be displayed The input parame C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Control User Manual do ters can be changed added or removed The changes will have an effect on the database One example is that the model contains the definition of all organizations from a business object See Model Editor 19 for more information H Block A block is a continuous area in an Excel worksheet A block contains data of a database re trieved by a query at the last synchronization and contains data that needs to be saved du ring the next synchronization A block uses one of the dimensions cell co
84. ts hubs gebruikers w gbr hubs leveranciers Y lyr gbr lvr id lvr lvr id 1 Z 3 4 5 D 5 5 g organisatienaam Iwr LE naam persoon ev functie organisatienaam Food and more 1 item organisatienaam Janssen Witgewerzorganizatie 3 terms 1 Hoef van der Engineer Amerstoort 2 Aeilkema E Dorm Consultant Exact Amersfoort Regiomanager Amerzfaart organisatienaam Piet Wan Den Herck bra 1 item organisatienaam OT Design 2 terms B Betrokken Rijen 39 MS 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 2 Vv gbr_ aanmeld code X P gbr_accordeur wen vlag gt vY gbr_achternaam v qbr administrateur vlag gbr_ lt Heunen Heunen Heunen Heuvelman Heuvelman Heuvelman Hoef van der Hoef van der Hoef wan der Hoekstra Hoekstra Hoekstra Hoot wan Hoof wan Hoot wan Houben Jalkema Marcel Janssen Jassen Jang de Jongen Ketelaar Klaassen Kooman Koopman Krekelmans EU pers Lange de Houben Jalkema Janszen dassen Jong de Jongen Ketelaars Klaassen Kooman Koopman Krekelmans KU pers Lange de N N T N N N T N HN N T N T N HN N H H Houben Jalkema Janssen Jassen Jong de Jongen Ketelaars Klaassen Kooman Koopman Krekelmans Kupers 2 Z SSS e
85. ts reserved Invantive Control User Manual Index NET 71 _4 404 50 405 50 _cC Certificate 53 Channel 48 72 Company network 47 Connection 72 Connection Configuration Invantive Producer 54 Contact Information Invantive Software BV 72 D Data 48 Database platform 49 Dbms export 42 Delete 39 Error 404 50 405 50 Exchange 47 Explanation of the plan 42 B a Failover 49 File format 41 H Harderwijk 72 http 48 https 48 IBM DB2 71 IBM DB2 for Windows 49 Insert 39 Installation 50 oracle client 60 tunneling web service 50 Invantive Control 1 system requirement 5 Invantive control block access control 21 active 21 code 21 comments 21 name border range 21 name data range 21 Invantive control business object datatype 21 default value 271 formula 21 label plural 21 label singular 21 layout range 21 list code field 21 list description 21 list source 21 name 21 position 21 read only 21 sync back 21 Invantive control calculation model Invantive Control concept block 1 concept 1 extension 1 functioning 1 model 1 parameter 1 pending changes 1 scope of the application 1 synchronize 1 invantive control configuration available connection 13 Configuration file 13 debug mode 13 development mode 13 installation location 13 3 32 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved invantive control configuration setting 13 target dire
86. ve Software BY is tevens leverancier van Invantive Vision Invantive Vision Is een projectmanagement systeem dat voornamelijk geschikt is voor architectenbureaus T bedrijven en dienstverleners in detachering en consultancy Projectontikkeling is een risicodragende dienstverlening De dienst bestaat uit het ontwikkelen wan vastgoed in de vorm van terreinen gebouwen of andere vormen van vastgoed zoals parkeergelegenheid Het ontwikkelen van vastgoed Is een activiteit die in verschillende wormen beoefend kan warden e De ontwikkeling van een project gebeurt binnen een speciaal voor dit doel opgerichte juridische eenheid waarin de verschillende betrokken partijen op basis van een overeenkomst samenwerken Behalve het ontwikkelen van een project zi K L c EL lam nr erle ben r c pn a red CAF ar clar artn AIE Er en mt ren t cled cea lers Minas P m 1 d aan aa 1 2 4 User Interface Model Developer This section explains how a model developer can use Invantive Control via the ribbon but tons in Microsoft Excel The model developer can use the same functions as the model user only the developer can also customize the model The following figure shows the tab Modeller with the buttons that the model developer can use This section gives the function for each button vld eae CRM Excel VO ixisx Microsoft Excel 3 Home Insert page Layout Formulas Data Review View Developer Addins InvantiveProducer Modeller Acrobat Team 7 x
87. ve Control 19 tains the following buttons e D Repository Worksheets shows the hidden worksheets The repository contains a work book with the model database and a blank worksheet see Repository Worksheets 30 e PP Show Trace opens a window with debug and analysis This screen can be used to analyse any possible malfunctions of lt Invantive Control see Show Tracel 31 e 3 Mark Row as New mark this row as new so it will be inserted in the knowledgebase at the next synchronization This function can be used when copying data between two know ledgebase 1 2 4 1 Model Editor The settings of the model such as the name version author password etc are stored In the model editor Here you can also enter modify and delete parameters blocks and exten sions There is also an overview of pending changes If a password is set for editing the mo del you will be prompted when selecting the button Edit Model see figure Yoer model wachtwoord in Het model it beveiligd met een wachtwoord Yoer s v p het wachtwoord in om toegang te krijgen tot het model Wachtwoord me The picture shows the screen of the model editor Invantive Producer Modelbewerker Toevoegen model Verwijder Model lt e Naam Auteur Pieter Schouten Bedrijf invantive Software B V Toegangscontrole Wachtwoord toegang j Wachtwoord bewerken p Sta wijzigingen buiten blokken toe 2004 2010 Invantive Softwa

Invantive Control User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents