Information Anywhere

What follows is a partial and unedited list of sessions selected for this track at TechWave. We are working diligently to finish developing conference content, edit the material and bring the session search application online. In the meantime please feel free to make use of this material. The full schedule should be available soon. Note that this material is subject to change without notice.

Afaria Remote Control Audience Job Function: IS/IT Management
Session Duration: 60 minutes
Learning Points You Will Take Away from this Class:
- Gain knowledge of how to use Afaria for client support, training and system diagnostics
In this session, you will be introduced to Afaria's Remote Control module. This feature enables real-time remote control of Windows- based PCs and handheld devices. Starting with a clean system, users will be educated in the installation of each component of the reference three tier architecture, including a sample Afaria deployment channel for the handheld client. Customers will gain a great understanding of the features avaible in the product and how it can be used for client support, training and system diagnostics.

Afaria Tips & Tricks - A Customer Roundtable
Audience Job Function: IS/IT Management
Session Duration: 90 minutes
Learning Points You Will Take Away from this Class:
- Tips & Tricks from a variety of Afaria customers
During this interactive roundtable session, several Afaria customers will describe their implementations, and share tips & tricks on a variety of topics. The session will close with discussion and Q&A time. Qwest will discuss targeted smart alerts to the field force (interfacing Web/Windows applications with Afaria), Focus on the Family will share on the power of session manager, and finally, Kone will discuss the design of a mobile solution and planning for change management through flexible technology. Customers are subject to additions and change.

Creating Java Application with SQL Anywhere and Eclipse
Audience Job Function: Application Developer, DBA
Session Duration: 60 minutes
Learning Points You Will Take Away from this Class:
- Develop a SQL Anywhere database application using the Eclipse IDE
- Provide data synchronization for mobile Java applications running in offline or occasinally-connected environments
- Learn about other Eclipse-based technologies to create database applications, such as DTP and Sybase WorkSpace
This presentation describes how to combine SQL Anywhere and Eclipse to develop powerful database applications for Java environments. The open source Eclipse IDE is one of the most popular cross-platform Java development environments and by using SQL Anywhere, Java developers can quickly create and deploy applications that can operate in a wide range of operating systems. The presentation offers a series of code examples to demonstrate how developers can provide database functionality within their Java applications. Additional topics covered include database embeddability, data synchronization, and using other Eclipse-based data management technologies such the Data Tools Platform (DTP) project and Sybase WorkSpace.

Developing Applications for SQL Anywhere using Visual Studio
Audience Job Function: Application Developer
Session Duration: 90 minutes
Learning Points You Will Take Away from this Class:
- develop applications for SQL Anywhere using Visual Studio
This session provides an overview of how to use Visual Studio to develop SQL Anywhere applications both for the desktop and for the web. The session will include an overview of ADO.NET, the data access API in the .NET Framework, and demonstrate SQL Anywhere's support for the most recent features of Visual Studio 2008 including LINQ (Language Integrated Query) and the Entity Framework. A number of examples and demonstrations will be given including a demonstration of SQL Anywhere's integration within the Visual Studio environment. As well, we will look at other new features of SQL Anywhere 11 that apply directly to the .NET platform.

Developing Database Applications for Windows Mobile Using SQL Anywhere
Audience Job Function: Application Developer, DBA
Session Duration: 90 minutes
Learning Points You Will Take Away from this Class:
- Develop offline and occasionally-connected frontline applications for Windows Mobile
- Create database schemas specifically designed to run on mobile devices
- Bring your data stored in enterprise backends to Windows Mobile
This presentation provides an overview of how to successfully develop a database application running on a Windows Mobile handheld device. It introduces SQL Anywhere for Windows Mobile and shows how developers can create powerful mobile applications that take advantage of rich database functionality as well as robust data synchronization. Using code examples, the presentation offers an in-depth look at creating mobile database applications using leading development environments such as PocketBuilder and Visual Studio. Other topics presented include implementation best practices and handling security in mobile database applications.

