Árvore de páginas

Versões comparadas

Chave

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

...

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_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_ATEND_BE6BEG
data.HAT_LOAD_CRIT_ATEND_BE9BEL.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_PROC_ATEND_BF1BEJ
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.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

...

Bloco de código
languagetext
themeMidnight
titleExemplo: Edição 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_B4Q.sql=select * Views que serao extraidas         ###
################################################  

from HAT_STMP_B4Q
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_BA0BA9.sql=select * from HAT_STMP_BA0BA9
data.HAT_STMP_BA1BAQ.sql=select * from HAT_STMP_BA1BAQ
data.HAT_STMP_BA3BAU.sql=select * from HAT_STMP_BA3BAU
data.HAT_STMP_BA9BAX.sql=select * from HAT_STMP_BA9BAX
data.HAT_STMP_BAQBB0.sql=select * from HAT_STMP_BAQBB0
data.HAT_STMP_BAUBB8.sql=select * from HAT_STMP_BAUBB8
data.HAT_STMP_BAXBBF.sql=select * from HAT_STMP_BAXBBF
data.HAT_STMP_BB0BC1.sql=select * from HAT_STMP_BB0BC1
data.HAT_STMP_BB8BCT.sql=select * from HAT_STMP_BB8BCT
data.HAT_STMP_BBFBEA.sql=select * from HAT_STMP_BBFBEA
data.HAT_STMP_BC1BE4.sql=select * from HAT_STMP_BC1BE4
data.HAT_STMP_BCTBI3.sql=select * from HAT_STMP_BCTBI3
data.HAT_STMP_BEABJE.sql=select * from HAT_STMP_BEABJE
data.HAT_STMP_BI3BLD.sql=select * from HAT_STMP_BI3BLD
data.HAT_STMP_BJEBLE.sql=select * from HAT_STMP_BJEBLE
data.HAT_STMP_BLDBQC.sql=select * from HAT_STMP_BLDBQC
data.HAT_STMP_BLEBQV.sql=select * from HAT_STMP_BLEBQV
data.HAT_STMP_BQCBQZ.sql=select * from HAT_STMP_BQCBQZ
data.HAT_STMP_BR8.sql=select * from HAT_STMP_BR8
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_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_B4A.sql=select * from HAT_STMP_B4A
data.HAT_STMP_B4C.sql=select * from 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

...