Scribd
Upload
4 views2 pages

Database Connection and Sync Details

The document contains various database connection strings and credentials for different systems, including MongoDB and SQL Server. It also includes SQL commands for retrieving synchronization timestamps from specific logs. Additionally, there is a JSON structure indicating a successful login with tokens provided for authentication.

Uploaded by

dao hung
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
4 views2 pages

Database Connection and Sync Details

The document contains various database connection strings and credentials for different systems, including MongoDB and SQL Server. It also includes SQL commands for retrieving synchronization timestamps from specific logs. Additionally, there is a JSON structure indicating a successful login with tokens provided for authentication.

Uploaded by

dao hung
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

pass wifi: Qlda@123

Fpt@12345
desktop pass: Bidv@123456
---
bảng SNAP_FEEDETL lưu trữ thông tin theo dõi tiến trình đồng bộ

"ConnectionStrings": {
"BVSContext":
"tW4lHaZRbRSNl+NIMOoj5RDZmS186s+5P4bnm7AN4sdjjlY1FQ2YsF19OcIqzMwe3/19EHzp8uvJOTGXzP
NqRkZvRwSKXhY6LLIPV6pnmZYFrXcjTlYZ0MNywHHfZ6lQtMa8LAitQyB0tfKZe+EAmL1bZFEJXE6SXkRdh
ciU1IPhIUWAC2aYDF6cKWVODe25Hi8Vu5zVU5jchz+N5cGU4dXc2JfBd/sP8U23P4r7uts="
},
"MongoDBConfig": {
"ConnectionURI":
"mongodb+srv://assets_sys:JUkEeTrsAIv2WG5@[Link]/?
retryWrites=true&w=majority&appName=Cluster0",
"DatabaseName": "assets_sys"
},
-------
Server=[Link];Database=assets_sys;User
Id=sa;password=cj0BeTH71fB02023;Trusted_Connection=False;TrustServerCertificate=Tru
e;MultipleActiveResultSets=true;
----------datastage dùng execute command activity lấy giá trị trực tiếp từ bảng ra
output
sqlplus -s etl_user/etl_pass@//[Link]:1521/ORCLPDB1 <<EOF
SET HEADING OFF
SET FEEDBACK OFF
SET VERIFY OFF
SET PAGESIZE 0
SELECT TO_CHAR(MAX(sync_time), 'YYYY-MM-DD HH24:MI:SS') FROM bidv_etl_log;
EXIT
EOF

----------------------
sqlplus -s apps/apps@[Link]:1546/UBCK25 <<EOF SET HEADING OFF
SET FEEDBACK OFF
SET VERIFY OFF
SET PAGESIZE 0
SELECT TO_CHAR(MAX(sync_time), 'YYYY-MM-DD HH24:MI:SS') FROM bidv_etl_log;
EXIT
EOF

----
{
"data": {
"token":
"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1laWQiOiIxIiwidW5pcXVlX25hbWUiOiJhZG1pb
kB3ZWJzaXRlLmNvbSIsIm5iZiI6MTc1MTEyOTYzNCwiZXhwIjoxNzUxMjEzNjM0LCJpYXQiOjE3NTExMjk2
MzQsImlzcyI6InNlbGYiLCJhdWQiOiJ1c2VyIn0.47XgxE5Bw4zYVLLeiXkhmDEc4T2SZ2pIUcTdIxkQ9lc
",
"refreshToken":
"cW+qMorJigEeWNEtNyB21glxsVW9VvUwR6dNTs9CR9odTn+MpGdfJztgDxQYidJ4qnA2JVts4LSbm4AOya
NcaZMrA2cD6Ia+jDbX0vYWtyuN9jABhOj+vFXk4XG8ebQOm2LCT7e0q5zYqxIQcamnc5pi85eNL+RxdtLI3
QjAsU/
v1OT9IWOQ8B28S0h7ti402pwLkAB8zZfCvN4+VOzz1vXM3pM3hwyyMoz3CJeinR8Wyr0KBXQrnidUR/9/
R/lFvmQWCnckLWrRzU2Z1TMLIOz5u9Yoq/
D2CabPnBB2DoZA3M6+DV9l9FF+coOD3KTEKGorVNQpPxRdfLjLxUgMVCdNSfqA8LoMiHSfzL91pdZ+sTRSU
kxP0TIrBoNn/w8tUhkhWcWzwmPmkmsdyL33yzNUeRu2tpnmYF/mJWXEOyY0QCnqpKL62uW4UfEImvpR"
},
"statusCode": 0,
"message": "Đăng nhập thành công"
}

---------
Server=localhost;Database=YourDbName;User
Id=your_user;Password=your_password;TrustServerCertificate=True;
dotnet ef dbcontext scaffold
"Server=[Link];Database=hung117nl;User
Id=hung117nl_SQLLogin_1;Password=xv9isow24b;TrustServerCertificate=True;"
[Link] -o Models --context AppDbContext --force

workstation id=[Link];packet size=4096;user


id=hung117nl_SQLLogin_1;pwd=xv9isow24b;data
source=[Link];persist security info=False;initial
catalog=hung117nl;TrustServerCertificate=True

You might also like