Invantive Studio User Manual
Contents
1. 16 Database platfOfMS sieraad aa akaa EK ayaan Eiaa ania 17 Redundante sarsii 17 InstallatlOn i oret sete riso a aaea e EE a Eea Eaa 18 Invantive Webservice Programming ccsscccsssscesseeeeseeeeseeesseeeeseeensaaeessaeeeseaensaesessaeeeseeeasaaseenaeeesaeeeeeeeeenaee 18 STUUR En 21 Connection CONMMOUFALON cassecssnesexciucsestecesesasexesacustacsssersacssusecsavencevseuessectaraseesavisesieeveoss vussadusucnexssetstueeseseuvecs 22 Providers Configuration ull c M M S Terminology zeen irre titre Euer EEren Eir dee deente seeedasctcetiegencesi ice jn Connection jJ Release 2014 RA Contact Information 40 Index 42 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 1 Invantive Studio User Manual rA 1 Invantive Studio Customized software development with Invantive Studio Invantive Studio is a software development environment for the modelling and development of high quality company software and customized applications The model driven develop ment environment makes it possible for you to develop and implement customized software solutions within your company rules Invantive Studio offers y2. 2 2 3 1 Query results Executing a query results in filling the tab Output with the records delivered by the query C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved A Invantive Query Tool E Pa Invantive Vision Query programma ioi xi Bestand Bewerken Editor Database Venster Help ae Uitvoeren ipd Exporteren al select from bubs taken v Resultaten DBMS Uitvoer Uitleggen Plan Spoor Historie Sleep een kolom hierheen om te groeperen op die kolom tak_nk XY tak bedrag vaste pis X V tak code 5 7 tak datum bijgewerkt omlaag 5 V tak datum dfi 10 8 2007 8 20 29 d 15 6 2009 18 27 18 7 8 2007 15 42 53 4 10 2007 14 23 50 5 704 Betrokken Rijen Also the number of rows and the execution time will be displayed 2 2 3 2 DBMS output This tab includes the output of dbms output put line statements only in combination with Oracle RDBMS 2 2 3 3 Explain Plan The Explain Plan can be executed using the menu item Explain Plan or using the key com bination Ctrl E Pa Invantive Estate Query programma Bestand Bewerken Database Venster Help Mi Uitvoeren g Expoi Uitvoeren F9 1 Select Uitleggen Plan _Ctrl E 2 from bubs telefoon contacten r 3 where vda ref sleutel 58 The executing of Explain Plan ensures the filling of the tab Explain Plan with the rows which are completed by the Explain Plan of Oracle C Copyright 200
3. 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 and applications based on Invantive Producer can exchange data with databases and other services using the internet or the company network It is also possible to use these applications without Invantive Webservice but for installations with more than one user this is strongly discouraged With the Invantive Webservice it will ta ke no time outside of the client installation to allow an extra user or PC to make use of a da tabase without the Invantive Webservice this will take considerably more time for each PC and or user The exchange of data happens through webservices that use the so called http and or https protocol Depending on the chosen security model you can exchange data with databases in the company network using the Invantive webservice both within the company network as well as on the internet from Invantive applications and applications based on Invantive Produ cer You can also if authorized exchange data with databases at various companies With this you can easily collaborate with multiple clients and or relations in an e
4. 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 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 IIS preferably webservice within the folder of the application or alternatively c inetpub wwwroot invantive webservice c inetpub wwwroot lt OMGEVING gt ws or preferably ENVIRONMENTDIR webservice 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 19 Invantive Studio User Manual Tum e Start Microsoft IIS with inetmgr or through Control Panel e Select Properties from the folder e Convert the folder to application with an own application pool Site name Default Web Site Path Alias Application pool MEE Perata set Example sales Physical path Ci inetpub wwwroot qbubs ws eti Pass through authentication Connect as Test Settings e Set the application in for use of the application pool ASP NET v4 0 Edit Application Pool 21 x
5. 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 more outside of the office For companies this means that work processes are assigned differently and should be optimized To allow for the work pro cesses to run as efficient and effective as possible it is required to have quick and safe ac cess to the company network through the Internet Webservices make it possible for companies to organize work processes through the Inter net even smarter By providing access to the company network and applications using web services it is possible to coordinate and optimize processes from each location 3 2 Advantages The Invantive Webservice offers various advantages e The Invantive Webservice makes it easy to quickly and safely exchange data through the internet between various databases and services For companies this means that the exe cution of financial calculations and the manufacturing and recording of contracts is availa ble from every location the Invantive Webservice allows different companies to work to gether more effective and more efficient within a project That is bec
6. Invantive Studio Manual Fi invantive d B Erato and Fin Copyright C Copyright 2004 2013 Invantive Softw are B V the Netherlands All rights reserved Alle rechten voorbehouden Niets uit deze uitgave mag w orden verveelvoudigd opgeslagen in een geautomatiseerd gegevensbestand of openbaar gemaakt in enige vorm of op enige w ijze hetzij elektronisch mechanisch door fotokopieen opnamen of enig andere manier zonder voorafgaande schriftelijke toestemming van de uitgever Ondanks alle aan de samenstelling van deze tekst bestede zorg kan noch de schrijver noch de uitgever aansprakelijkheid aanvaarden voor eventuele schade die zou kunnen voortvloeien uit enige fout die in deze uitgave zou kunnen voorkomen Deze handleiding is een naslagw erk bedoeld om het gebruik te verduidelijken Indien gegevens in de voorbeeldaf beeldingen overeenkomen met gegevens in uw systeem dan is de overeenkomst toevallig Auteurs Jan van Engelen Michiel de Brieder Mathijs Terhaag Tanja Middelkoop Guido Leenders Tatjana Daka The JasperReports License Version 1 0 Copyright C 2001 2004 Teodor Danciu teodord users sourceforge net All rights reserved Redistribution and use in source and binary forms w ith or w ithout modification are permitted provided that the follow ing conditions are met 1 Redistributions of source code must retain the above copyrightnotice this list of conditions and the follow ing disclaimer 2 Redistri
7. 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 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 Jr Invantive Webservice E 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 Bestand Bewerken Beeld Favorieten Extra Help GQ ee Bp zoeken j gt Mappen Tr O Finance win32_11gR1_dient dient Type Bestands en maptaken Bestandsmap 5 3 2009 10 49 mj Dit bestand een andere naam Bestandsmap 5 3 2009 10 48 geven Bestandsmap 5 3 2009 10 49 gy Dit bestand verplaatsen Bestandsmap 5 3 2009 10 51 A Dit bestand kopi ren Toepassing 12 2 2009 13 21 Configuratie instellingen 12 2 2009 13 21 Dit bestand op het web e publiceren HTML Document 12 2 2009 13 21 Dit bestand per e mail verzenden XK Dit bestand verwijdere
8. 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 Invantive Webservice mo Attributes ConnectionString the ADO NET connection string for the specified provider You can specify Data Source User Id and other settings provider the name of the ADO NET connection provider For example Oracle DataAccess Client The failover level The failover level can define a list of database or webservice settings It supplements the webservice database element Connection settings defined in a failover can be used to have a failover connection when one connection cannot be established This can be useful when relying on a internet connection or presence of a VPN tunnel Settings defined in this section will be evaluated one after another starting top down When any of the failovers can be established no other failovers will be tried Attributes none Examples This example illustrates a single connection The software will sequentially try EOS Connect to the authenticationServer Active Directory server Connect to one of the connections in the failover First the database connection when connection from the internal network or VPN The first webservice connection The second or failover webservice connection
9. 11 1 0 dient_1 oo4o mesg ab ORACLE_BUNDLE Enterprise CA Macromedia H E Microsoft abjoracte_GROUP Oracle OraClient11g_home1 m MozillaPlugins ab ORACLE_HOME c orace product 11 1 0 dient_1 a opc ab ORACLE HOME SOFTWAREYORACLE EY OraClientiig homei a ORACLE BBjoRACLE HOME OraClient11g_home1 ex KEY_OraClient1ig_home ab sQLPATH c pracle product 11 1 0 dient_1 dbs 5 OLEDB lab stmtCacheSize 0040 H ODP NET H Policies Z3 Program Groups H E Realtek e Add a string with the name TNS ADMIN and make it point to the network location C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Webservice Register editor Bestand Bewerken Beeld Favorieten Help Hewlett Packard Gegevens Z3 Hitman Pro geen waarde ingesteld HP OLS t c orade product 11 1 0 dient_1 MSHELP a s ab nLs LANG is DUTCH THE NETHERLANDS WE8MSWIN 1252 CI JavaSoft ab OLEDB xd e 1n nt 1 oledb mesg Z3 Logitech labjoo40 Int 110040 mesg 53 Microsoft abJORACLE GROUP REG SZ Binaire waarde a Mozilaplugins ab ORACLE HOME REG SZ DWORD waarde ht 1 opc abJORACLE HOME REG SZ Waarde met meerdere tekenreeksen aClientiig homei ORACLE abJORACLE HOME REG SZ Waarde met uitbreidbare tekenreeks EA KEY_OraClient11g_home1 ab SQLPATH REG_SZ Crrade produc T U dient_1 dbs oB ab stmtcacheSize REG_SZ 0 0040 H ODP NET H E Policies
10. IBMDB2 ook via ODBC mogelijk maken maken 22594 ER Ondersteuning voor redundante verbindingen failover 23279 PR Onder specifieke condities treedt een Byte error op bij gebruik van de webservice Installation e No specialties Implementation e No specialties 4 Contact Information Invantive Software BV Location Harderwijk Stephensonstraat 3b 3846 AK Harderwijk the Netherlands Phone 31 88 0026500 Fax 31 84 2258178 E mail info invantive com C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved KEN Invantive Studio User Manual We Web www invantive com Route Follow the instructions of your navigation system The offices are located above Carglass Parking spots are on the right side Parking spots are indicated with a sign with Invantive C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Index NET 39 404 18 405 18 CASE 1 Certificate 21 Channel 16 40 Company network 15 Connection 40 Connection Configuration Invantive Producer 22 Contact Information Invantive Software BV 40 D Data 16 Database platform 17 Dbms export 10 Delete 7 E Error 404 18 405 18 Exchange 15 Explanation of the plan 10 ibis Failover 17 File format 9 H Harderwijk 40 http 16 https 16 IBM DB2 39 IBM DB2 for Windows 17 Insert 7 Installation 18 oracle client 28 tunneling web service 18 I
11. Le A d rv 3 Dete Gr are Styles 7a Sor amp Find amp 60 0 E Format A gt Filter Select r Clipboard 5 Font Alignment Number z Cells Editing Al id f organisatienaam Food and more 1 item g 12 i B C D rs m organisatienaam Food and more 1 item E n 12 3 persoon functie plaats 4 Born van der Accountmanager Amersfoort 5 G organisatienaam Janssen Uitgeversorganisatie 3 items 7 8 persoon functie plaats 189 Hoef van der Engineer Amersfoort 1 Aeilkema Regiomanager Amersfoort e 144 Dorn Consultant Exact Amersfoort 12 13 organisatienaam Mekra 1 item 17 18 organisatienaam Piet Van Den Herck bna 1 tan 22 23 organisatienaam OT Design 2 items M 4 F hil Sheets PJ IIML u Ready RII HJ 10096 1J e The image shows the result of the SQL query in Adobe Acrobat File Edit View Document Comments Forms Tools Advanced Window Help x mc Ries 2 f g 4 2 2 Boole a m 5 Find y functie Food and more 1 item Accountmanager Janssen Uitgeversorganisatie 3 items Engineer Regiomanager Consultant Exact Mekra 1 item Communicatie Piet Van Den Herck bna 1 item Sr Channel Manager General Business Sales Amsterdam QT Design 2 items Helpdesk Teamleider Amersfoort Account Manager Amersfoort i260x926in a C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Studio Us
12. Program Groups Realtek a ee a REI REI E Deze computer HKEY_LOCAL_MACHINE SOFTWARE ORACLEKEY_OraClient11g_home1 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 Register editor Bestand Bewerken Beeld Favorieten Help CJ Hewlett Packard A Naam Gegevens c1 Hitman Pro ab Standaard geen waarde ingesteld ante ab MSHELP_TOOLS c oracle product 11 1 0 dient_1 MSHELP C HPQ Intel a ab OLEDB c orade product 11 1 0 dient_1 oledb mesg Logitech ab oo40 c rade productM 1 1 0 dient_1 oo4o mesg Z3 Macromedia ab ORACLE_BUNDLE Enterprise Z3 Microsoft abJORACLE GROUP Oracle OraClient11g_home1 Z3 MozillaPlugins ab ORACLE_HOME c orade product 11 1 0 dient_1 zy opsc ab ORACLE_HOME_ SOFTWAREYORACLEWEY OraClientiig homei ORACLE abJORACLE HOME OraClientiig homei AN KEY OraClientiig homei ab soLPATH c oradeproductM 1 1 0 dient_1 dbs zy OLEDB ab StmtCacheSize 0 0040 o finance a ODP NET CQ Policies Program Groups CJ Realtek m A EE EE RE E De Deze computer HKEY_LOCAL_MACHINE SOFTWARE ORACLE KEY_OraClient11g_home1 e If you use Oracle Instant Client then there is no NLS LANG in the Windows registr
13. 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 Venster tal Uitvoeren gd Exporteren SQL gebied Sessies Databasesessies Help C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved KR Invantive Studio User Manual Mo This menu consists of three specific database menu items SQL area This menu item places the following query in the editor select from itgen db sglarea r where 1 71 order by elapsed time desc Sessions Database session Menu Help Va Invantive Vision Query programma Bestand Bewerken Editor Database Venster Help t Uitvoeren gd Exporteren Inhoud _ Shift F1 1 Using this menu the Help for the Query Tool can be requested as part of the Invantive Vision Help Export Menu Pa Invantive Vision Query programma Bestand Bewerken Editor Database Venster Help i Uitvoeren l Exporteren Exporteer naar Microsoft Excel Exporteer naar Adobe PDF Exporteer naar Microsoft XPS Afdrukken be pre Using the Export tab you can print the output of queries or export it to different formats 2 2 3 Query output The query output can be started with the function key F9 If the editor contains a valid query this will lead to output in different tabs under the tab Out put
14. gt lt serviceurl gt http localhost ThisIsAnExmaple Service svc lt serviceurl gt lt provider gt lt providers gt gt lt providers gt lt Custom logging gt SF lt provider order 999 file C ws distribute invantive sdk Invantive Data Providers Logging dll class Invantive Data LoggingProvider gt lt log gt C temp invantive logging log lt log gt lt provider gt gt lt Most preferred provider due to order 400 Data access provider for Invantive Estate and or Invantive Vision Generates an Oracle SQL execute request Invantive Estate and Invantive Vision currently only support the Oracle RDBMS gt T Xprovider order 400 file Invantive Estate Data Provider dll class Invantive Estate Data InvantiveEstateDataProvider gt gt lt Less preferred provider due to order 300 Data access provider for Invantive Producer products The following Invantive Producer products require the use of Oracle RDBMS Invantive Studio Invantive Query Tool The following Invantive Producer products run with all supported database platforms although this specific provider does not yet support it Use a database specific provider instead Invantive Composition Invantive Control gt Sez lt provider order 300 file Invantive Producer Data Provider dll class Invantive Producer Data InvantiveProducerDataProvider F gt gt lt providers gt 3 7 5 Providers
15. instead of a database connection by default The providers tag contains a list of providers available each one consisting of the provider tag Attributes of the provider tag order Sorting order of the provider The higher the value the sooner it is called file The file name of the provider This can be a path relative to the Pro viders directory or an absolute path Fully specify the path or use a path relative to the Invantive Webservice in stallation folder Do not use the ASP NET IIS prefix to indicate the current folder Class Optional Full class name of the provider You can specify the class name to increase startup performance since it reduces the time needed querying the file You need to specify the class if you want to load a single provider in a file that contains multiple providers The elements of the provider tag All you can specify elements within the provider tag See for instance the lt templatesfolder gt element in the example below Their names and values will be passed as attributes to the provider during in stantiation Example lt providers gt lt provider order 998 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Studio User Manual Me file C ws distribute invantive sdk Invantive XXX Provider dll class Invantive XXX Provider Provider gt lt templatesfolder gt C temp templates lt templatesfolder
16. 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 a gt C 2004 2013 Invantive BV the Netherlands www invantive com Header http svn invantive com repos pl04 trunk help nl manual Topics bubs Providers Configuratie xml 23549 2013 11 01 14 21 27Z smoke Configuration of providers for Invantive Webservice Purpose You can configure providers here sorted by order Providers are tried to handle a request in decreasing order So the provider with order 500 is offered the request before the provider with order 400 is offered the request Providers with order 70 80 90 100 and 200 are reserved for Invantive internal use see the table below Explanation Providers are used to provide functionality that is not part of the webservice A provider knows how to handle a specific action on a specific platform Some providers are included in the installation such as providers for database or webservice connectivity or a file logging provider The default providers are included in the software so they are not listed here between the providers tag A provider does in general NOT define WHERE the action will be executed That is normall
17. products such as products iv products ie Invantive Control and Invantive Composition With the Invantive Query Tool you can 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 Retrieve old queries from a file or from the list in the tab History 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 Request the output of dbms output itgen output and itgen log of an Oracle PL SQL block only in combination with Oracle RDBMS e Retrieve an execution plan query plan or explain plan of an Oracle SQL query only in C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 3 Invantive Studio User Manual A 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 in
18. 4 2013 Invantive Software B V the Netherlands All rights reserved aa 5 Invantive Studio User Manual Mo Fg Invantive Estate Query programma lof xi Bestand Bewerken Editor Database Venster Help gg Uitvoeren ed Exporteren Select from bubs gesprekken where id 68 Resultaten DBMS Uitvoer Uitleggen Plan Spoor Historie E Id 0 Parent 1 Depth 0 Operation SELECT STATEMENT ALL_ROWS Cost 1 CPU Cost 9241 10 Cost 1 Cardinality 1 Bytes 509 E Idi Parent Depth 1 Operation TABLE ACCESS BY INDEX ROWID TABLE USR_JDZ_BUBS BUBS_GESPREKKEN gt ANALYZED Cost 1 CPU Cost 9241 10 Cost 1 Cardinality 1 Bytes 509 Id 2 Parent 1 Depth 2 Operation Index UNIQUE SCAN INDEX UNIQUE USR_JDZ BUBS BUBS_GSK_PK gt ANALYZED Cost 0 CPU Cost 1050 10 Cost 0 Cardinality 1 Bytes 0 44 Betrokken Rijen In the tab the way the query will be executed by Oracle is shown in tree form With this the to be executed actions are in order of the ID so from a branch with the deepest level back to the parent level and back to a related level this is called Processing in Order 2 2 3 4 Trace This tab contains the result of an Oracle trace only in combination with Oracle RDBMS 2 2 3 5 History executed queries Executing a query ensures the filling of the tab history because the data of the last executed query is added Pa Invantive Vision Query programma Fei fan Ea Bestand Bewerken
19. Editor Database Venster Help it Uitvoeren ed Exporteren 1 select from bubs taken v Resultaten DBMS Uitvoer Uitleggen Plan Spoor Historie Bleep een kolom hierheen om te groeperen op die kolom Uitvoeringstid EV BetrokkenBien EV Startuitvoerng EV SQL tekst 28 911 s 5 704 172 2011 13 48 select from bubs taken v 15 551 s 6 617 172 2011 13 47 select from bubs_leveranciers_v 385 ms 17 2 2011 13 47 select from bubs_units_v 3 301 s 172201 1245 select from bubs_projecten_v 5 704 Betrokken Rijen As long as the Query Tool is open a record is added after each output 2 3 Availability The following Invantive products provide a user license of Invantive Query Tool e products iv products ola C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved PA Invantive Query Tool sm d e nvantive Control nvantive Composition The Invantive Query Tool is also separately available and can be downloaded via the link http webservice invantive com qt publish htm 2 4 System Requirements To use Invantive Query Tool on your PC or terminal server you will need the following soft ware including licenses Microsoft NET 4 5 Minimum 2 GB of internal memory e Screen resolution of 1280 x 1024 or higher e Invantive Webservice or local drivers Use on Mac tablet or smartphone is not possible 2 5 Installation Perform the next steps to install Invantive Query Too
20. 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 Click on Certificates Local Computer in the middle part of the window e Click on the right on Personal e Select All tasks and then Import e Set up the filter for Personal Information Exchange pfx e Select the pfx bestand as Personal Certificate e Enter the password e lf desired you select the check box Mark this key as exportable e Allow automatic placement in the storage for the certificate based on the type e Select Finish Close the MMC e t is not necessary to save the settings of MMC C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Jr Invantive Webservice EAN 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 set
21. Installer Specify Home Details ORACLE 11 g DATABASE Install Location Specify a base location for storing all gace sotene and sonnouraton relatad f fi ls gle locaton is ihe Oracle Base directory Create c an configuration files let OraClient11g home1 cAoracleiproducti1 1 1 0iclient 1 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved B Invantive Webservice HE e Subsequently a number of checks will be performed If problems are found solve them first Oracle Universal Installer Product Specific Prerequisite Checks ORACLE 11 DATABASE ATABASE Product Specific Prerequisite Checks Checking Oracle Home path for spaces Automatic 4 Succeeded Checking for Oracle Home incompatibilities O Heb Installed Products Install Cancel 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 E Invantive Studio User Manual Mo wi Oracle Universal Installer Summary Summary Oracle Client 11 1 0 6 0 Global Settings Source O Financeiwin32_11gR1_clienticlientistageiproducts xml Oracle Base c oracle Oracle Home cAoracleiproducti 1 1 0 client 1 OraClient11g home Installation Type Administrator Product Languages Arabic Bengali Brazilian Portuguese Bulgarian Canadian French Cata
22. M Managing Director Guido Leenders Registered office Hierden
23. N 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 D Ai J Contents 1 1 1 2 1 2 1 1 3 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 Invantive Studio 1 Ihubgbj 1 UC EEE 1 Release 2014 Riise R O a EA 1 System Requirements nsusssasrsenssarsenssananenenanarenseananennsannmensenandennenanmaneanandnnndanndnns 2 Invantive Query Tool 2 Leam SOLE ariens enden PUM CU ol fe oesia2 cus seccetewsices siete anaes cettwcaesatcousrecainscvseptodsccaaduaderepeabeusatneusesan ae uueatn Query Tool Examples eo OLD t PETE Lo A sn System Requirements creer nere rne anita oo snwnnnas wannnnsn Eiin naasse 12 Installation zz oeeervenenterrsonseienenn otiy eua Uu cR DoEE DR RERO DAR CKKSRRRUMR ERR OAEEKDRSXUEEUR AROKER 12 Lili 14 Release 20 Eu 14 Invantive Webservice 15 Web services m m 15 Advantag8S e M 15 System Requirements 952225 ecc tuens sececiasandecedeaseneicnaadecentsseadid dzdgexaeanecceieans 15 CONCE Pb
24. NET Framework version NET Framework v4 0 30319 m Managed pipeline mode Integrated m IV Start application pool immediately cm e Set the standard page Service ashx C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Webservice 20 w Enable default content Neeeeeee nnn nnn nnn nnne nnn nnn nnne L1 d Service svc e You can now test the web service by opening the page You will receive output such as t23522 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Studio User Manual E c Qo ws ita pbubs Service Service You have created a service To test this service you will need to create a client and use it to call the service You can do this using the svcutil exe tool from the command lir svcutil exe http local ws ita pbubs Service svc wsdl This will generate a configuration file and a code file that contains the client class Add the two files to your client application and use the genera ce class Test Static void Main ServiceClient client new ServiceClient Use the client variable to call operations on the service Always close the client client Close Visual Basic Class Test Shared Sub Main Dim client As ServiceClient New ServiceClient Use the client variable to call operations on the service Always close the client client Close End Sub
25. ause 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 the planning of pro jects execution of complex calculation models and the registration of work hours Using the Invantive Webservices the data can depending on the security model be retrieved and processed in the own administration This makes it possible to provide multiple clients and or relations quick and safe access to the company network with the Invantive Webser vice With the Invantive Webservice work processes can be organized even smarter and be op timized The result is the more effective and efficient work on a project 3 3 System Requirements Client C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Jr Invantive Webservice 16 To use Invantive Webservice on your PC or terminal server you will need the following soft ware including licenses 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
26. butions in binary form must reproduce the above copyrightnotice this list of conditions and the follow ing disclaimer in the cumentationand or other materials provided w ith the distribution 3 The end user documentation included w ith the redistribution if any must include the follow ing acknow ledgment This product includes softw are developed by Teodor Danciu http jasperreports sourceforge net Alternately this acknow ledgment may appear in the softw are itself if and w herever such third party acknow ledgments normally appear 4 The name JasperReports must not be used to endorse or promote products derived from this softw are w ithout prior written permission Forw ritten permission please contact teodord users sourceforge net 5 Products derived fromthis softw are may not be called JasperReports nor may JasperReports appear in their name without prior w rittenpermission of Teodor Danciu THIS SOFTWARE IS PROVIDED AS IS AND ANY EXPRESSED OR IMPLIED WARRANTIES INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED IN NO EVENT SHALLTHE APACHE SOFTWARE FOUNDATION OR ITS CONTRIBUTORS BELIABLE FOR ANY DIRECT INDIRECT INCIDENTAL SPECIAL EXEMPLARY OR CONSEQUENTIAL DAMAGES INCLUDING BUT NOT LIMITED TO PROCUREMENT OF SUBSTITUTE GOODS OR SERV ICES LOSS OF USE DATA OR PROFITS OR BUSINESS INTERRUPTION HOWEVER CAUSED ANDON ANY THEORY OF LIABILITY WHETHER I
27. connections default Customer A Production forceDefault false gt lt group name Customer A connection name Production database connectionString Data Source authenticationServer User Id user name Password thepublicpassword Pooling false provider Invantive CustomerA Acti veDirectory lt failover gt database connectionString Data Source localhost User Id username Pass word thepublicpassword Pooling false provider Oracle DataAccess Client gt lt webservice url http www customer a com ws encoding binary compression true gt lt webservice url http failover customer a com ws encoding binary compression true gt lt failover gt lt connection gt lt group gt lt connections gt This example illustrates connections to different database platforms The soft ware will try to Connect to the IBM DB2 UDB database when connection DB2 is selected Connect to the Microsoft SQL Server database when connection SQLServer is selected Connect to the Oracle MySQL server when connection MySQL is selected Connect to the Oracle RDBMS server when connection Oracle is selected connections default Customer A Production forceDefault false gt lt group name Customer A lt connection name DB2 gt database connectionString Server localhost Database THE DATABASE UID us ername PWD password CurrentSchema schema provider IBM Data DB2 gt lt connection gt
28. dvtiirZ invantive local 90 i 91 e This one describes that on the server with IP address 192 168 172 16 on port 1521 a pro gram runs that knows how to make a connection with an Oracle database with the SID dv C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Studio User Manual Mo t11r2 and the global name dvt11r2 invantive com e Full instructions on creating tnsnames ora can be found in the Oracle documentation e Make sure that the tnsnames ora file is located on the same place on all PC s preferably in way to make it easy to add services from a central location For fixed workplaces often a network drive is used for example as follows B Zoekresultaten Bestand Bewerken Beeld Favorieten Extra Help Qoe DD Pader rmm E weg Naam In map O Finance Andere locaties Bureaublad Deze computer E Min documenten Min netwerklocaties Details Zoekresultaten Systeemmap e Open the register with regedit and go to the key HKLM SOFTWARE Oracle KEY_OraC lient11g_home1 5 Register editor Bestand Bewerken Beeld Favorieten Help Hewlett Packard Naam Gegevens Zg Hitman Pro ab Standaard geen waarde ingesteld d Eg HP ab MSHELP_TOOLS c orade product 11 1 0 dient_1 MSHELP 2 i ab NLS_LANG DUTCH THE NETHERLANDS WEBMSWIN1252 ud UE abJoLEps c prade product 11 1 0 dient 1loledb mesg i i Logitech abjooso c orade product
29. ent 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 contains connections groups C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved E Invantive Studio User Manual o Attributes default The default connection The format is group connection the first connection with the given name will be used when the group element is omitted forceDefault If true only the default connection can be used No other connection is eligible for selection based upon this settings xml file You can use for in stance when you add a new default connection and you want to make sure everyone switches to the new connection irrespective of what connection is currently used as default The group level This level defines a set of connections logically grouped together You are free to choose the way of grouping Examples of logical manner of grouping by customer by environment production test Attributes name The name of the group The connection level This level defines an actual logical connection For example Production environment Acme s
30. eo 0 organisatienaam Janssen Uitgeversorganisatie 3 items 1 Hoef van der Engineer Amersfoort 2 Aeilkema Regiomanager Amersfoort 3 Dorn Consultant Exact Amersfoort organisatienaam Piet Van Den Herck bna 1 item organisatienaam QT Design 2 items 8 Betrokken Rijen e Displaying the description of an object using the F4 key This corresponds to the Oracle function Describe The figure below shows the data in the business object persons bub S gebruikers v Pa Invantive Estate Beschrijven bubs gebruikers v DE x Kolom Sleep een kolom hierheen om te groeperen op die kolom gbr_nk Xv gbr aanmeld code X v gbr_accordeur_uen vlag X v gbr_achternaam X VY gbr_administrateur vlag X Y gbr_d Heunen Heunen Heunen Heuvelman Heuvelman Heuvelman Hoef van der Hoef van der Hoef van der Hoekstra Hoekstra Hoekstra Hoof van Hoof van Hoof van Houben Houben Houben Jalkema Jalkema Jalkema Of oo uone CI ro Marcel Janssen Janssen Janssen Jassen Jassen Jassen Jong de Jongen Jong de Jong de Jongen Jongen Ketelaars Ketelaars Ketelaars Klaassen Klaassen Klaassen Kooman Kooman Kooman Koopman Krekelmans Koopman Koopman Krekelmans Krekelmans Kuypers Kuypers Kuypers N N Y N N N Y N N N Y N Y N N N N N Z zZz Z Z Z Z Z Z lt lt z z z z z z lt z Lange de Lange de Lange de C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 5 In
31. er Manual o 2 2 2 Editor In the editor you can execute queries There are five types of SQL statements possible e Select e Insert e Update Delete e PL SQL Begin End without line breaks and blank lines A possible transaction is immediately recorded at the end of the execution of the statement Menu File Pa Invantive Vision Query programma Bewerken Editor Database Venster Help Ctri o Bestand Open Opslaan Ctri 5 Bewaren Als Ctri amp Shift S Afdrukken Ctrl P Afsluiten Col w Here queries can be opened saved saved under a different name and printed In addition via Exit the Query Tool can be closed Menu Editor C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved No Invantive Query Tool EN Va Invantive Vision Query programma Bestand Bewerken Editor Database Venster Help i i uitvoe Teruadraaien Ctrl Z Opnieuw Ctrl V Krippen Chri4 X Kopi ren Ckrl4 C Plakken Ctrl V Selecteer Alles Ctr A Zoeken Ctrl F Vind Volgende F3 Vervangen Ctrl R Ga naar Regel Ctrl G Commentaar Ctrl B Ortcommentaneren Blok CrrH Shift B Hoofdletters Ctrl U Kleine Letters Ctrl L Eerste Letter Hoofdletter Ctrl I Beschrijven F4 The Editor menu contains all items with which you can edit the query text Menu Editor Pa Invantive Vision Query programma Bestand Bewerken Editor Database Venster Help E ga Uitvoeren gj Expoi W
32. es H Invantive Configuration Mel E3 Advanced Retrieve settings from Z ofile settings xml m Number of available connections 23 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved AN 2 Invantive Query Tool EN Next comes the login screen Next enter the username password and connection and se lect OK C Copyright 2004 2011 Invantive Software BV the Netherlands All rights Gebruikersnaam system ss SSOSCSCSCS Wachtwoord pess Verbinding invantive Production LAN of htt f Bewaar wachtwoord Vv Automatisch verbinden o Amten e n order to change the settings of Invantive Query Tool after installation press Crtl when starting up Invantive Query Tool 2 6 Versions This chapter describes the changes in the application per version 2 6 1 Release 2014 R1 Released XX XX 2014 Invantive Producer bXX Changes and bug fixes Invantive Qu dbms output en explain plan in Query Tool ery Tool 2171 PR Invantive Qu Describe werkt niet in Query Tool ondanks rechten op de functie itgen querytool describe 8 ery Tool 1994 B Invantive Qu E meest recente documenten stuk of 10 tonen in Bestandsmenu C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved ae 4 Invantive Studio User Manual e 2 ery Tool Installation No specialties Implementation No specialties
33. fficient 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 connection are is retrieved in a list with available connections and the related possible redundant channels e On the basis of the retrieved preferences and availability a channel is chosen for commu nication e Through this channel a connection is established with the service provided by the webser vice C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Studio User Manual Me e Data and requests are exchanged If the connection drops then the connection is automatically established again A possible al ternative channel for the connection is used if the desired channel is not available 3 5 Database platforms An installation of the Invantive Webservice consists of one or multiple installations of the In vantive Webservice programming In addition to the programming you also need to indicate the connections to databases that can be used through this installation These can at least be the following database platforms e Microsoft SQL Server e Oracle RDBMS e MySQL e IBM DB2 UDB L
34. formation on what SQL is and how it can be used can be found at http en wikipe dia org wiki SQL The manual at http sqlzoo net also provides a good insight and in addition allows for inter active learning of how you can use SQL to retrieve edit and create data SQLzoo net EN i n p oM ET TIE Sam BBC Country Profiles TFURCTONE SET Some examples ol simple warax statements 2 2 Functioning This paragraph describes the functioning of the Query Tool The Query Tool consists of two parts The editor section 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 The figure below shows the request by means of a SQL query of persons grouped by or ganization C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Mo Invantive Query Tool 4 Fa Invantive Estate Query programma OF XI Bestand Bewerken Verbinding Editor Database Venster Help 4 Uitvoeren id Exporteren select gbr gbr_naam persoo gbr gbr_functie functie lvr lvr naam organisat ienaam lvr lvr plaats plaats bubs gebruikers v gbr bubs leveranciers v lvr gbr lvr id lvr lvr id ab 2 3 E 5 6 H 8 9 Resultaten DBMS Uitvoer Uitleggen Plan Spoor Historie lvr lvr naam persoon EY functie EV organisatienaam Food and more 1 item 1 Bomvande Accommamge m
35. inux 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 configuration file you can adjust in which order this happens see image See also Providers Configuration 25 Invantive Webservice Routing Service or data requested A Provider BS von name gt a Invantive Loy Invantive om Producer 3 6 Redundance For a higher availablity you can install multiple installations of the Invantive Webservice pro gramming These installations can be located on ne server or on multiple servers With C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 2 Invantive Webservice REN multiple servers you ensure a better availability even if a server breaks then the users can still keep on working see image Invantive Webservice Failover Invantive Webservice st q Invantive gt Webservice Invantive Webservice The redundance can be set in the settings xml file See also Connection configuration 221 As soon as aconnection is no longer available the programming of your user will try to use a dif ferent available connection
36. ite 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 physical connections listed will be brought online during application use Attributes name The name of the logical connection The webservice element This element defines a connection using the Invantive Providers Webservice pro vider This provider is capable of proxying database connections over HTTP HTTPS A client can connect to a database directly through a webservice but a webservice can route this request also to another Invantive Webservice and so on Attributes url the url of the Invantive Webservice encoding the encoding to use This will be passed as header on the request Allowed values are binary or text Default binary Use text for debug ging purposes or with poor CPU compression the compression method to use This will be passed as header on the request Allowed values are auto true or false Default auto will set compression enabled Within a fast LAN network and or with slow servers we recommend no compressi on In all other situations we recommend
37. l e Use an Internet browser to go to the link http webservice invantive com qt publish htm Then click Install next save the file and execute it Invantive B V Invantive Producer Query tool Name Invantive Producer Query tool Version 50 0 1 1 Publisher Invantive B V The following prerequisites are required e Windows Installer 3 1 Microsoft NET Framework 4 x86 and x64 If these components are already installed you can launch the application now Otherwise click the button below to install the prerequisites and run the application Click on the button Install to install the Invantive Query Tool on the computer C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 13 Invantive Studio User Manual z Application Install Security Warning Ed e Do you want to install this application Invantive Producer Query tool From Hover over the string below to see the full domain webservice invantive com Publisher Invantive B V Install Don t Install While applications from the Internet can be useful they can potentially harm your computer If you do nottrust the source do not install this software More Information After installation the following window will be shown In this screen you need to enter the location of the connection file See Connections Settings 221 for an explanation of the con nection file Select OK to save your chang
38. lan Croatian Ome als P M e The progress is displayed C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved B Invantive Webservice ER Oracle Universal installer Install ORACLE T1 p DATABASE Install Ideal Platform for Grid Computing Low cost servers and storage Highest availability Best scalability Installed Products B Next e Afterwards a configuration program for the network configuration is started Choose Can cel we advise you to use the configuration file tnsnames ora as described in the next part of the instructions C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 35 Invantive Studio User Manual Oracle Net Configuration Assistant Welcome Y Welcome to the Oracle Net Configuration Assistant To access a database service or other type of service you use a connect identifier The Assistant has determined that your client can use the easy connect naming method for identifying the database you wantto access With easy connect naming you use the host port optional and service name ofthe database as the connect identifier Click Help for more information about connecting to a database using easy connect Annuleren Help J Terug Volgende gt e Select Next Ww Oracle Universal Installer Configuration Assistants ORACLE 4 1 g DATABASE Configuration Assi
39. lt connection name SQLServer C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved E Invantive Studio User Manual o 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 database connectionString Server localhost Database database Uid userna me Pwd password provider MySql Data MySqlClient 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 connections default Customer A Production forceDefault false gt lt group name Customer A connection name Production database connectionString Data Source authenticationServer User Id user name Password thepublicpassword Pooling false provider Invantive CustomerA Acti veDirectory failover database connectionString Data Source localhost User Id username Pass word thepublicpassword Pooling false provider Oracle DataAccess Client webservice url http www customer a com ws encoding binary compression true gt lt webservice url http failover customer a com ws encoding binary compression true gt lt failover gt lt connection gt lt group gt
40. n Andere locaties GC win32 ligR1 dient C Min documenten d Deze computer Mijn netwerklocaties e The Oracle installation program appears C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved om Invantive Studio User Manual 2 Oracle Universal Installer Welcome ORACLE 1 DATABASE Welcome The Oracle Universal Oracle prodi Deinstall Products About Oracle Universal Installer L4 e We recommend to install the most comprehensive version within the license agreement so that all devices are readily available if they should be needed later C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 2 Invantive Webservice KEN Ne 3 Oracle Universal Installer Select Installation Type ORACLE 9418 DATABASE Select Installation Type Oracle Client11 1 06 0 Product et Languages a b Hep Installed Products e Select the required languages via Product Languages Here we recommend to choose all languages C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved EEN Invantive Studio User Manual Mo w Language Selection Language Selection Oracle Client 11 1 0 6 0 Please select the languages in which your product Oracle Client 11 1 0 6 0 will run Available Languages Selected Languages Thai Traditional Chinese d Turkish Oracle Universal
41. nvantive Query Tool 2 Invantive Studio 1 system requirement 2 Invantive Webservice 15 system requirement 15 Microsoft net framework 4 5 18 Microsoft iis 18 Microsoft SQL Server 17 39 Model 1 MySQL 17 MySQL Connector Net 39 N Nls lang 36 o Oracle 17 client 28 36 explain plan 10 trace 11 Output 9 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Studio User Manual Work process 15 P Processing in order 10 Provider 17 Providers 25 Q Query execution time 9 result 9 rw 9 Query Tool editor section 3 history of executed queryies 11 output section 3 Query Tool examples 3 N Redundance 17 Register 36 Route 40 Routing 17 S Security model 16 Select 7 Servce svc 18 Settings xml 22 SQL 3 ST Tns admin 36 Tnsnames ora 36 Tnsping 36 Update 7 Web Service 15 16 tunneling 18 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved tive Solutions for EY 2 5 Real Estate and Finance 224 Invantive Software B V Stephensonstraat 3b 3846 AK Harderwijk the Netherlands Tel 31 88 00 26 500 Fax 31 84 22 58 178 info invantive com www invantive com IBAN NLI RABO 0123 5297 02 Chamber of Industry and Commerce 08194155 VAT NL820681131B01 Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved RSIN 820681 131 Pol iouis o
42. o an advanced model driven software development environment for the development of high quality software and applica tions 1 1 Terminology Hieronder beschreven we de gebruikte termen 1 2 Versions This chapter describes the changes in the application per version 1 2 1 Release 2014 R1 Released XX XX 2014 Invantive Producer bXX Changes and bug fixes Invantive Stu System Configuration ConfigurationErrorsException Error creating the Web Proxy specified in dio the system net defaultProxy configuration section C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved rA Invantive Studio 2 2 dio Installation e No specialties Implementation e No specialties 1 3 System Requirements To use Invantive Studio on your PC or terminal server you will need the following software in cluding licenses e Invantive Producer Microsoft NET 4 5 Minimum 2 GB of internal memory e Screen resolution of 1280 x 1024 or higher nvantive Webservice or local drivers for Invantive Producer Use on Mac tablet or smartphone is not possible 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
43. or 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 available at http dev mysql com downloads connector net The installation of the MySQL client MySQL Connector Net proceeds as follows Double click the MSI installation file from the zip at above mentioned website e Choose the button Next e Choose the button Typical e Choose the button Install e Choose the button Finish Configuration MySQL Client Specific settings for the MySQL Connector Net client can be found at http dev mysal com doc refman 5 6 en connector net connection options html 3 7 5 4 IBM DB2 Provider for Invantive Webse
44. ou the possibility to conceptuali ze and design company software This means that you can develop customized company software that is easily adjustable to your company rules and grows along with the organizati on In addition our software development environment optimizes all your development pro cesses Invantive Studio allows you automate software development processes amongst which design development testing analysis implementation and maintenance of your cus tomized software development The advantage of this is that you can adjust the various pro cesses to each other save on development costs and improve the quality of the company software Some advantages for you in a nutshell e Model driven software development environment CASE for the designing and further de velopment of high quality software and applications e Optimization of your software development processes e Organization wide provision and automation of customized software development e Realtime software repository for the editing installing and validating of software packages e Version management system for the simple management editing and compiling of softwa re from the repository e Real time access to your data warehouse for the compiling analyzing and editing of ope rational data e Simple requesting of implementation manuals and application descriptions in PDF and Ex cel format Flexibility and functionality are what makes Invantive Studio int
45. rvice 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 Webservice Configuration IBM DB2 Client There are no configuration settings for the IBM DB2 Client 3 8 Terminology Hieronder beschreven we de gebruikte termen 3 8 1 Channel A channel is the medium on which data and requests are exchanged between an Invantive Producer client application and an Invantive Webservice server 3 8 2 Connection A connection is the definition of possibilities to establish a channell 40 between an Invantive Producer client application and an Invantive Webservice server 3 9 Versions This chapter describes the changes in the application per version 3 9 1 Release 2014 R1 Released XX XX 2014 Invantive Producer bXX and c fixes Sk DB2 data ne TU D Rc support 23456 ER IBM DB2 ook via ODBC ER __
46. stants The following configuration assistants will configure and start the components you selected earlier Tool Name Status Type Oracle Client Oracle Net Configuration Assistant Cancelled Recommended Configuration assistant Oracle Net Configuration Assistant was canceled Installed Products C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved oa 77 m saa Invantive Webservice E e Close the error message about the failure of the Oracle Net Configuration Assistant Select Exit wf Oracle Universal Installer End of Installation Siel x X cnc g DATABASE End of Installation The installation of Oracle Client was successful but some configuration assistants failed were cancelled or skipped Help Installed Products Back Next Install Oracle Client Configuration Follow these steps to configure the Oracle client e Construct if not available yet a tnsnames ora configuration file e n a tnsnames ora file tns is the abbreviation for Transparant Network Substrate all Oracle based databases services and the route via the network to get there are descri bed e An example of a description of the service 1 dvtiirZ invantive local 82 description 83 address list 84 address protocol tcp host 192 168 172 16 port 1521 85 86 97 connect data 88 sid dvtiir2 59 global name
47. tings 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 If you start an Invantive based application product for the first time the settings xml file is searched for at multiple locations in succession e the installation folder containing setup exe e from the installation folder a folder upwards e from the installation folder a folder up and the file folder in it e from the installation folder two folders up e from the installation folder two folders up and the file folder under it e from the installation folder three folders up e from the installation folder three folders up and the file folder under it e in the folder c ws If the settings xml file can not be found the user will be asked where the settings xml file is located The chosen location of the settings xml file is remembered and used from that mo ment In the text below it is described how it works lt xml version 1 0 encoding utf 8 lt C 2004 2013 Invantive BV the Netherlands www invantive com SHeader http svn invantive com repos pl04 trunk help nl manual Topics verbin dingsconfiguratie xml 23549 2013 11 01 14 21 272 smoke Purpose Configuration of the Invantive Webservice and direct database connections available to client and the Invantive Webservice acting as a database cli
48. vantive Studio User Manual ES The result of the SQL query can be exported to Microsoft Excel Adobe PDF Microsoft XPS and can be printed on a printer P Invantive Estate Query programma Pije XI Bestand Bewerken Verbinding Editor Database Venster Help n Exporteer naar Microsoft Excel Espen naar adobe OF 4 Exporteer naar Microsoft ma from Afdrukken Join UIT reveranc rcr v INI on gbr lvr id lvr lvr id order by lvr lvr naam i 0 Jo 0 50 dz Resultaten DBMS Uitvoer Uitleggen Plan Spoor Historie Sleep een kolom hierheen om te groeperen op die kolom persoon EY organisatienaam Xv functie plaats Ev Born van der Food and more Accountmanager Amersfoort Hoef van der Janssen Uitgeversorganisatie Engineer Amersfoort Aeilkema Janssen Uitgeversorganisatie Regiomanager Amersfoort Dom Janssen Llitgeversorganisatie Consultant Exact Amersfoort Breukhoven Mekra Communicatie Amersfoort Brouns Piet Van Den Herck bna Sr Channel Manager General Business Amsterdam i Fasen BT Design Account Manager Amersfoort 8 Betrokken Rijen e The image shows the result of the SQL query in Microsoft Excel C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Jr Invantive Query Tool EN x id Or Wee Personen per organisatie Microsoft Excel El zs Home Insert Page Layout Formulas Data Review View Team a e cs gH X General geImset
49. y that s why you need to define the NLS_LANG environment variable in Windows e Test the connection from a command prompt with tnsping ro t Windows Ve Copyright 1985 2003 H gt tnsping acciir2 invantive local INS Ping Utility for 32 bit Windows Version 11 1 0 6 Production on 07 SEP 2009 14 37 26 Copyright lt c 1997 2887 Oracle All rights reserved Used parameter files iC app Administrator product 11 1 c lient_1 network admin sqlnet ora Used TNSNAMES adapter to resolve the alias Attempting to contact lt description lt address list address Cprotocol tepdChost 192 168 172 16 gt Cport 1521 gt gt gt lt connect data sid acciir2 gt lt global_name acciir2 inyvantive local gt gt gt OK B msec HEN Dn e t is still not certain if the user password are correct but it is certain that a network connec tion to the Oracle service can be built C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 39 Invantive Studio User Manual o Finally check the connection by logging in with SQL Plus 3 7 5 2 Microsoft SQL Server Provider for Invantive Webservice In this chapter the configuration of the provider is described In addition some suggestions are provided to execute the installation of the Microsoft pro gramming However this is no replacement of the knowledge and experience with the local situation and trainings that an administrat
50. y specified by the settings xml C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved A Invantive Webservice E 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 default providers are always available A list of the default providers and there order which cannot be used again Order Name Comments 70 Oracle MySQL Provider supporting the execution of actions on Oracle MySQL Built and tested with Connector Net 6 7 4 See http dev mysql com doc refman 5 6 en connector net html File Invantive Data Providers MySql dll 80 Microsoft SQL Server Provider supporting the execution of actions onMicrosoft SQL server 7 0 and later See http msdn microsoft com en us library kb9s9ks0 aspx File Invantive Data Providers SqlServer dll 90 IBM DB2 UDB Provider supporting the execution of actions onIBM DB2 UDB 9 7 for Windows Not tested on any other version File Invantive Data Providers IbmDb2 dll 100 Oracle RDBMS Provider supporting the execution of actions onOracle RDBMS 9i 12c Needs ODP NET and OCI to be installed File Invantive Data Providers Oracle dll 200 Invantive Webservice Provider that is executing action by forwarding it to another Invantive Webservice over HTTP HTTPS File Invantive Data Providers Webservice dll Order 200 ensures that forwaring is preferred
Download Pdf Manuals
Related Search