Google Apps Directory Sync: Tips for Microsoft Active Directory

The Google Apps Directory Sync tool really should be installed at any mid to large corporation using a Microsoft Windows Server (or any LDAP compatible directory server).  It eliminates the need to add, change, or delete users in two different places.

LDAP Directory Sync is definitely complex with a steep learning curve.  You need a good understanding of how to create LDAP queries as there are only limited examples in the provided documentation.  However, once it's configured there should be little reason to change it.

It's our experience that in most installations you'll need one configuration file for synchronizing Users, Profiles, and Contacts and another configuration file for Groups.

If you're migrating in batches from an email server such as Exchange Server to Google Apps it's best to synchronize only users that are a member of a Security Group such as "Google Apps Users".  That way the user is created in Google Apps only after they've been made a member of the security group.

Here's a sample LDAP user query: 

(memberOf=CN=Google Apps Users,OU=Security Groups,DC=domainname,DC=local)

Replace OU=Security Groups,... with the appropriate location in your Active directory tree of the security group.

And note that Google Postini has the same ability to synchronize to Microsoft Active Directory or your LDAP directory server.

Or give us a call at Interlockit.com.  We're happy to configure it for you.

Google Apps and Docs misconceptions

The Microsoft camp frequently points out how Microsoft Office has all the features that businesses want right now and therefore wants you to conclude that you don't need Google Apps, but this misses the main point; Google Docs are complementary to Microsoft Office.

Google Docs has been providing rich real-time collaboration to millions of users for nearly four years.  You can edit and share documents from the browser from anywhere in the world.  A growing number of corporations are using it as their primary productivity software but there's no need to.

Google Docs makes Office 2003 and 2007 better because you can store any file in Google's cloud and share them in their original format with anyone on the internet.  No more guessing if you have the latest version.

Google Docs represents a real alternative for companies: a chance to get the collaboration features you need today and end the endless cycle of "upgrades".

Try it out free for 30 days.  The only thing you have to lose is a server or two.

http://googleenterprise.blogspot.com/2010/05/upgrade-here.html

More applications coming for Google Apps Customers

More applications for Google Apps will reduce customer training time on why their Google Apps accounts don't work on Picasa and other handy Google services.  Currently your Google Apps login id will only work on the core messaging and collaboration applications forcing customers to use a personal gmail account for the rest.

The overhaul is expected this fall.  More details can be found here: http://googleenterprise.blogspot.com/2010/05/more-google-applications-coming-for.html

Last blog post... 4 weeks ago. What kept us busy in April

Lots on the go but having tons of fun.  Here's some of the things that kept us busy in April at Interlockit.com:

• Interlockit.com is mentioned in a PC World Article on Google Apps Sync for Outlook - note our mention of the improved return on investment with the web interface over sticking with outlook.  I am an accountant (CMA) after all...
• Hiring and mentoring of new technical staff members
• Joint presentations with Google Canada on Google Apps to a large group of franchisees in the transportation industry.  It was very successful... We'll share the exciting details in the future
• Lots of client deployments of Google Apps
• Received official Canadian reseller status for a brand of high quality internet routers.  Google Apps shines when we clean up the customer's internet connectivity and massively improve throughput and reliability.  We'll broadcast more details once we have the e-commerce site up and running
• and... my vote for best new feature among many released for Google Apps Premier Edition in April is Drag and drop file attachments

Another Update: Migrating from Microsoft Exchange to Google Apps now even easier

I've configured and fixed many Microsoft Exchange email implementations over the years but have never hung out my shingle as a Microsoft Exchange guru.  Having now put the Google apps exchange migration tool through its paces in the wild...

Here is my opinion that I'd enjoy hearing different perspectives on:

Migrating from Microsoft Exchange Server 2003 or 2007 to Google Apps Premier Edition is easier and less costly than upgrading to Exchange 2007 or 2010 respectively.

To help out those that currently use Microsoft Exchange:

• Feature debate: Exchange wins in some areas
• Prefer to manage your own in-house servers: Exchange wins
• Entire company loves Outlook: Exchange wins, or maybe not?
• Too much important historic email sitting in Outlook offline email archives: winner?

I'll pause there.  Please comment publicly on blog.  We do moderate all postings but only for politeness, not for opposing opinions.

Update: Migrating from Microsoft Exchange to Google Apps now even easier

