yourfanat wrote: I am using another tool for Oracle developers - dbForge Studio for Oracle. This IDE has lots of usefull features, among them: oracle designer, code competion and formatter, query builder, debugger, profiler, erxport/import, reports and many others. The latest version supports Oracle 12C. More information here.
Cloud Computing
Conference & Expo
November 2-4, 2009 NYC
Register Today and SAVE !..

2008 West
Data Direct
SOA, WOA and Cloud Computing: The New Frontier for Data Services
Red Hat
The Opening of Virtualization
User Environment Management – The Third Layer of the Desktop
Cloud Computing for Business Agility
CMIS: A Multi-Vendor Proposal for a Service-Based Content Management Interoperability Standard
Freedom OSS
Practical SOA” Max Yankelevich
Architecting an Enterprise Service Router (ESR) – A Cost-Effective Way to Scale SOA Across the Enterprise
Return on Assests: Bringing Visibility to your SOA Strategy
Managing Hybrid Endpoint Environments
Game-Changing Technology for Enterprise Clouds and Applications
Click For 2008 West
Event Webcasts

2008 West
Get ‘Rich’ Quick: Rapid Prototyping for RIA with ZERO Server Code
Keynote Systems
Designing for and Managing Performance in the New Frontier of Rich Internet Applications
How Can AJAX Improve Homeland Security?
Beyond Widgets: What a RIA Platform Should Offer
REAs: Rich Enterprise Applications
Click For 2008 Event Webcasts
In many cases, the end of the year gives you time to step back and take stock of the last 12 months. This is when many of us take a hard look at what worked and what did not, complete performance reviews, and formulate plans for the coming year. For me, it is all of those things plus a time when I u...
Using the Eclipse Data Tools Platform with PowerBuilder and SQL Anywhere
Now a top-level project at

To learn more about DTP, resources can be found at

SQL Anywhere is a suite of databases and data exchange technologies that pack a lot of power and performance into a small footprint. The SQL Anywhere Server database supports 32-bit and 64-bit servers on all major platforms. Many ISVs embed the SQL Anywhere Server database into their applications because not only can it scale from client/server environments with hundreds, even thousands, of users storing hundreds of gigabytes of data, but it can also be easily hidden in an application that runs on desktop and laptop computers requiring little or no IT support. You can learn more about SQL Anywhere by visiting

This tutorial shows you how to install the Data Tools Platform Eclipse plug-in and how to use some of its features against a SQL Anywhere 10 database.

  •   SQL Anywhere 10.0.1 or higher
  •   DTP 1.5M6 End-user or later
  •   Depending on what version of DTP you download, you will need specific versions of:
    -   Eclipse SDK. At the time this writing, Eclipse 3.2.2 SDK was required.
    -   EMF runtimes (EMF + SDO). At the time of this writing, EMF 2.2.2 (EMF +SDO) was required.
    -   GEF runtimes. At the time of this writing, GEF 3.2.2 was required.
  •   JRE 1.5 or higher
  •   Sybase jConnect 6.05 - available at

Before You Begin Downloading the Data Tools Platform
The first thing you need to do is download the DTP plug-in and include it in your Eclipse folder. You may also have to download the EMF and GEF plug-ins if you don't already have them. When you download and extract all the files, you have to merge them into your current Eclipse folder, where you typically launch the application. Here's a link where you can download DTP; it also has links to all of its dependencies (EMF and GEF):

Starting the Sample Database
This tutorial uses the sample database provided with the installation of SQL Anywhere. It's called demo.db and you can find it in the samples folder of your SQL Anywhere installation. If you're running on Mac OS X, Linux, or Unix, you'll need to configure the samples by sourcing the file 'samples/' from your SQLAnywhere 10 installation folder. If you're running on Windows, the samples folder is defined in the %SQLANYSAMP10% environment variable.

Stop all the databases running on your machine, find this file, change to its directory, and run the following command in a command prompt: dbeng10 demo.db.

This will start a database engine called 'demo', listening on port 2638 with one database called 'demo'.

Creating a Driver Template and Connection Profile
In this section we'll cover how to define a driver template and create a connection profile to be used to connect to our sample database.
1.  In Eclipse, click 'File' | 'New' | 'Other' (see Figure 1)
2.  Choose 'Connection Profile' (see Figure 2)
3.  Click Next. Specify 'Sybase ASA' as the connection profile type (see Figure 3) (Note: The SQL Anywhere Server database was called ASA in previous versions of the product.)
4.  Click Next. Give the connection profile a name, type 'sqlanywhere10' (see Figure 4)
5.  Click Next. Here we have to choose a driver, but we have no driver templates defined. Click the browse button circled in the image below (see Figure 5)
6.  Click 'Add' to add a new driver template (see Figure 6)
7.  Choose the 'Sybase JDBC Driver for Sybase ASA 9.x (see Figure 7)
    -   Even though we're connecting to a SQL Anywhere 10 database, we can use this driver template and change the appropriate settings
    -   Change the driver name to 'Sybase JDBC Driver for SQL Anywhere 10.x'
    -   Make sure the 'Edit New Driver Definition Immediately' box is checked
