WhatsApp Web launched and now available on the Desktop via Google Chrome browser

WhatsApp Web

WhatsApp, popular messaging app has launched web client known as WhatsApp Web.Now WhatsApp Web can be accessible through Web URL: https://web.whatsapp.com in your Google Chrome browser, see below.

Whats App Web App

As per the WhatsApp blog: - "Web client is simply an extension of your phone: the web browser mirrors conversations and messages from your mobile device -- this means all of your messages still live on your phone."

• Media can be download directly to your Desktop
• Media can be upload from your Desktop Hard Drive

Limitation or point to know before use WhatsApp Web:

1. Working only on Android, Windows Phone, BlackBerry or Nokia S60 devices
2. iOS devices are not supported (due toApple platform limitations)
3. Requires the latest version of WhatsApp to be installed on  your smartphone
4. It is mirroring your phone
5. The pone will need to be connected to the web/net at all times
6. Need to have the latest version (Version 2.11.498 installed on my phone) of WhatsApp installed on your phone
7. Use with Google Chrome web browser only.
8. You can't create and leave Groups
9. You can't use New Broadcast
10. You can't block users

How to Connect your web browser to your WhatsApp Client ?

• Below are the simple steps or instructions to connect WhatsApp Web:

1. Open Web URL: https://web.whatsapp.com in your Google Chrome browser (Works only on Chrome)
2. Open Whatsapp tap on Menu option (which contains options like New Group, Status, etc)
3. Tap on WhatsApp Web:
4. 
5. Scan the QR Code on Chrome browser:
6. 
7. After successfully QR Code Scanned you should see the page as below:

• You can also see the status of connectivity on your phone devices.

• You can disconnect or Log out from the connected computer, refer the below steps:

1. Open Whatsapp tap on Menu option
2. Tap on WhatsApp Web
3. Tap on Log out from all computers

Thanks for visiting :)!!

I will keep updating the more details for the same.

If you have any question please ask here and kindly share it.

+Vivek Kumar 

Read More...

SQL Server Reporting Services (MSSQLSERVER) - ERROR: 1053

Description: Windows could not start the SQL Server Reporting Services (MSSQLSERVER) service on local computer. Error 1053: The service did not respond to the start or control request in a timely fashion.

Cause / Problem: The state like “started, stopped, paused, etc.” all installed Windows services controlled by Microsoft Windows Service Control Manager.

• By default, 30,000 milliseconds (30 seconds) Service Control Manager will wait for a service to respond.

• By editing or creating the ServicesPipeTimeout DWORD value, the Service Control Manager timeout period can be overridden, thereby giving the service more time to start up and report ready to the Service.

When attempting to start, stop or pause a service, one of the following error messages is encountered:

• 'Error 1053: The service did not respond to the start or control request in a timely fashion.'

• 'Error 7009: Timeout (30000 milliseconds) waiting for the service to connect.'

• 'Error 7000: The failed to start due to the following error: The service did not respond to the start or control request in a timely fashion.'

Issue with Operation System:

• Windows XP 32/64 bit

• Windows Vista 32/64 bit

• Windows 7 32/64 bit

• Microsoft Server 2003/2008 - 32/64 bit

• Microsoft Server 2008 R2

Solution:

Note: Microsoft Windows Registry Editor may cause serious problems with your computer, edit at your own risk.

Follow the below steps:

1. Start Run and type =>> “regedit”
2. Navigate to the following registry key=>> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
3. On Right pane =>> locate the ServicesPipeTimeout entry

Note: If the ServicesPipeTimeout entry does not exist, you must create it, follow the below steps to create:

1. Right Click on Control =>> New =>> DWORD Value
2. Rename the new DWORD as =>> ServicesPipeTimeout
3. Right-click ServicesPipeTimeout =>> Modify
4. Click Decimal, type 120000 (2 minute) =>> OK
5. Restart the computer

After that you should be able to start the SQL Server Reporting Services(MSSQLSERVER).

-Vivek Kumar 

Read More...

ETL Job or Components

ETL Components:

ETL Job or Components

1. Data Extraction
2. Data Transformation
3. Data Loading
4. Data Refresh Method
5. Data Sourcing Method
6. Data Landing / Staging Design
7. Job Scheduling
8. Job Sequencing
9. Historical Data Migration
10. Changed Data Captrue
11. Audit & Verification
12. Admin
13. Validation & Cleansing
14. Aggregate
15. Logging & Monitoring
16. Surrogate Key Generation & Mgmt
17. History / SCD Mgmt
18. Exception Handing
19. Data Conformation & De duping
20. Restart / Reload

-Vivek Kumar 

Read More...

List of Popular ETL Tools/Software

List of Popular ETL Tools/Software

• Commercial ETL Tools:

1. Informatica – PowerCenter
2. IBM – Infosphere Information Server
3. Oracle Data Integrator (ODI)
4. Oracle Warehouse Builder (OWB)
5. Microsoft - SQL Server Integration Services
6. SAS - Data Integration Studio
7. SAP - BusinessObjects Data Integrator
8. IBM - Websphere DataStage (Ascential DataStage)
9. IBM - Cognos Data Manager (Cognos DecisionStream)
10. IBM - DB2 Warehouse Edition
11. AB - Initio
12. Information Builders - Data Migrator

• Open source ETL Tools: (Freeware)

1. Talend - Open Studio for Data Integration (Integrator Suite)
2. Apatar
3. Clover ETL
4. GeoKettle
5. Jasper Soft ETL
6. KETL (™)
7. Pentaho Data Integration (PDI, Kettle)
8. Actuate Corporation
9. SpagoBI
10. HPCC System
11. Jedox
12. EplSite ETL
13. GETL ETL
14. Scriptella ETL
15. RapidMiner
16. Anatella

• Other ETL Tools:

1. Embarcadero Technologies - DT/Studio
2. IKAN - ETL4ALL
3. Pervasive - Data Integrator
4. Group 1 Software (Sagent) - DataFlow
5. Sybase - Data Integrated Suite ETL
6. Expressor Software - Expressor Semantic Data Integration System
7. Elixir - Elixir Repertoire

-Vivek Kumar 

Read More...