We've put the new Microsoft Exchange migration tool through its paces and it's definitely delivering beyond expectations.

What is most impressive is the ability to do parallel processing.  It's now feasible for us to migrate hundreds of users in a single night.  Thousands of users could be done over a weekend with lots of time to spare.

This tool will definitely reduce the cost of customer migrations.

Android Phones and the Google Nexus One from HTC

I've now had sufficient time to put the Google One Nexus through its paces and I fully recommend it to all Google Apps customers.  It's a beautiful phone.  Businesses can save big on IT labour because setup is as simple as turning on the phone and signing the user into their Google Apps account.  Everything instantly integrates; email, calendar, and contacts.

Ask your IT department how many hours they spend on Blackberries, iPhones, and Windows Mobile devices and drop me an email (or comment if you don't mind making it public).  Since I'm a professional accountant I'm interested in calculating the ROI across a range of samples.

Here's what I now recommend to corporations running Google Apps for phones:

1. Google Nexus One running Android OS 2.1.  End user can completely configure it themselves.  It's unlocked so you can swap your Rogers Sim for an AT&T Sim and save big on roaming charges when you travel.  Only minus is that you need to install EasyTether or PdaNet for modem tethering with your notebook.  The LG Eve didn't require extra software for tethering.  I look forward to testing a phone like the Motorola Droid which has a hardware keyboard to see if the setup is just as simple as the Nexus One.
2. iPhone - You have to carefully read the documentation to get the full experience.  We usually help the IT department do the first few but the integration is excellent and second only to the Android.
3. Blackberry - still the preferred unit for speedy typing of emails on the go but it's really showing its age with too much complexity.  It still integrates wonderfully with Google Apps but the IT department definitely has to configure it for most users to get full email, calendar sync, and contacts sync.

Earth Shattering news: Migrating from Microsoft Exchange to Google Apps now even easier

For me as an insider this is teary-eyed stuff.  Customers should care because data migrations to Google Apps from Microsoft Exchange will be easier and more cost effective with this tool.

And our team and I will get to spend less nights waking up multiple times to check on desktop data migrations.  Getting ahead of myself... Let us put it through the paces on our own internal Exchange Server test beds first.  Overall Google has always impressed me with the quality of their product releases.  There are third party tools that do the same but most were poorly documented.

• Migrating from Microsoft Exchange now even easier

Welcome to Canada, Google Nexus One!

I've placed my Nexus One order and will report back on its suitability for business executives as compared to the LG Eve and Blackberry Bold.

Why the Nexus One?  Because I get to deal directly with Google and don't have to wait for Rogers to release software updates.  Our Rogers LG Eve is still on Android OS 1.5.  The Nexus One runs on Android OS 2.1.

The LG Eve running OS 1.5 can't invite multiple attendees to a meeting which is important for the on the road executive.  This was addressed in Android OS 2.0 plus with 2.1 you get Turn-by-turn GPS, Google Earth, etc.

Nexus One now compatible with the AT&T 3G network and shipping to Canada
Rogers Wireless: Welcome to Canada, Google Nexus One!

I'm also keeping an eye on the Samsung Galaxy Spica for $450.  If Rogers release OS 2.1 for the Spica it should be a good phone and less expensive than the Nexus One.

DocVerse joins Google

Google Docs is simply awesome because I can edit and share my documents from any computer instantly from anywhere.  However, it still has to coexist with the 600 million users of Microsoft Office.  It's a pain to remember to upload your Excel spreadsheet to Google Documents every time you change it.

This is the problem that DocVerse solves.  Google just acquired them.  I look forward to seeing how Google integrates DocVerse into their solution offering.

Backup Solutions

I did a business process review with a customer yesterday and we both realized that their years of documents and contracts were stored on a single computer with zero backups.

I woke up early today worrying about my client's data.  There are hundreds of different backup solutions to choose from.  I've tested many.  My favourite is Mozy.  Please install it or call us.  Then we can all sleep better knowing that the data is securely backed up in the cloud.

P.S. Use my referral link https://mozy.com/?ref=VX97E6 or referral code VX97E6 and we both receive an extra 512 Mb of backup space.

Throw away your USB drive

Now that Google Apps allows you to upload files of any type without having to convert them to Google Doc format you can stop carrying around your USB drive.  No more having to remember to copy that complex financial forecast in Microsoft Excel to your notebook hard drive or USB stick.  Just open a web browser at the board meeting, log-in and open the file from Google Docs.

Your Google Apps account starts with a minimum of 10 Gb's of storage.

Gmail and Google Apps Calendar management tips

I think children are sometimes the best test of whether a process is simple or not.  My 6 year old is like most and really doesn't care about daddy being late for something so I built him a schedule on Gmail and made sure it integrates with my schedule on Google apps.  He loves it!

Here's a few tips I think are worth sharing with business users from this exercise:

• Learn how "Quick Add" works.  It's a phenomenal time saver.  Enter "today 800 am Bus to School 20 min" or "wed 2 pm Budget meeting 2 hours".  Google Calendar will automatically create the appropriate appointment for you.  If you get it wrong use the Undo Link that appears as part of the yellow message telling you what you just added.
• Open your calendar, Settings, Labs (Gapps administrator has to allow labs for this to appear)
• Enable the components: "Who's my one-on-one with?", "Free or busy", and my personal and my 6 year old's favourite "Next meeting"

Sure there's a whole bunch of encouragement for my 6 year old that helps too, but now I can leave a screen open that's his schedule (coordinated with dad's and mom's) that he's enjoying keeping up with.

Yikes, I'm 2 minutes late for picking him up for the dentist.  Gotta run.

What if your notebook computer was stolen?

How long would it take for you to be up and running with full access to all Email, Calendaring, and Contacts?

If running Google Apps; as fast as you can get to another computer with a web browser; probably minutes.

If running Microsoft Outlook you have to restore from backups; or if on Exchange configure Outlook on another computer...  I'll spare you the details but probably a few hours at least.

Just had a customer have his notebook stolen while on a trip.  The data in his outlook PST file plus all his Excel spreadsheets is at risk because it wasn't encrypted nor password protected.  Identity and financial information theft is a real possibility.  Sure you can use a Windows password, but a tech guy like me can plug the physical drive into another computer and still access all the data unless it was specifically encrypted.

So buy a better notebook with an encrypted drive like this one from Seagate or upgrade to a more expensive version of windows?  Or simply pay $50/year and store your documents (even in MS Excel format) on highly secure Google Apps servers using Google Documents?

Google Apps allows all browser sessions to use https.  So no data will get transmitted nor stored on the local computer in a usable form for a hacker.

I may sound biased but I'll be recommending the Google Apps solution to my customers. :)

Huge cost savings for Canadians travelling to the U.S. with their cell phone

I've had a few clients run up thousand dollar phone bills while travelling into the U.S. For the past few years I've been swapping my Rogers SIM Card for an AT&T SIM card when I cross the border.

Here are the steps to avoid the outrageous $1.45/minute roaming charges from Rogers:

• Unlock your phone by purchasing an unlock code from http://www.gsmphonesource.com. This is required but only has to be done once. If you break your phone and get a replacement you'll have to unlock it again.
• Buy an AT&T prepaid plan from an AT&T corporate store. You have to go in person. Only the corporate stores will let you pick a number anywhere in the U.S. instead of just their local area. A prepaid plan only requires a credit card. The problem with prepaid is that you can only browse the web with the 100 Mb $19.99 data plan. It will not support BIS which is what allows your Blackberry to use it's built in software for email. Custom email apps like Gmail for the Blackberry will still work though!
• Alternative: Buy a monthly plan asking them to waive the $36 activation fee. Don't tell them you're only using it for a trip. Make sure there are zero penalties if you cancel it if you're "unhappy with the service during the first 30 days". Cancel it when you're done your trip. You must register the account to a U.S. address and it's faster if you have a US dollar credit card to pass the credit check. Pick all the options you want on the plan accordingly for minutes, voice mail, texting, and data. AT&T charges extra for tethering if you want to access the internet from your laptop via a Blackberry (or Android phone) with USB cable but this is cheaper than the $10/day most hotels charge for high speed internet in your room.
• With your Canadian SIM still installed call forward your cell phone to the new AT&T cell number. Note this incurs long distance against your Canadian cell long distance plan every time someone calls it. Alternatively, don't call forward and just check your voicemail frequently. Power down your phone. Remove the battery and slide out your SIM card. Replace it with the AT&T SIM card and test calling it from another phone.
• When you return swap out the SIM card, turn off call forwarding. If your email does not work visit http://rogers.blackberry.com or http://bell.blackberry.com and login. Enter your PIN/IMEI at the prompt. If on Google Apps you'll have to re-start or login to the blue Google Sync icon for your contacts and calendar to continue synchronizing.

End result? You pay as low as $29 for 200 minutes instead of $290 or $1.45/minute with Rogers. AT&T has unlimited plans starting at $69.99/month.

Follow-up on Draytek 2950G

We've been running the Draytek 2950G for a few weeks now and the client is very happy with the results.  It balances the load between the 2 WAN ports much better than the prior NetGear router did.

Here's a screen shot of the Data Flow Monitor during a large file transfer:

And this is the NAT table showing the internet sessions split between the 2 WAN ports.  Since WAN port 1 is 12 Mb/s download compared to 1.5 Mb/s for WAN port 2 it allocates more traffic to WAN port 1.

This router is a great way to combine 2 low cost internet data lines for load balancing and fail over/redundancy.  A Rogers Business Cable line for $99/month plus a Teksavvy high-speed DSL line for $69/month should provide lots of capacity and reliability for most medium sized offices.

Bookmark Sync for Chrome

This is so handy for folks like me that work on multiple computers.  Install or update to the latest Chrome browser and you can synchronize and merge your web page bookmarks across all your computers.

Details are here:
http://googleblog.blogspot.com/2010/01/extensions-bookmark-sync-and-more-for.html

Prior to this 4.0 release I found Chrome had some compatibility issues with certain web sites but it's definitely the no contest performance winner over all other web browsers.

Android Phone OS makes impressive gains

I've been using the LG Eve GW620 Android 3G phone from Rogers for a few weeks now.  I'm extremely impressed by the platform but it is ready for prime time use by heavy business users?

It's awesome if your company is already on Google Apps or Gmail as it synchronizes automatically with your email, calendar, and contacts plus uploads pictures directly into Picasa.  There are no extra applications to install or web accounts to set-up like you have to with a Blackberry.  You also don't need Blackberry Enterprise Server (BES) to make everything insantaneous and eliminate the typical 10 to 15 minute delay for email.  Keeping everything in the Google family certainly makes everything simpler to set-up and simpler to use.

One limitation I've run into is the inability to create new calendar appointments that include other attendees.  Also, I can't run real time stock streaming software like Quotestream, however, I've opened a ticket with Quotemedia to see if there is a work around. (Update: Open this link directly to install the mobile Java version of Quotestream Wireless.  It works but cuts off the edges of the window if you hold the phone horizontally instead of vertically)

The Android phone platform is definitely growing rapidly.  I was surprised to see that Android has 27% market share compared to iPhone's 54% market share for mobile ads displayed.

First Impression: DrayTek Vigor2950G Dual Wan Router

After much research we recently installed the Draytek Vigor2950G Dual Wan Router for a client to replace their NetGear FVS336G.  I'm impressed by its functionality and sophistication for $475 USD.  The NetGear's load balancing was simplistic and couldn't properly utilize the combined bandwidth of the customer's T1 line and Rogers Cable modem.

All of the customer's software applications are cloud computing based so our goal is to provide redundancy, yet still utilize all the bandwidth available for better performance.  We also wanted stronger QoS for consistently clear phone calls over Voip.

We configured the Draytek to allocate up to 75% of the T1 line to Voip/SIP calls.  The 75% can still be used by other traffic but only when it isn't needed for Voip.

There are certainly more expensive firewalls/routers with the same functionality.  So far it's working great.  I'll post again after we've had more time to put it through it paces.

Surf the web via your Blackberry - no Internet stick required

Who likes to pay separately for their Internet stick and its data plan?

I've been using Blackberries to surf the web from my notebook (as tethered modems) for over 3 years yet still very few people know about it.  It's never been simple to configure.  There are no additional monthly costs outside of your existing Blackberry data plan.  Make sure you have a 500 Mb/month plan or greater or it's very pricey.

2 ways to make it work via a USB cable which also charges your battery:

• The old way is complex, details are here but it can be done over Bluetooth or a USB cable.
• The new way is to install Blackberry Desktop 5.0.1 or greater and simply click the IP Modem button but this works only with a USB cable

It works on Rogers Wireless and Bell Mobility.  Should work on Telus but I haven't tested it myself.

There's no need for buying software like Tether for Blackberry. I hope this helps a few people save some money.