Invantive Query Tool User Manual
Contents
1. Oracle Universal Installer Summary EN ORACLE 1 1 E DATABASE Summary Oracle Client 11 1 0 6 0 Global Settings Source IF inancelwins 11gR1_clienticlientistagelproducts xml Oracle Base coracle Oracle Home cloraclelproduct 1 1 Mrlient 1 OraClient 1g home installation Type Administrator Product Languages Arabic Bengali Brazilian Portuguese Bulgarian Canadian French Catalan Croatian emme Lo Help Installed Products Back M a A TEEM e The progress is displayed C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 8 Invantive Query Tool User Manual ee sa Oracle Universal installer install ORACLE ms 5 DATABASE Install Wa Ideal Platform for Grid Computing Low cost servers and storage Highest availability Best scalability Installed Products VEE IE A i j 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 EEN Oracle Net Configuration Assistant Welcome Welcome to th Oracle Met Configuration Assistant To access a database service or other type of service wou Use a connect identifier The Assistant has determined that your client can2. 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 Server 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 ma 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 2 7 4 Providers Configuration In the providers configuration file providers xml you configure which requests a
3. Invantive Query Tool 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 disclaimer 2
4. e Supply the database user with a connection or connect to an already installed Invantive product with associated user codes e Retrieve the structure of a table or view e Request the output of dbms_ output itgen_output and itgen_log of an Oracle PL SQL block only in combination with Oracle RDBMS e Retrieve an execution plan query plan or explain plan of an Oracle SQL query only in combination with Oracle RDBMS e Request the trajectory Oracle Trace of a SQL statement only in combination with Ora cle RDBMS 1 1 Learn SQL More information on what SQL is and how it can be used can be found at http en wikipe dia org wiki SQL The manual at http sqlzoo net also provides a good insight and in addition allows for inter active learning of how you can use SQL to retrieve edit and create data C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Jr Invantive Query Tool ost BBC Country Profiles FURCTIONS GROUP BY SELECT SELECT INSERT VALUES 1 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 1 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 Cop
5. 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 MERCHANTABILITY AND FITNESS FORA 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 SERVICES LOSS OF USE DATA OR PROFITS OR BUSINESS INTERRUPTION HOWEVER CAUSED ANDON ANY THEORY OF LIABILITY
6. SEE OE EE EE EE N RE OE N AE EN 2 8 2 Connec UON OE EE OE EE RE ED N EE 2 9 VerSOnS sees ee EE GE Oe EE Ee EE GE GE Ee GR ee Ee ie ee 2 9 1 RE EERS ED od TEE EE N N N EE OE EE N N OE EE OE 3 Contact Information Index C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Query Tool User Manual do 1 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
7. Settings xml 21 SQL 1 i Ins admin 35 Insnames ora 35 Insping 35 Update 6 Web Service 14 15 tunneling 17 Work process 14 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved el eee Invantive Software B V P GE ss Kaz 4 k SC En Stephensonstraat 3b owt tS a SA E EN mo a A 3846 AK Harderwijk on pg ee ed E E 24 the Netherlands nr S E SE Tel 31 88 00 26 500 en a o oo ae i aa SE is SC Fax 31 84 22 58 178 info invantive com www invantive com IBAN NLI RABO 0123 5297 02 Chamber of Industry and Commerce 08194155 VAT NL820681 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 23 PM Managing Director Guido Leenders Registered office Hierden
8. Use the easy connect naming method for identifring the database WOU wantto access With easy connect naming vou use the host portaptinnah and service name ofthe database as the connect identifier Click Help for more information about connecting to a database using easy connect e Select Next Oracle Universal Installer Configuration Assistants a E ORACLE 1 1 DATABASE Configuration Assistants The following configuration assistants will configure and start the components you selected earlier Tool Mame Type Oracle Client Mi Oracle Net Configuration Assistant Cancellec Recommended d Bety oe TEE Ges l l g atails CP rogr 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 35 Invantive Query Tool User Manual e Close the error message about the failure of the Oracle Net Configuration Assistant e Select Exit ee 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 een Install Oracle Client Configuration Follow these steps to configure the Oracle client e Construct if not available yet a tnsnames ora configur
9. 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 Invantive uery Tool 1 1 Learn O se Ee Ge n N OE DE De EE me 1 2 Fiinetionind ME 1 2 1 Query Tool Examples TEEN 1 2 2 Ter AE N recente ENG EE AAA N N EN 1 2 3 QUIS Ty OE GE EE EE N EE N NT EE NN N 1 3 Available EE OE side n Ad ee ee DS sees Roe 1 4 System Requirements us SE SE ENE sn eo NG We GEN We dineke 1 5 installation issie ee ER Ee EE ie Ge ee RO GE 1 6 VE e oen N DE EE eeen 1 6 1 REIS ZOE EE 2 Invantive Webservice 2 1 Web services N EE EE EE EE N EE EN EN 2 2 AVAMA SS RE SE EE EE SE OE EG EE DE EE EE ese EE 2 3 System Requirements NEEN ER ER RE Re RE RE RR ER ER Ee Re Re Re RE RE RE RE 2 4 GONCEPI EE EE N 2 5 Database platforms racer N RE Se SERE EE RR EE seen cust ananda ne dine aen 2 6 Redundance zenne tene 2 7 Installation sos ee ee RD dd canes GR EE enden haten aneh 2 71 Invantive Webservice Programming an kes kke EE ke ER RR EE EE ke ER ARE ER Re ER RR EE RR RE EE ER Re RR Re EE 2 7 2 Be OE AE OE TE EE OR GO N EE EE N 2 7 3 Connection Configuration aans ennn ennnenenennennnnennnennsnnnnenanennsennnenanennsnnnnenenenennnnnenenenn 2 1 4 Providers CORTIQUPAUO NM sieke sade SR N KEN Ede EA en DE EO senaten ee We we N GED N Ak ek GN EN eN ad 2 1 5 POV dies EE OD OR EO AE EE N RE EE EE ER 2 8 ES jip ied ele RE N EE OE EE EE 2 8 1 Bg
10. filling of the tab history because the data of the last executed query is added Pa Invantive ision Query programma lof NI Bestand Bewerken Editor Database Wenster Help 1 select from bubs taken v ia Uitvoeren el Exporteren Resultaten DBMS Uitvoer Uitleggen Plan Spoor Historie Sleep een kolori hierheen am te groeperen op die kolom Uitvoeringstd ET Betrokken Rien Ev Start uitvoerng v Ev SOL tekat 28 911 e 6 704 172 2001 15 48 select from bubs taken v 15 551 e 6 617 172 2011 13 47 select from bubs leveranciers v 309 ME 17 2 2011 13 47 select from bubs uns vw 3 301 s 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 1 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 d Invantive Query Tool User Manual 2 e Invantive Control 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 1 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
11. gt Cport 1521222 connect data sid acciir2 global name acciir2 invantive local gt gt gt OK lt A msec HEN 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 ee Invantive Webservice E e Finally check the connection by logging in with SQL Plus 2 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 2 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 a
12. mail verzenden XC Dit bestand verwijderen Andere locaties Ca Wn32_ Lior 1 dient G Mijn documenten ad Deze computer KA Min netwerklocaties e The Oracle installation program appears C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Webservice 28 vd Oracle Universal Installer Welcome f Ed ORACLE 1 1 g DATABASE A T A BASE Welcome The Oracle Unive rsal Instal lier 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 E Invantive Query Tool User Manual va Oracle Universal Installer Select Installation Type ORACLE 1 e 5 DATABASE A T A B A 5 E Select Installation Type BEE be Installed Products 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 Es Invantive Webservice am et 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 Slo
13. 5 Invantive Query Tool User Manual 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 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 91 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
14. LP a ABJNLS LANG REG SZ DUTCH THE NETHERLANDS WESMSWIN1252 ABJOLEDE Ge AA MAAR attent 1 oledbnesg CO JavaSoft Ni A Sleutel Logitech 2b oo40 Ge int_1 po4o mesg 9 Macromedia lab ORACLE BUNDLE REG_S2 RE Sa SE Gal Microsoft ABJORACLE GROUP REG SZ Binaire waarde i E MozillaPlugins ab ORACLE HOME REG 54 DWORD waarde id ODBC ab ORACLE _HOME REG 52 Waarde met meerdere tekenreeksen faClient11g_home1 ORACLE ab ORACLE HOME a REG S Waarde met uitbreidbare tekenreeks J KEY OraClientiig home j ab SOLPATH REG SZ ma Eprade product 11 1 0 dient_1 dbs E OLEDB ab StmtCachesize REG SZ 0 E oan H E ODP NET GC Policies ES Program Groups E Realtek D D Deze computer HKEY LOCAL MACHINE SOFTWARE ORACLE KEY OraClientiig homei 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 d Register editor Sele Bestand Bewerken Beeld Favorieten Help HI Hewlett Packard Naam Type Gegevens CA Hitman Pro lab Standaard REG SG geen waarde ingesteld el HP ab MSHELP TOOLS REG SZ ersch t 11 1 0 dient_1 MSHEL a REG SZ se A ab OLEDE REG_SZ cr orade product 11 1 0 dient_1 oledb mesg Ga Logitech lab oo4a REG SZ c o
15. 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 o Hewlett Packard Naam Type Gegevens 2 Hitman Pro lab Standaard REG SZ geen waarde ingesteld ABJIMSHELP TOOLS REG SZ clpradeproductVi1 1 0 dient_1 MSHELP sa dek abjnLs LANG REG SZ DUTCH THE NETHERLANDS WESMSWIN1252 aa D REG SZ c prade product 11 1 0 dient_1 oledb mesg Gi ia Logitech REG SZ c orade product 11 1 0 dient_1 oo040 mesg G Macromedia BBJORACLE BUNDLE REG SZ Enterprise ee 1 Microsoft BBJORACLE GROUP REG G Orade OraClientiig home1 E MozllaPluging ab ORACLE_HOME REG SZ c oracle product 11 1 0dient 1 HE ope GBJORACLE HOME REG SZ SOFTWAREVORACLEIKEY OraClientiig home1 G ORACLE ab ORACLE HOME REG SZ Oratlient11g_home1 MEER Ie oracient11a homel T gade REG SZ c oracle product 11 1 0 dient_1 dbs EE ab StmtCachesize REG SZ 1 Policies H Program Groups EE 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 Query Tool User Manual Po m Register editor EER Bestand Bewerken Beeld Favorieten Help E Hewlett Packard Naam Type Gegevens LI Hitman Pro REG SZ geen waarde ingesteld JHP ab MSHELP TOOLS REG SZ c oracle product 11 1 0 cient_1 MSHE
16. atabase 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 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 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 connec
17. ation 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 of the service Gelb dwtlire invantive local oe description El address list ot address protocol tep host L lp US LI port 1521 oo 1 sl 1 or connect data oc Sid dytlire LU LO Global name dwtiir invantiwe local fe H 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 ee Invantive Webservice ER 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 Zoekresultaten Bestand Bewerken Beeld Favorieten Extra Help Ka A Zoeken gt Mappen Hak Naam In map insnames ora O Finance 1kB ORA bestand Andere locaties IE Bureaublad A Deze computer Mijn documenten KA Min netwerklocaties Details
18. ation 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 Jr Invantive Webservice me 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 2 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 compa
19. e Software B V the Netherlands All rights reserved 23 Invantive Query Tool User Manual f Attributes MconnectionString 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 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 connectionStrin
20. eer naar Adobe PDF Exportee Using the Export tab you can print the output of queries or export it to different formats 1 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 1 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 na Invantive Query Tool User Manual ie Pa Invantive Vision Query programma Bestand Bewerken Editor Database Wenster Help Jie Uitvoeren sd Exporteren 1 select from hubs taken tak_nk ir Me ar tt ME 10 8 2007 8 20 29 1157 j 15 6 2009 182718 1158 7 8 2007 15 42 53 1160 4 10 2007 14 23 50 6 704 Betrokken Rijen 28 10 s Also the number of rows and the execution time will be displayed 1 2 3 2 DBMS output This tab includes the output of doms output put line statements only in combination with Oracle RDBMS 1 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 sl Expor Se Uitvoeren F9 1 Select Uitleggen Plan Ctri E 2 EO hubs telefoon contacten r E where wda ret sleutel S Database Wenster Help The e
21. em Breukhoven Communicatie organisatienaam Piet Van Den Herck bna 1 item i Brouns Sr Channel Manager General Business Sales Amsterdam organisatenaam QT Design 2 items i Engel Helpdesk Teamleider Amersfoort Fasen Account Manager Amersfoort 1269 x 0 26 in al C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved ee Invantive Query Tool e 1 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 Vision Query programma Bewerken Editor Database Venster Help Ctrl Bestand Open Opslaan Ctri 5 Bewaren Als Ctrl Shitt 5 Afdrukken Chri P Afsluiten Or 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 Invantive Query Tool User Manual Pa Invantive Vision Query programma Bestand gt Ae Uitvoe Bewerken Terugdr aaien prepa Kmppen Kopi ren Delen Selecteer Alles Zoeken Vind Volgende Vervangen Verster Ckrl Z Ctrl Chrltz CEC Ctrl Ctrl Ctrl F F3 Chrl R Ga
22. g 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 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 MySOL 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 sdatabase CONNECTIONS LEI etvEr lors host Databases TEE 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 a
23. g de Jonger Ketelaar Klaassen Kooman Koopman Krekelmans Kuuperz Lange de Houben Jalkema Janszen dassen Jong de Jongen Ketelaars Klaassen Kooman Koopman Krekelmans KU pers Lange de K K Y K K K Y K K K Y K Y M K K K K Houben Jalkema Janssen Jassen Jong de Jongen Ketelaars Klaassen Kooman Koopman Krekelmans Kupers 2 Z ZITA Lange de C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Jr Invantive Query Tool 4 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 II Fi Bestand Bewerken Verbinding Editor Database Venster Help gt L i Uitvoeren la Exporteren gbr lvr id Ge ler luvr id lvr lvr naam persoon HET organisatienaam T functie plaat Born wan der Food and more Accountmanager Amersfoort Hoet wan 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 AT Design Account Manager Amersfoort 8 Betrokken Rijen EZ 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 5 Invan
24. hnological 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 2 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
25. ication pool immediately Cancel e Set the standard page Service ashx C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 1 Invantive uery Tool User Manual Service SWL e You can now test the web service by opening the page You will receive output such as 23522 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 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 CF Class Test Static void Maint ServiceClient client new ServiceClient J Use the client variable to call operations on the service Z Always close the client eclient Close Visual Basic Class Test Shared Sub Mani Dim client As ServiceClient New ServiceClient Use the client variable to call operations on the service Always close the client client Close End Sub End Class 2 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 R
26. 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 One 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 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 2 3 System Requirements Client C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved KEN Invantive Query Tool User Manual MP 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 memo
27. naar Regel Ctrl G Commentaar CAR Ontcommentaneren Biak Ckr Shift B Hoofdletters Chr Kleine Letters Chr Eerste Letter botze Ctrl I Beschrijven Fa The Editor menu contains all items with which you can edit the query text Menu Editor Fa Invantive ision Query programma Bestand Bewerken Editor Database venster Help Ae Uitvoeren sd Expol 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 Vision Query programma Bestand Bewerken Editor Database pe 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 8 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 te Uitvoeren ed 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 Exporteer naar Microsoft Excel Export
28. nd 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 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 2 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 Netherland
29. ntive Webservice and its components 2 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 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 ml 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 nm 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 K Site name Default Web Site Path Example sales Physical path Ci 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 Ei Mame NET Framework version NET Framework 4 0 30319 Managed pipeline mode Integrated Iw Start appl
30. ny 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 241 Invantive Webservice Routing Service or data requested Ay Provider LAN Your name gt Invantive Vision Invantive Producer 2 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 Invantive Query Tool User Manual Dos 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 Fs u sel Invantive Invantive Webservice Webservice O Invantive gt Webservice H Invantive Webservice The redundance can be set in the settings xml file See also Connection configuration 21 As soon as a connection is no longer available the programming of your user will try to use a dif ferent available connection 2 7 Installation This element describes the installation of the Inva
31. 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 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 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 e 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 l
32. onfiguration 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 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 me 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 277 smoke Purpose Configuration of the Invantive Webservice and direct database connections available to client and the Invantive Webservice acting as a database client Explanation Connections are used to retrieve data from a database and to update the contents of databases This settings file can accommodate all settings for d
33. ons Settings 21 for an explanation of the con nection file Select OK to save your changes D Invantive Configuration C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved KN Invantive Query Tool User Manual Je e Next comes the login screen Next enter the username password and connection and se lect OK EF Connect C Copyright 2004 2011 Invantive Software BV the Netherlands All rights DOT linvantive Production LAN of http h m e In order to change the settings of Invantive Query Tool after installation press Crt when starting up Invantive Query Tool 1 6 Versions This chapter describes the changes in the application per version 1 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 CR 2 Se 3 leyta PO ery Tool Installation e No specialties Implementation e No specialties 2 Invantive Webservice This chapter describes the possibilities of the Invantive Webservice 2 1 Web services Because of the tec
34. or higher e Invantive Webservice or local drivers Use on Mac tablet or smartphone is not possible 1 5 Installation Perform the next steps to install Invantive Query Tool e Use an Internet browser to go to the link http webservice invantive com qt publish htm Then click Install next save the file and execute it Invantive B V Invantive Producer Query tool Name Invantive Producer Query taal 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 DV 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 Connecti
35. rade product 11 LO dient_1 o040 mesg CH a E ab ORACLE BUNDLE REG 5 Enterprise Cy Microsoft ab ORACLE_GROUP REG SZ Oracle Craflientiig homei CH MozilaPlugins laB ORACLE HOME REG SZ c oracle product 11 1 0 dient_1 E opec labJoRACLE HOME REG SZ SOFTWAREVORACLEIKEY OraClientiig home1 GJ ORACLE BbJoRACLE_HOME_ REG SZ CraClient11g_home1 H KEY OraClientiig home1 ab SOLPATH REG 57 c orade product 11 1 0 dient_1 dbs J OLEDE ab StmtCacheSize REG SZ 0 J 0040 Cen REG SZ o finance CH ODP NET o Policies C Program Groups o Realtek HE H H EE Deze computer HKEY LOCAL MACHINE SOFTWARE ORACLE KEY OraClientiig homei 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 va A 23 ad 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 protocol tcp gt host 192 168 172 16
36. re 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 Vers C 2004 2013 Invantive BV the Netherlands www invantive com Header http svn invantive com repos p104 trunk help nl manual Topics bubs Providers Comtiguratie 2ml 23549 SE e tt 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 2
37. ry 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 2 4 Concept With the Invantive Webservice Invantive applications and applications based on Invantive Producer can exchange data with databases and other services using the internet or the company network It is also possible to use these applications without Invantive Webservice but for installations with more than one user this is strongly discouraged With the Invantive Webservice it will ta ke no time outside of the client installation to allow an extra user or PC to make use of a da tabase without the Invantive Webservice this will take considerably more time for each PC and or user The exchange of data happens through webservices that use the so called http and or https protocol Depending on the chosen security model you can exchange data with databases in the company network using the Invantive webservice both within the company network as well as on the internet from Invantive applications and applications based on Invantive Produ cer You can also if authorized exchange data with databases at various companies With this you can easily collaborate with multiple clients and or relations in an efficient manner where ver you are and whenever you feel the need to Every client and or relation also has an own install
38. s All rights reserved KEN Invantive Query Tool User Manual Ps Configuration IBM DB2 Client There are no configuration settings for the IBM DB2 Client 2 8 Terminology Hieronder beschreven we de gebruikte termen 2 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 2 8 2 Connection A connection is the definition of possibilities to establish a channell 39 between an Invantive Producer client application and an Invantive Webservice server 2 9 Versions This chapter describes the changes in the application per version 2 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 3 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 ee Contact Information ao Web www invantive com Route Follow the instructions of
39. t 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 log 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 gt lt providers gt 2 7 5 Providers The Invantive Webservice can make use of various providers that record and retrieve data but also offer o
40. ther services Here are the standard available providers 2 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 Invantive Query Tool 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 r KI e Vorige id ka e Zoeken EE Mappen Adres ICH O Finance win32_11aR1_dient dient Al Naam I 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 IP Dit bestand kopi ren 32kB Toepassing 12 2 2009 13 21 Cd setup Configuratie instellingen 12 2 2009 13 21 KA Dit bestand op het web E welcome HTML Document 12 2 2009 13 21 publiceren EJ Dit bestand per e
41. tion 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 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 Invantiv
42. tive Query Tool User Manual Jp at al wi EVERE Personen per ofganisatie Microsoft Excel el Ss Home Insert Page Layout Formulas Data Rewiew Yie Team A P DO El P A Microsoft San 8 5 SS General e Ay a Insert dT Gap ER vi ar B 7U As ES Sw sn Styles eech D at op e J Ei aa Ar SS ES Per io Zi d EE Format A Filter Select Clipboard a Fant z Alignment Number Gell Editing Je organisatienaam Food and more litem onganizatienaam Food and more 1 item 2 3 persoon functie plaats A Bom van der Accountmanager Amersfoort e E organisatenaam Janssen Uitgeversorganisatie 3 items d g persoon functie plaats DH Hoef wan der Engineer Amersfoort T 10 Aeilkema Hegiomanager Amersfoort 11 Dorr Consultant Exact Amersfoort 12 13 organizatienaam Mekra 1 item 17 12 organizatienaam Piet Van Den Herck bna 1 Very tat 23 organitatienaam OT Design 2 items M a EH Sheet PA l Dj ry E fx Ready l ER aanse El L L e The image shows the result of the SQL query in Adobe Acrobat File Edit View Document Comments Forms Tools Advanced Window Help x K ER fd so Find N 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 it
43. un 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 OR e 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 If 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 ER Invantive Query Tool User Manual MP e Start Microsoft IIS through inetmagr 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 2 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 c
44. venian Spanish Swedish a Thai Traditional Chinese aj en d OK Cancel e Select OK and then Next We recommend to install the software under c oracle z Oracle Universal Installer Specify Home Details f OX ORACLE 148 DATABASE Install Location Specify a base location for SCH all Klek SE and commu ral On related files This location is the Oracle Base directory Cre ne Oracle Ba ach oper system t By Saui potus re and configuration files are in d OracHerg 19 home gt CIoracletiprodurtd1 1 Oclient 1 Installed Products C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved KEN Invantive Query Tool User Manual ebe 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 EE Ee ie environment meets all of the ear le EES for HEEL LE and Checking Oracle Home path for spaces Automatic M Succeeded Checking for Oracle Home incompatibilities Automatic mi 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 Es Invantive Webservice ES
45. xecuting 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 1 l 7 Invantive Estate Query programma Eila E Bestand Bewerken Editor Database Venster Help ze 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 1 CPU Cost 9241 10 Cost1 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 1 2 3 4 Trace This tab contains the result of an Oracle trace only in combination with Oracle RDBMS 1 2 3 5 History executed queries Executing a query ensures the
46. 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 an Invantive Query Tool User Manual Index Certificate 20 Channel 15 39 Company network 14 Connection 39 Connection Configuration Invantive Producer 21 Contact Information Invantive Software BV 39 D Data 15 Database platform 16 Dbms export 9 Delete 6 Error 404 17 405 17 Exchange 14 Explanation ofthe plan 9 D a Failover 16 File format 8 H Harderwijk 39 http 15 https 15 IBM DB2 38 IBM DB2 for Windows 16 Insert 6 Installation 17 oracle client 27 tunneling web service 17 Invantive Query Tool 1 Invantive Webservice 14 system requirement 14 Microsoft net framework 4 5 17 Microsoft iis 17 Microsoft SQL Server 16 38 MySQL 16 MySQL Connector Net 38 N Nis lang 35 O Oracle 16 client 2 7 35 explain plan 9 trace 10 Output 8 BD Processing in order 9 Provider 16 Providers 24 Q Query C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Query execution time 8 result 8 row 8 Query Tool editor section 2 history of executed queryies 10 output section 2 Query Tool examples 2 RB Redundance 16 Register 35 Route 39 Routing 16 SS Security model 15 Select 6 Service svc 17
47. yright 2004 2013 Invantive Software B V the Netherlands All rights reserved 3 Invantive Query Tool User Manual Jr lel Es Pa Invantive Estate Query programma Bestand Bewerken Verbinding Editor Database Venster Help Uitvoeren ell Exporteren select ghr ghr naam person ghr gbr functie functie Lauer Ier naam organisat ienaatm lvr lyr plaats plaats hubs gebruikers w gbr hubs leveranciers v lyr Or Ier id lvr lvr id 1 d A 4 5 D 5 5 g organisatienaam Iwr Last naam functie AM organisatienaam Food and more 1 item organisatienaam Janssen Witgewerzorganizatie 3 items persoon Hoef van der Engineer Amerstoort 2 Aellkema 4 arm Regiomanager Amersfoort Consultant Exact Amersfoort organisatienaam Piet Wan Den Herck bra 1 item organisatienaam OT Design 2 items amp Betrokken Rijen EZ 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 vi Pa Invantive Estate Beschrijven bubs gebruikers v Vv gbr aanmeld code 7 obt accordeur uwen vlag gt ae gbr_achternaam ze gbr administrateur vlag 3 ag obt Heunen Heunen Heunen Heuvelman Heuvelman Heuvelman Hoef van der Hoef van der Hoef wan der Hoekstra Hoekstra Hoekstra Hoot van Hoof wan Hoot wan Houben Jalkema Marcel Janssen Jassen Jan
Download Pdf Manuals
Related Search