Skip navigation
All People > TMACUL > Tiago MACUL's Blog > 2015 > September




CA API Management Drives Digital Transformation by Connecting Retailer Systems to Build Growth in the Application Economy; Cuts Implementation Time by 42 Percent





NEW YORK, Sep 28, 2015 (BUSINESS WIRE) -- CA Technologies CA, +1.75%announced that IceMobile, the leading global loyalty agency and division of Alliance Data, is using CA API Management to integrate real-time transactional data and customer relationship management (CRM) and point of sale (POS) systems with the IceMobile Bright Loyalty Platform which delivers instant, personalized mobile offers to the customer’s mobile device. This integration puts the technical infrastructure in place for IceMobile retail customers to connect with the Bright Loyalty platform and put data analytics to use to increase shopper engagement and customer loyalty.

“With CA API Management, we completely transformed how we connect to our retailers. We eliminated the need to develop and test custom software and have cut the implementation time from 14 weeks to eight weeks,” said Sander van Duijin, director of Sales at IceMobile. “The CA API solutions make our end-to-end offering more scalable which enables us to connect more costumers to our Bright Loyalty Platform.”

IceMobile recognized it could improve its customers’ loyalty programs, drive more meaningful consumer engagement and increase share of wallet by connecting to the rich data siloed in the retailer’s legacy IT systems. The challenge was to make the connection with minimal effort and disruption on the customers’ IT systems and staff; CA API Management was the answer. IceMobile worked with CA’s local integration partner Enable-U to kick start the first implementation of CA API Management on a retailer site.


“APIs are the building blocks of digital transformation. For IceMobile, our API management solutions helped them integrate multiple customer data sources. This data consolidation enabled IceMobile to build stronger, more meaningful multi-channel engagement for its customers,” said Rahim Bhatia, senior vice president, API Management, CA Technologies. “This positions IceMobile and its customers for success in application economy.”

About IceMobile

IceMobile’s mission is to add emotion to transactional loyalty, which they uniquely focus on food retail. IceMobile stands out by creating magic at the intersection of creativity and technology and data. By combining data and digital to deliver personalized mobile experiences, they boost revenue, increase customer loyalty and reach new costumers for retailers worldwide. More information

About CA Technologies

CA Technologies CA, +1.75% creates software that fuels transformation for companies and enables them to seize the opportunities of the application economy. Software is at the heart of every business in every industry. From planning, to development, to management and security, CA is working with companies worldwide to change the way we live, transact, and communicate – across mobile, private and public cloud, distributed and mainframe environments. Learn more at

Follow CA Technologies

Social Media Page
Press Releases

Legal Notices

Copyright © 2015 CA, Inc. All Rights Reserved. All trademarks, trade names, service marks, and logos referenced herein belong to their respective companies. The content provided in this document is for informational purposes only and does not form a warranty of any kind. Actual results may vary depending on the size and complexity of a user’s technical environment.


View source version on

SOURCE: CA Technologies

CA Technologies
Leanne Agurkis
Mobile: (407) 620-2136

Requirement: Create a request, change Order and Contact through Web Services

Scripting- VB

Step1: Create a web reference in the front end.

Start the front end.
Go to Website menu and click “Add web reference”.
In the URL box provide the web service URL and click go.http://:8080/axis/services/USD_R11_WebService?wsdl”’
We can find the methods being pulled out.
Add the webreference with the name “WebReference”.

Lendo retorno XML Retorno WebService – Read return XML doselect
”’ <summary>
”’ Leitura do XML de retorno do WebService do CA-USD, Criado por Tiago MACUL 02/2008
”’ </summary>
Private Function LerXMLca(ByVal strXML As String) As Data.DataRow

‘ Proc que procura no xml por determinado objetos , passando pra respectivas variaveis
Dim ds As Data.DataSet
Dim dt As New System.Data.DataTable
Dim dr As System.Data.DataRow

dr = dt.NewRow
ds = FnStrXmlToDataset(strXML)


Dim sNome As String = “”
Dim intTables As Integer
Dim intRows As Integer = 0

For intTables = 0 To ds.Tables.Count – 1

Select Case ds.Tables(intTables).TableName
Case “UDSObject”
dr(“Handle”) = ds.Tables(0).Rows(0).Item(0)
Case “Attribute”
For intRows = 0 To ds.Tables(intTables).Rows.Count – 1
sNome = ds.Tables(intTables).Rows(intRows).Item(“AttrName”)
dr(sNome) = ds.Tables(intTables).Rows(intRows).Item(“AttrValue”)
End Select
Return dr
End Function

CRIANDO UM NOVO REQUEST, Problem or Incident
‘txtcategoria.Text == objeto criado na tela ex :pcat:5103
‘Tipo = attrVal += {“type”, “crt:182”} (page 50)
‘crt:180 = Request;
‘crt:181 = Problem available only with the ITIL installation;
‘crt:182 = Incident available only with the ITIL installation

‘Insert group = group_id
‘{“group”, “cnt:7558700F85FB2143B03D306D3CEF904D”}

Dim usd As New localhost.USD_WebService
‘usd.Url =
Dim Sid As Integer
Dim Result As String = “”
Dim attr(20) As String
Dim username, password As String
Dim resposta As String
Dim type As String
Dim category As String
Dim description As String

username = txtuser.Text ‘ServiceDesk
password = txtsenha.Text ‘ServiceDesk
type = txttype.Text
category = txtcategoria.Text
description = txtdescricao.Text

Sid = usd.login(username, password)

Dim userhandle As String
userhandle = usd.getHandleForUserid(Sid, username)

