The perfect combination of fusioninsight Libra and the ODI 12c

This article describes how to synchronize PostgreSQL data to Fusioninsight LibrA via the ODI 12c.

1. fusioninsight Libra Client Configuration

Configure the Fusioninsight Libra client on the ODI service to complete the client authentication operation.

[[email protected] ~]$ source /u02/huawei/client/bigdata_env [[email protected] ~]$ kinit candonPassword for [email protected]: [[email protected] ~]$ klist Ticket cache: FILE:/tmp/krb5cc_1000Default principal: [email protected]Valid starting       Expires              Service principal2018-10-08T17:00:58  2018-10-09T17:00:55  krbtgt/[email protected][[email protected] ~]$ odi

2. Configure Client access authentication

Log in to the CN server as the operating system user oMM, start the environment variable operation and the setup allows the ODI server to access Libra.

 --Create user [[[email protected] ~]$ gsql-d postgres-p 25308postgres=# Create user rhnuser with sysadmin identif IED by ' [email protected] ';--Set the client service that allows 192.168.120.80 native [[email protected] ~]$ gs_guc set-z coordinator-n All-i all-h "host all Rhnuser 192.168.120.80/32 sha256"  

• -Z coordinator indicates that the instance type is coordinator.
• -N all represents all hosts of the cluster.
• -I all represents all instances of the host.
• -H indicates that the statement that needs to be incremented in "pg_hba.conf" is specified.
• All means that the client is allowed to connect to any database.
• Rhnuser represents the user who connects to the database.
• 192.168.120.80/32 indicates that only host connections with an IP address of 192.168.120.80 are allowed. The IP address here cannot be the IP in the cluster, in the process of use, please change the configuration according to the actual network.
• SHA256 indicates that the jack user's password is encrypted using the SHA256 algorithm when connected
  This command adds a rule to the "pg_hba.conf" file for all CN instances to authenticate clients that connect to the CN. 3. Create a physical architecture

  To create Libra, for example, the PostgreSQL architecture is created in the same vein.
  odi-> topology, physical architecture->postgresql-> New data server, new physical schema, as shown in:
  
  

  4. Create a logical architecture

  Odi-> topology--Logical architecture->postgresql-> new logic scheme
  

  5. Create an ODI model

  The Model Odi-> Designer, as shown in:
  
  Finally, click on the "Reverse engineering" synchronization table structure.

  6. Create an ODI project

  Odi-> Designer project, as shown in:
  

  7. Create a Project Map

  Please refer to the relevant ODI article on the blog for details, as shown in the following:
  
  
  

  8. Run Map

  
  

The perfect combination of fusioninsight Libra and the ODI 12c