Servoy iPhone Application Builder Installation Guide iPhone Application Builder Installation

Servoy iPhone Application Builder Installation Guide iPhone Application Builder Installation Guide Page 1 Table of Contents Welcome to Servoy.............................................................................................................................3 Overview of the Main Sections:...................................................................................................................3 Fast Facts.............................................................................................................................................4 Product Pricing and Availability..................................................................................................................4 Minimum System Requirements.................................................................................................................4 Top 10 New Features in Servoy 4.0.............................................................................................................5 About Servoy...............................................................................................................................................6 Section 1: Servoy Overview...............................................................................................................7 What it Is and How It's Different................................................................................................................7 Productive Development Environment.......................................................................................................7 Flexible Deployment Options......................................................................................................................7 Leading Tool For Creating SaaS Applications.............................................................................................8 Extensible....................................................................................................................................................9 Standards-Based..........................................................................................................................................9 Section 2: Installation.......................................................................................................................10 Downloading the Servoy Community Edition...........................................................................................10 Installing the iPhone Application Builder.................................................................................................10 Section 3: Hands-On Tutorials.........................................................................................................13 Before You Begin........................................................................................................................................13 Exercise #1 – Checking out the solution....................................................................................................13 Exercise #2 – Creating a Basic Application...............................................................................................17 Exercise #3 – Deploying Your Solution to Your iPhone...........................................................................28 Exercise #4 – Build an Application Based on Your Own SQL Data..........................................................31 iPhone Application Builder Installation Guide Page 2 Welcome to Servoy Thanks for taking the time to check out Servoy's iPhone Application Builder example file. This document will tell you how to install it and get up and running creating your own iPhone applications. Overview of the Main Sections: Fast Facts ● ● ● ● Pricing & Availability System Requirements Top 10 New Features in 4.0 About Servoy Section 1 – Servoy Overview ● Servoy 4.0 Overview – for people who are new to Servoy Section 2 – Installation ● ● Downloading and Installing the Community Edition Installing the iPhone Application Builder solution Section 3 – Hands On We'll walk you through creating a very simple iPhone application. This will allow you to get a better idea of how the tool works. ● ● ● ● Exercise #1 – Checking Out the Solution Exercise #2 – Creating a Basic Form With Objects Exercise #3 – Deploying Your Solution to Your iPhone exercise #4 – Build an Application Based on Your Own SQL Data We are very interested in your feedback on our software and how we can make this guide even more helpful to you. Please contact Brenda Christensen for additional information, including access to technical support, or to schedule a personalized demo. The Servoy Team sales@servoy.com iPhone Application Builder Installation Guide Page 3 Fast Facts Product Pricing and Availability Servoy comes complete out of the box – including an Enterprise-level SQL Anywhere database by iAnywhere (a Sybase company) – and ready to go. Servoy's standards-based IDE is a plug-in for the most popular IDE in the world – Eclipse. Product Servoy 4.1 Community Edition Servoy 4.1 Developer Servoy 4.0 Smart Client Servoy 4.0 Web Client Servoy 4.0 Headless Client Servoy 4.0 Application Server Availability December 1, 2008 December 1, 2008 December 1, 2008 Pricing FREE $895 $349 per concurrent client OR per server OR based on your business model FREE (included with Client) December 1, 2008 Volume licensing and 20% Education discount available as are CPU and Server licenses for web deployment. Minimum System Requirements Servoy 4.1 Developer Windows Java 1.5.0 or higher 500 MB of free RAM Hard disk with 300MB free Windows XP or Vista Networking: TCP/IP Servoy 4.1 Application Server Windows Java 1.5.0 or higher 500 MB of free RAM Hard disk with 300MB free Windows XP or Vista Networking: TCP/IP Linux Java 1.5.0 or higher 500 MB of free RAM Hard disk with 300MB free Mac OS X Apple Java 1.5 500 MB of free RAM Mac OS X 10.4 or higher 300MB free disk space Solaris Linux Java 1.5.0 or higher 500 MB of free RAM Hard disk with 300MB free Mac OS X Apple Java 1.5 Mac OS X 10.4 or higher 500 MB of free RAM 300MB free disk space iPhone Application Builder Installation Guide Page 4 Servoy 4.1 - Smart Client Deployment Windows Java 1.5.0 or higher 256 MB of free RAM Hard disk with 300MB free Windows XP or Vista Networking: TCP/IP Servoy 4.1 - Web Client Deployment Windows Linux Mac OS X FireFox 2,3, Safari, Camino, Opera Mac OS X 10.2 or higher 50MB free disk space Linux Java 1.5.0 or higher 256 MB of free RAM Hard disk with 300MB free Mac OS X Apple Java 1.5 Mac OS X 10.4 or higher 256 MB of free RAM 300MB free disk space Internet Explorer 6,7, FireFox 2,3, FireFox 2,3 Safari, Opera 256 MB of free RAM 256 MB of free RAM Hard disk with 50MB free Hard disk with 50MB free Windows XP or Vista Networking: TCP/IP Top 10 New Features in Servoy 4.0 1. 2. 3. Servoy Developer is now based on Eclipse – the world's most-used IDE; Form Inheritance allows you to re-use forms and override methods rather than having to duplicate forms with similar functionality; Form Variables allow you to define variables in the context of a form – rather than having to define multiple application-wide “global” variables – reducing clutter and streamlining development efforts; Live client debugging for both Smart Client (client/server) and Web Client (browser-based) solutions – giving you unprecedented abilities in debugging applications; Enhanced scripting environment with new auto-complete functionality, user-defined code coloring, conditional/persistent breakpoints and inline XML support; New menubar plug-in – you can now control all the menus in Servoy, create your own new contextual menus, window menus and your own toolbars to solutions; New JasperReports plug-in that allows seamless integration with JasperReports – even in multitenant SaaS applications; Design broadcasting will update the Smart Client and Web Client live as changes are made to the application – avoiding the need to relaunch Smart Client or “refresh” page in the Web Client; You can now edit multiple objects at a time (forms, methods, value lists, table definitions, etc.) 4. 5. 6. 7. 8. 9. iPhone Application Builder Installation Guide Page 5 10. Built-in Team support for multiple Servoy repositories as well as CVS and Subversion which allow multiple developers in disparate locations the ability to check in/out objects, create multiple versions, and view the differences between versions. About Servoy The Servoy development and deployment environment has been used by tens of thousands of developers and hundreds of thousands of end users to be more productive and efficient. Small to medium size Independent Software Vendors (ISV's), businesses, corporate work groups, educational institutions and government agencies use Servoy to easily create and deploy user interface applications for data stored in SQL databases and deploy those applications via a native Smart Client or via a browser with Servoy Web Client all from a single code base. Servoy has built-in functions to be able to deploy software from a single code-base to both on-Premise and SaaS deployment models. North America Address: Servoy USA 299 W. Hillcrest Drive Suite 115 Thousand Oaks, CA 91360 European Headquarters: Servoy B.V. De Brand 26 3823 LJ Amersfoort The Netherlands Voice: +31 33 455 9877 Phone Numbers : Sales: 1-877-4-SERVOY (877-473-7869) Switchboard: (805) 624-4959 Web: General: http://www.servoy.com Store: http://www.servoy.com/store Tutorials: http://www.servoy.com/developer Online Forum: http://forum.servoy.com Media Contact: Brenda Christensen (805) 624-4959 x813 bchristensen@servoy.com iPhone Application Builder Installation Guide Page 6 Section 1: Servoy Overview What it Is and How It's Different Servoy is a cross-platform application development and deployment environment used to create and deploy applications. Servoy consists of a powerful GUI designer, is fully event-driven and scriptable through JavaScript (or straight Java) to help you build and deploy your applications much faster than traditional development environments. Productive Development Environment For Developers Developers can build front-ends to databases in minutes -- without having to write any SQL code, even when combining data from multiple sources. Servoy is based on industry standards - there are no proprietary technologies or languages to learn. For ISVs and Vertical Market Products If your current technology is older – and you're considering a re-write – Servoy is the tool for you. You can get your rewrite done quickly in this standards based Rapid Application Development Tool (RAD). Lower your costs with our zero deployment environment. Open up markets with no recoding - to Linux, Windows, Mac. Deploy seamlessly to the web, hand helds, mobile units. Deploy to a browser and native client from the same code base – and increase your profits by offering your software as a service. For Corporate IT Applications developed with Servoy can access data from all popular SQL back-ends such as Oracle, Microsoft SQL Server, IBM DB/2, IBM Informix, Sybase, OpenBase, MySQL, PostgreSQL, Firebird; and combine data from different databases into a single user interface (UI). Servoy applications can be deployed on all popular operating systems including Microsoft Windows, Mac OS X, Linux, Solaris and other UNIX systems. Flexible Deployment Options Once you've built your application you can choose to deploy it in a number of different ways – all from the same code base and all from the same Servoy Application Server – all at the same time. Servoy Smart Client The Servoy Smart Client is our native, zero deployment client. The majority of our customers deploy the Smart Client on their LAN, WAN and over the Internet for a rich client experience without the hassles of traditional client deployment. Using Java WebStart technology – the deployment is easy- the user opens a browser, points to the URL of the Servoy Application Server, and clicks. A one time 2MB download comes down to the local computer and it automatically launches – and gives the user the option of creating a desktop shortcut. Then, every time the application is launched (either through the browser or via the shortcut) – the software checks to see if there is a new version of the software available. If there is, it will automatically download and configure itself and continue to launch. Zero deployment hassles. iPhone Application Builder Installation Guide Page 7 Servoy Web Client The Servoy Web Client is a 100% HTML + CSS rendering of the application. There are no browser plugins, no Active-X controls, and no other software required – only a browser. Servoy will automatically do the rendering of the application – so the developer doesn't have to write any code at all to deploy to the browser. In addition, the application utilizes AJAX to provide a rich experience without having to reload the entire page after every action, and supports complex interactions such as showing/hiding/coloring objects, live calculation updates and more. All the methods run server-side – so your web application is secure. When a web-based user updates information - the changes are automatically (and intelligently) broadcast to all the LAN/WAN users just as if that web-based user were on the local network. It works the other way around as well – if a LAN/WAN user makes an update – that information is sent both to other Web Client users , Smart Client users and Headless Client users as well. The Servoy Web Client can be run in any modern browser including Firefox, Internet Explorer, Safari, and Opera on Windows, Mac OS X, Linux and Solaris. Servoy Headless Client The Servoy Headless Client is an instance of the Client code running in memory on the Server. This allows the developer to connect to it via JSP (Java Server pages), other Java Applications or other web services. This ensures that you can use other technologies and still leverage all the business logic and methods used in your Servoy applications. Just like with the Web Client - when a web-based user updates information on a Headless Client-based JSP page - that change is automatically (and intelligently) broadcast to all the LAN/WAN users just as if that web-based user were on the local network. Servoy Runtime Client The Servoy Runtime Client is designed as a local computer install, not for network deployment. This is great for offline data gathering, large product catalogs, configuration managers, etc. We also have a synchronization plug-in or iAnywhere's MobiLink software that allows you to synchronize the offline data back into the main database(s). When you synchronize the data – that new and changed data is broadcast to all Smart Client, Web Client and Headless Client users automatically. Leading Tool For Creating SaaS Applications Servoy comes with a number of functions that make it easy to create robust Software as a Service applications – including: ● ● ● ● Functions that automatically filter datasets that allow the user to perform ad hoc searches while maintaining data security (full multi-tenancy support) Automatic audit trail that not only tracks data changes – but will help in workflow analysis (how the users actually use the applications Full support for custom, event-triggered functions for usage statistics, conditional screen elements, and user preferences Able to deploy the same application in multiple ways – from the same code base – either hosted or as on-premises install iPhone Application Builder Installation Guide Page 8 Extensible Servoy has a 100% Java-based plug-in API. This robust API allows you to use custom, free or off-the-shelf Java jar files to extend the functionality of Servoy at the Developer, Client, and Application Server levels. Plug-ins can do anything that Java can do – including communicating with the client computer, running processes server-side, and even changing the Developer and Client user interface elements (menus, lookand-feel, etc.). Standards-Based Finally, Servoy is based on Industry Standards. You can use SQL commands, call stored procedures, format fields to use HTML or RTF. The data communication layer uses SSL (Secure Socket Layer), TCP/IP and RMI (Remote Method Invocation). You can connect to web services via SOAP and XML. The Web Client uses AJAX, HTML, XML and other standards-based technologies. There is no proprietary database and no proprietary scripting language and no proprietary file formats when you use Servoy. The scripting language is JavaScript – which is the most-used scripting language in the world. It doesn't stop there – because Servoy automatically compiles all the JavaScript into Java byte code for fast, secure execution. Because Servoy is a 100% Java application, Servoy is both database and platform agnostic. You can connect to any modern SQL database that has a JDBC driver – and you can even connect to more than one database at a time, from multiple vendors, across the LAN, WAN and Internet – and created unified views of your data without programming. iPhone Application Builder Installation Guide Page 9 Section 2: Installation This section will describe how to download the Servoy Community Edition and install the iPhone Application builder – so you can get up and running quickly! Downloading the Servoy Community Edition 1. 2. 3. 4. Download the Servoy 4.1 BETA 5 (or later) software from: http://www.servoy.com/generic.jsp? mt=393&taxonomy_id=553&dl=iPhone Install the software by double-clicking the installer. It's OK if you just want to accept all the “defaults” during installation. Once it's finished installing – double-click the “Servoy Developer” icon Once you see the “Welcome” page – you know that Servoy's been fully installed – including the Sybase iAnywhere database – and is ready to go. Installing the iPhone Application Builder 1. First, we'll create a new database and database connection. In Servoy, it's a snap. Simply expand the “Database Servers” node and right-click (or Control-Click on Mac) on any existing connection name in the Solution Explorer – then choose “Create Sybase Database”. NOTE: MAKE SURE THERE ARE NO SPACES IN THE NAME OF YOUR SERVOY INSTALLATION DIRECTORY!! iPhone Application Builder Installation Guide Page 10 2. Enter “servoy_iphone_framework” (NO quotes) and click OK: 3. Once it's done creating the database and starting it up – you will see the connection information: If you want – you can view a Flash movie on this basic process – just substitute “servoy_iphone_framework” as the name of the new database. 4. At this point YOU MUST exit the Servoy Developer and stop the Sybase database (in the Windows tray – it looks like a lightening bolt – or on Mac it's stopping the “dbsrv10” process from Applications:Utilities) and restart Servoy Developer. This ensures that the Sybase database and new connection properties are written to disk correctly. Open up a browser and enter the URL: http://localhost:8080/servoy-admin This is Servoy's browser-based administration tool. You can do a whole host of things from this single set of pages – but we're going to focus on importing a solution. Click on the “Solutions” tab and click the “Import Solution” link at the bottom. You should see a screen that looks like this: 5. iPhone Application Builder Installation Guide Page 11 6. Click on the “Browse” button and locate the Servoy file you downloaded. It's called “Servoy_iPhone_Builder.servoy” - and click the “Import” button at the bottom of the screen. 7. 8. MAKE SURE you DO check “Import sample data”: Servoy will now automatically create all of the necessary tables, import the data into the appropriate tables and import the entire iPhone Application Builder into the master repository database. Now you're almost ready to begin creating your own iPhone applications! Continue on to Section 3 where “the magic” begins... iPhone Application Builder Installation Guide Page 12 Section 3: Hands-On Tutorials Before You Begin Make sure you've already installed Servoy Developer 4.1 and you've installed the iPhone Application Builder as per the instructions in Section 2. Exercise #1 – Checking out the solution Estimated Time: 2-3 Minutes Everything in Servoy starts by either by creating a new solution – or checking out an existing solution. This example assumes that you've never checked anything out of the repository (e.g. you're starting from a fresh install). 1. Open Servoy Developer and right click on the “All solutions” node in the Solution Explorer and choose “Check Out”: 2. In the choose “Checkout Servoy solution from repository” dialog leave “localhost” in the Server address field and the User and Password fields blank and click “Next”: iPhone Application Builder Installation Guide Page 13 3. Click on + next to “mod_iPhone”, and click the HEAD version (this is always the latest version in your repository) – and click “Finish”: iPhone Application Builder Installation Guide Page 14 4. Click the “Run in Background” button – and this will begin the checkout process. This process will copy all of the resources out of the repository and on to your local hard drive. 5. Once that's done – you'll see that you now have an “active” solution. An active solution is marked with a green “S” icon in the Solution Explorer: 6. To start the Servoy Smart Client so you can see the iPhone Application Builder – simply click the icon on the toolbar – or choose “Start Smart Client” from the “Actions” menu: iPhone Application Builder Installation Guide Page 15 7. In a few seconds you should see that the Smart Client has launched in a separate window. This is the actual solution just the way end users will see it. When you're in Servoy Developer you can use this instance for debugging and previewing any new forms that you create. iPhone Application Builder Installation Guide Page 16 Exercise #2 – Creating a Basic Application Estimated Time: 15-20 Minutes Building and deploying a simple iPhone application is very fast and easy. In this example we'll create a simple, 1 form application that it based on one of the sample databases that is included with the default installation of Servoy. If you want to use your own SQL database – then do example 3 below before starting this one. If you haven't already – make sure you have installed Servoy Developer and installed the iPhone Application Builder solution. You should have also already completed exercise #1 – and have the iPhone Application Builder open in the Servoy Smart Client as pictured above. Our application is going to be pretty simple – a “Main Screen” that will show main navigation buttons (we're only going to create one – but you can add others later); a Customer List and a Customer Detail form. In practice, it's a good idea to create all of your forms first, and then go back and add items to it. Why? Simply because you may want to navigate to different items and unless you have the forms created, you won't be able to hook things up right away – and you may forget to later. We've included a “Sample CRM” iPhone application that you can explore later – but for now click the “+” button in the “Solutions” section. Now in the “Solution Properties” section – click into the “Solution Name” field and name your solution “HelloWorld”. Make any notes you want to – and in the “Form Prefix” field – enter “hello”. This will prefix all the forms you create with the physical name of “hello” to ensure that ALL forms you create will have a unique name. iPhone Application Builder Installation Guide Page 17 In the “Forms” section below the “Solutions” section – click the “+” button, and fill out the properties as noted below: Display Name: Main Reference: Main Form Form Type: Form Server: example_data Table: customers Left Button (checkmark) Breadcrumb (selected) Text: Apps Go Form: [Application List] iPhone Application Builder Installation Guide Page 18 A “breadcrumb” is the button in the upper left hand side of the screen that will take you back to the section you just came from. In this case – since this is the first form we've created – it will take us back to the builtin listing of all the iPhone applications. Click the “+” button next to “Forms” again, and create another form with these properties: Display Name: Customers Reference: Customer List Form Type: List - Navigation Server: example_data Table: customers Left Button (checkmark) Breadcrumb (selected) Text: Main Go Form: Main Form iPhone Application Builder Installation Guide Page 19 Click the “+” button next to “Forms” again, and create another form with these properties: Display Name: Customer Reference: Customer Detail Form Type: Form Server: example_data Table: customers Left Button (checkmark) Breadcrumb (selected) Text: List Go Form: Customer List Right Button (checkmark) Edit button (selected) Edit Form: Customer Detail iPhone Application Builder Installation Guide Page 20 The top right button will allow us to edit the customer data. You don't have to include this button if you want the data to be read-only – but in this case we'll allow the users to edit the data. In order to edit the data, you have to specify what form is going to be used – and in this case it automatically entered the name of the current form. But, if you wanted to have an edit button on a list view – then that's when you would have to manually specify an edit form. Now that we have all of our forms defined – we can add objects to them. Click on the “Main” form and then click the “+” next to “Form Objects” and you'll see a dialog: This dialog will allow you to create multiple items at once – which is really handy. It's a feature we'll use later when we're defining the fields on the Customer Detail form – but for now just choose “Navigation Item” from the list and click “Create” - then click “Done.” Navigation Items are used when you want to jump to another form – or execute your own Servoy code. You can also optionally sort the data and filter the data on the form you're navigating to. Make sure your properties look like the ones below: iPhone Application Builder Installation Guide Page 21 We want our list of customers sorted by company name – so click the “Sort...” button: Click on the “companyname” field and then click the “>>” button (you can also just double-click on the companyname column to move it). Now click “OK”. That's it! When we navigate from the Main form to the Customer List – our data will be sorted by the companyname field. You can choose as many sort column as you would like – and you can always come back and remove the sort – or change it at any time. We're done with the Main form, so click on the “Customer List” form and click the “+” button in form objects. Did you notice that you didn't get a chance to choose the type of object on the form? That's because this form is defined as a “List – Navigation” - and so it will always have only a single item – a label. In addition, there are several options that are dimmed out – or made unavailable. This is because list views on the iPhone look and behave a certain way. We need to set up what data will be shown in our list. We want to show the company name field – so click the “...” button next to “%%field%%”. This will allow you to choose one or more fields to display in the list. We recommend you only show a single field because the iPhone display isn't that wide. When you see the “Label Text” dialog – select %%field%% and then double-click the “companyname” field on the left, then click “OK.” iPhone Application Builder Installation Guide Page 22 Once you have set the label text – we need to do something when the label is clicked on. In this case, we want to go to the Customer Detail form. In the “On Click” section of the properties choose “Customer Detail” from the “Go to a form” menu: There's no need to sort the results – since we'll be looking at a single record – and the iPhone Application Builder will automatically navigate to the record you clicked on – so there's no need to add a Filter. iPhone Application Builder Installation Guide Page 23 For advanced developers – you'll notice that you have the option of running your own code on click. Simply enter (or paste) the Servoy method code you want to execute – and it will be run automatically when the item is clicked. We've defined two out of the three screens. The last screen we need to define is the Customer Details. Click on the Customer Details form and click the “+” button next to “Form Objects”. You'll see the same “Create Form Object(s)” dialog as we saw earlier. This time choose “Field – Text” and you'll see that two additional pop-up menus appear: “Dataprovider” and “Label.” Choose “companyname” from the “Dataprovider” list – and notice that the “Label” is automatically filled out with the value “Companyname”. This is the label that will appear next to the field on the form – and you can either edit it here – or edit it later. For now, enter “Name” into the “Label” and click “Create.” Once you've created the field – the Dataprovider and Label will clear – and you can create another object. It can be any object, not just a text field. Go ahead and add some more text fields to the form: Object Type Field – Text Field – Text Field – Text Field – Text Field – Text Dataprovider contactname address city contacttitle country Label Contact Address City Title Country iPhone Application Builder Installation Guide Page 24 When you're done creating the items click the “Done” button. CONGRATULATIONS! You've just created your first iPhone Application! Now we're ready to preview our application. At the bottom of the “Solutions” list – click the “Properties” button to show the Solution Properties and click the “Preview Solution” button: After a couple of seconds (if there are no errors) – you'll see the iPhone preview window. This is an approximation of how it will look on the iPhone. Click on your HelloWorld solution. iPhone Application Builder Installation Guide Page 25 Notice how the main button says “Navigation” - we'll fix that in a minute – but go ahead and click it. You'll see the list of all the customers. Notice the breadcrumb in the upper left? That will take you back to the main navigation form. For now, click any one of the customers: iPhone Application Builder Installation Guide Page 26 You can click the “Edit” button and edit the data. By default – all the editable fields will appear on the same form, but you can change the behavior so that all editable fields have their own separate edit window (like the default “Contacts” application) by choosing “Separate edit screen per editable item” in the form properties of the Customer Detail form. There's another problem with this screen, however. It seems that we have the Title field in the wrong spot. It should be below the contact name. So let's go back and fix the two errors: change the text on the navigation item and change the order of the fields on the Customer Detail form. Close the Preview window by clicking the close box on the upper left (upper left for Mac folks). Click on the “Main Form” from the “Forms” list. Since there is only one item – the Navigation Item is already selected. Change the “Label” text from “Navigation” to “Customer List”: iPhone Application Builder Installation Guide Page 27 Now, to change the order of the fields on the Company Detail. Click on the “Company Detail” form from the “Forms” list – and click on the “Title” field in the “Form Objects” list. Then click the “up” button so that the “Title” field appears below the “Contact” field. iPhone Application Builder Installation Guide Page 28 iPhone Application Builder Installation Guide Page 29 iPhone Application Builder Installation Guide Page 30 You can preview the solution again just to make sure it's the way you want. OK – so now we've build our first simple application, let's check it out on the actual iPhone! Exercise #3 – Deploying Your Solution to Your iPhone Estimated Time: 2 minutes Open up Safari on your iPhone and enter the following URL: http://yourIPaddress:8080/servoy-webclient (where “yourIPaddress” is replaced with the IP address from your computer). When you open that URL they will see a screen similar to this (you may have to pinch it to make it a little bigger): iPhone Application Builder Installation Guide Page 31 Tap on the “mod_iPhone” application – and you'll see the same list of Solutions you did in the iPhone preview window. Choose your “HelloWorld” application: iPhone Application Builder Installation Guide Page 32 iPhone Application Builder Installation Guide Page 33 iPhone Application Builder Installation Guide Page 34 Exercise #4 – Build an Application Based on Your Own SQL Data Estimated Time: 2-3 minutes You can easily create connections to any type of SQL database that has a JDBC driver (most modern SQL databases do). If you want to connect to Microsoft SQL Server, PostgreSQL, or Sybase – the drivers are already pre-installed for you. If you want to connect to another database – (like MySQL, DB2, etc) – just download the JDBC driver from the vendor's site – and put the entire “zip” folder into the “drivers” folder located in the “application_server” folder of your Servoy install directory – and restart Servoy Developer. You can connect to the database on the LAN. WAN and even over the Internet, and you can connect to as many types of databases as you want – there is no limit. To be able to build applications using that database, you need to make a database connection in Servoy – so Servoy will know where the database is and how to connect to it. 1. Open Servoy and right click on the “Database Servers” node and choose “New Server” and choose the type of database you want to connect to. iPhone Application Builder Installation Guide Page 35 2. Once you choose a type of database – you'll see the configuration panel appear: This example is for a new Sybase connection – but setting up any other database is the same process. Fill in the “Server name” with what YOU want to call this database connection. Can be anything (“hostedOracle”, “deptSvr452”, etc). 1. ut in the username and password for the database connection you want to use (the default for a new SQL Anywhere database is dba/sql). 2. In the URL string – replace “localhost” with the IP address of where the server is running and change the port if it's not running on the default port. 3. Replace “” with the physical name of the database. 4. If you're using Oracle choose the catalog (optional depending on your setup) and/or the Schema. TIP: When using oracle – make sure the database name is in ALL CAPS. 5. To test your connection, choose “Save” from the “File” menu (Ctrl + S). If you don't see an error – then the connection has been tested and is now ready to go. Extra Credit: Go back to exercise #2 – and rather than using the “example_data” connection – use the one you just created and create your own iPhone application(s) using your own data! iPhone Application Builder Installation Guide Page 36