Dim attrVal(10), attr2(1), prop(1)
Dim requestHandle, requestNumber As String
attrVal = New String() {“customer”, userhandle, “category”, category, “description”, description, “type”, “crt:182”, “zrepmeth”, “400001”, “group”, “cnt:7558700F85FB2143B03D306D3CEF904D”}
prop = New String() {}
attr2 = New String() {}
requestHandle = “”
requestNumber = “”

usd.createRequest(Sid, userhandle, attrVal, prop, “”, attr2, requestHandle, requestNumber)
resposta = “Executado com Sucesso ! requestHandle = ” & requestHandle & ” requestNumber = ” & requestNumber
Catch ex As Exception
resposta = Err.Number.ToString & ” – ” & Err.Description & ” – ” & ex.Message
End Try
txtResposta.Text = resposta

Criando novo registro – Create new row in Custom Table
Dessa mesma maneira é possível acessar outros objetos

Dim USD As New localhost.USD_WebService ‘Referência do WebService do CA USD
Sid = USD.login(User, pass) ‘Login no USD, pega session ID
userHandle = USD.getHandleForUserid(Sid, User)

Dim updateFailArray(9) As String
Dim Attributes(1) As String
Dim ObjResult As String = “”
Dim ticket_handle As String = “” ‘Referência do objeto que será criado

‘Atribuição dos valores para atualização da tabela
updateFailArray(0) = “campo1”
updateFailArray(1) = “Valor1”
updateFailArray(2) = “campo2”
updateFailArray(3) = “valor2”
updateFailArray(4) = “campo3”
updateFailArray(5) = “valor3”

USD.createObject(Sid, “zcustom_table”, updateFailArray, Attributes, ObjResult, ticket_handle)

Atualizando um Objeto – Update object

Dim USD As New localhost.USD_WebService ‘Referência do WebService do CA USD
Sid = USD.login(User, pass) ‘Login no USD, pega session ID
Dim updateArray3(14) As String ‘
Dim updateArray4(14) As String
Dim ticket_handle As String = “” ‘Referência do objeto que será alterado
updateArray3(0) = “zmax_num”
updateArray3(1) = “1”
updateArray3(2) = “summary”
updateArray3(3) = “titulo do chamado”
USD.updateObject(Sid, ticket_handle, updateArray3, updateArray4)

Fechando um chamado

Dim USD As New localhost.USD_WebService ‘Referência do WebService do CA USD
Sid = USD.login(User, pass) ‘Login no USD, pega session ID
Dim ticket_handle As String = “cr:1001” USD.closeTicket(Sid, “ticket fechado”, ticket_handle)

Anexo URL

Dim USD As New localhost.USD_WebService ‘Referência do WebService do CA USD
Sid = USD.login(User, pass) ‘Login no USD, pega session ID
USD.attachURLLink(Sid, 0, “URL”, “URLName”, “Descrição”)

Anexo URL

Dim updateAttach(14) As String
Dim updateAttach2(1) As String
Dim objResultAttach As String = “”
Dim newHandleAttach As String = “”


updateAttach(0) = “description”
updateAttach(1) = docUrl
updateAttach(2) = “orig_file_name”
updateAttach(3) = docUrl
updateAttach(4) = “attmnt_name”
updateAttach(5) = “nome do anexo”
updateAttach(6) = “attmnt_name”
updateAttach(7) = “LINK_ONLY”

USD.createObject(Sid, “attmnt”, updateAttach, updateAttach2, objResultAttach, newHandleAttach)

Catch ex As Exception

End Try

Link Anexo URL

Dim objs(0) As String
objs(0) = newHandleAttach ‘ “attmnt:400014”
usd.createLrelRelationships(Sid, “cr:400001”, “attachments”, objs)
Catch ex As Exception
TextBox1.Text = ex.Message & ” – ” & Err.Number & ” – ” & Err.Description
End Try

Criando LOGs

Dim USD As New localhost.USD_WebService ‘Referência do WebService do CA USD
Sid = USD.login(User, pass) ‘Login no USD, pega session ID
USD.createActivityLog(Sid, creator, ticket_handle, strWklgDesc, logType, 0, False)

Lendo Relacionamentos – LRel

Dim usd As New localhost.USD_WebService
Dim Sid As Integer
Dim Result As String = “”
Dim attr(20) As String
Sid = usd.login(“ServiceDesk”, “ServiceDesk”)
Result = usd.getLrelValues(Sid, “chg:400001”, “asset”, 0, -1, attr)
Catch ex As Exception
MsgBox(Err.Number.ToString & ” – ” & ex.Message)
End Try

factory names ::. See page 40
Object NameFactory NameTable Name DB


Post Original

Trabalhando com o WebService do SDM – Tiago Macul



Saiba mais:

Web Services Best Practices for CA Service Desk Manager (CA SDM)

CA Service Desk

Como apagar um campo no CASDM – Delete Field  – Tiago Macul



Title: How to remove a customized field from Unicenter Service Desk and the MDB


O programa de publicação é o:C:\Program Files (x86)\CA\Service Desk Manager\


Processo de publicação de personalizações


  • wsp_schema.sch -
    • Contém todas as tabelas e colunas criadas/administradas pelo WSP (Pintor de Tela Web).
  • wsp_index.sch
    • Índices administrados pelo WSP.
  • wsp.altertbl
    • Novas tabelas criadas que ainda não foram publicadas, isto é, ainda não constam no Banco de Dados.
    • Todas as publicações são armazenadas neste arquivo e são descartadas suas informações após a publicação e recriadas em novas publicações, ou seja, sempre haverá uma perda do arquivo após concluído o processo.
  • wsp.altercol
    • Novas colunas criadas que ainda não foram publicadas no banco de dados

             Segue o seguinte formato:




#                    ADD   yyy

#                    ADD   zzz

