SQL Server Integration Services, using its designer interface, or BIDS, has made it possible to process data using many of the data flow related items in its Toolbox without writing a line of code. This is a very attractive option for someone who is a beginner with some knowledge of databases, and for end users who may want to look up some detail buried in the data. This tutorial by Dr. Jayaram Krishnaswamy shows how the designed package extracts data from an SQL Server 2005 and processes it using several of its built-in transformations.Read Data Processing using Derived Column and Aggregate Data Transformations in full
"ERWin from Computer Associates (CA) is one of the most popular data modeling software in the market. I’ve been using this data modeling tool since its release 3; it’s now at release 7. In this article I’ll show how to create a data model from scratch, starting with logical and physical models, and then forward engineer the physical model to Oracle database". In this article by Djoni Darmawikarta we’ll create a data model for Sales Order, with customer and product data.Read Data Modeling with ERWin in full
Many data modelers recognize the advantages of standardizing the names of their modeling objects, particularly when they apply prime-class-modifier words pattern; but, they can’t afford its tedious manual execution.
InfoSphere Data Architect affords functions for building glossary of the standard pattern words that you can then employ while developing and maintaining your data models. This automation encourages the data modeler to apply naming standard to their modeling objects which in turn promotes consistency across their data models.
This article by Djoni Darmawikarta features the naming standard functionality in the glossary model of that IBM software.Read Data Modeling Naming Standards with IBM InfoSphere Data Architect in full
In this article by Amy Unruh, co-author of the book Google App Engine Java and GWT Application Development, we look at ways to structure and access your data objects to make your application faster and more scalable.Read Data Modeling and Scalability in Google App in full
In this article by Wolfgang Niefert, you will learn about the Advanced data migration tools, xFusion Studio in particular. You will also get to know a few tips and recommendations which you could use in your own project.Read Data Migration Scenarios in SAP Business ONE Application- part 2 in full
In this two-part article series by Wolfgang Niefert, you will be introduced to the tools and methods which will help you to migrate data from different sources into the SAP Business ONE application.Read Data Migration Scenarios in SAP Business ONE Application- part 1 in full
In this article by Gill Cleeren and Kevin Dockx, authors of Microsoft Silverlight 4 Data and Services Cookbook, we will learn about the following:
- Displaying data in a customized DataGrid
- Inserting, updating, and deleting data in a DataGrid
- Sorting and grouping data in a DataGrid
In this article series by Gill Cleeren and Kevin Dockx, authors of Microsoft Silverlight 4 Data and Services Cookbook, we will cover the following recipes:
- Using the different modes of data binding to allow persisting data
- Data binding from Expression Blend 4
- Using Expression Blend 4 for sample data generation
ADO.NET Data Services leverages the ADO.NET Entity Framework to build data services for relational data sources. These include support for MySQL, DB2, and Oracle in addition to MS SQL Server. It can also be used with non-relational data using an add-on provider model. With ADO.NET Data Services, the developers can build dynamic internet applications (AJAX, Silverlight, etc) that works across intranets as well as the internet. With this in place data access by applications is made possible using URI Syntax and using HTTP verbs operating on the data.
In this article by Dr. Jayaram Krishnaswamy, you will learn how to create a ADO.NET Data Service from scratch. You will also learn how you may access data using the URI constructs. The backend data for this tutorial comes from a copy of Northwind database named TestNorthwind on a named instance of SQL Server 2008. In order to work through this tutorial you should have Visual Studio 2008 SP1 installed. You also need to have .NET Framework 3.5 installed.Read Data Access with ADO.NET Data Services in full
Retrieving data from heterogeneous database servers at Data Access Layer (DAL) has become common while developing enterprise level applications. This, in turn, leads to writing server specific code at DAL level and plugging in a configuration logic that determines which server is to be used at run-time. For an application of medium sized complexity this is well and good. However, as the complexity increases, the server specific code and the configuration logic tend to become part of the infrastructure that runs the application, which in turn adds to the over-all complexity of the application. It is in such scenario that Object Relational Mapping (ORM) frameworks come into picture. These frameworks dynamically generate the required SQL for the targeted database system. Using ORM frameworks the target database system can be changed via configuration file entries. Thus, they take care of configuration logic as well. In this article by A. P. Rajshekhar, we will work with Hibernate, one of the commonly used ORM frameworks.Read Data Access Using Spring Framework: HibernateTemplate in full
In this article by Satish Kore, we will learn how to interact with a server environment (specifically built with Java). We will look at the various data access components which includes HTTPService class and WebService class. This article focuses on providing in-depth information on the various data access methods available in Flex.Read Data Access Methods in Flex 3 in full
In this article by Naveen Balani, we will have a look at the CXF architecture in detail.
The architecture of CXF is built upon the following components:
- Messaging and Interceptors
- Service Model
- Data bindings
- Protocol bindings
Vim is one of the most powerful open source editors used by programmers and system administrators around the world. While Vim itself is inherently a powerful editor, personalizing it to suit your needs can be a daunting task.
In this article by Kim Schulz, author of Hacking Vim 7.2, we will cover:
- Adding a more visual color
- Adding line numbers
- Spell checking your language
- adding helpful tool tips
- modifying key bindings
With the widespread empowering of website owners being able to manage their own website's content, there are a huge number of content management systems available. Joomla! is one of the most popular of these content management systems with a large user base and active community who are constantly working to improve Joomla! for new and future users.
In the first article we have learned How to Style the search Module and Search Component
In the Second article of this article series by Richard Carter, author of Joomla! 1.5 Templates Cookbook we will learn:
- Customizing the breadcrumb
- Styling pagination
- Linking back to the top of your page
The article, IBM Lotus Notes 8.5.3, helps you master the IBM Lotus Notes 8.5.3 client to become an expert at e-mail, calendaring and scheduling, contacts, to dos, and much more. This article by Barry Max Rosen, author of Instant IBM Lotus Notes 8.5.3 How-to, explains how IBM Lotus Notes 8.5.3 is highly customizable and works the way you want it to work.
Read Customizing your IBM Lotus Notes 8.5.3 experience in full
WordPress is a powerful and effective open source web publishing platform that enables anyone, regardless of computer skills, to create and maintain a world-class website. Millions of people worldwide have adopted WordPress, and its popularity continues to increase.
In this article by Michael David, author of WordPress 3 Search Engine Optimization, we'll align your SEO strategy with the WordPress platform and help you solidify your plan. You'll need to set realistic goals and timelines for your business or website through educated investigation and analysis. Proper and thorough planning is needed to ensure that you succeed in the competitive search markets.Read Customizing WordPress Settings for SEO in full
In the previous article, we saw module installation and how to add extra fields to our user profiles. In this article by Michael Peacock we will look into customizing user activity in Drupal 6 Social Networking.
Specifically, you will learn:
- About Gravatars(Globally Recognized Avatars) and how to enable them
- About settings and rules for users
- How users can track the activity of each other
- How to allow our users to customize their own blogs
- More about users, roles, and permissions
There are numerous menus in the front end of every application. They are often displayed as standalone boxes. The menu items are generally arranged one below the other. Menus can also be integrated into the design horizontally so that at first sight they aren't even recognizable as cohesive menus. CSS menus, which can even be transparent, are very cool.
These menus and the menu links are dynamically administered in Joomla! from database content in the Menus work area. Joomla! has six different menus in the sample data. (main menu, top menu, other menu, user menu, example pages, and key concepts) In this article by Hagen Graf, we will discuss administering, creating and managing menus in Joomla!Read Customizing the Menus Menu in Joomla! in full
This two-part article by James Kennard shows how we can modify the server response by working with the global document object.
It contains the following recipes:
- Setting the document title
- Setting the document generator
- Setting the document description
- Adding metadata to the document
- Changing the document character set
- Changing the document MIME type
- Controlling client caching of responses