Blah, blah

dbo.Agent

Property Type Required Description
Id int Y Primary Key
Name nvarchar(250) Y Name of the agent service
Address nvarchar(1000) Y Endpoint address of an agent
ExtractPath nvarchar(max) Y Path on the machine where agent is installed to store extracted flat files
BufferSizeInBytes int Y Size of the stream writer buffer which is used for writing into extract files. Recommended value is 64k (65535)
MaxCpuUsagePct tinyint Y Maximum allowed CPU usage on the machine where agent is installed. Acceptable values are in range from 20 to 100

dbo.Attribute

dbo.Blob

Property Type Required Description
Id int Y Primary Key
Name nvarchar(250) Y Name of the blob container
AccountName nvarchar(250) Y
AccountKey nvarchar(250) Y

dbo.Connection

dbo.DataSource

dbo.DataSourceType

dbo.DelimitedFlatFile

dbo.DerivedColumn

dbo.ExecutionLog

dbo.ExtractFile

This table contains properties of extract file which will be created by agent.
Property Type Required Description
Id int Y Primary Key
Name nvarchar(250) Y Name of the extract file
CompressionId int Y Compression which will be applied on extract files
Delimiter nvarchar(20) Y Delimiter which will be used to separate data source columns in extract file
DistributionCount int Y Number of file distributions i.e. number of extract files which are going to be created per data source

dbo.Interface

dbo.InterfaceCategory

dbo.InterfaceDependence

dbo.InterfaceDependenceType

dbo.LoadPattern

dbo.MessageLog

dbo.Schedule

dbo.SourceData

dbo.SourceDataCategory

dbo.SourceDataType

dbo.Task

dbo.TaskLog

dbo.TaskStatus

dbo.TaskType

Last edited Nov 17, 2016 at 3:24 AM by knyazs, version 7