Árvore de páginas

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

...

13 - Após isso o processo de extração de dados extração de dados é finalizado. Clique em Sair para encerrar o instalador.


Configurar agendamento no Windows

Preparar o arquivo config.properties

Para configurar o agendamento no Windows o primeiro passo é ajustar o arquivo config.properties. Na pasta onde foi instalado o HAT_SETUP abra o arquivo install.properties e copie da chave Views que serao extraidas os valores que iniciam com HAT_STMP_... e substitua os valores da chave Views que serao extraidas no config.properties. O exemplo abaixo mostra como deve ficar o arquivo config.properties:

Bloco de código
languagetext
themeMidnight
titleExemplo: config.properties
linenumberstrue
################################################
###         Propriedades da operadora        ###
################################################
registroAnsOperadora=REGISTRO_ANS_OPERADORA
 
################################################
###    Configuracao de conexao mssql
################################################
jdbc.driver_path=jdbc/sqljdbc4.jar
jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.url=jdbc:sqlserver://IPBancoDeDados:1433;DatabaseName=NomeBancoDeDados
jdbc.username=UsuarioBD
jdbc.password=SenhaBD
 
################################################
###        Views que serao extraidas         ###
################################################
 
data.HAT_STMP_B06.sql=select * from HAT_STMP_B06
data.HAT_STMP_BA0.sql=select * from HAT_STMP_BA0
data.HAT_STMP_BA1.sql=select * from HAT_STMP_BA1
data.HAT_STMP_BA3.sql=select * from HAT_STMP_BA3
data.HAT_STMP_BA6.sql=select * from HAT_STMP_BA6
data.HAT_STMP_BA9.sql=select * from HAT_STMP_BA9
data.HAT_STMP_BAN.sql=select * from HAT_STMP_BAN
data.HAT_STMP_BAQ.sql=select * from HAT_STMP_BAQ
data.HAT_STMP_BAU.sql=select * from HAT_STMP_BAU
data.HAT_STMP_BAW.sql=select * from HAT_STMP_BAW
data.HAT_STMP_BAX.sql=select * from HAT_STMP_BAX
data.HAT_STMP_BB0.sql=select * from HAT_STMP_BB0
data.HAT_STMP_BB2.sql=select * from HAT_STMP_BB2
data.HAT_STMP_BB6.sql=select * from HAT_STMP_BB6
data.HAT_STMP_BB8.sql=select * from HAT_STMP_BB8
data.HAT_STMP_BBF.sql=select * from HAT_STMP_BBF
data.HAT_STMP_BBI.sql=select * from HAT_STMP_BBI
data.HAT_STMP_BBK.sql=select * from HAT_STMP_BBK
data.HAT_STMP_BBM.sql=select * from HAT_STMP_BBM
data.HAT_STMP_BBN.sql=select * from HAT_STMP_BBN
data.HAT_STMP_BC0.sql=select * from HAT_STMP_BC0
data.HAT_STMP_BC1.sql=select * from HAT_STMP_BC1
data.HAT_STMP_BCT.sql=select * from HAT_STMP_BCT
data.HAT_STMP_BDL.sql=select * from HAT_STMP_BDL
data.HAT_STMP_BE4.sql=select * from HAT_STMP_BE4
data.HAT_STMP_BE6.sql=select * from HAT_STMP_BE6
data.HAT_STMP_BE9.sql=select * from HAT_STMP_BE9
data.HAT_STMP_BEA.sql=select * from HAT_STMP_BEA
data.HAT_STMP_BF1.sql=select * from HAT_STMP_BF1
data.HAT_STMP_BFC.sql=select * from HAT_STMP_BFC
data.HAT_STMP_BFD.sql=select * from HAT_STMP_BFD
data.HAT_STMP_BFE.sql=select * from HAT_STMP_BFE
data.HAT_STMP_BFG.sql=select * from HAT_STMP_BFG
data.HAT_STMP_BFJ.sql=select * from HAT_STMP_BFJ
data.HAT_STMP_BFO.sql=select * from HAT_STMP_BFO
data.HAT_STMP_BFP.sql=select * from HAT_STMP_BFP
data.HAT_STMP_BG7.sql=select * from HAT_STMP_BG7
data.HAT_STMP_BG8.sql=select * from HAT_STMP_BG8
data.HAT_STMP_BG9.sql=select * from HAT_STMP_BG9
data.HAT_STMP_BI3.sql=select * from HAT_STMP_BI3
data.HAT_STMP_BI6.sql=select * from HAT_STMP_BI6
data.HAT_STMP_BIA.sql=select * from HAT_STMP_BIA
data.HAT_STMP_BJ4.sql=select * from HAT_STMP_BJ4
data.HAT_STMP_BJE.sql=select * from HAT_STMP_BJE
data.HAT_STMP_BLD.sql=select * from HAT_STMP_BLD
data.HAT_STMP_BLE.sql=select * from HAT_STMP_BLE
data.HAT_STMP_BQC.sql=select * from HAT_STMP_BQC
data.HAT_STMP_BR4.sql=select * from HAT_STMP_BR4
data.HAT_STMP_BR8.sql=select * from HAT_STMP_BR8
data.HAT_STMP_BRV.sql=select * from HAT_STMP_BRV
data.HAT_STMP_BT4.sql=select * from HAT_STMP_BT4
data.HAT_STMP_BT5.sql=select * from HAT_STMP_BT5
data.HAT_STMP_BT6.sql=select * from HAT_STMP_BT6
data.HAT_STMP_BT7.sql=select * from HAT_STMP_BT7
data.HAT_STMP_BT8.sql=select * from HAT_STMP_BT8
data.HAT_STMP_BTQ.sql=select * from HAT_STMP_BTQ
data.HAT_STMP_BTS.sql=select * from HAT_STMP_BTS
data.HAT_STMP_BTU.sql=select * from HAT_STMP_BTU
data.HAT_STMP_BVI.sql=select * from HAT_STMP_BVI
data.HAT_STMP_BW3.sql=select * from HAT_STMP_BW3
data.HAT_STMP_CidIncompativel_BAA.sql=select * from HAT_STMP_CidIncompativel_BAA
data.HAT_STMP_CRIT_ATEND_BEG.sql=select * from HAT_STMP_CRIT_ATEND_BEG
data.HAT_STMP_CRIT_ATEND_BEL.sql=select * from HAT_STMP_CRIT_ATEND_BEL
data.HAT_STMP_PROC_ATEND_BE2.sql=select * from HAT_STMP_PROC_ATEND_BE2
data.HAT_STMP_PROC_ATEND_BEJ.sql=select * from HAT_STMP_PROC_ATEND_BEJ
data.HAT_STMP_REGRASCOBERTURA.sql=select * from HAT_STMP_REGRASCOBERTURA
data.HAT_STMP_SE1.sql=select * from HAT_STMP_SE1
data.HAT_STMP_VINCULOSODONTO.sql=select * from HAT_STMP_VINCULOSODONTO
 
