Subscribe for automatic updates: RSS icon RSS

Login icon Sign in for full access | Help icon Help
Advanced search

Pages: 1 [2]
  Reply  |  Print  
Author Topic: Wednesday - Breakout - How To Write Portable SQL Code - Sebastien Flaesch  (Read 3426 times)
Sebastien F.
Four Js
Posts: 463


« Reply #15 on: November 20, 2020, 02:34:35 pm »

Efisio,

1) You must check the options provided by PostgreSQL to authenticate users.
See for ex: https://hub.packtpub.com/postgresql-security-a-quick-look-at-authentication-best-practices-tutorial/
Understand: This is NOT a problem of the ODI layer:
Genero provides the CONNECT TO ... USER ... USING instruction, to let you pass a login/pswd for the DB connection.
Up to you to secure the login/pswd at runtime (at least your should encrypt the password if written in a file)
Can be discussed 1:1

2) You could use different Genero tools to inspect the sources and find SQL variable usage.
Contact me directly for more details...
Reuben B.
Four Js
Posts: 834


« Reply #16 on: November 20, 2020, 09:34:30 pm »

Efisio,

Re: DB Users, I know you said PostgreSQL, but with Informix there was recently syntax added that introduced the concept of a trusted database connection, where you could then change the user you were connected as in your code e.g.
Code
  1. CONNECT TO dbname TRUSTED  -- connect as trusted application/system user
  2. ...
  3. INPUT username, passsword
  4. ...
  5. SET SESSION AUTHORIZATION TO username -- change to real user, no need to store users password in fglprofile etc
  6.  

http://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_Connections_045.html
http://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_Connections_042.html

AFAIK that is Informix only, but I'd like to think that if the other database brands had similar functionality that the ODI layer could implement the appropriate syntax for the other database brands.

Reuben


Product Consultant (Asia Pacific)
Developer Relations Manager (Worldwide)
Author of https://4js.com/ask-reuben
Contributor to https://github.com/FourjsGenero
Sebastien F.
Four Js
Posts: 463


« Reply #17 on: November 21, 2020, 10:28:01 am »

Reuben,

Quote
AFAIK that is Informix only, but I'd like to think that if the other database brands had similar functionality that the ODI layer could implement the appropriate syntax for the other database brands.

Such feature is really vendor specific.

It's not just like converting TODAY to SYSDATE(...)

So the answer is NO, the ODI layer will not make such Informix emulation.

Seb
Pages: 1 [2]
  Reply  |  Print  
 
Jump to:  

Powered by SMF 1.1.21 | SMF © 2015, Simple Machines