subscribe  It's quick and easy!

Access to 196 free guest articles, discussions and more, just create your free OfficeUsers User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

 

How to link different data sources together

Available for Members. This is an off-site link.  Please review our Terms of Service (bottom of page) for additional information.  See Related Articles


 Article Abstract:

(klaus_salchner) In today's enterprises, different types of data are sitting in various data stores. Relational data is most likely to be in a SQL Server database or Oracle database. Many enterprise applications have their own database with its own data and data model. User and account information reside in a directory like Active Directory or Active Directory Application Mode.

For more information about the directory services, please refer to the following article. Smaller, more fluent and mobile data sits in Excel spreadsheets or Microsoft Access databases. Each enterprise has large amounts of files like Word documents, Excel Spreadsheets, HTML documents, etc. which are sitting on a file system. It's a common practice to use Microsoft Indexing Server to index all the files sitting on the file system or a web server. Microsoft Indexing Server creates an indexing catalog and also provides a SQL query interface which enables you to simply search the index. For more information about Microsoft Indexing Server please refer to the following article.

 Read this article...

 Related Articles - For Members.
Lookup Tables
Configuring a Linked Microsoft Access Server on SQL 2005 Server
Access and SQL Part 2: Putting VBA and SQL Together
Access and SQL Part 1: Setting the SQL Scene
PowerPoint and Excel Worksheets
Masking Social Security Numbers in an Excel Worksheet
Microsoft Excel Formula and VBA Macro Code To Fill All Blank Cells In a List
Excel Security and Excel Password Protection
Excel Vlookup formula-function explained

Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati


Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

No Comments/Feedback Posted Yet. Post Your Comments/Feedback


   




 
 
[ Register ] [ Webcasts ] [ Podcasts ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to OfficeUsers ] [ Recent Orig. Content ]
© 1997-2009, Bits on the Wire, Inc.  

Some names and products covered by OfficeUsers are the registered trademarks of their respective owners.