Core Connector Worker in Workday HCM | ZaranTech
"Uh Workday connectors, integration building blocks, core connectors, what are they launching an integration system? What are the change detection? What are the transaction logs and integration sequence generator? We are going to touch these things."— Workday 连接器、集成构件、核心连接器是什么、怎么启动集成系统、什么是变更检测、事务日志和集成序列生成器——这些我们都要讲到。
"When it's come to the Workday connectors, we are going to configure the service attributes, services, maps, and transaction logs. And Workday defines the rules and how they are going to extract it."— 讲到 Workday 连接器时,我们要配的是服务属性、服务、映射和事务日志;规则和怎么取数是 Workday 定好的。
"First scenario is we have a new hire. Second, we have a change of manager. Third, we have a promotion where a person has a new position. Fourth, we have a salary change."— 第一个场景是新员工,第二个是换经理,第三个是晋升到一个新职位,第四个是调薪。
"If your end party does not want a Workday standard output, we can transform for them. Here it we can use document transformation, we can use Workday Studio or we can use any middleware platform."— 如果对方系统不要 Workday 的标准输出,我们可以替它转:可以用文档转换、用 Workday Studio,或者用任何中间件平台。
"We may deliver uh files from one to any number of uh uh target system, but the best is like restricted to three or less transformations. Uh like we That is recommended to use uh document transformation for three transformation, not more than that."— 一个文件可以发给任意多个目标系统,但最好限制在三层转换以内;文档转换用到三层为止,再多就不建议了。
"when we say end-to-end connector, it means that everything from business function, everything are configured automatically. We just need to configure it, and there is no coding added in it."— 所谓端到端连接器,就是从业务功能往下都已经自动配好了,我们只需要做配置,里面不用加代码。
"An integration template is a is a collection of integration services that enables communication between Workday and the third-party system or external system."— 集成模板就是一组集成服务的集合,用来打通 Workday 和第三方系统、或外部系统之间的通信。
"That's the naming convention I use. Uh it is always depends on your company which naming convention they use. In most of the companies, they use INT001 or something like with their IDs."— 这是我用的命名规范;具体要看公司习惯,多数公司会用 INT001 这类带编号的写法。
"Services have a launch parameter, integration configurations, data section, sequence generator, mapping, and document retention."— 服务里包含启动参数、集成配置、数据段、序列生成器、映射和文档保留这几块。
"Default is three characters, but few uh few of the vendors, they want just two characters. Normally, private address is hidden and it's not available. But, if you need the private address to be enabled, you have to select it by by force."— 默认是三位国家码,但有供应商只要两位;私密地址默认是隐藏的、拿不到,要输出就必须强制勾开。
"what fields are available in core connector worker are these fields: location, location name, country, address line, regions, and all these things. And with each field, there's a description available."— 核心连接器里能用的字段就是这些:location、location name、country、address line、region 之类,每个字段都带一段说明。(注:此处口播说 worker,画面其实是 Location 连接器的字段页)
"This core connector location will able to extract location from Workday. And send it to the third party."— 这个核心连接器 Location 能从 Workday 抽出地点数据,然后发给第三方。
"If you select on the full extract this file, this means that it will pick all the changes, everything not all the changes, it will pick the the current snapshot for the whole data. It will pick everything which is in Workday."— 勾了 Full Extract,意思就是把当前整份数据的快照都取出来,不是只取变化,Workday 里有什么就出什么。
"We have always a person who is initiated this uh integration. We have the name of that person. We have a person who ran this ran as this like normally. This is not Logan McNeely. It will be a some integration user."— 总有一个发起集成的人,页面上会留名字;还有以谁的身份跑这一栏——正常情况下那不该是 Logan,而应该是某个集成用户。
"This information for all the the connector, no matter which connector you are going to use, it has this header tag. Header tag informs us few things."— 不管你用哪个连接器,输出里一定会有这个 header 标签,它会告诉你几件事。
"This is specifically one location has always this one area. There will be no way that they have a multiple uh one location has a multiple information. This will be always one-to-one. And then their address, they may have more than one address. So, this column or this header will repeat."— 一个地点的主体信息永远只有一份,不可能一对多;但地址可能有多个,所以这个地址块会重复出现。
"If you remember in when we ran the integration first time, this information was empty. The last successful entry moment and the effective date. Now this is auto populated."— 还记得第一次跑的时候这两个格子是空的吗——上次成功的 entry moment 和 effective date,现在系统已经自动填好了。
"did you realize that we have a prior values, too? It is an attribute. ... And if it is empty, it means that it's a new uh location. It created in this area."— 你发现输出里也带了 prior value 吗?它是个属性;如果为空,就说明这条地点是这次新建的。
"So, for now, we are using ISO three, right? Three digits country code. So, if I change it to ISO two, my output will change. ... it's more like a uh configurations mapping. Like we are transforming data as per uh vendor requirement or the third-party system requirement."— 现在我们用的是 ISO 三位国家码,我改成两位,输出就会变。这更像配置层面的映射:按供应商要求改写法,但不算真正的转换。
"So, normally we mention with the with the same name of integration where it's used along with the name user. We enter anything, it doesn't matter. It does not require new password to sign in and do not allow user interface sessions."— 命名一般跟它服务的集成同名、再加 user 后缀;关键是勾上登录时不需要改密码,并且不允许界面会话。
"See, it fails. Now, if you look at the the error message, the following expected error and the error is the task submitted is not authorized. That means the user is not authorized."— 看,跑失败了。打开错误信息,是意料之中的那条:the task submitted is not authorized,意思是这个用户没被授权。
"Remember you are you probably you have been working on the report and task area. So in case of integrations, we need to use this integration permission. Not on location and task, but towards this area."— 你们以前做报表和任务用的是那套权限;做集成得用这个 integration permission,不是 location、也不是 task。
"Now I have to activate the security policies. So I am going to enable integration user for the location security group. And it I provide access for the view for the location and manage locations."— 现在得激活安全策略:给 location 安全组启用集成用户,开的是 Location 的查看权和 Manage Locations。
"And if you see, it is in the green color. Green color means new or addition. If it is yellow, it means change. If it is red, it means deletion."— 你看它是绿色的:绿色代表新增;如果是黄色就是改动,红色就是删除。
"you go on the integration systems and integration events. Click here. And okay, and you will find all the integration events ran till today. So, for any operational activities, you may need to use this integration events more often."— 到 integration systems 里点 integration events,就能看到今天为止跑过的所有集成事件;做运维时用得最多的就是它。
"The thing is like this is what I'm hard coding it. It does not make sense for uh, schedule integration, right? So, I need to use a determined value at run time. I want to to set some data and parameter at run time."— 我这样是把它硬编码了,对排程跑的集成来说没意义;所以要用 Determine Value at Runtime,让参数在跑的时候再算。
"I'm not sure about others for for now for few minutes so I'll just keep only three enabled for now. And then I will enable all and I will show you what happens then."— 其他几项我现在不确定,先只开这三项;然后我全打开,给你看会发生什么。
"As soon as I completed this this shows an error and error means there are some mandatory parameters which I have I haven't make it as enabled on the launch parameters."— 我一保存就报错,意思是 launch parameters 里有几个强制项我没启用、没给值。
"You can click include all fields output in uh, include all fields in output. Or if you know what you are actually looking for, you can only enable those things. Required fields are means that if this field does not exist in output, it will fail."— 可以点 include all fields in output 一把全开;清楚自己要什么就只勾那些。勾了 Required Field 就意味着:输出里缺这个字段,集成会直接失败。
"In position section, I will just add effective date for now. ... To make it simple and make it more clear, I will just use these four areas only."— position 段我先只加 effective date。为了简单清楚,就只用这四个区块。
"And this is a mandatory field. And for now, I'm just mentioning it any is true. Or just true. So, whatever is there, it will come. This will pick all the information from Workday."— 这是个强制字段。我现在先随便给一个 Is True,那样有什么就出什么,等于把 Workday 里的信息全取出来。
"someone has added the middle name with the yellow with the green color. Someone changed the first name and it's a yellow color."— 有人新增了 middle name,显示成绿色;有人改了 first name,就是黄色。
"It's a bigger file. It's like if you see that uh there are 31 employees, but the data is quite high. And if If see uh on the top, it's always like a header. And then the worker information."— 这个文件大得多:31 名员工,但数据量相当高。顶上永远是一段 header,然后才是 worker 信息。
"In all of the in in the different sections, like a position, uh status section, uh in the compensation or allowance section, you will always find one tag with operation. Operation tag will tell us that either it's a change, it's a modification, it's a new or not."— 在 position、status、compensation 或 allowance 这些不同的段里,你都会看到一个 operation 标签,它告诉你这条是变化、修改、新增,还是没有变化。