Encryption and Security Strategies for Laptops and Handhelds
Audience Job Function: IS/IT Management
Session Duration: 90 minutes
Learning Points You Will Take Away from this Class:
- How to strike the right balance between confidentiality, integrity and availability, particularly when data is exchanged
- How to put strategies in place to ensure compliance and enable access to encrypted information
- How to protect against theft of mobile devices by implementing security and managing the devices
Companies and public sector bodies alike are at risk from unauthorized access and the loss of valuable corporate and personal data. Recent events in the news have highlighted just how real this risk is. Achieving confidentiality of data through encryption is straightforward, the challenge that organizations face is how to strike the right balance between confidentiality, integrity and availability, particularly when data is exchanged between partner organizations, and data is stored on mobile devices that reside outside the glass house of security. Technology is available to secure data, but processes also need to be in place to ensure compliance and enable access to the encrypted information. Protecting against theft of mobile devices involves implementing security and managing the devices on the front line

Full Text Search in SQL Anywhere
Audience Job Function: Application Developer, DBA, System Analyst
Session Duration: 90 minutes
Learning Points You Will Take Away from this Class:
- Exploit the full text search capabilities of SQL Anywhere
- Configure full text indexes
- Understand how full text search results can be integrated with SQL result sets to foster a powerful, integrated searching solution for database applications
In this talk we will describe how Application Developer, s can exploit the new full text search capabilities in the SQL Anywhere Panorama release. The session will describe how full text indexes are built, how they are maintained, and how full text search results can be combined with ordinary SQL search conditions in the same SQL query to provide a high-performance, integrated search solution for both structured and semi-structured data.

Getting Starting with MobiLink in SQL Anywhere 11
Audience Job Function: Application Developer, DBA, Consultant, IS/IT Management, Corporate Management, Other: Web Developer
Session Duration: 90 minutes
Learning Points You Will Take Away from this Class:
- Mobilize a database using MobiLink synchronization technologies included with SQL Anywhere
- Understand distributed data environments and requirements for synchronizing data across distributed environments
- Understanding of development tools available with SQL Anywhere to mobilize databases using MobiLink
This presentation will discuss MobiLink synchronization technologies available with SQL Anywhere. This is an introduction to how MobiLink synchronization works, geared towards an audience that has minimal knowledge of data synchronization. Topics covered will include MobiLink architecture, the synchronization process, how to determine what data to synchronize, and setting up a synchronizing environment.

How Partners have Extended Afaria: Powerful Tools and Techniques for Administrators
Audience Job Function: IS/IT Management
Session Duration: 60 minutes
Learning Points You Will Take Away from this Class:
- Revolution Consulting
- HandStep
- Additional Partners TBD
Sybase iAnywhere partners Handstep, Revolution Consulting and Smartphones Telecom will rely on their vast customer experiences to discuss how they have extended Afaria functionality in a variety of ways. Handstep will introduce powerful tools for Afaria administrators through their Afaria Toolbox, which is a set of utilities that extend Afaria device management and security in innovative ways. Afaria administrators will learn new ways to handle complex administrative tasks such as rebuilding devices from scratch, deploying huge numbers of devices easily and managing device groups with or without Active Directory. Revolution Consulting will detail the latest advancements they have made in helping customers address administrative and operational issues within Afaria environments. Topics such as expanding visibility to important system activity, alternate methods for initiating channel executions, and improving compliance and control will be addressed. Finally, partner Smartphones Telecom will discuss how to determine the best way to initially deploy large scale mobile applications. The company will provide a technical overview of how they pre-provision mobile devices for the extended mobile workforce. Pre-configuration of devices will be demonstrated using Afaria and a deployment for a customer will be explored. This session will wrap up with a Q&A session.

Leveraging Your Web Infrastructure to Create High Availability MobiLink Data Synchronization
Audience Job Function: Application Developer, DBA, Consultant, IS/IT Management, Corporate Management, Other: Web Developer
Session Duration: 90 minutes
Learning Points You Will Take Away from this Class:
- Make decisions on the requirements for designing a high availability data synchronization environment.
- Analyze and remove a single point of failure from a 24/7 environment for data synchronization.
- Understand the security considerations and maintenance required for a 24/7 data synchronization environment.
Data synchronization has become an important part of many corporate information systems. Synchronizing high availability databases and setting up synchronization systems without a single point of failure are two challenges that organizations face as they bring synchronization systems to the 24/7 requirements of modern data systems. This presentation will outline architectural design considerations for leveraging existing web infrastructure to create a high availability data synchronization environment. Discussions will include synchronizing high availability consolidated and remote databases, removing single points of failure from the synchronization system, and the challenges of running 24/7 data synchronization environments. This will include discussions on the Relay server, MobiLink server farms, load balancing, and hot failover.

