https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Config/ Recent content in Configuration on Syniti Documentation Hugo -- gohugo.io en-us https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Config/Build_Process/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Config/Build_Process/ Build Process The following is a high-level overview of how Collect builds packages and pulls data from the Source system. Create Source and Target connections in System Administration (performed by an Administrator) Register Targets in Collect Register Sources in Collect Fetch tables, which will build a System Type Group with the name of the Source in Common. Activate the Tables in the System Type Group in Common. Import the System Type Group tables in Collect. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Config/Configure_Parameters_in_Common/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Config/Configure_Parameters_in_Common/ Configure Parameters in Common Collect parameters are high-level fields used throughout the component that must be configured per installation. These parameters are configured within Common. Refer to Common documentation for detailed information. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Config/Create_DBMoto_Source_Connections/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Config/Create_DBMoto_Source_Connections/ Create DBMoto® Source Connections If using DBMoto® and downloading (replicating) data from a database other than Oracle, Microsoft SQL Server or IMB DB2 LUW (where connections are created automatically), create a DBMoto® source connection. To create a DBMoto® source connection: Check that the database is supported by contacting the DBMoto® support team at http://support.boaweb.com. Launch DBMoto®. In the Metadata Explorer, expand the DBMoto_Client.metadata. Right-click Sources and select Add New Connection. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Config/Encrypt_CranSoft_DataSource_Password/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Config/Encrypt_CranSoft_DataSource_Password/ Encrypt CranSoft® Data Source Password To enable encryption for Collect, an Administrator must encrypt the CranSoft® Data Source password in System Administration. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Config/Register_Target_and_Source_Data_Sources/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Config/Register_Target_and_Source_Data_Sources/ Register Target and Source Data Sources Target and Source data sources must be registered using the preferred method in Common. Refer to Register a Data Source in Common for more information. A data source can also be registered in System Administration, but this method is not recommended. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Config/Set_up_Connection_Types/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Config/Set_up_Connection_Types/ Set up Connection Types Connection Types require SQL Server to download the data dictionary from the source database, a substring sample command and the windows driver to embed in the package. Columns included in the download must be named the same as the example in the database. The connection string in this table must be fully populated or consequently, the database user ID and password are ignored when using a user-defined ODBC connection. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Config/Set_Up_Schedule_Groups/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Config/Set_Up_Schedule_Groups/ Set Up Schedule Groups Tables that do not have a Schedule Group set up run multi-thread limited to the number of jobs set in the general queue. The general queue is used for non-DSP event processing. Schedule Groups are used for scheduling a subset of tables and/or to download tables in a single thread. Consider downloading using a single thread when downloading very large tables. While downloading many small tables all together using multi-thread may run efficiently, downloading several large tables together can result in database contention on the data file. https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Config/Setup_and_Configuration_for_Collect/ Mon, 01 Jan 0001 00:00:00 +0000 https://hcloward.github.io/HCloward.github.io-syniti-hugo/Collect/Config/Setup_and_Configuration_for_Collect/ Setup and Configuration for Collect Before getting started with Collect, verify the following has been completed: Set up Security (performed by an Administrator) Register Target and Source Data Sources Create DBMoto® Source Connections Encrypt Data Source Password (performed by an Administrator) Configure Parameters in Common Set up Connection Types Set up Schedule Groups