Invantive Webservice User Manual
Contents
1. 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 Webservice User Manual E c Qo ws ita pbubs Service Service You have created a service To test this service you will need to create a client and use it to call the service You can do this using the svcutil exe tool from the command lir svcutil exe http local ws ita pbubs Service svc wsdl This will generate a configuration file and a code file that contains the client class Add the two files to your client application and use the genera ce class Test Static void Main ServiceClient client new ServiceClient Use the client variable to call operations on the service Always close the client client Close Visual Basic Class Test Shared Sub Main Dim client As ServiceClient New ServiceClient Use the client variable to call operations on the service Always close the client client Close End Sub End Class 1 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 Start MVC with Run Go to the File menu and select Add Remove Snap in Click on Certifcates and click on Add e Select C2. Invantive Webservice Manual d Solutions for Re al nd Fin invantive Estate a ance Copyright C Copyright 2004 2013 Invantive Softw are B V the Netherlands All rights reserved Alle rechten voorbehouden Niets uit deze uitgave mag w orden verveelvoudigd opgeslagen in een geautomatiseerd gegevensbestand of openbaar gemaakt in enige vorm of op enige w ijze hetzij elektronisch mechanisch door fotokopieen opnamen of enig andere manier zonder voorafgaande schriftelijke toestemming van de uitgever Ondanks alle aan de samenstelling van deze tekst bestede zorg kan noch de schrijver noch de uitgever aansprakelijkheid aanvaarden voor eventuele schade die zou kunnen voortvloeien uit enige fout die in deze uitgave zou kunnen voorkomen Deze handleiding is een naslagw erk bedoeld om het gebruik te verduidelijken Indien gegevens in de voorbeeldafbeeldingen overeenkomen met gegevens in uw systeem dan is de overeenkomst toevallig Auteurs Jan van Engelen Michiel de Brieder Mathijs Terhaag Tanja Middelkoop Guido Leenders Tatjana Daka The JasperReports License Version 1 0 Copyright C 2001 2004 Teodor Danciu teodord users sourceforge net All rights reserved Redistribution and use in source and binary forms w ith or w ithout modification are permitted provided that the follow ing conditions are met 1 Redistributions of source code must retain the above copyrightnotice this list of conditions and the foll
3. 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 5 1 Hewlett Packard Naam Gegevens c1 Hitman Pro ab Standaard geen waarde ingesteld ante ab MSHELP_TOOLS c oracle product 11 1 0 dient_1 MSHELP C HPQ Intel eh ab OLEDB c oradeproductM 1 1 0 dient_1 oledb mesg 3 Logitech ab oo40 c rade productM 1 1 0 dient_1 0040 mesg Z3 Macromedia ab ORACLE_BUNDLE Enterprise Z3 Microsoft abJORACLE GROUP Oracle OraClient11g_home1 1 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 2 4 OraClientiig homei ab soLPATH c oradeproductM 1 1 0 dient_1 dbs 1 OLEDB ab StmtCacheSize 0 0040 or finance a ODP NET 51 Policies 1 Program Groups Realtek 8 De Deze computer HKEY_LOCAL_MACHINE SOFTWARE ORACLE KEY_OraClient11g_home1 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 Test the connection from a command prompt with tnsping r
4. among the installed programs there will then be listed Microsoft NET Framework 4 5 Copy invantive webservice in the distribution to the folder that is known within Microsoft IIS preferably webservice within the folder of the application or alternatively c inetpub WwwrootNnvantive 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 Start Microsoft IIS with inetmgr or through Control Panel C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 5 Invantive Webservice User Manual E Select Properties from the folder Convert the folder to application with an own application pool Add Application 21 x Site name Default Web Site Path 1 Alias Application pool praed __splct _ Example sales Physical path C inetpub wwwroot qbubs ws eil 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 x Framework version Framework v4 0 30319 Managed pipeline mode Integrated Start application pool immediately om Set the standard page Service ashx C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Webservice
5. consist of two types physical connection either an Invantive Webservice or direct database connec tion failovers All physical connections listed will be brought online during application use Attributes name The name of the logical connection The webservice element This element defines a connection using the Invantive Providers Webservice pro vider This provider is capable of proxying database connections over HTTP HTTPS A client can connect to a database directly through a webservice but a webservice can route this request also to another Invantive Webservice and so on Attributes url the url of the Invantive Webservice encoding the encoding to use This will be passed as header on the request Allowed values are binary or text Default binary Use text for debug ging purposes or with poor CPU compression the compression method to use This will be passed as header on the request Allowed values are auto true or false Default auto will set compression enabled Within a fast LAN network and or with slow servers we recommend no compressi on In all other situations we recommend compression to be enabled The database element This element defines a connection to a database using a provider Specific for that type of database C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Webservice E Attributes Con
6. ANY THEORY OF LIABILITY WHETHER IN CONTRACT STRICT LIABILITY OR TORT INCLUDING NEGLIGENCE OR OTHERWISE ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE Contents 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 7 1 1 7 2 1 7 3 1 7 4 1 7 5 1 8 1 8 1 1 8 2 1 9 1 9 1 Invantive Webservice 1 lE dicli gc 1 Advantage6s eee iecur e itx itia is DR 1 System Requirements i ekR voco aeu 1 Concept ERE K RRAEEREER REA Database platforms cerne eru haa Ronan ER RR UIDERETUR Installation Invantive Webservice Programming Certificate ecrit Connection Configuration Providers Configuration Providers Terminology Channel Connection VGNSIONS eaeversraeen Release 2014 R1 Contact Information 26 Index 28 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 1 Invantive Webservice User Manual ES 1 Invantive Webservice This chapter describes the possibilities of the Invantive Webservice 1 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 m
7. 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 1 OLEDB lab stmtCacheSize 0040 8 51 ODP NET H Policies 1 Program Groups 35 51 Realtek 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 5 Hewlett Packard Gegevens 1 Hitman Pro geen waarde ingesteld HP OLS t c orade product 11 1 0 dient_1 MSHELP a ab NLs LANG is DUTCH THE NETHERLANDS WE8MSWIN 1252 1 JavaSoft ab OLEDB xd e 1n nt 1 oledb mesg 1 Logitech labjoo40 Int 110040 mesg 53 Microsoft abJORACLE GROUP REG 52 Binaire waarde a 2 MozillaPlugins ab ORACLE HOME REG SZ DWORD waarde ht 1 opc abJORACLE HOME REG SZ Waarde met meerdere tekenreeksen aClientiig homei 1 ORACLE abJORACLE HOME REG SZ Waarde met uitbreidbare tekenreeks 98 KEY OraClientiig home1i ab sQLPATH REG SZ Crrade producti T U Ydient ildbs oB ab StmtCachesize REG_SZ 0 0040 58 51 ODP NET H E Policies 1 Program Groups 5 1 Realtek m ee 5 REI Deze computer HKEY_LOCAL_MACHINE SOFTWARE ORACLE KEY_OraClient11g_home1 Change also the NLS_LANG to DUTCH THE NETHERLANDS
8. acle Universal Installer Welcome f x ORACLE 1 DATABASE Welcome The Oracle Universal Oracle prodi Deinstall Products About Oracle Universal Installer L4 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 EM iN 5 Oracle Universal Installer Select Installation Type ORACLE DATABASE Select Installation Type Oracle Client11 1 06 0 Product 1 Heb Installed Products 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 Invantive Webservice User Manual Mo w Language Selection Language Selection Oracle Client 11 1 0 6 0 Please select the languages in which your product Oracle Client 11 1 0 6 0 will run Available Languages Selected Languages Thai Traditional Chinese d Turkish Oracle Universal Installer Specify Home Details ORACLE 11 g DATABASE Install Location Specify a base location for storing all gace sotene and sonnouraton relatad f fi ls gle locaton is ihe Oracle Base directory Create c an configuration files let OraClient11g home1 cAoracleiproducti1 1 1 0iclien
9. atform for Grid Computing Low cost servers and storage Highest availability Best scalability Installed Products B Next 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 NEN Invantive Webservice 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 Wolgende gt e Select Next Ww Oracle Universal Installer Configuration Assistants 5 ORACLE 4 1 g DATABASE Configuration Assistants The following configuration assistants will configure and start the components you selected earlier Tool Name Status Type Oracle Client 5 Oracle Net Configuration Assistant Cancelled Recommended Configuration assistant Oracle Net Configuration Assistant
10. ation 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 1 3 System Requirements Client To use Invantive Webservice on your PC or terminal server you will need the following soft ware including licenses Microsoft NET 4 5 Minimum 2 GB of internal memory Screen resolution of 1280 x 1024 or higher On Premises For the use of Invantive Webservice as server within the private network you will need so called on premises use Operating system Windows 2008 R1 Service Pack 2 Windows 2008 R2 or Windows C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Webservice 2 2012 Minimum of 4 Gb internal memory Screen resolution of 1280 x 1024 or higher Minimal 1 central processing unit for server use not older than 2 years Drivers for the supported databases or own specific drivers for business applications 1 4 Concept With the Invantive Webservice Invantive applicatio
11. he 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 o Invantive Webservice User Manual o file C ws distribute invantive sdk Invantive XXX Provider dll class Invantive XXX Provider Provider gt lt templatesfolder gt C temp templates lt templatesfolder gt lt serviceurl gt http localhost ThisIsAnExmaple Service svc lt serviceurl gt lt provider gt lt providers gt gt lt providers gt lt Custom logging gt SF lt provider order 999 file C ws distribute invantive sdk Invantive Data Providers Logg
12. iders 11 R Redundance 3 Register 22 Route 26 Routing 2 SS Security model 2 Semice sc 4 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 4 Invantive Webservice User Manual Settings xml 8 pa Tns admin 22 Tnsnames ora 22 Tnsping 22 W Web Service 1 2 tunneling 4 Work process 1 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved tive Solutions for EY 2 5 Real Estate and Finance 224 Invantive Software B V Stephensonstraat 3b 3846 AK Harderwijk the Netherlands Tel 31 88 00 26 500 Fax 31 84 22 58 178 info invantive com www invantive com IBAN NLI RABO 0123 5297 02 Chamber of Industry and Commerce 08194155 VAT NL820681 131B01 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved RSIN 820681131 Pol Managing Director Guido Leenders Registered office Hierden
13. ing 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 45 lt providers gt 1 7 5 Providers The Invantive Webservice can make use of various providers that record and retrieve data but also offer other services Here are the standard available providers 1 7 5 1 Oracle Provider for Invantive Webservice In this chapter the configuration of the provider is described In additio
14. lands All rights reserved om Invantive Webservice User Manual Mo t11r2 and the global name dvt11r2 invantive com Full instructions on creating tnsnames ora can be found in the Oracle documentation Make sure that the tnsnames ora file is located on the same place on all PC s preferably in way to make it easy to add services from a central location For fixed workplaces often a network drive is used for example as follows B Zoekresultaten Bestand Bewerken Beeld Favorieten Extra Help Qi D 3 Prater rmm FE i rte Naam In map O Finance Andere locaties Bureaublad Deze computer E Min documenten Min netwerklocaties Details Zoekresultaten Systeemmap Open the register with regedit and go to the key HKLMSOFTWARE Oracle KEY_OraC lient lg 5 Register editor Bestand Bewerken Beeld Favorieten Help 58 53 Hewlett Packard Naam Gegevens li 1 Hitman Pro ab Standaard geen waarde ingesteld 84 HP ab MSHELP_TOOLS c orade product 11 1 0 dient_1 MSHELP 2 ab NLs LANG DUTCH THE NETHERLANDS WESMSWIN1252 ud UE 8 c prade product 11 1 0 dient_1 oledb mesg 8 Logitech ab oo40 c oracle product 11 1 0 dient_1 0040 mesg ab ORACLE_BUNDLE Enterprise 1 Macromedia 58 1 Microsoft abJORACLE GROLP Oracle OraClientiig homei 5 53 MozillaPlugins ab ORACLE c Voradeproduct M 1 1 0 dient_1 a 1 opc ab
15. n some suggestions are provided to execute the installation of the Oracle program ming However this is no replacement of the knowledge and experience with the local situa tion and trainings that an administrator or DBA has from his role and the results of the instal C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved IF Invantive Webservice EN lation are therefore not guaranteed Oracle Client Installation The installation of the Oracle client can be done following the next steps Navigate to the folder containing the setup program for example Bestand Bewerken Beeld Favorieten Extra Help Q ee Bp zoeken j gt mappen Fiz o Finance win32_110R1_dient dient Type Bestands en maptaken Bestandsmap 5 3 2009 10 49 wi 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 d publiceren HTML Document 12 2 2009 13 21 Dit bestand per e mail verzenden X Dit bestand verwijderen Andere locaties G win32 11081 dient C Min documenten d Deze computer Min netwerklocaties The Oracle installation program appears C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 16 Invantive Webservice User Manual rA wf Or
16. n the configuration file you can adjust in which order this happens see image See also Providers Configuration E Invantive Webservice Routing Service or data requested S eve rame Provider Your name gt Invantive Cu Vision a m Invantive Producer 1 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 multiple servers you ensure a better availability even if a server breaks then the users can still keep on working see image C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Invantive Webservice oa Invantive Webservice Failover Im um im Invantive Webservice 8 Invantive Webservice Invantive Webservice The redundance can be set in the settings xml file See also Connection configuration As Soon as a connection is no longer available the programming of your user will try to use a dif ferent available connection 1 7 Installation This element describes the installation of the Invantive Webservice and its components 1 7 1 Invantive Webservice Programming Execute following steps to make the Invantive Webservice available to the users Install Microsoft IIS 7 or 8 including ASP NET support Install Microsoft NET Framework version 4 5 or newer In the Control Panel
17. nectionString the ADO NET connection string for the specified provider You can specify Data Source User Id and other settings provider the name of the ADO NET connection provider For example Oracle DataAccess Client The failover level The failover level can define a list of database or webservice settings It supplements the webservice database element Connection settings defined in a failover can be used to have a failover connection when one connection cannot be established This can be useful when relying on a internet connection or presence of a VPN tunnel Settings defined in this section will be evaluated one after another starting top down When any of the failovers can be established no other failovers will be tried Attributes none Examples This example illustrates a single connection The software will sequentially try Eos Connect to the authenticationServer Active Directory server Connect to one of the connections in the failover First the database connection when connection from the internal network or VPN The first webservice connection The second or failover webservice connection connections default Customer A Production forceDefault false gt lt group name Customer A connection name Production database connectionString Data Source authenticationServer User Id user name Password thepublicpassword Pooling false provider Invantive CustomerA Acti
18. nnection 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 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 1 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 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved 3 Invantive Webservice User Manual ES Oracle RDBMS MySQL IBM DB2 UDB Linux Unix Windows The actual choice of the database platform depends on which application you will be using Some company applications only work on a portion of the database platforms The support of extra database platforms can be added by a system developer or ordered with Invantive Requests are routed to providers as soon as requests for data or actions arrive to the web server I
19. 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 1 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 Choose the button Next Choose the button Typical Choose the button Install 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 1 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 p
20. ns and applications based on Invantive Producer can exchange data with databases and other services using the internet or the company network It is also possible to use these applications without Invantive Webservice but for installations with more than one user this is strongly discouraged With the Invantive Webservice it will ta ke no time outside of the client installation to allow an extra user or PC to make use of a da tabase without the Invantive Webservice this will take considerably more time for each PC and or user The exchange of data happens through webservices that use the so called http and or https protocol Depending on the chosen security model you can exchange data with databases in the company network using the Invantive webservice both within the company network as well as on the internet from Invantive applications and applications based on Invantive Produ Cer You can also if authorized exchange data with databases at various companies With this you can easily collaborate with multiple clients and or relations in an efficient manner where ver you are and whenever you feel the need to Every client and or relation also has an own installation of the Invantive Webservice The Invantive Webservice works as follows e Auser 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 co
21. o t Windows Ve Copyright 1985 2863 H gt tnsping acciir2 invantive local TNS Ping Utility for 32 bit Windows Version 11 1 6 Production on 07 SEP 2009 14 37 26 Copyright 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 tep gt Chost 192 168 172 16 gt Cport 1521 gt gt gt connect data sid acciir2 gt lt global_name acciir2 inyvantive local gt gt gt 0 msec ERA 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 Invantive Webservice User Manual o Finally check the connection by logging in with SQL Plus 1 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
22. omputer Account and click on Next e Select Local Computer and click on Finish Select OK Click on Certificates Local Computer in the middle part of the window Click on the right on Personal Select All tasks and then Import Set up the filter for Personal Information Exchange pfx e Select the pfx bestand as Personal Certificate Enter the password lf desired you select the check box Mark this key as exportable Allow automatic placement in the storage for the certificate based on the type Select Finish Close the MMC 15 not necessary to save the settings of MMC C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved A Invantive Webservice Start Microsoft IIS through inetmgr Click right on the website usually Default Website Go to Edit bindings Add a https binding and choose the Friendly Name of the certificate that you have just imported 1 7 3 Connection Configuration To make a connection with an Invantive application or an application based on Invantive Pro ducer there needs to be a file settings xml with included within the configuration of the con nection settings This has to be an XML file with the same design as the example The file can contain the configuration to connect with one or more servers If you start an Invantive based application product for the first time the settings
23. ore 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 1 2 Advantages The Invantive Webservice offers various advantages The Invantive Webservice makes it easy to quickly and safely exchange data through the internet between various databases and services For companies this means that the exe cution of financial calculations and the manufacturing and recording of contracts is availa ble from every location the Invantive Webservice allows different companies to work to gether more effective and more efficient within a project That is because the Invantive Webservice simplifies the exchange of information between different parties within a project The Invantive Webserive makes it possible to give part ners through http s authorized access to applications and databases The advantage of this is that existing applications and applications based on Invantive Producer can easily exchange data This means that partners can use applic
24. ow ing disclaimer 2 Redistributions in binary form must reproduce the above copyrightnotice this list of conditions and the follow ing disclaimer in the cumentationand or other materials provided w ith the distribution 3 The end user documentation included w ith the redistribution if any must include the follow ing acknow ledgment This product includes softw are developed by Teodor Danciu http jasperreports sourceforge net Alternately this acknow ledgment may appear in the softw are itself if and w herever such third party acknow ledgments normally appear 4 The name JasperReports must not be used to endorse or promote products derived from this softw are w ithout prior written permission Forw ritten permission please contact teodord users sourceforge net 5 Products derived fromthis softw are may not be called JasperReports nor may JasperReports appear in their name w ithout prior w rittenpermission of Teodor Danciu THIS SOFTWARE IS PROVIDED AS IS AND ANY EXPRESSED OR IMPLIED WARRANTIES INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED IN NO EVENT SHALLTHE APACHE SOFTWARE FOUNDATION OR ITS CONTRIBUTORS BELIABLE FOR ANY DIRECT INDIRECT INCIDENTAL SPECIAL EXEMPLARY OR CONSEQUENTIAL DAMAGES INCLUDING BUT NOT LIMITED TO PROCUREMENT OF SUBSTITUTE GOODS OR SERV ICES LOSS OF USE DATA OR PROFITS OR BUSINESS INTERRUPTION HOWEVER CAUSED ANDON
25. provider s configuration Default providers The default providers are always available A list of the default providers and there order which cannot be used again Order Name Comments 70 Oracle MySQL Provider supporting the execution of actions on Oracle MySQL Built and tested with Connector Net 6 7 4 See http dev mysql com doc refman 5 6 en connector net html File Invantive Data Providers MySql dll 80 Microsoft SQL Server Provider supporting the execution of actions onMicrosoft SQL server 7 0 and later See http msdn microsoft com en us library kb9s9ks0 aspx File Invantive Data Providers SqlServer dll 90 IBM DB2 UDB Provider supporting the execution of actions onIBM DB2 UDB 9 7 for Windows Not tested on any other version File Invantive Data Providers IbmDb2 dll 100 Oracle RDBMS Provider supporting the execution of actions onOracle RDBMS 9i 12c Needs ODP NET and OCI to be installed File Invantive Data Providers Oracle dll 200 Invantive Webservice Provider that is executing action by forwarding it to another Invantive Webservice over HTTP HTTPS File Invantive Data Providers Webservice dll Order 200 ensures that forwaring is preferred instead of a database connection by default The providers tag contains a list of providers available each one consisting of the provider tag Attributes of the provider tag order Sorting order of the provider The higher the value the sooner it is called file T
26. qlClient gt lt connection gt lt connection name MySQL gt database connectionString Server localhost Database database Uid userna me Pwd password provider MySql Data MySqlClient gt lt connection gt lt connection name Oracle gt database connectionString Data Source localhost User Id username Pass word password provider Oracle DataAccess Client lt connection gt lt group gt lt connections gt gt connections default Customer A Production forceDefault false gt lt group name Customer A connection name Production database connectionString Data Source authenticationServer User Id user name Password thepublicpassword Pooling false provider Invantive CustomerA Acti veDirectory failover database connectionString Data Source localhost User Id username Pass word thepublicpassword Pooling false provider Oracle DataAccess Client webservice url http www customer a com ws encoding binary compression true gt lt webservice url http failover customer a com ws encoding binary compression true gt lt failover gt lt connection gt lt group gt lt connections gt 1 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 provide
27. r specifieke condities treedt een Byte error op bij gebruik van de w ebservice Installation No specialties Implementation No specialties 2 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 Invantive Webservice User Manual Tum Web www invantive com Route Follow the instructions of your navigation system The offices are located above Carglass Parking spots are on the right side Parking spots are indicated with a sign with Invantive C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved Index 25 4 404 4 405 4 C s Certificate 7 Channel 2 26 Company network 1 Connection 26 Connection Configuration Invantive Producer 8 Contact Information Invantive Software BV 26 D Data 2 Database platform 2 a a Error 404 4 405 4 Exchange 1 Failover 3 H Harderwijk 26 http 2 https 2 IBM DB2 25 IBM DB2 for Windows 2 Installation 4 oracle client 14 tunneling web service 4 Invantive Webservice 1 system requirement 1 Microsoft net framework 4 5 Microsoft iis 4 Microsoft SQL Server 2 25 MySQL 2 MySQL Connector Net 25 Nils lang 22 Oracle 2 client 14 22 P Provider 2 Prov
28. ro 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 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 1 8 Terminology Hieronder beschreven we de gebruikte termen 1 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 1 8 2 Connection A connection is the definition of possibilities to establish a channel 26 between an Invantive Producer client application and an Invantive Webservice server 1 9 Versions This chapter describes the changes in the application per version 1 9 1 Release 2014 R1 Released XX XX 2014 Invantive Producer bXX and c fixes nO DB2 data Sa TU D Rc support 23456 ER IBM DB2 ook via ODBC ER IBM DB2 ook via ODBC mogelijk maken maken 22594 ER Ondersteuning voor redundante verbindingen failover 23279 PR Onde
29. rs 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 272 smoke Configuration of providers for Invantive Webservice Purpose You can configure providers here sorted by order Providers are tried to handle a request in decreasing order So the provider with order 500 is offered the request before the provider with order 400 is offered the request Providers with order 70 80 90 100 and 200 are reserved for Invantive internal use see the table below Explanation Providers are used to provide functionality that is not part of the webservice A provider knows how to handle a specific action on a specific platform Some providers are included in the installation such as providers for database or webservice connectivity or a file logging provider The default providers are included in the software so they are not listed here between the providers tag A provider does in general NOT define WHERE the action will be executed That is normally specified by the settings xml C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved A Invantive Webservice EN But specific providers may contain the location WHERE the action will be execu ted as default value or specified as attributes with the
30. s 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 ge Invantive Webservice User Manual o Attributes default The default connection The format is group connection the first connection with the given name will be used when the group element is omitted forceDefault If true only the default connection can be used No other connection is eligible for selection based upon this settings xml file You can use for in stance when you add a new default connection and you want to make sure everyone switches to the new connection irrespective of what connection is currently used as default The group level This level defines a set of connections logically grouped together You are free to choose the way of grouping Examples of logical manner of grouping by customer by environment production test Attributes name The name of the group The connection level This level defines an actual logical connection For example Production environment Acme site Under this level the actual transport mechanism and its settings can be defi ned The connection and associated failovers are tried when initially establishing the connection and when reconnecting after the provider detected a connection loss The elements of this level can
31. t 1 C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved B Invantive Webservice Subsequently a number of checks will be performed If problems are found solve them first Oracle Universal Installer Product Specific Prerequisite Checks ORACLE 11 DATABASE ATABASE Product Specific Prerequisite Checks Checking Oracle Home path for spaces Automatic 4 Succeeded Checking for Oracle Home incompatibilities Help Installed Products Install Cancel Check the settings Check if ODP Net is listed between the products to be installed Execute the installation by choosing Install C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved o9 Invantive Webservice 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 cioracle Oracle Home cAoracleiproducti 1 1 0 client 1 OraClient11g home Installation Type Administrator Product Languages Arabic Bengali Brazilian Portuguese Bulgarian Canadian French Catalan Croatian O mnl M The progress is displayed C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved B Invantive Webservice Oracle Universal installer Install ORACLE T1 p DATABASE Install Ideal Pl
32. veDirectory lt failover gt database connectionString Data Source localhost User Id username Pass word thepublicpassword Pooling false provider Oracle DataAccess Client lt webservice url http www customer a com ws encoding binary compression true gt lt webservice url http failover customer a com ws encoding binary compression true gt lt failover gt lt connection gt lt group gt lt connections gt This example illustrates connections to different database platforms The soft ware will try to Connect to the IBM DB2 UDB database when connection DB2 is selected Connect to the Microsoft SQL Server database when connection SQLServer is selected Connect to the Oracle MySQL server when connection MySQL is selected Connect to the Oracle RDBMS server when connection Oracle is selected connections default Customer A Production forceDefault false gt lt group name Customer A lt connection name DB2 gt database connectionString Server localhost Database THE DATABASE UID us ername PWD password CurrentSchema schema provider IBM Data DB2 gt lt connection gt lt connection name SQLServer C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved aa Invantive Webservice User Manual o database connectionString Server localhost Database database User Id us ername Password password provider System Data S
33. was canceled Installed Products C Copyright 2004 2013 Invantive Software B V the Netherlands All rights reserved oa 77 m Gad Invantive Webservice Close the error message about the failure of the Oracle Net Configuration Assistant Select Exit Oracle Universal Installer End of Installation 5 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 Construct if not available yet a tnsnames ora configuration file n a tnsnames ora file tns is the abbreviation for Transparant Network Substrate all Oracle based databases services and the route via the network to get there are descri bed 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 connect data 88 sid dvtiir2 88 global name dvtiirZ invantive local 90 i 91 e This one describes that on the server with IP address 192 168 172 16 on port 1521 a pro gram runs that knows how to make a connection with an Oracle database with the SID dv C Copyright 2004 2013 Invantive Software B V the Nether
34. xml file is searched for at multiple locations in succession the installation folder containing setup exe e from the installation folder a folder upwards from the installation folder a folder up and the file folder in it from the installation folder two folders up from the installation folder two folders up and the file folder under it from the installation folder three folders up from the installation folder three folders up and the file folder under it in the folder c ws If the settings xml file can not be found the user will be asked where the settings xml file is located The chosen location of the settings xml file is remembered and used from that mo ment In the text below it is described how it works lt xml version 1 0 encoding utf 8 lt C 2004 2013 Invantive BV the Netherlands www invantive com SHeader http svn invantive com repos pl04 trunk help nl manual Topics verbin dingsconfiguratie xml 23549 2013 11 01 14 21 272 smoke Purpose Configuration of the Invantive Webservice and direct database connections available to client and the Invantive Webservice acting as a database client Explanation Connections are used to retrieve data from a database and to update the contents of databases This settings file can accommodate all settings for database and web service connections that are used by Invantive products This file contains a number of structured element
Download Pdf Manuals
Related Search