...
13 - Após isso o processo de extração de dados extração de dados é finalizado. Clique em Sair para encerrar o instalador.
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 | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
################################################ ### 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 |
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 | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
Para dar continuidade ao processo de implantação acesse o Passo 3 - Configurar o HAT Admin
...