Setting Up DBMoto for DataGarage
Contents
1. daily change count put in the Metrics process The default value is 11 00 pm 7 Create all Targets in DataGarage Target databases can only be Microsoft SQL Server in DataGarage 5 5 Refer to the DataGarage User Manual for details on creating targets HiT Software Inc A Back Office Associates LLC Company Copyright 2012 8 Create all Sources in DataGarage Source databases can be Oracle IBM DB2 or Microsoft SQL Server Refer to the DataGarage User Manual for details on creating sources 9 Restore the DBMoto Client database from the DBMoto Client bak file in the Database folder in the DataGarage installation package 10 Create a user ID called CranSoft and assign the db owner role 11 Start the DBMoto Management Center The following steps remove the default DBMoto metadata and add a specialized DBMoto for DataGarage metadata so that connections and replications can be set up automatically from DataGarage 12 In the Metadata Explorer expand the tree and select the entry metadata DBMoto Management Center File View Tools Window Help 26 7 Metadata Explorer 52 Metadata b amp UE DBMoto local 2 13 From the right mouse button menu choose Remove Metadata 14 Select the entry local 15 From the right mouse button menu choose Add New Metadata HiT Software Inc A Back Office Associates LLC Company Copyright 2012 162. DN di Docs DBConfig dll 0 DBMAgent pdb Digital Line Detect di en 10 DBConfig pdb DBMBusinessRules dll El di Easy GIF Animator di it DBGate dll DBMBusinessRules pdb F Easy Gif Animator Extension B DBGate pdb DBMetadata dll Es di Flip video Log DBGate XmlSerializers dll 0 DBMetadata pdb GIF Movie Gear Ritmo DB2 Date created 1 19 2012 1 18 PM jDBMoto config Google Ritmo i Size 347 KB DBMoto config bck ii HiT Software di ServerFiles DBLogReader dll DBMoto his 8 DBMoto V6 SqlServerCe 10 DBLogReader pdb DBMoto license xml di synccache DBMAgent exe DBMoto log CodePages S APILibrary dll DBMAgent exe config DBMoto server config I Confia z ju passos gt HiT Software Inc A Back Office Associates LLC Company Copyright 2012 aa fi C Inetpub virtualroot DevNetApps WebUserArea 4f3346c AINA eal DRE TOM E END 17 LP search Cs Folders 1 Address m C TUTTI EEUU Nuno Date Modified Attrbu c3Badues File Folder 6 15 2009 10 56 AM ri E CodePages File Folder 7 14 2010 5 52 PM Config File Folder 7 19 2010 9 07 PM 89 Readkfe File Folder 6 30 2010 5 12 PM CodePages Gen Folder 7 6 2010 12 42 PM Config ex Folder 7 6j2010 12 42 PM 8 Docs Blog File Folder 8 18 2010 2 02 PM Qe Stuff File Folder 2 25 2010 8 05 PM e CRitm
3. In the Metadata Connection wizard type a name for the metadata and select Microsoft SQL Server as the database Kj Metadata Connection Wizard Select the database that will contain the DBMoto metadata tables and indicate which provider to use We recommend that you create and use a database M Metadata M Data Provider s Database E Microsoft SAL Server 7 Provider Ey Microsott Driver S LClient Assembly 17 Click Next to display the connection parameters f Metadata Connection Wizard Data Source User ID CranSoft Password RRRRARAK El Optional Initial Catalog Enlist Encrypt Data Source The name or network address of the instance of SQL Server to which to HiT Software Inc A Back Office Associates LLC Company Copyright 2012 18 19 20 21 22 23 24 In the Data Source field type the IP address or server name for the installation of SQL Server which is running the DataGarage database In the User field type CranSoft and enter the password for that database user Metadata Connection Wizard x DBMoto Specify the connection parameters for the metadata Select provider Set connection string Connection properties Select qualifier El Required SI Define metadata Data Source DBMoto_Client User ID CranSoft Summary Optional Initial Catalog Enlist False Encrypt Fa
4. Schedule Groups Test Connection Build Package D e Locate the DBMoto Package e After verifying that the sources have the same names click Build Package If DBMoto for DataGarage was installed correctly and you are using the default settings for the DBMoto package the data replication process runs automatically For help on installing and setting up DBMoto for DataGarage contact dbmoto support hitsw com Creating DBMoto Source Connections This step is necessary only if you are downloading replicating data from a database other than Oracle where connections are created automatically For all other databases 1 Both Microsoft SQL Server and IBM DB2 LUW are supported as source databases If you are using another database check that your database and version is supported by contacting the DBMoto support team at dbmoto support hitsw com 2 Inthe Metadata Explorer expand the DBMoto Client metadata 3 Select Sources and from the right mouse button menu choose Add New Connection 4 Inthe Source Connection wizard set values that match the connection specified in DataGarage on the Target Source Setup page Use the DBMoto User s Guide via the Help button for help in filling out the fields in the wizard 5 Complete the wizard and check that the connection has been created in the Metadata Explorer 6 Create additional connections as needed HiT Software Inc A Back Office Associates LLC Company Copyright
5. 2012 For Further Information DBMoto DataGarage Setup DataGarage Installation amp Upgrade Manual Appendix D Download amp Install DBMoto for DataGarage DataGarage Usage DataGarage User Manual Oracle Database Permissions http www hitsw com products_ services dbmoto users guide setupguides DBMoto7 DG SetupOracle pdf Microsoft SQL Server Database Permissions and Connection Information http www hitsw com products_services dbmoto users guide setupguides D BMoto7 DG SetupSQLServer pdf IBM DB2 LUW Database Setup http www hitsw com products services dbmoto users guide setupguides DBMoto7 DG SetuplBMDB2LUW pdf DBMoto User s Guide http www hitsw com products services dbmoto users guide DBMotoUsersGuide html HiT Software Inc A Back Office Associates LLC Company Copyright 2012
6. 4660 826F 0FGFABSCOS7B A DEMBusinessRules di A a218fdcb a0ce 4347 9c4c 09cadeBcdeb9 8 D amp Metadata dii 350KB Application Extension 8 18 2010 9 44AM ad Dp te dies aaa BS DEMoto config 2KB XML Configuration File 8 18 2010 1 48PM 27 Set up a security profile for DBMoto Data Replicator as follows e Copy the dbmoto inf file from the DataGarage install folder to the original DBMoto install folder e Edit DBMotoSetSecurity bat in the DataGarage Processes folder to add the original installation folder for DBMoto secedit configure db secedit sdb cfg C Program Files HiT Software DBMoto 7 dbmoto inf e Save DBMotoSetSecurity bat e Run DBMotoSetSecurity bat by double clicking the file 28 Restart Microsoft IIS 29 Restart CranSoft Services 30 Verify that the Process Mirror Changes Service Page is active e Log into System Administration e Select Service Pages from Resources on Switchboard HiT Software Inc A Back Office Associates LLC Company Copyright 2012 9 vV 5 Web AppA Active Start Stop Failed Log All Jobs J DataGarage Log Delete Service J DataGarage Test All Connections Service v Stop l 90 DataGarage Schedule Service v Stop d 31 Build the DBMoto Package in DataGarage e Log into DataGarage e Click Target Setup on Switchboard e Locate the DBMoto Target e Click Sources V S Sourcea Connection Type Schema Owner Active Tables
7. Setting Up DBMoto for DataGarage DBMoto V7 and above DataGarage v 5 5 PHIT TWA A BackOffice Associates LLC Company Copyright This document is copyrighted and protected by worldwide copyright laws and treaty provisions No portion of this documentation may be distributed or reproduced by any means or in any form without HiT Software s prior written permission COPYRIGHT NOTICE Copyright 2012 HiT Software Inc A BackOffice Associates LLC Company All Rights Reserved Disclaimer Information in these HTML documents is subject to change without notice Although efforts have been made to ensure the accuracy of these documents HiT Software Inc assumes no responsibility for damages incurred directly or indirectly from errors omissions and discrepancies between the software and the documents If you find any problems in the documentation please report them to HiT Software Inc Trademarks CranSoft and DataGarage are registered trademarks of BackOffice Associates LLC HiT Software DBMoto and Ritmo are registered trademarks or trademarks of HiT Software Inc All other marks are used for the benefit of their respective owners and HiT Software Inc disclaims any interest in such marks Contact Information HiT Software Inc Tel 1 408 345 4001 Fax 1 408 345 4899 Electronic mail info hitsw com Web site www hitsw com Introduction DBMoto for DataGarage is a supplementary option for DataGa
8. es that match the Sources you created in DataGarage See Creating DBMoto Source Connections below Targets are created in DBMoto automatically by DataGarage Review the document http www hitsw com products services dbmoto users guide setupguides D BMoto7 DG SetupIBMDB2LUW pdf for information on required database permissions and settings for IBM DB2 LUW Other Contact the DBMoto support team to verify support for your database databases with dbmoto support hitsw com in the DBMoto Management Center with ODBC OLE DB names that match the Sources you created in DataGarage See Creating or NET DBMoto Source Connections below Provider access 25 Exit the DBMoto Management Center 26 On your Windows desktop copy the contents of the DBMoto installation folder to the DataGarage install folder For example copy all the files in C Program Files HiT Software DBMoto V7 to C Mnetpub virtualroot DevNetApps W eb UserArea 4f3346ca 235a 46bd 84d8 1d234b873a0c Processes Ou OS C Program Files HiT Software DBMoto V7 X Search m File Edit view Tools Organize v views 11 SlideShow f Burn Compatibility Files e Folders v Name MI Date taken B Tags MI Size M Rating CodePages APILibrary pdb DBMAgent InstallLog c k Network Assistant M Config 19 APILibrary XML DBMAgent Installtate
9. fore DBMoto to avoid errors when DBMoto checks the metadata To add a dependency select the service in the list then click Add The DBMoto Data Replicator Service will not start until the selected service has started For example if you select SQL Server service and click Add SQL Server is added as a dependency the DBMoto service does not start until the SQL Server service starts At the end of the installation the DBMServiceMonitor program is available in the Windows Notification area System Tray You can use this program to start the DBReplicator service after creating metadata tables in the DBMoto Management Center see below 4 Obtain a copy of the DataGarage Installation amp Upgrade Manual Refer to Appendix D Download amp Install DBMoto for DataGarage The information below summarizes the steps in Appendix D 5 Run the DataGarage 5 5 DBMoto enhancement sq script the DataGarage database to add the DBMoto specific options to DataGarage 6 From the DataGarage Switchboard Configuration Parameters DBMoto Settings tab configure DBMoto for DataGarage settings DBMoto Setting Description Server Address Server address of DBMoto This address must match the application server of CranSoft with a port set to 58361 The default value is NULL Populate once OnValidate is clicked Number of tables in each mirroring group Groups are used to check system logs for Group Size changes It is more efficien
10. icense key License keys are typically sent within 4 hours during North American business hours Pacific Time except on weekends and US holidays Contact HiT Software at info hitsw com if you do not receive the key within two business days DBMoto version 7 and above requires Microsoft NET Framework 2 0 SP 2 or Microsoft NET framework 3 5 SP1 Make sure that you have installed an appropriate version of Microsoft NET framework on your system Once you have received the license key install DBMoto on the same server as DataGarage by running the downloaded setup exe file e When you reach the Setup Type screen click the Standard Installation option e Inthe Customer Information and Setup Options screen click Import then supply the path name to the license file that you received via email e Check the option to install the DBReplicator as a Windows service but note that the service does not start automatically by default e Use the DBMoto Service Dependencies window to specify services needed by DBMoto prior to the DBMoto Data Replicator Service startup If your metadata database see below is not local on the same system where DBMoto is installed you do not need to set dependencies HiT Software Inc A Back Office Associates LLC Company Copyright 2012 Click Done to close the window If you have a local database installed on the same system as DBMoto that is storing your DBMoto metadata the database must be running be
11. lse x Password User password j AT Edit Test www hitsw com Back Next gt Help Click Next to complete the qualifiers for the database Click Next to set the metadata Choose to use an existing metadata DBMoto Client Complete the wizard In the Metadata Explorer select the new metadata DBMoto Client and choose Global Script from the right mouse button menu to verify that the global script is available in the Global Script Editor In the Metadata Explorer add connections for source databases as needed Oracle Connections are automatically provided when you build the DBMoto package in DataGarage Review the document http www hitsw com products services dbmoto users guide setupguides D BMoto7 DG SetupOracle pdf for information on required database permissions for Oracle Microsoft SQL Create source connections in the DBMoto Management Center with names Server that match the Sources you created in DataGarage See Creating DBMoto Source Connections below Targets are created in DBMoto automatically by DataGarage Review the document http www hitsw com products services dbmoto users guide setupguides D BMoto7 DG SetupSQLServer pdf for information on required database permissions and settings for Microsoft SQL Server HiT Software Inc A Back Office Associates LLC Company Copyright 2012 IBM DB2 LUW Create source connections in the DBMoto Management Center with nam
12. o p amp 2 File Folder 6 30 2010 5 12 PM Quo CiRAmo File Felder 6 30 2010 5 12 PM oid suff C ServerFies File Folder 6 30 2010 5 12 PM Ritmo 062 Casdserverce Folder 7126 2010 9 28 PM amp Rmo i File 7 26 2010 6 18 PM amp Serverhles AMA DBMOTO TEST xml 35KB XML Document 6 29 2010 10 45AM Sdiserverce S aPtubrary di 102KB Application Extension 8 18 20109 5 synccache 9 BoaFunctionsLB dii 19KB Application Extension 5 26 2009 10 10AM 8 C 15642407 FF20 414A 5 30 A777ED24E568 S BOANetReadTable Net di 156 Appication Extension 7 22 2010 3 41 PM H E 90EACIAE BFAF 43F7 83A1 83CC37045878 DataGarageWeb di 344KB Application Extension 8 18 2010 2 00PM B2 DBConfig dil 118KB Application Extension 8 18 20109 44 AM 8 E 32328576 764 4394 86 2 5324862 637 5 D6Gate dii 158KB Application Extension 8 18 2010 9 44 AM A 9 665617c0 4633 459b 8469 4dS 035366d S 08Grid ct 386KB Application Extension S 18 20109 44 AM 8 4886 857 7059 4 8 4 0360 i D6LogReader di SA2KB AppkcationExtension 8 18 20109 4 AM 8 E 6173CE14 0FA9 4687 86CA 74CSA48F6CD3 39KB Application Sj 18 20109 45 AM E 07669A7F 1A0C 46FE A360 EBZFBEZOCBES Bur 28 E 85360FDF 189A 47C3 8109 227C1E119FEC fap COMAgent 174 03557080 30F2 47FO AAB7 AB386E LEFD48 E DeMAgent InstaliState Date Created 62520106 01 PM A E 6928022 9237
13. rage It provides two packages for data replication from Microsoft SQL Server Oracle IBM DB2 LUW or other ODBC enabled databases to Microsoft SQL Server Complete data replication Refresh followed by regular data updates Mirroring of changed data only This is valuable in situations where the size of tables does not permit a complete data replication within the allotted time frame Complete data replication Refresh using DBMoto replication technology Depending on your environment this can offer an alternative more effective approach to complete data replication DataGarage includes several tools to facilitate the installation and setup of DBMoto for DataGarage You will need to run these tools as well as download and install DBMoto for DataGarage This guide describes how to set up your DataGarage environment to make use of the new DBMoto packages Installing and Setting Up DBMoto for DataGarage The instructions below assume that you have an installed and working copy of DataGarage as well as an installed and working copy of Microsoft SQL Server Note that DBMoto for DataGarage and DataGarage should be installed on the same server 1 Download DBMoto for DataGarage from HiT Software s web site http www hitsw com datagarage index html Note that the download page requires contact information for the customer where you are using DBMoto for DataGarage Use an email address where you will be able to receive an evaluation l
14. t to check once for a group of tables then to log in for each table individually Group Size must be determined by the client Each group runs single thread mode with one table refreshing at a time The default value is 50 Maximum Limit of simultaneous connections to the source system The default value is 8 Connections Mirror Interval For the Mirroring Package type changed data only the number of seconds between checking the source database log for changes As a recommendation do not use a value less than 60 seconds The value could be set to 600 so the system can be checked every 10 minutes Source DBMS have special requirements for installation please review t the section For Further Information in this document The default value is 900 Start Replicator If enabled the DBMoto Replicator is started after each Build Package process If disabled the DBMoto Replicator must be manually started in the DBMoto Management Center on the application server This feature is enabled by default If enabled allows the group to mirror after each Build Package process If disabled the Enable Group must be manually restarted in the DBMoto Management Center on the Ege Gto application server The DBMoto Replicator must be running before the data download process can start This feature is enabled by default m Controls when all tables without rules will have the boaDBMotolnd set back to zero and the Metric Time
Download Pdf Manuals
Related Search