#                    END


               Onde *** é uma tabela e yyy e zzz são colunas, podem existir N quantidades de tabelas e colunas até que finalize em END

  • tblobj.cfg
    • Todas as tabelas do CA Service Desk, armazena respectivamente o nome do objeto e da tabela no banco de dados.
  • ddict.sch
    • Todas os objetos tabelas e colunas



A publicação utiliza as variáveis de ambiente:

  • $NX_ROOT




O Processo para apagar:

Os seguintes passos descrevem como apagar um campo ou uma tabela da base de dados MDB.

OBS: Salve os arquivos antes de executar o procedimento.


  • Apague o  campo (que quer deletar) do arquivo wsp_schema.sch localizado em:


          normalmente o local completo é:

                    C:\Program Files (x86)\CA\Service Desk Manager\site\mods\majic\wsp_schema.sch


  • Apague o campo do arquivo wsp.mods localizado em:




  • Remova a linha do arquivo ddict.sch:

          %NX_ROOT%service desk\site\ddict.sch


Run the relevant xxxbuild against the relevant table ==> acces file directory and run sqlbuild -p [table] [database]

Warning: Make sure to backup the data in this table prior to rebuilding.


  • Pare o Serviço do Service Desk (pdm_halt)
  • Inicie o Serviço do Service Desk (net start "CA Service Desk Manager Servidor")
  • Rode o comando pdm_wspupd
    • A linha do campo é excluído do wspcol
  • Pare o Serviço do Service Desk (pdm_halt)
  • Remova  a linha correspondente da publicação do arquivo de log wsp_schema.log


  • Rode o comando pdm_publish


Talvez seja necessário apagar os registros das seguintes tabelas:

  • Colunas
    • delete wspcol where table_name = [table] and column_name = [column]
  • Tabelas
    • delete wsptbl
    • delete wspcol


Verifique também os seguintes arquivos:


  • \\…\service desk\site\tblobj.cfg
  • wsp.altercol
  • wsp.altertbl
  • wsp_index.sch


E SE....

nada funcionar, a última solução é remover todas as personalizações criadas para isso remova toda a pasta site/mods





Como modificar o esquema usando o Pintor de tela da web - CA Service Management - 14.1 - Portuguese - Brazil - CA Techno…


AHD04400:Erro de argumento

Posted by TMACUL Champion Sep 24, 2015

Working Mother

Posted by TMACUL Champion Sep 23, 2015

CA Technologies | Working Mother


What We Love

CA Technologies

Leaders at this IT management software and solutions company have a natural level of comfort with modern technology, which plays to employees’ advantage when it comes to on-the-job flexibility. At least 30% of the workforce here formally telecommutes or works from home full-time, using systems that allow access to office computers, phones and files from afar. Should parents have a child who is unwell, they can take up to eight paid illness days off to look after him or her. On-site sick, nap and lactation rooms along with unlimited vacation time grant employees relief. In a recent internal survey, 93% of female respondents said management supports work life balance.

CEO Michael Gregoire

VP, HR Beth Conway

CA Technologies Named to 2015 Working Mother 100 Best Companies - MarketWatch

CA Technologies Named to 2015 Working Mother 100 Best Companies | Business Wire


NEW YORK, Sep 22, 2015 (BUSINESS WIRE) -- Working Mother magazine today named CA Technologies CA, -1.92% as one of the 2015 Working Mother 100 Best Companies for its commitment to progressive workplace programs, including advancement of women, flexibility, child care and paid parental leave. The 100 Best Companies are featured in the October/November issue of Working Mother and

“Once again, CA is honored to be recognized by Working Mother as one of their 100 Best Companies,” said Beth Conway, vice president, Human Resources, CA Technologies. “We support our working parents in achieving work-life integration through our progressive workplace programs and promote a corporate culture that fosters empowerment, growth and innovation. By delivering comprehensive programs and benefits to meet the needs of our employees and their families, we can help drive a happier and more loyal employee base – which drives success for everyone.”

CA Technologies offers a wide-array of work-life options including a robust parental leave program with automatic phase back to work; private, on-site nursing rooms for new moms; a Healthy Pregnancies, Healthy Babies maternity program for moms to be; subsidized onsite Montessori-certified Children’s Centers; adoption assistance; flexible work schedules and telecommuting.



Jennifer Owens, editorial director of Working Mother Media, says, “Thirty years is an important milestone and we are happy to honor it. But we know, too, that the road ahead to truly supportive workplaces for all employees remains long. Today, more than 2 million people work at a Best Company but that’s a drop in the bucket when you consider that our nation is home to 24 million working mothers—70 percent of moms with kids under age 18 are employed.”

Subha Barry, vice president, general manager, Working Mother Media, says, “As we celebrate the 30th anniversary of Working Mother’s 100 Best Companies, we are keen to recognize leaders who have built initiatives that truly support all employees. They are the vanguard of successful companies, with policies that matter to American families.”

The complete list of Working Mother’s 2015 100 Best Companies can be found here.

About Working Mother Media

