In the following video i made a very simple sample for how to retrieve data from two different data sources based on the input data
At first step we creating a simple flow from HttpInput node -- Compute Node -- HttpReply Node
Step 2 Creating our databases, schemas and tables with same columns names using SQL commands and insert one record at least for each for our test
Step 3 Create a procedure for each we will use to retrieve data
Step 4 Create the ODBC connection with databases we created
Step 5 Configure the integration node to identify the DBs we created and configure at the ODBC then reload the integration node
Step 6 Write compute node code
1 - Define schema and table names that are constant regardless of DB environment
2 - Build the SQL Query String
3 - Execute the dynamic SQL using PASSTHRU
4 - Tells ACE which DSN to use at runtime
5 - Add metadata to the output showing which database was accessed
Why this can be useful ?
In another scenario we can face a connection issue with the DB so we can use the global cache to identify that issue and route to the other DB based on that and for sure it will need some other configuration but it's a valid good scenario to test
We can also switch between the DBs using the UDP and API docs commands
#IBM #App #Connect #ACE #API #console #mq #broker #odbc #sql #database #log #retrieve #node #esql #postman #middleware #ESB #integration #developer