Migrating to SQL Anywhere
Audience Job Function: Application Developer, DBA, Consultant, IS/IT Management
Session Duration: 60 minutes
Learning Points You Will Take Away from this Class:
- Using the SQL Anywhere migration wizard
- Migrating stored procedures
- Migrating applications
This talk will provide some tips, tricks and techniques for migrating data and applications from other RDBMS vendors into a SQL Anywhere database so you can take advantage of SQL Anywhere's capabilities in your next generation applications.

Mobilizing ASE, Oracle and SQL Server Databases
Audience Job Function: Application Developer, DBA
Session Duration: 90 minutes
Learning Points You Will Take Away from this Class:
- Determine the requirements necessary to mobilize your enterprise database
- Utiilize the visual MobiLink synchronization wizards to define and deploy your synchronization models
- Learn the different caveats behind data synchronization to ASE, Oracle, or SQL Server databases
This presentation demonstrates how to mobilize data stored in existing enterprise backends using SQL Anywhere and MobiLink technology. Using the visual tools available in SQL Anywhere, the presentation shows the simplicity of defining and deploying data synchronization models, no matter where the enterprise data resides. The presentation illustrates data synchronization to Sybase ASE, Oracle, and Microsoft SQL Server by mobilizing the existing sample databases included with those products.

Offline Wikipedia with SQL Anywhere
Audience Job Function: Application Developer, Consultant, IS/IT Management
Session Duration: 60 minutes
Learning Points You Will Take Away from this Class:
- Understand using a staging-database to allow synchronization to systems do not provide native syncing support
- Understand an example of mobilizing a web application
- Learn tips for handling very large database files/optimization tricks
Wikipedia, a popular open-content encyclopedia, is the largest and fastest growing general-reference resources on the internet. The entire wikipedia content is freely available for download, weighing in at approximately 15 gigabytes of text. While it is possible to create a complete, offline version of Wikipedia on a laptop, the lack of space and computing resources on a mobile device make it impractical on such platforms. This talk will examine a solution that allows users to keep a user-defined set of articles for offline use on a mobile device. This solution, based on SQL Anywhere, allows synchronization through services to a MySQL-based web application (MediaWiki). This talk will also explore the more general question of using a staging database to add synchronization to a web application that lacks it as a native feature.

Seamless Synchronization and other UltraLite Features
Audience Job Function: Application Developer
Session Duration: 60 minutes
Learning Points You Will Take Away from this Class:
- Understand how to sync wireless applications
- Understand what is new in UltraLite in SQL Anywhere 11
Wireless networks change many things for mobile applications, including the demands on data synchronization. No longer a batch process, data sync must now take place seamlessly behind the scenes without interrupting the user. This talk shows how to implement seamless synchronization with UltraLite databases. It also provides an overview of other new UltraLite features in SQL Anywhere 11.

Solution Packs (ECF Server, Multicast, Web Reporting, Directory Sync, Content Mgr)
Audience Job Function: IS/IT Management
Session Duration: 60 minutes
Learning Points You Will Take Away from this Class:
- Demonstration of available Solution Packs from Professional Services
- Cluster Manager, Task Scheduler, Directory Synchronization, Web Reporting, Afaria ECF Translator, Multicast for Afaria, Xpress and Content Manager
This session will introduce and demonstrate several of the available Solution Packs which have been created by iAnywhere Professional Services for solving common business problems by extending existing iAnywhere products. Some of the solutions include Cluster Manager, Task Scheduler, Directory Synchronization, Web Reporting, Afaria ECF Translator, Multicast for Afaria, Xpress and Content Manager.

SQL Anywhere in a Web 2.0 World
Audience Job Function: Application Developer, DBA, Consultant, IS/IT Management
Session Duration: 90 minutes
Learning Points You Will Take Away from this Class:
- Understand service-based database access, using SQL Anywhere, to create RIA technology-based web applications
- Understand how the HTTP Server and PHP support in SQL Anywhere can be used to create a service-based database access model
- Gain more knowledge into the advantages of deploying applications using RIA technologies
The internet is a fast, dynamic space. The past year has seen the development of a number of new RIA (Rich Internet Application) technologies that promise a new generation of web applications. This talk will examine these new technologies and explain how SQL Anywhere fits into the new web world. Examples will inlcude SQL Anywhere integration with Microsoft Silverlight, Adobe AIR, JavaFX, and Ajax using a service-based database access model.

