BCS Master Detail Infomation Collector

To collect information to be subsequently used in a master detail scenario the BCSMDInfo component fulfills that requirement.

Once the component has executed successfully the following information is returned.

As you can see all the information to establish the master detail scenario is collected.
Component documentation can be located http://archbrooks.com/compdoc/BCSMDInfo/html/BCS%20Collect%20Master%20Detail%20Information.htm.
The source code for this tool is located at http://cc.embarcadero.com/item/29690.
A modification was added to collect database user login credentials.  The Universal User Login component was used for this feature.  The article for the utility can be found at https://archbrooks.us/b4/post.php?post=903.
A new table was created to support this level of user verification.  It schema is listed below.
[codesyntax lang=”mysql”]

-- phpMyAdmin SQL Dump
-- version 4.0.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 17, 2014 at 01:17 PM
-- Server version: 5.5.24-log
-- PHP Version: 5.3.26
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `bcswebtools`
--
-- --------------------------------------------------------
--
-- Table structure for table `dbct`
--
CREATE TABLE IF NOT EXISTS `dbct` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(25) NOT NULL,
  `pwd` varchar(25) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[/codesyntax]
This table contains a user name and a password value for verification purposes.
Mr. Arch Brooks, Software Engineer, Brooks Computing Systems, LLC authored this article.