Working Mother Media (WMM), a division of Bonnier Corporation (, publishes Working Mother magazine and its companion website, The Working Mother Research Institute (, the National Association for Female Executives ( and Diversity Best Practices ( are also units within WMM. WMM’s mission is to serve as a champion of culture change. Working Mother magazine is the only national magazine for career-committed mothers. Follow us on Facebook, Twitter, LinkedIn and Pinterest.

About CA Technologies

CA Technologies CA, -1.92% creates software that fuels transformation for companies and enables them to seize the opportunities of the application economy. Software is at the heart of every business in every industry. From planning, to development, to management and security, CA is working with companies worldwide to change the way we live, transact, and communicate – across mobile, private and public cloud, distributed and mainframe environments. Learn more at

Follow CA Technologies

Legal Notices

Copyright © 2015 CA, Inc. All Rights Reserved. All trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.


View source version on

SOURCE: CA Technologies

CA Technologies
Rita O’Brien, 631-342-6687
Working Mother
Andrea Kaplan, 917-836-2741

I cannot see group members on ticket, what can i do?


When: I select my group and i´ll try to select analyst, i cannot found it?


solution: access contact information and update contact_type to analyst.

Do you need select CA Service Desk group member´s?


Maybe, this SQL command can be helps.



select grp.last_name as group_name, cnt.last_name, grpmem.manager_flag, grpmem.notify_flag

from mdb..grpmem

inner join mdb..ca_contact as grp on grpmem.group_id = grp.contact_uuid

inner join mdb..ca_contact as cnt on grpmem.member = cnt.contact_uuid

On projects sometimes is need optimizations (custom), normally is received information a little different would must be, can be duplicate, blank or simply formatted on UPPER CASE and for this case we can turn it to lower using this MS SQL function (oracle native).


UPPER CASE  ==(turn)==> Upper Case

TIAGO MACUL ==(turn)==> Tiago Macul




alter FUNCTION dbo.[InitCap] ( @InputString varchar(8000) )






DECLARE @counter          INT

DECLARE @CharTemp          CHAR(1)

DECLARE @PrevChar      CHAR(1)

DECLARE @OutputString  VARCHAR(255)



SET @OutputString = LOWER(@InputString) --left everthing lower

SET @counter = 1 --starting counter



--loop one by one characters, do it until max lenght from input string

WHILE @counter <= LEN(@InputString)


  --loading temporary variable

    SET @CharTemp    = SUBSTRING(@InputString, @counter, 1)


    --previous character, if first it´s empty

    SET @PrevChar = CASE WHEN @counter = 1 THEN ' '

                        ELSE SUBSTRING(@InputString, @counter - 1, 1)




  --looking for special characters where cannot be upper

    IF @PrevChar IN (' ', ';', ':', '!', '?', ',', '.', '_', '-', '/', '&', '''', '(')


        IF @PrevChar != '''' OR UPPER(@CharTemp) != 'S'

  --STUFF function inserts a string into another string, it´ll replace first upper

            SET @OutputString = STUFF(@OutputString, @counter, 1, UPPER(@CharTemp))




    SET @counter = @counter + 1




RETURN @OutputString






The first thing what you need know: VERY Important! Using pdm_load can be destructive so always back up your database before you perform a pdm_load, and use pdm_userload unless instructed to use pdm_load.


Important! Make a backup copy of the database before running pdm_load with this option. After old database records are removed, you must restore the CA SDM database with this backup copy if you want to recover any deleted records, use pdm_extract for this procedure.

Looking for results

select last_name, dbo.InitCap(last_name)

from mdb..ca_contact


How to use it:


select '{"' + userid + '","' +  dbo.InitCap(last_name)  + '"}'

from mdb..ca_contact

where userid is not null


build one text archive inserting on top - mycontacts.txt

TABLE ca_contact

userid last_name


pdm_load -u -f mycontacts.txt




update  mdb..ca_contact

set last_name =dbo.InitCap(last_name)

Com toda a estrutura pronta, preparada, SDM e EEM instalados a configuração de administradores, analistas e usuários que é toda pronta por padrão de fábrica na solução CA Service Desk.


Obtém-se por padrão da solução alguns tipos de acesso sendo:  administrador, analista e usuário.


Possibilita a validação da credencial de acesso:


Sem acesso

Nega acesso a produtos CA, a menos que a autenticação externa seja permitida e válida.


O acesso aos produtos CA sempre é permitido, sem necessidade de autenticação adicional.


O acesso aos produtos CA é permitido por meio do nome de usuário e da senha do sistema operacional.

PIN/Número de PIN

Os usuários desse tipo podem acessar apenas se informarem o valor correto no campo PIN do seu registro de contato. Se você selecionar a opção PIN, poderá escolher qual campo no registro de contato armazena o PIN, digitando o nome de atributo do campo na caixa de edição do Campo do PIN.


O acesso aos produtos CA é permitido pelo CA EEM. Essa opção só está disponível se o CA SDM estiver integrado ao CA EEM.


Estas configurações de tipo de acesso são realizadas no seguinte caminho: Administração Gerenciamento da segurança e das funçõesTipos de acessoCriar um tipo de acessoConfigurar autenticação pela web para um tipo de acesso



Portanto (como exemplo) pode-se definir:






Configurando CA EEM - Brazilian Portuguese

Access Type - acctyp - Brazilian Portuguese

Configurar autenticação para um tipo de acesso

Partição de dados


1. Logue no CA Service Desk como administrador
2.Clique na ABA Administração
3. Clique em Service Desk
4. Clique em Dados de aplicativos
5. Clique em Códigos
6. Clique em Departamentos
7. Clique em Criar
8. Preencha as informações
9. Clique em Salvar



Create a Department

From: CA Technologies Releases Latest Sustainability Report – Press Releases on


CA Technologies Releases Latest Sustainability Report

Integrates Principles of the United Nations Global Compact and meets GRI G4 Guidelines

Submitted by:CA Technologies

Categories:Sustainability, Technology

Posted:Sep 08, 2015 – 09:00 AM EST



NEW YORK, Sep. 08 /CSRwire/ - CA Technologies (NASDAQ:CA) today released its latestsustainability report, outlining how the company is furthering its corporate social responsibility (CSR) efforts. The report was drafted in accordance with the Global Reporting Initiative (GRI) G4 Core guidelines and incorporates the Ten Principles of the UN Global Compact.

At CA Technologies, sustainability begins with a strong value system and a principled approach to doing business. This means operating in ways that meet fundamental responsibilities in the areas of human rights, labor, environment and anti-corruption. By incorporating the Global Compact principles into its CSR strategies, policies and procedures, CA has established a culture of integrity and set the stage for long-term success.

“We live in an application economy. With more than 180 billion app downloads expected in 2015, these solutions are rapidly reshaping how we live and work. Face-to-face communication with a brand is giving way to interactions through our devices. This new world needs, and people increasingly expect, products that are built with sustainability in mind,” says Erica Christensen, vice president, Corporate Social Responsibility, CA Technologies. “CA continues to pursue new discoveries that advance sustainability for the company, our customers and the communities we serve.”

Report highlights include:

  • Green Building/Leases—In 2014, CA increased its green office space by 55,000 square feet, totaling 470,000 square feet since 2012.
  • Operational Efficiency—Operational improvements, including lighting reductions, smart-spacing facilities and implementing efficiencies in data centers, have enabled CA to reduce its GHG emissions by 7.7 percent in 2014.
  • External Recognition—CA was named to the World and North America Dow Jones Sustainability Indexes, as well as to the 2014 Global Compact 100 Index, a global stock index that combines corporate performance on environmental, social and governance issues with a requirement for consistent baseline profitability.
  • EPA ENERGY STAR®—CA’s Framingham, MA and Islandia, NY, facilities were awarded the U.S. Environmental Protection Agency (EPA) ENERGY STAR certification for their efforts to reduce energy consumption, improve energy security and reduce pollution by promoting products and maintaining buildings that meet the highest energy-efficiency standards.
  • Employees Giving Back—In FY2015, the company matched more than $1.3 million in employee donations to more than 1,500 nonprofits. In addition to CA Together in Action, the company’s worldwide employee volunteer month in October, and an annual Green Week of activities in April to celebrate Earth Day, employees are able to use up to three workdays each year to give back.
  • Inclusion and Diversity—CA’s THRIVE program helps create an inclusive and flexible workplace by attracting, nurturing and retaining a diverse workforce. In the company’s most recent Employee Opinion Survey, 87 percent of respondents said CA fosters an environment where people with diverse backgrounds can succeed.
  • STEM Education—CA supports science, technology, engineering and math (STEM) programs tailored to different grade levels and age groups, helping to build the STEM pipeline at every age of schooling. This includes partnerships with Boys & Girls Clubs of America, Citizen Schools,, IT-oLogy and PENCIL, which are encouraging Pre-K–12 students to discover an interest in technology education and careers. CA also supports post–high school programs through partnerships with the Anita Borg Institute for Women and Technology, NPower and Year Up, and works with the Clinton Global Initiative, Change the Equation and 100Kin10 to engage with others focused on the advancement of STEM learning.
  • Stakeholder Engagement—CA continues to be involved with the UN Global Compact, Ceres and its advocacy coalition, BICEP (Business for Innovative Climate & Energy Policy). Both the UN Global Compact and Ceres enable CA to increase its interactions with a network of companies, investors, environmental organizations, public interest groups and governments that seek to address sustainability challenges.

About CA TechnologiesCA Technologies (NASDAQ:CA) creates software that fuels transformation for companies and enables them to seize the opportunities of the application economy. Software is at the heart of every business in every industry. From planning, to development, to management and security, CA is working with companies worldwide to change the way we live, transact and communicate—across mobile, private and public cloud, and distributed and mainframe environments. Learn more at CA Technologies

Encontrou este erro?   - Do you found this error using pdm_load?  

"dbload 9964 FATAL tokfile.c 537  Invalid character encountered in input"

Como Resolver? Salve como UTF-8   / How to solve? File.. Save as... UTF-8



Acess o original em:,780909,CA_Technologies_tem_nova_lideranca_para_area_de_Produtos,780909,5.htm


Ayman Sayed, ex-Cisco, é o novo Chief Product Officer da companhia

A CA Technologies anuncia a contratação de Ayman Sayed como Chief Product Officer (CPO) da companhia. Sayed ficará baseado em Santa Clara, na Califórnia, e responderá diretamente ao presidente global da CA, Mike Gregoire. Entre suas atribuições está a estruturação de um portfólio ainda mais inovador e focado nas necessidades de negócios trazidas pela Economia dos Aplicativos, tendência global em que as pessoas fazem todo o possível por meio de apps.

“Ayman é um talentoso executivo de Tecnologia, com uma grande visão. Ele construiu softwares de classe mundial para o desenvolvimento de organizações, operados globalmente e em escala”, diz Gregoire. “Focado na excelência do produto, Sayed irá construir com a CA um portfólio diferenciado para ajudar nossos clientes a vencerem os mais difíceis desafios de negócios que surgem com a Economia dos Aplicativos. Estou feliz de tê-lo a bordo. ”

Sayed trabalhou na Cisco por 16 anos, tendo ocupado posições de liderança nos principais projetos da companhia. Foi vice-presidente de Tecnologia para Sistemas Operacionais de Rede, quando supervisionou 2.500 engenheiros e liderou o desenvolvimento do software que opera a rede na qual quase todos os produtos da empresa funcionam.

Ele ajudou a Cisco a ser pioneira em redes programáveis e conduziu uma inovação ampla do software de operação de rede, que permitiu a evolução da rede inteligente para apoiar o conhecimento sobre as aplicações e a Internet das Coisas. Sayed liderou uma transformação da empresa rumo à adoção de metodologia Ágil de desenvolvimento.

Formado em Engenharia Elétrica pela Universidade do Cairo, o executivo tem mais de 25 anos de experiência em gerenciar organizações de software de alta performance. Ele foi diretor de engenharia na Plaintree Systems, onde liderou os times de engenharia e de desenvolvimento.

“Estou muito animado por me juntar à CA, com sua rica história e forte tradição de excelência em softwares”, diz Sayed. “Serei parceiro dos excelentes engenheiros da companhia para inovar e entregar soluções para empresas que transformem negócios na Economia dos Aplicativos. ”

Sobre a CA Technologies

CA Technologies (NASDAQ: CA) cria softwares que potencializam a transformação das empresas e lhes permite aproveitar as oportunidades da economia dos aplicativos. Software está no centro de todas as empresas em todos os setores. Do planejamento ao desenvolvimento, da gestão à segurança, a CA Technologies trabalha com empresas em todo o mundo para mudar a maneira como vivemos, compramos, vendemos e nos comunicamos – por meio da nuvem (privada e pública), de plataformas móveis e de ambientes de TI, dos distribuídos ao mainframe. Saiba mais em

Contatos CA Technologies para a imprensa

CA Technologies
Débora Lima –

Zeno Group | 11 3146.0977
Eduardo Gaggini –
Carolina Freitas –
Claudia Daré –

English version: CA SDM Loading contacts pdm_load


É de extrema importância ter ciência que utilizar os comandos pdm_load e pdm_userload podem destruir sua base de dados, para mitigar este risco, faça sempre um backup anter de qualquer alteração, utilize o pdm_extract..



Tabela do banco de dados

select * from ca_contact




Comando de BACKUP
pdm_extract ca_contact > ca_contact.txt



2. Extrutura da table


bop_sinfo -dq cnt

Factory cnt < ca_contact, usp_contact >


  id <contact_uuid>    UUID UNIQUE

  producer_id          LOCAL STRING(20)

  persistent_id        LOCAL STRING(60)

  supervisor_contact_uuid SREL ->

  last_mod_dt last_update_date DATE

  creation_date        DATE

  last_name            STRING(100) REQUIRED SKEY

  first_name          STRING(100) SKEY

  middle_name          STRING(100) SKEY

  alias                STRING(30)

  delete_flag inactive SREL -> actbool.enum REQUIRED

  version_number      INTEGER

  last_mod_by last_update_user STRING(64)

  creation_user        STRING(64)

  exclude_registration INTEGER

  delete_time          DATE

  userid              STRING(100)

  phone_number pri_phone_number STRING(40)

  alt_phone alt_phone_number STRING(40)

  mobile_phone mobile_phone_number STRING(40)

  type contact_type    SREL ->

  billing_code cost_center SREL ->

  location location_uuid SREL ->

  dept department      SREL ->

  organization organization_uuid SREL ->

  admin_org admin_organization_uuid SREL ->

  company company_uuid SREL ->

  notes comment<comments> STRING(255)

  fax_phone fax_number STRING(40)

  beeper_phone pager_number STRING(40)

  email_address        STRING(120)

  pemail_address pager_email_address STRING(120)

  room_location        STRING(30)

  contact_num alternate_identifier STRING(30)

  position job_title  SREL ->

  tenant_group        SREL ->

  cenv                BREL <- lrel_cenv_cntref.cnt (LREL nr) {cnt = ?}

  cntntf              BREL <- lrel_notify_list_cntntf.cnt (LREL cr) {cnt = ?}

  service_locs        BREL <- lrel_svc_locs_svc_groups.cnt (LREL loc) {cnt = ?}

  service_pcat        BREL <- lrel_svc_grps_svc_pcat.cnt (LREL pcat) {cnt = ?}

  service_chgcat      BREL <- lrel_svc_grps_svc_chgcat.cnt (LREL chgcat) {cnt = ?}

  service_isscat      BREL <- lrel_svc_grps_svc_isscat.cnt (LREL isscat) {cnt = ?}

  service_wftpl        BREL <- lrel_svc_grps_svc_wftpl.cnt (LREL wftpl) {cnt = ?}

  att_ntfrlist        BREL <- lrel_ntfr_cntlist_att_ntfrlist.cnt (LREL ntfr) {cnt = ?}

  cntissntf            BREL <- lrel_notify_list_cntissntf.cnt (LREL iss) {cnt = ?}

  cntchgntf            BREL <- lrel_notify_list_cntchgntf.cnt (LREL chg) {cnt = ?}

  macro_ntf            BREL <- lrel_att_cntlist_macro_ntf.cnt (LREL macro) {cnt = ?}

  mgs_ntf              BREL <- lrel_dist_cntlist_mgs_ntf.cnt (LREL mgs) {cnt = ?}

  member_list          BREL <- (LREL member) {group = ?}

  group_list          BREL <- grpmem.member (LREL group) {member = ?}

  cnthandling_list    BREL <- (LREL special_handling) {contact = ?}

  web_url              LOCAL STRING(0) DERIVED('http://<servername>:8080/CAisd/pdmweb.exe?' || CAST(id AS NVARCHAR))

  all_creq            BREL <- cr.customer {customer = ?}

  all_chg              BREL <- chg.requestor {requestor = ?}

  all_iss              BREL <- iss.requestor {requestor = ?}

  all_open_creq        QREL <- cr {customer = ? and active = 1}

  combo_name          LOCAL STRING(0) DERIVED(last_name || isnull(', ' || first_name || ' ' || middle_name))

  combo_name2          LOCAL STRING(0) DERIVED(last_name || ',' || isnull(first_name) || ',' || isnull(middle_name))

  log_reader          BREL <- {contact = ?}

  roles                BREL <- {contact = ?}

  active_special_handling QREL <- contact_handling {contact = ? and special_handling.delete_flag = 0}

  workload            QREL <- cr {assignee = ? and active = 1}

  workload_chg        QREL <- chg {assignee = ? and active = 1}

  workload_iss        QREL <- iss {assignee = ? and active = 1}

  workload_wf          QREL <- wf {assignee = ? and status = 'PEND'}

  workload_isswf      QREL <- iss_wf {assignee = ? and status = 'PEND'}

  cr_nf_list          BREL <- qp_cr_cnt.cnt_srel {cnt_srel = ?}

  chg_nf_list          BREL <- qp_chg_cnt.cnt_srel {cnt_srel = ?}

  iss_nf_list          BREL <- qp_iss_cnt.cnt_srel {cnt_srel = ?}

  change_tasks        QREL <- wf {assignee = ? AND status.allow_task_update = 1}

  issue_tasks          QREL <- iss_wf {assignee = ? AND status.allow_task_update = 1}

  tenant              SREL -> REQUIRED

  access_type c_acctyp_id SREL ->

  notify_method1 c_cm_id1 SREL ->

  notify_method2 c_cm_id2 SREL ->

  notify_method3 c_cm_id3 SREL ->

  notify_method4 c_cm_id4 SREL ->

  notify_ws1 c_ws_id1  SREL -> wrkshft.persistent_id

  notify_ws2 c_ws_id2  SREL -> wrkshft.persistent_id

  notify_ws3 c_ws_id3  SREL -> wrkshft.persistent_id

  notify_ws4 c_ws_id4  SREL -> wrkshft.persistent_id

  domain c_domain      SREL ->

  vendor c_vendor      SREL ->

  service_type c_service_type SREL -> no_contract_sdsc.code

  timezone c_timezone  SREL -> tz.code

  integration_cnt      INTEGER

  confirm_save        INTEGER

  notify_urgency1      LOCAL SREL -> noturg.enum

  notify_urgency2      LOCAL SREL -> noturg.enum

  notify_urgency3      LOCAL SREL -> noturg.enum

  notify_urgency4      LOCAL SREL -> noturg.enum

  schedule c_schedule  SREL -> wrkshft.persistent_id

  available c_available INTEGER

  pgroups              LOCAL STRING(0)

ldap_dn              STRING(512)

  auto_bias_wf        LOCAL INTEGER

  auto_bias_isswf      LOCAL INTEGER

  linked_id_usp_contact id<contact_uuid> UUID UNIQUE

  cost                DOUBLE

  currency_type        SREL ->


  audit_userid        LOCAL SREL -> TENANCY_UNRESTRICTED

  sap_personID        STRING(32)



Estrutura de carga: pdm_extract ca_contact

TABLE ca_contact

  admin_organization_uuid alias alt_phone_number alternate_identifier comment company_uuid contact_type cost_center creation_date creation_user delete_time department email_address exclude_registration fax_number first_name floor_location id inactive job_function job_title last_name last_update_date last_update_user location_uuid mail_stop middle_name mobile_phone_number organization_uuid pager_email_address pager_number pri_phone_number room_location supervisor_contact_uuid tenant tenant_group userid version_number

  { "" ,"" ,"" ,"" ,"Usuário para a integração do Asset Management" ,"", "2307" ,"" ,"" ,"" ,"" ,"" ,"" ,"" ,"" ,"" ,"", "16226C765005B94E957E0F477DEF1B1C" ,"0" ,"" ,"" ,"System_AM_User",

  "06/17/2015 15:52:24" ,"ServiceDesk" ,"" ,"" ,"" ,"" ,"" ,"" ,"" ,"" ,"" ,"", "C6F2D388395F734EBC4C6AEEBCBF68E4" ,"" ,"System_AM_User" ,"1" }




3. Exemplo


loading_cnt.txt - conteúdo do arquivo

TABLE ca_contact

userid  last_name email_address alt_phone_number

{"","user Last Name ","",""}


1. Crie o arquivo  loading_cnt.txt file

TABLE ca_contact

userid  last_name email_address alt_phone_number

{"","user Last Name ","",""}

2. pdm_load -i  -f carga_cnt.txt

command = C:\PROGRA~2/CA/SERVIC~1\bin\dbload -i -v  CARGA_~1.TXT


Processing CARGA_~1.TXT


        userid: []

        last_name: [user Last Name]

        email_address: []

        alt_phone_number: []

        alias: []

        id: [3988E217CE309B42B1250564894A02CD]

        inactive: [0]

        tenant: [00]

ca_contact :

Rows  :1



Errors : 0

MaxKey : 0



Ending Totals:

Total tables :1

Total rows  :1

Total inserts:1

Total updates:0

Total errors: 0

Highest Table keys processed    :ca_contact(0)

Files processed: 1

3. faça a carga do arquivo
Utilizando o contato criado, para carregar a tabela secundária usp_contact utilize o comandopdm_deref

TABLE usp_contact

userid access notify_method1 notify_method2 notify_method3 notify_method4

{"name.lastname", "Cliente" , "Normal","Normal","Normal","Normal"}

4. Crie seu arquivo de entrada load_uspcnt.txt



input = userid

output = id

rule = "select id FROM ca_contact WHERE userid=?"


05.Crie seu arquivo spec cnt_spec.txt
CASDM_cntload_04.jpg06.Rode o comando Dref utilizando a sintaxe


pdm_dref -s (spec file name)    <  (input file name)    > (exit file name)



pdm_deref -v -s cnt_spec.txt < load_uspcnt.txt > load_uspcnt_exit_A


TABLE usp_contact

      id access notify_method1 notify_method2 notify_method3 notify_method4

     { "4B066F502B009F48BC53A4CAC6DFA9AA", "Cliente", "Normal", "Normal",

     "Normal", "Normal" }

07. load_uspcnt_exit_A.txt



input = access

output = c_acctyp_id

rule = "select id FROM Access_Type_v2 WHERE sym=?"


05. Crie seu arquivo spec acctyp_spec.txt, Para saber mais sobre o objeto Accces  clique aqui

06. Rode o comando Dref



pdm_dref -s (spec file name)    <  (input file name)    > (exit file name)



pdm_deref -v -s Access_Type_spec.txt < load_uspcnt_exit_A.txt > load_uspcnt_exit_B.txt




TABLE usp_contact

      id c_acctyp_id notify_method1

     { "4B066F502B009F48BC53A4CAC6DFA9AA", "10004", "Normal", }

07. load_uspcnt_exit_B.txt



input = notify_method1

output = notify_urgency1

rule = "select id FROM Notification_Urgency WHERE sym=?"


08. Crie seu arquivo spec notify_spec.txt, Quer saber mais sobre o objeto noturg Clique aqui

09. Rode o comando Dref



pdm_dref -s (spec file name)    <  (input file name)    > (exit file name)



pdm_deref -v -s notify_spec.txt < load_uspcnt_exit_B.txt > load_uspcnt_exit_C.txt


TABLE usp_contact

      id c_acctyp_id notify_urgency1

     { "4B066F502B009F48BC53A4CAC6DFA9AA", "10004", "401" }

10. load_uspcnt_exit_C.txt
11. Este mesmo processo funciona para todos os campos

12. Para carregar rode o comando


pdm_load -v -a -f load_uspcnt_exit_C.txt










DEREF - pdm_deref - Everthing do you need know

CA SDM Load department using pdm_load - dept - ca_resource_department

CA Service Desk Manager Load Category using pdm_load - pcat - Prob_Category - User view Prob_Ctg Category.xlsx

jueves, 13 de agosto de 2015

Universal Network: El Portafolio de Agile Operations de CA transforma la experiencia del usuario



CA Technologies combina soluciones de desarrollo y operaciones para agregar velocidad, escalas y calidad para la administración de TI, y cumplir con las exigencias de la Economía de las Aplicaciones


México, 12 de Agosto de 2015 – CA Technologies anuncia una actualización de su portafolio de creación de monitoreo y la creación del concepto de Agile Operations. La compañía ha combinado las funcionalidades de las herramientas de su portafolio DevOps - CA APM y CA UIM – para traer al mercado una solución completa de innovación en la administración de TI. La inspiración para el cambio proviene del uso de la metodología Ágil del funcionamiento de TI, la cual es una combinación de distintas tecnologías para crear procesos más eficientes. El objetivo es agregar agilidad, escalas y calidad para satisfacer las demandas generadas por la nueva realidad de la economía digital.


Agile Operations es una evolución de la metodología ágil, que surgió desde hace 14 años en los Estados Unidos de América, cuando los profesionales de TI lanzaron el Manifiesto Ágil. Ellos propusieron nuevas reglas para hacer el desarrollo de los programas de forma más rápida y colaborativa.  Agile Operations trae una lógica basada en la velocidad y la eficiencia en los procesos de administración diaria del departamento de TI, de acuerdo con la necesidad y las demandas creadas por los usuarios y la búsqueda de servicios infalibles con mayor capacidad de respuesta.


"Hubo un momento en que la estabilidad de los sistemas fue la única preocupación dentro del área de TI de una empresa. En el mundo de la Economía de las Aplicaciones, donde la gente quiere hacer todo por medio de las aplicaciones, el software se ha convertido en el corazón de las empresas de la mayoría de los sectores. Este movimiento aumenta la presión en la tecnología, que ahora tiene que ser, sobre todo, capaz de innovar - mientras trabaja bien", comenta el Vicepresidente de Enterprise Management de América Latina, João Fábio Valentin.


Este concepto afina el motor que impulsa la Economía de las Aplicaciones, al responder directamente a las tres principales demandas creadas por esta gran tendencia: velocidad, escalas y calidad. La actualización y combinación de las herramientas de CA de monitoreo de desempeño de las aplicaciones, y la administración integrada de la infraestructura de TI facilitan la creación de entornos de confianza.


Experiencia del usuario: diferencial competitivo en la Economía de las Aplicaciones


Las empresas necesitan una estructura cada vez más precisa de tecnología para responder a las demandas de los consumidores digitales. Se necesita poner atención, sobre todo, a la experiencia del usuario. Además, de que esta debe ser positiva, los sistemas y las redes tienen que trabajar sin errores detrás de escena, es decir, en las TI. Las soluciones de Agile Operations, actúan juntas para identificar y reparar defectos en el sistema y ofrecer a los usuarios una experiencia fluida y sin fallas. Ahora, los desarrolladores y administradores siguen estas métricas en una sola pantalla.



La Aplicación de Administración del Rendimiento de CA (APM – Application Performance Management), permite gestionar de forma proactiva la experiencia del usuario con las aplicaciones, cualquiera que sea la plataforma que él esté conectando al sistema, como un smartphone, una tableta, un ordenador portátil o a través de una plataforma como el mainframe. La herramienta ha ganado una nueva interface y otras posibilidades de análisis, como acortar el tiempo a partir de los servicios o de usuarios específicos.


La Administración de Infraestructura Unificada de CA (UIM – Unified Infraestructure Management) ofrece una visión de 360 grados en los ingresos y en la disponibilidad de los sistemas, así como de la infraestructura. La herramienta ofrece ahora funciones para integrar el software de Big Data.


"O bien el equipo de operaciones o el de desarrollo de TI se vuelven más eficientes cuando se crea una dinámica de evaluaciones rápidas. Esto aumenta la calidad, permite que las entregas lleguen antes en el mercado y genera conocimiento organizacional”, dijo João Fábio Valentin.


Acerca de CA Technologies

CA Technologies (NASDAQ: CA) ofrece softwares que impulsan la transformación de las empresas y les permite aprovechar las oportunidades de la economía las aplicaciones. El software es el corazón de cada negocio y de cada industria. Desde la planificación, el desarrollo, hasta la administración y la seguridad, CA está trabajando con compañías de todo el mundo para cambiar la forma en que la vivimos, realizamos transacciones, y nos comunicamos - a través de la nube (privada y pública), de plataformas móviles y de entornos de TI, de los distribuidos al mainframe. Para mayor información, favor de consultar en