Synchronizing SQL Anywhere Databases in a .NET Environment
Audience Job Function: Application Developer, DBA, System Analyst, IS/IT Management, Corporate Management, Other: Web Developer
Session Duration: 90 minutes
Learning Points You Will Take Away from this Class:
- Understand the technologies available when using SQL Anywhere to develop data synchronization in a .NET environment
- Understand how to write .NET MobiLink synchronization scripts
- Learn how to integrate data synchronization directly into an application written in the .NET environment
.NET development technologies provide the ability to rapidly develop, mange, and deploy secure applications in a Windows environment. This provides easy integration of new solutions into existing infrastructure to meet growing business needs. SQL Anywhere technologies provide an array of tools and APIs to easily integrate MobiLink data synchronization in to your .NET environment. This presentation will provide development considerations when synchronizing a SQL Anywhere database in a .NET environment. Topics will include the new MobiLink client (dbmlsync) synchronization API, the MobiLink server API, object-based data flow using the Direct Row Handling API, writing .NET synchronization scripts, and server initiated synchronization.

UltraLite and MobiLink - Performance Measurement & Optimization for your Mobile Solution
Audience Job Function: Application Developer, Consultant, IS/IT Management
Session Duration: 90 minutes
Learning Points You Will Take Away from this Class:
- Develop a performance test framework and identify areas for improvement in your solution.
- Understand which settings can optimize your synchronization performance.
- Understand some advanced programming techniques which will allow your Windows Mobile solutions to have faster page-to-page navigation and an improved user experience.
This presentation will disclose lessons learned and best practices utilized by Accenture to develop large scale mobile solutions with Sybase iAnywhere SQL Anywhere.

Utilizing UltraLiteJ to Quickly Extend Existing SQL Anywhere Applications to BlackBerry Devices
Audience Job Function: Application Developer, DBA, System Analyst, Consultant, IS/IT Management, Corporate Management
Session Duration: 60 minutes
Learning Points You Will Take Away from this Class:
- Build Java mobile applications for BlackBerry devices utilizing UltraLiteJ
- Re-use existing SQL Anywhere database for building UltraLiteJ-based applications, which will dramatically save you time and engineering effort
- Synchronize UltraLiteJ-based applications with SQL Anywhere enterprise database utlizing MobiLink
Help Sybase customers understand how they can extend their existing SQL Anywhere-based applications to BlackBerry devices quickly, easily, and cost-effectively by utilizing UltraLiteJ and MobiLink.

Web Development with SQL Anywhere and PHP
Audience Job Function: Application Developer, DBA, System Analyst, Object Administrator, Consultant, IS/IT Management, Corporate Management
Session Duration: 90 minutes
Learning Points You Will Take Away from this Class:
- Begin building a web application with SQL Anywhere and PHP
- See how SQL Anywhere is relevant in current mainstream web application development
- Understand how SQL Anywhere can take you beyond current mainstream web application development
PHP is the most popular language for creating applications for the Web. SQL Anywhere has many features that make it ideal for Web applications. This talk will explore development and architecture of PHP Web applications using SQL Anywhere and deployed on IIS, Apache, or the SQL Anywhere HTTP server. We will talk about creating Web pages with dynamic content and using Web services and JavaScript with Ajax to create rich internet applications (RIAs). We will also discuss how SQL Anywhere technology can enable exciting new applications such as maintaining local copies of your Web applications or taking your Web applications off-line.

Welcome to Afaria 6.0 - A Deep Dive Into New Product Features
Audience Job Function: IS/IT Management
Session Duration: 60 minutes
Learning Points You Will Take Away from this Class:
- Greatly expanded capabilities for managing and securing Windows Mobile and Smart Phone, Palm, Symbian and RIM BlackBerry devices
- New security capabilities for handheld devices
In its latest releases, Afaria furthered its leadership position in mobile device management and security by expanding the breadth of functionality available for managing mobile devices, as well as enhancing mobile device security. In this session, we'll demonstrate the newest features of Afaria including greatly expanded capabilities for managing and securing Windows Mobile and Smart Phone, Palm, Symbian and RIM BlackBerry devices. In addition, we'll highlight Afaria's new security capabilities for handheld devices. You will also get a first look the newly release product features, functionality and technical enhancements as well as a sneak peek at future development.