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
PSTN or Public Switched Telephone Network is the collection of all the telephone networks, which are interconnected in the world. If we want to be able to route calls from and to the PSTN using OpenSER, we need to be connected to a PSTN. To send calls to the PSTN, we need a device called PSTN gateway. There are several manufacturers such as Cisco, Nortel, and others who manufacture this kind of equipment. You can also use an Asterisk PBX box for this task. Asterisk makes an affordable PSTN gateway that is very competitive with the big players mentioned above. In this article by Flavio E. Goncalves, we will see how to use asterisk as a PSTN gateway for OpenSER.Read Using Asterisk as a PSTN Gateway for OpenSER in full
The coming of Ajax was an important landmark in the history of Web 2.0. Ajax is a group of technologies that enable developers to build interactive, feature-rich web applications. Most of these technologies were available many years before Ajax itself. However, the advent of Ajax represents the transition of the web from static pages that need to be refreshed whenever data was exchanged to dynamic, responsive and interactive user interfaces.
In this article by Ayman Hourieh, you will learn about the following:
- Ajax and the benefits of using it in web applications.
- How to install an Ajax framework in Django.
- How to use the Open Source jQuery framework.
- Live searching of bookmarks.
- Editing a bookmark in place without loading a separate page.
- Auto-completion of tags when submitting a bookmark.
A search feature in a website is always beneficial. In this article by Dan Liliedahl, we will see how to add search capabilities to an OpenCms website and will also discuss how to create a search index for blog content. Before all this we will start of with a small discussion on Lucene search engine.Read Configuring OpenCms Search in full
Once your portal is looking the way you want it to, it is time to share your creation with the rest of the world. We want to transfer our site from our local computer and set it up on the World Wide Web.
In this article by Daniel N. Egan, you will know the following:
- How to obtain a domain name for your site
- What to look for in a hosting provider
- How to modify your files to prepare for moving to a host
- How to set up your database on a hosted site
- What file permissions are needed for your site to run