8.  After clicking 'OK,' press the 'Add Jar/Zip' button to browse for the jConnect 6.05 JAR file: jconn3.jar
9.  Set the driver properties at the bottom of the screen as show in Figure 8
10.  Click 'OK'
11.  Now that we've defined a driver template, we can return to this screen, choose our new driver, and click 'OK' to continue (see Figure 9)
12.  Set the connection profile settings as shown below and click 'Finish' (see Figure 10)

Now that we've created a connection profile, we can use the Data Source Explorer to connect to our sample database and view database objects in the object tree.

Connecting to SQL Anywhere 10
To connect to our SQL Anywhere sample database, we need to open the Data Source Explorer view.
1.  Click 'Window' | 'Show View' | 'Other' (see Figure 11)
2.  Choose 'Connectivity' | 'Data Source Explorer'
3.  Click 'OK' (see Figure 12)

The Data Source Explorer initializes in your Eclipse environment. You can click and drag the title to dock it wherever you like.

About José Ramos
José Ramos is a product manager for Sybase iAnywhere and is responsible for the direction and life cycle planning of Sybase iAnywhere products. With more than seven years of experience, he also plays an active role in customer demonstrations and education to ensure the continued success of SQL Anywhere, the industry-leading database management and data movement technology built for frontline environments. José holds a Bachelor of Mathematics in Computer Science from the University of Waterloo in Ontario, Canada.

In order to post a comment you need to be registered and logged in.

Register | Sign-in

Reader Feedback: Page 1 of 1

I've made a connection to a odbc driver and it work fine, I can write my sql statement and execute it whit no problem.

Anyway I don't see any tables or stored procedure under Data Source Explorer for any of the connection I've create whit ping successfully.

Neither whit jdbc:odbc and other jdbc drive such as Sql Jdbc that work fine tto

Your Feedback
Fabio wrote: I've made a connection to a odbc driver and it work fine, I can write my sql statement and execute it whit no problem. Anyway I don't see any tables or stored procedure under Data Source Explorer for any of the connection I've create whit ping successfully. Neither whit jdbc:odbc and other jdbc drive such as Sql Jdbc that work fine tto
SOA World Latest Stories
There is a huge demand for responsive, real-time mobile and web experiences, but current architectural patterns do not easily accommodate applications that respond to events in real time. Common solutions using message queues or HTTP long-polling quickly lead to resiliency, scalability...
"We started a Master of Science in business analytics - that's the hot topic. We serve the business community around San Francisco so we educate the working professionals and this is where they all want to be," explained Judy Lee, Associate Professor and Department Chair at Golden Gate...
We call it DevOps but much of the time there’s a lot more discussion about the needs and concerns of developers than there is about other groups. There’s a focus on improved and less isolated developer workflows. There are many discussions around collaboration, continuous integration a...
The dynamic nature of the cloud means that change is a constant when it comes to modern cloud-based infrastructure. Delivering modern applications to end users, therefore, is a constantly shifting challenge. Delivery automation helps IT Ops teams ensure that apps are providing an optim...
Modern software design has fundamentally changed how we manage applications, causing many to turn to containers as the new virtual machine for resource management. As container adoption grows beyond stateless applications to stateful workloads, the need for persistent storage is founda...
"CA has been doing a lot of things in the area of DevOps. Now we have a complete set of tool sets in order to enable customers to go all the way from planning to development to testing down to release into the operations," explained Aruna Ravichandran, Vice President of Global Marketin...
Subscribe to the World's Most Powerful Newsletters
Subscribe to Our Rss Feeds & Get Your SYS-CON News Live!
Click to Add our RSS Feeds to the Service of Your Choice:
Google Reader or Homepage Add to My Yahoo! Subscribe with Bloglines Subscribe in NewsGator Online
myFeedster Add to My AOL Subscribe in Rojo Add 'Hugg' to Newsburst from CNET Kinja Digest View Additional SYS-CON Feeds
Publish Your Article! Please send it to editorial(at)!

Advertise on this site! Contact advertising(at)! 201 802-3021

SYS-CON Featured Whitepapers