...
Acesse a pasta bin/agent dentro da pasta ETL_LINUX, digite os comandos:
chmod 777 +x agent-healthcare.jar
chmod 777 +x 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_LOAD_B06B4Q.sql=select * from HAT_LOAD_B06B4Q data.HAT_LOAD_B26BA0.sql=select * from HAT_LOAD_B26BA0 data.HAT_LOAD_BA0BA1.sql=select * from HAT_LOAD_BA0BA1 data.HAT_LOAD_BA1BA3.sql=select * from HAT_LOAD_BA1BA3 data.HAT_LOAD_BA3BA9.sql=select * from HAT_LOAD_BA3BA9 data.HAT_LOAD_BA6BAQ.sql=select * from HAT_LOAD_BA6BAQ data.HAT_LOAD_BA9BAU.sql=select * from HAT_LOAD_BA9BAU data.HAT_LOAD_BANBAX.sql=select * from HAT_LOAD_BANBAX data.HAT_LOAD_BAQBB0.sql=select * from HAT_LOAD_BAQBB0 data.HAT_LOAD_BAUBB8.sql=select * from HAT_LOAD_BAUBB8 data.HAT_LOAD_BAWBBF.sql=select * from HAT_LOAD_BAWBBF data.HAT_LOAD_BAXBC1.sql=select * from HAT_LOAD_BAXBC1 data.HAT_LOAD_BB0BCT.sql=select * from HAT_LOAD_BB0BCT data.HAT_LOAD_BB2BEA.sql=select * from HAT_LOAD_BB2BEA data.HAT_LOAD_BB6BE4.sql=select * from HAT_LOAD_BB6BE4 data.HAT_LOAD_BB8BI3.sql=select * from HAT_LOAD_BB8BI3 data.HAT_LOAD_BBFBJE.sql=select * from HAT_LOAD_BBFBJE data.HAT_LOAD_BBIBLD.sql=select * from HAT_LOAD_BBIBLD data.HAT_LOAD_BBKBLE.sql=select * from HAT_LOAD_BBKBLE data.HAT_LOAD_BBMBQC.sql=select * from HAT_LOAD_BBMBQC data.HAT_LOAD_BBNBQV.sql=select * from HAT_LOAD_BBNBQV data.HAT_LOAD_BC0BQZ.sql=select * from HAT_LOAD_BC0BQZ data.HAT_LOAD_BC1BR8.sql=select * from HAT_LOAD_BC1BR8 data.HAT_LOAD_BCTBTQ.sql=select * from HAT_LOAD_BCTBTQ data.HAT_LOAD_BDLBTS.sql=select * from HAT_LOAD_BDLBTS data.HAT_LOAD_BE4BTU.sql=select * from HAT_LOAD_BE4BTU data.HAT_LOAD_CRIT_ATEND_BE6BEG.sql=select * from HAT_LOAD_CRIT_BE6ATEND_BEG data.HAT_LOAD_BE9CRIT_ATEND_BEL.sql=select * from HAT_LOAD_CRIT_ATEND_BE9BEL data.HAT_LOAD_BEAPROC_ATEND_BE2.sql=select * from HAT_LOAD_PROC_BEAATEND_BE2 data.HAT_LOAD_PROC_ATEND_BF1BEJ.sql=select * from HAT_LOAD_BF1PROC_ATEND_BEJ data.HAT_LOAD_BFCB4A.sql=select * from HAT_LOAD_BFCB4A data.HAT_LOAD_BFDB4C.sql=select * from HAT_LOAD_BFD data.HAT_LOAD_BFE.sql=select * from HAT_LOAD_BFE data.HAT_LOAD_BFG.sql=select * from HAT_LOAD_BFG data.HAT_LOAD_BFJ.sql=select * from HAT_LOAD_BFJ data.HAT_LOAD_BFO.sql=select * from HAT_LOAD_BFO data.HAT_LOAD_BFP.sql=select * from HAT_LOAD_BFP data.HAT_LOAD_BG7.sql=select * from HAT_LOAD_BG7 data.HAT_LOAD_BG8.sql=select * from HAT_LOAD_BG8 data.HAT_LOAD_BG9.sql=select * from HAT_LOAD_BG9 data.HAT_LOAD_BI3.sql=select * from HAT_LOAD_BI3 data.HAT_LOAD_BI6.sql=select * from HAT_LOAD_BI6 data.HAT_LOAD_BIA.sql=select * from HAT_LOAD_BIA data.HAT_LOAD_BJ4.sql=select * from HAT_LOAD_BJ4 data.HAT_LOAD_BJE.sql=select * from HAT_LOAD_BJE data.HAT_LOAD_BLD.sql=select * from HAT_LOAD_BLD data.HAT_LOAD_BLE.sql=select * from HAT_LOAD_BLE data.HAT_LOAD_BQC.sql=select * from HAT_LOAD_BQC data.HAT_LOAD_BR4.sql=select * from HAT_LOAD_BR4 data.HAT_LOAD_BR8.sql=select * from HAT_LOAD_BR8 data.HAT_LOAD_BRV.sql=select * from HAT_LOAD_BRV data.HAT_LOAD_BT4.sql=select * from HAT_LOAD_BT4 data.HAT_LOAD_BT5.sql=select * from HAT_LOAD_BT5 data.HAT_LOAD_BT6.sql=select * from HAT_LOAD_BT6 data.HAT_LOAD_BT7.sql=select * from HAT_LOAD_BT7 data.HAT_LOAD_BT8.sql=select * from HAT_LOAD_BT8 data.HAT_LOAD_BTQ.sql=select * from HAT_LOAD_BTQ data.HAT_LOAD_BTS.sql=select * from HAT_LOAD_BTS data.HAT_LOAD_BTU.sql=select * from HAT_LOAD_BTU data.HAT_LOAD_BVI.sql=select * from HAT_LOAD_BVI data.HAT_LOAD_BW3.sql=select * from HAT_LOAD_BW3 data.HAT_LOAD_CidIncompativel_BAA.sql=select * from HAT_LOAD_CidIncompativel_BAA data.HAT_LOAD_CRIT_ATEND_BEG.sql=select * from HAT_LOAD_CRIT_ATEND_BEG data.HAT_LOAD_CRIT_ATEND_BEL.sql=select * from HAT_LOAD_CRIT_ATEND_BEL data.HAT_LOAD_PROC_ATEND_BE2.sql=select * from HAT_LOAD_PROC_ATEND_BE2 data.HAT_LOAD_PROC_ATEND_BEJ.sql=select * from HAT_LOAD_PROC_ATEND_BEJ data.HAT_LOAD_REGRASCOBERTURA.sql=select * from HAT_LOAD_REGRASCOBERTURA data.HAT_LOAD_SE1.sql=select * from HAT_LOAD_SE1 data.HAT_LOAD_VINCULOSODONTO.sql=select * from HAT_LOAD_VINCULOSODONTO 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 próximo passo é extrair os dados da base de dados utilizando o agent-healthcare.jar.
Acesse a pasta bin/agent dentro da pasta ETL_LINUX onde o arquivo agent-healthcare.jar está localizado e execute o comando java -jar agent-healthcare.jar. Ele irá conectar no banco de dados e realizar a extração.
Após realizarmos a extração de dados para a carga inicial precisamos configurar o agendamento para a integração de dados do TOTVS Protheus para o TOTVS Saúde Portal Autorizador. Para isso precisamos editar o arquivo config.properties removendo as views que começam com HAT_LOAD_... da chave Views que serao extraidas, deixando somente as que iniciem com HAT_STMP_...
B4C
################################################
### 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 próximo passo é extrair os dados da base de dados utilizando o agent-healthcare.jar.
Acesse a pasta bin/agent dentro da pasta ETL_LINUX onde o arquivo agent-healthcare.jar está localizado e execute o comando java -jar agent-healthcare.jar. Ele irá conectar no banco de dados e realizar a extração.
Após realizarmos a extração de dados para a carga inicial precisamos configurar o agendamento para a integração de dados do TOTVS Protheus para o TOTVS Saúde Portal Autorizador. Para isso precisamos editar o arquivo config.properties removendo as views que começam com HAT_LOAD_... da chave Views que serao extraidas, deixando somente as que iniciem com HAT_STMP_...
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_B4Q | ||||||||
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_BFPB4Q data.HAT_STMP_BG7BA0.sql=select * from HAT_STMP_BG7BA0 data.HAT_STMP_BG8BA1.sql=select * from HAT_STMP_BG8BA1 data.HAT_STMP_BG9BA3.sql=select * from HAT_STMP_BG9BA3 data.HAT_STMP_BI3BA9.sql=select * from HAT_STMP_BI3BA9 data.HAT_STMP_BI6BAQ.sql=select * from HAT_STMP_BI6BAQ data.HAT_STMP_BIABAU.sql=select * from HAT_STMP_BIABAU data.HAT_STMP_BJ4BAX.sql=select * from HAT_STMP_BJ4BAX data.HAT_STMP_BJEBB0.sql=select * from HAT_STMP_BJEBB0 data.HAT_STMP_BLDBB8.sql=select * from HAT_STMP_BLDBB8 data.HAT_STMP_BLEBBF.sql=select * from HAT_STMP_BLEBBF data.HAT_STMP_BQCBC1.sql=select * from HAT_STMP_BQCBC1 data.HAT_STMP_BR4BCT.sql=select * from HAT_STMP_BR4BCT data.HAT_STMP_BR8BEA.sql=select * from HAT_STMP_BR8BEA data.HAT_STMP_BRVBE4.sql=select * from HAT_STMP_BRVBE4 data.HAT_STMP_BT4BI3.sql=select * from HAT_STMP_BT4BI3 data.HAT_STMP_BT5BJE.sql=select * from HAT_STMP_BT5BJE data.HAT_STMP_BT6BLD.sql=select * from HAT_STMP_BT6BLD data.HAT_STMP_BT7BLE.sql=select * from HAT_STMP_BT7BLE data.HAT_STMP_BT8BQC.sql=select * from HAT_STMP_BT8BQC data.HAT_STMP_BTQBQV.sql=select * from HAT_STMP_BTQBQV data.HAT_STMP_BTSBQZ.sql=select * from HAT_STMP_BTSBQZ data.HAT_STMP_BTUBR8.sql=select * from HAT_STMP_BTUBR8 data.HAT_STMP_BVIBTQ.sql=select * from HAT_STMP_BVIBTQ data.HAT_STMP_BW3BTS.sql=select * from HAT_STMP_BW3BTS data.HAT_STMP_CidIncompativel_BAABTU.sql=select * from HAT_STMP_CidIncompativel_BAABTU 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_REGRASCOBERTURAB4A.sql=select * from HAT_STMP_REGRASCOBERTURAB4A data.HAT_STMP_SE1B4C.sql=select * from HAT_STMP_SE1 data.HAT_STMP_VINCULOSODONTO.sql=select * from HAT_STMP_VINCULOSODONTOB4C ################################################ ### 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 |
...