################################################
###     Parametros obrigatorios do Agent   ###
################################################
# Credenciais do FTP
gdc.unlock=FALSE
gdc.uploadTrying=1
gdc.uploadSecond=1
 
gdc.upload_url=https://pagprostorage.blob.core.windows.net/arquivos-integracao
gdc.key=P3N2PTIwMTctMTEtMDkmc3M9YiZzcnQ9c2NvJnNwPXJ3ZGxhJnNlPTIwMzAtMTItMDJUMjM6NDQ6MzFaJnN0PTIwMTgtMDgtMjBUMTY6NDQ6MzFaJnNwcj1odHRwcyZzaWc9YXpLR3JITkdGbDBYNWwzd3BGRE1yNnUxV3JGdE5lOElUYkRmVzd2ZmNobyUzRA==
gdc.blob_type=BlockBlob
 
gdc.upload_archive=Integracao_HAT-${yyyyMMddHHmmss}.zip
gdc.upload_manifest=manifest-${yyyyMMddHHmmss}.txt
 
# Parametro responsavel por verificar se sera utilizado criptografia de senhas.
gdc.crypto=FALSE
 
# Backup
gdc.backup=TRUE

Preparar o arquivo sync_data.bat

O arquivo sync_data.bat será utilizado para executar o comando de extração de dados no tempo programado no Agendador de tarefas do Windows. Abaixo o exemplo de como deve ficar o arquivo sync_data.bat.

Bloco de código
languagebash
themeMidnight
titleExemplo: sync_data.bat
linenumberstrue




Para dar continuidade ao processo de implantação acesse o Passo 3 - Configurar o HAT Admin

...