public class LineageService
extends java.lang.Object
Constructor and Description |
---|
LineageService() |
Modifier and Type | Method and Description |
---|---|
java.lang.String |
getColumnDetails(java.lang.String userName,
java.lang.String password,
java.lang.String outputFormat,
java.lang.String endPointType,
int mappingSequenceId)
Returns the List
|
java.lang.String |
getColumnDetailsByMapSeqIds(java.lang.String userName,
java.lang.String password,
java.lang.String outputFormat,
java.lang.String endPointType,
java.lang.String mappingSequenceIds)
Returns the List
|
java.lang.String |
getColumnLineage(java.lang.String userName,
java.lang.String password,
java.lang.String outputFormat,
java.lang.String lineageType,
java.lang.String systemName,
java.lang.String environmentName,
java.lang.String tableName,
java.lang.String columnName,
java.lang.String projectIds)
Returns the Lineage Object String in the form of JSON for the specified
system, environment, table and column name.
|
java.lang.String |
getColumnsBySysEnvTabs(java.lang.String userName,
java.lang.String password,
java.lang.String outputFormat,
java.lang.String endPointType,
java.lang.String systemEnvironmentTableJsonArray,
java.lang.String propertiesTypes,
java.lang.String projectIds)
Returns the List
|
java.lang.String |
getEnvironmentLineage(java.lang.String userName,
java.lang.String password,
java.lang.String outputFormat,
java.lang.String lineageType,
java.lang.String systemName,
java.lang.String environmentName,
java.lang.String projectIds)
Returns the Lineage Object String in the form of JSON for the specified
system and environment name.The returned Lineage object contains the
details about the source and target environments like systemName,
environmentName.
|
java.lang.String |
getEnvironmentsBySystemNamesAs(java.lang.String userName,
java.lang.String password,
java.lang.String outputFormat,
java.lang.String endPointType,
java.lang.String systemNames,
java.lang.String projectIds)
Returns the List
|
java.lang.String |
getLineageColumns(java.lang.String userName,
java.lang.String password,
java.lang.String outputFormat,
java.lang.String endPointType,
java.lang.String systemName,
java.lang.String environmentName,
java.lang.String tableName,
java.lang.String propertiesTypes,
java.lang.String projectIds)
Returns the List
|
java.lang.String |
getLineageEnvironments(java.lang.String userName,
java.lang.String password,
java.lang.String outputFormat,
java.lang.String endPointType,
java.lang.String systemName,
java.lang.String projectIds)
Returns the List
|
java.lang.String |
getLineageTables(java.lang.String userName,
java.lang.String password,
java.lang.String outputFormat,
java.lang.String endPointType,
java.lang.String systemName,
java.lang.String environmentName,
java.lang.String projectIds)
Returns the List
|
java.lang.String |
getSystemLineage(java.lang.String userName,
java.lang.String password,
java.lang.String outputFormat,
java.lang.String lineageType,
java.lang.String systemName,
java.lang.String projectIds)
Returns the Lineage Object String in the form of JSON for the specified
system name.
|
java.lang.String |
getTableLineage(java.lang.String userName,
java.lang.String password,
java.lang.String outputFormat,
java.lang.String lineageType,
java.lang.String systemName,
java.lang.String environmentName,
java.lang.String tableName,
java.lang.String projectIds)
Returns the Lineage Object String in the form of JSON for the specified
system, environment and table name.
|
java.lang.String |
getTablesBySysEnvs(java.lang.String userName,
java.lang.String password,
java.lang.String outputFormat,
java.lang.String endPointType,
java.lang.String systemEnvironmentJsonArray,
java.lang.String projectIds)
Returns the List
|
java.lang.String |
resetLineageData(java.lang.String userName,
java.lang.String password)
It will reset the lineage data.
|
java.lang.String |
syncLineageData(java.lang.String userName,
java.lang.String password)
It will sync the lineage data.
|
public java.lang.String getSystemLineage(java.lang.String userName, java.lang.String password, java.lang.String outputFormat, java.lang.String lineageType, java.lang.String systemName, java.lang.String projectIds)
APIConstants.LineageType.FORWARD
,
APIConstants.LineageType.REVERSE
,
APIConstants.LineageType.DUAL
. And the
projectIds value should be like "1,2,3.." to get the lineage on specific
projects and "null" to get the lineage on all projects.
outputFormat can be either JSON or XML. If outputFormat is not
specified, by default the method will return the JSON String.userName
- Stringpassword
- StringlineageType
- String - valid types FORWARD, REVERSE, DUAL.systemName
- StringprojectIds
- String - value should be like "1,2,3..."outputFormat
- String - Valid values: JSON or XMLpublic java.lang.String getEnvironmentLineage(java.lang.String userName, java.lang.String password, java.lang.String outputFormat, java.lang.String lineageType, java.lang.String systemName, java.lang.String environmentName, java.lang.String projectIds)
APIConstants.LineageType.FORWARD
,
APIConstants.LineageType.REVERSE
,
APIConstants.LineageType.DUAL
. And the
projectIds value should be like "1,2,3.." to get the lineage on specific
projects and "null" to get the lineage on all projects.
outputFormat can be either JSON or XML. If outputFormat is not
specified, by default the method will return the JSON String.userName
- Stringpassword
- StringlineageType
- String - valid types FORWARD, REVERSE, DUAL.systemName
- StringenvironmentName
- StringprojectIds
- String - value should be like "1,2,3..."outputFormat
- String - Valid values: JSON or XMLpublic java.lang.String getTableLineage(java.lang.String userName, java.lang.String password, java.lang.String outputFormat, java.lang.String lineageType, java.lang.String systemName, java.lang.String environmentName, java.lang.String tableName, java.lang.String projectIds)
APIConstants.LineageType.FORWARD
,
APIConstants.LineageType.REVERSE
,
APIConstants.LineageType.DUAL
. And the
projectIds value should be like "1,2,3.." to get the lineage on specific
projects and "null" to get the lineage on all projects.
outputFormat can be either JSON or XML. If outputFormat is not
specified, by default the method will return the JSON String.userName
- Stringpassword
- StringlineageType
- String - valid types FORWARD, REVERSE, DUAL.systemName
- StringenvironmentName
- StringtableName
- StringprojectIds
- StringoutputFormat
- String - Valid values: JSON or XMLpublic java.lang.String getColumnLineage(java.lang.String userName, java.lang.String password, java.lang.String outputFormat, java.lang.String lineageType, java.lang.String systemName, java.lang.String environmentName, java.lang.String tableName, java.lang.String columnName, java.lang.String projectIds)
APIConstants.LineageType.FORWARD
,
APIConstants.LineageType.REVERSE
,
APIConstants.LineageType.DUAL
. And the
projectIds value should be like "1,2,3.." to get the lineage on specific
projects and "null" to get the lineage on all projects.
outputFormat can be either JSON or XML. If outputFormat is not
specified, by default the method will return the JSON String.userName
- Stringpassword
- StringlineageType
- String - valid types FORWARD, REVERSE, DUAL.systemName
- StringenvironmentName
- StringtableName
- StringcolumnName
- StringprojectIds
- StringoutputFormat
- String - Valid values: JSON or XMLpublic java.lang.String getColumnDetails(java.lang.String userName, java.lang.String password, java.lang.String outputFormat, java.lang.String endPointType, int mappingSequenceId)
APIConstants.EndPointType.SOURCE
,
APIConstants.EndPointType.TARGET
,
APIConstants.EndPointType.BOTH
. If we
specify endPointType as SOURCE then the returned column object will have
the source information like source system name, source environment name
etc.. If we specify endPointType as TARGET then the returned column
object will have the target information like target system name, target
environment name etc.. If we specify endPointType as BOTH then the
returned column object will have both the source and target information
like source system name, source environment name, target system name,
target environment name etc..
outputFormat can be either JSON or XML. If outputFormat is not
specified, by default the method will return the JSON String.userName
- Stringpassword
- StringendPointType
- String - valid types SOURCE, TARGET, BOTH.mappingSequenceId
- intoutputFormat
- String - Valid values: JSON or XMLpublic java.lang.String getColumnDetailsByMapSeqIds(java.lang.String userName, java.lang.String password, java.lang.String outputFormat, java.lang.String endPointType, java.lang.String mappingSequenceIds)
APIConstants.EndPointType.SOURCE
,
APIConstants.EndPointType.TARGET
,
APIConstants.EndPointType.BOTH
. If we
specify endPointType as SOURCE then the returned column object will have
the source information like source system name, source environment name
etc.. If we specify endPointType as TARGET then the returned column
object will have the target information like target system name, target
environment name etc.. If we specify endPointType as BOTH then the
returned column object will have both the source and target information
like source system name, source environment name, target system name,
target environment name etc..
outputFormat can be either JSON or XML. If outputFormat is not
specified, by default the method will return the JSON String.userName
- Stringpassword
- StringendPointType
- String - valid types SOURCE, TARGET, BOTH.mappingSequenceIds
- StringoutputFormat
- String - Valid values: JSON or XML
Sample 'mappingSequenceIds' :
[1,2]
public java.lang.String getLineageEnvironments(java.lang.String userName, java.lang.String password, java.lang.String outputFormat, java.lang.String endPointType, java.lang.String systemName, java.lang.String projectIds)
APIConstants.EndPointType.SOURCE
,
APIConstants.EndPointType.TARGET
,
APIConstants.EndPointType.BOTH
. If we
specify endPointType as SOURCE then the returned environment object will
have the source information like source system name, source environment
name etc.. If we specify endPointType as TARGET then the returned
environment object will have the target information like target system
name, target environment name etc.. If we specify endPointType as BOTH
then the returned environment object will have both the source and target
information like source system name, source environment name, target
system name, target environment name etc.. And the projectIds value
should be like "1,2,3.." to get the list of environments of specific
projects and "null" to get the list of environments of all projects.
outputFormat can be either JSON or XML. If outputFormat is not
specified, by default the method will return the JSON String.userName
- Stringpassword
- StringendPointType
- String - valid types SOURCE, TARGET, BOTH.systemName
- StringprojectIds
- StringoutputFormat
- String - Valid values: JSON or XMLpublic java.lang.String getEnvironmentsBySystemNamesAs(java.lang.String userName, java.lang.String password, java.lang.String outputFormat, java.lang.String endPointType, java.lang.String systemNames, java.lang.String projectIds)
APIConstants.EndPointType.SOURCE
,
APIConstants.EndPointType.TARGET
,
APIConstants.EndPointType.BOTH
. If we
specify endPointType as SOURCE then the returned environment object will
have the source information like source system name, source environment
name etc.. If we specify endPointType as TARGET then the returned
environment object will have the target information like target system
name, target environment name etc.. If we specify endPointType as BOTH
then the returned environment object will have both the source and target
information like source system name, source environment name, target
system name, target environment name etc.. And the projectIds value
should be like "1,2,3.." to get the list of environments of specific
projects and "null" to get the list of environments of all projects.
outputFormat can be either JSON or XML. If outputFormat is not
specified, by default the method will return the JSON String.userName
- Stringpassword
- StringendPointType
- String - valid types SOURCE, TARGET, BOTH.systemNames
- StringprojectIds
- StringoutputFormat
- String - Valid values: JSON or XML
Sample 'systemNames' :
["S1","S2","S3"]
public java.lang.String getLineageTables(java.lang.String userName, java.lang.String password, java.lang.String outputFormat, java.lang.String endPointType, java.lang.String systemName, java.lang.String environmentName, java.lang.String projectIds)
APIConstants.EndPointType.SOURCE
,
APIConstants.EndPointType.TARGET
,
APIConstants.EndPointType.BOTH
. If we
specify endPointType as SOURCE then the returned table object will have
the source information like source system name, environment name and
table name etc.. If we specify endPointType as TARGET then the returned
table object will have the target information like target system name,
environment name and table name etc.. If we specify endPointType as BOTH
then the returned table object will have both the source and target
information like source system name, source environment name, source
table name, target system name, target environment name , target table
name etc.. And the projectIds value should be like "1,2,3.." to get the
list of tables of specific projects and "null" to get the list of tables
of all projects.
outputFormat can be either JSON or XML. If outputFormat is not
specified, by default the method will return the JSON String.userName
- Stringpassword
- StringendPointType
- String - valid types SOURCE, TARGET, BOTH.systemName
- StringenvironmentName
- StringprojectIds
- StringoutputFormat
- String - Valid values: JSON or XMLpublic java.lang.String getTablesBySysEnvs(java.lang.String userName, java.lang.String password, java.lang.String outputFormat, java.lang.String endPointType, java.lang.String systemEnvironmentJsonArray, java.lang.String projectIds)
APIConstants.EndPointType.SOURCE
,
APIConstants.EndPointType.TARGET
,
APIConstants.EndPointType.BOTH
. If we
specify endPointType as SOURCE then the returned table object will have
the source information like source system name, environment name and
table name etc.. If we specify endPointType as TARGET then the returned
table object will have the target information like target system name,
environment name and table name etc.. If we specify endPointType as BOTH
then the returned table object will have both the source and target
information like source system name, source environment name, source
table name, target system name, target environment name , target table
name etc.. And the projectIds value should be like "1,2,3.." to get the
list of tables of specific projects and "null" to get the list of tables
of all projects.
outputFormat can be either JSON or XML. If outputFormat is not
specified, by default the method will return the JSON String.userName
- Stringpassword
- StringendPointType
- String - valid types SOURCE, TARGET, BOTH.systemEnvironmentJsonArray
- StringprojectIds
- StringoutputFormat
- String - Valid values: JSON or XML
Sample 'systemEnvironmentJsonArray' :
{"S2":["Env_A","Env_B"]}
public java.lang.String getLineageColumns(java.lang.String userName, java.lang.String password, java.lang.String outputFormat, java.lang.String endPointType, java.lang.String systemName, java.lang.String environmentName, java.lang.String tableName, java.lang.String propertiesTypes, java.lang.String projectIds)
APIConstants.EndPointType.SOURCE
,
APIConstants.EndPointType.TARGET
,
APIConstants.EndPointType.BOTH
. If we
specify endPointType as SOURCE then the returned column object will have
the source information like source system name, environment name, table
name and column name etc.. If we specify endPointType as TARGET then the
returned column object will have the target information like target
system name, environment name, table name and column name etc.. If we
specify endPointType as BOTH then the returned column object will have
both the source and target information like source system name, source
environment name, source table name,source column name, target system
name, target environment name , target table name and target column name
etc.. And the projectIds value should be like "1,2,3.." to get the list
of columns of specific projects and "null" to get the list of columns of
all projects.
APIConstants.PropertiesType.TECHNICAL
,
APIConstants.PropertiesType.BUSINESS
,
APIConstants.PropertiesType.NONE
If we specify the propertiesTypes as BUSINESS then the column object will
have business properties like colum definition, comments etc.. If we
specify the propertiesTypes as TECHNICAL then the column object will have
technical properties like column length,precision etc.. If we specify the
propertiesTypes as NONE then the column object will have only
system,environment,table and column name only.
outputFormat can be either JSON or XML. If outputFormat is not
specified, by default the method will return the JSON String.userName
- Stringpassword
- StringendPointType
- String - valid types SOURCE, TARGET, BOTH.systemName
- StringenvironmentName
- StringtableName
- StringprojectIds
- StringpropertiesTypes
- String - valid types TECHNICAL, BUSINESS, NONE.outputFormat
- String - Valid values: JSON or XMLpublic java.lang.String getColumnsBySysEnvTabs(java.lang.String userName, java.lang.String password, java.lang.String outputFormat, java.lang.String endPointType, java.lang.String systemEnvironmentTableJsonArray, java.lang.String propertiesTypes, java.lang.String projectIds)
APIConstants.EndPointType.SOURCE
,
APIConstants.EndPointType.TARGET
,
APIConstants.EndPointType.BOTH
. If we
specify endPointType as SOURCE then the returned column object will have
the source information like source system name, environment name, table
name and column name etc.. If we specify endPointType as TARGET then the
returned column object will have the target information like target
system name, environment name, table name and column name etc.. If we
specify endPointType as BOTH then the returned column object will have
both the source and target information like source system name, source
environment name, source table name,source column name, target system
name, target environment name , target table name and target column name
etc.. And the projectIds value should be like "1,2,3.." to get the list
of columns of specific projects and "null" to get the list of columns of
all projects.
APIConstants.PropertiesType.TECHNICAL
,
APIConstants.PropertiesType.BUSINESS
,
APIConstants.PropertiesType.NONE
If we specify the propertiesTypes as BUSINESS then the column object will
have business properties like colum definition, comments etc.. If we
specify the propertiesTypes as TECHNICAL then the column object will have
technical properties like column length,precision etc.. If we specify the
propertiesTypes as NONE then the column object will have only
system,environment,table and column name only.
outputFormat can be either JSON or XML. If outputFormat is not
specified, by default the method will return the JSON String.userName
- Stringpassword
- StringendPointType
- String - valid types SOURCE, TARGET, BOTH.systemEnvironmentTableJsonArray
- StringprojectIds
- StringpropertiesTypes
- String - valid types TECHNICAL, BUSINESS, NONE.outputFormat
- String - Valid values: JSON or XML
Sample 'systemEnvironmentJsonArray' :
{"S2":{"Env_Excel":["dbo.Categories","dbo.Customers"],"Web_Env":["dbo.ADS_ASSOCIATIONS","dbo.ADS_FORM"]}}
public java.lang.String syncLineageData(java.lang.String userName, java.lang.String password)
userName
- - Stringpassword
- - Stringpublic java.lang.String resetLineageData(java.lang.String userName, java.lang.String password)
userName
- - Stringpassword
- - String