Histórico da Página

...

O TOTVS Saúde Portal Autorizador ETL foi criado para facilitar o processo de extração de dados da base Protheus e importação desses dados na base do TOTVS Saúde Portal Autorizador.

...

title	Atenção

...

Ao final, o implantador deve confirmar com o time de produto se os dados foram importados com sucesso.

Requisitos

Sistema operacional Windows

Ter instalado a ultima versão do Java 64 bits (https://www.java.com/pt_BR/download/manual.jsp)Caso esteja

Informações

title	Atenção

Caso esteja instalando em um ambiente multi-operadora consulte o documento Implantação em ambientes multi-operadora - Home Soluções Saúde - TDN (totvs.com)

O TOTVS Saúde Portal Autorizador ETL não possui suporte oficial a sistemas operacionais Linux, mas é possível realizar a configuração seguindo a documentação disponível em Implantação em ambientes Linux

...

Nesse passo você poderá selecionar se quer customizar as views para alterar o nome das tabelas ou dos campos.Para saber mais sobre a customização das views acesse Views para ETL no TOTVS Saúde Portal Autorizador

Informações

title	Atenção

Caso tenha informado um alias para as views é necessário editar o nome das views no arquivo install.properties.

Para isso siga as instruções do passo 11.1 antes de continuar.

...

Bloco de código

language	bash
firstline	26
title	install.properties
linenumbers	true

...
################################################
###        Views que serao extraidas         ###
################################################  

data.HAT_LOAD_B06B4Q_DOC.sql=select * from HAT_LOAD_B06B4Q_DOC
data.HAT_LOAD_B26B4A_DOC.sql=select * from HAT_LOAD_B26B4A_DOC
data.HAT_LOAD_B2JB4C_DOC.sql=select * from HAT_LOAD_B2JB4C_DOC
data.HAT_LOAD_B2KBA0_DOC.sql=select * from HAT_LOAD_B2KBA0_DOC
data.HAT_LOAD_BA0BA1_DOC.sql=select * from HAT_LOAD_BA0BA1_DOC
data.HAT_LOAD_BA1BA3_DOC.sql=select * from HAT_LOAD_BA1BA3_DOC
data.HAT_LOAD_BA3BA9_DOC.sql=select * from HAT_LOAD_BA3BA9_DOC
data.HAT_LOAD_BA6BAQ_DOC.sql=select * from HAT_LOAD_BA6BAQ_DOC
data.HAT_LOAD_BA9BAU_DOC.sql=select * from HAT_LOAD_BA9BAU_DOC
data.HAT_LOAD_BANBAX_DOC.sql=select * from HAT_LOAD_BANBAX_DOC
data.HAT_LOAD_BAQBB0_DOC.sql=select * from HAT_LOAD_BAQBB0_DOC
data.HAT_LOAD_BAUBB8_DOC.sql=select * from HAT_LOAD_BAUBB8_DOC
data.HAT_LOAD_BAWBBF_DOC.sql=select * from HAT_LOAD_BAWBBF_DOC
data.HAT_LOAD_BAXBC1_DOC.sql=select * from HAT_LOAD_BAXBC1_DOC
data.HAT_LOAD_BB0BCT_DOC.sql=select * from HAT_LOAD_BB0BCT_DOC
data.HAT_LOAD_BB2BEA_DOC.sql=select * from HAT_LOAD_BB2BEA_DOC
data.HAT_LOAD_BB6BE4_DOC.sql=select * from HAT_LOAD_BB6BE4_DOC
data.HAT_LOAD_BB8BI3_DOC.sql=select * from HAT_LOAD_BB8BI3_DOC
data.HAT_LOAD_BBFBJE_DOC.sql=select * from HAT_LOAD_BBFBJE_DOC
data.HAT_LOAD_BBIBLD_DOC.sql=select * from HAT_LOAD_BBIBLD_DOC
data.HAT_LOAD_BBKBLE_DOC.sql=select * from HAT_LOAD_BBKBLE_DOC
data.HAT_LOAD_BBMBQC_DOC.sql=select * from HAT_LOAD_BBMBQC_DOC
data.HAT_LOAD_BBNBQV_DOC.sql=select * from HAT_LOAD_BBNBQV_DOC
data.HAT_LOAD_BC0BQZ_DOC.sql=select * from HAT_LOAD_BC0BQZ_DOC
data.HAT_LOAD_BC1BR8_DOC.sql=select * from HAT_LOAD_BC1BR8_DOC
data.HAT_LOAD_BCTBTQ_DOC.sql=select * from HAT_LOAD_BCTBTQ_DOC
data.HAT_LOAD_BDLBTS_DOC.sql=select * from HAT_LOAD_BDLBTS_DOC
data.HAT_LOAD_BDTBTU_DOC.sql=select * from HAT_LOAD_BDTBTU_DOC
data.HAT_LOAD_CRIT_ATEND_BE4BEG_DOC.sql=select * from HAT_LOAD_CRIT_BE4ATEND_BEG_DOC
data.HAT_LOAD_CRIT_ATEND_BE6BEL_DOC.sql=select * from HAT_LOAD_BE6CRIT_ATEND_BEL_DOC
data...HAT_LOAD_PROC_ATEND_BE2_DOC.sql=select * from HAT_LOAD_PROC_ATEND_BE2_DOC
data.HAT_LOAD_PROC_ATEND_BEJ_DOC.sql=select * from HAT_LOAD_PROC_ATEND_BEJ_DOC 

...

12 - Extraindo os dados

Será feito o processo de extração dos dados e envio dos dados extraídos para o local onde eles serão processados e importados para o HAT.

...

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107

################################################
###         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_B06B4Q.sql=select * from HAT_STMP_B06B4Q

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_BFGB4A.sql=select * from HAT_STMP_BFGB4A
data.HAT_STMP_BFJB4C.sql=select * from HAT_STMP_BFJB4C
data.HAT_STMP_BFOBA0.sql=select * from HAT_STMP_BFOBA0
data.HAT_STMP_BFPBA1.sql=select * from HAT_STMP_BFPBA1
data.HAT_STMP_BG7BA3.sql=select * from HAT_STMP_BG7BA3
data.HAT_STMP_BG8BA9.sql=select * from HAT_STMP_BG8BA9
data.HAT_STMP_BG9BAQ.sql=select * from HAT_STMP_BG9BAQ
data.HAT_STMP_BI3BAU.sql=select * from HAT_STMP_BI3BAU
data.HAT_STMP_BI6BAX.sql=select * from HAT_STMP_BI6BAX
data.HAT_STMP_BIABB0.sql=select * from HAT_STMP_BIABB0
data.HAT_STMP_BJ4BB8.sql=select * from HAT_STMP_BJ4BB8
data.HAT_STMP_BJEBBF.sql=select * from HAT_STMP_BJEBBF
data.HAT_STMP_BLDBC1.sql=select * from HAT_STMP_BLDBC1
data.HAT_STMP_BLEBCT.sql=select * from HAT_STMP_BLEBCT
data.HAT_STMP_BQCBEA.sql=select * from HAT_STMP_BQCBEA
data.HAT_STMP_BR4BE4.sql=select * from HAT_STMP_BR4BE4
data.HAT_STMP_BR8BI3.sql=select * from HAT_STMP_BR8BI3
data.HAT_STMP_BRVBJE.sql=select * from HAT_STMP_BRVBJE
data.HAT_STMP_BT4BLD.sql=select * from HAT_STMP_BT4BLD
data.HAT_STMP_BT5BLE.sql=select * from HAT_STMP_BT5BLE
data.HAT_STMP_BT6BQC.sql=select * from HAT_STMP_BT6BQC
data.HAT_STMP_BT7BQV.sql=select * from HAT_STMP_BT7BQV
data.HAT_STMP_BT8BQZ.sql=select * from HAT_STMP_BT8BQZ
data.HAT_STMP_BTQBR8.sql=select * from HAT_STMP_BTQBR8
data.HAT_STMP_BTSBTQ.sql=select * from HAT_STMP_BTSBTQ
data.HAT_STMP_BTUBTS.sql=select * from HAT_STMP_BTUBTS
data.HAT_STMP_BVIBTU.sql=select * from HAT_STMP_BVIBTU
data.HAT_STMP_BEA_BW3CONSULTA.sql=select * from HAT_STMP_BEA_BW3CONSULTA
data.HAT_STMP_CidIncompativelBE2_BAACONSULTA.sql=select * from HAT_STMP_CidIncompativelBE2_BAACONSULTA
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

...

Atalhos

Árvore de páginas

Versões comparadas

Versão antiga 13

Nova versão Atual

Chave

Requisitos

12 - Extraindo os dados