Posts

User sqlplus with Lawson (Tips and Tricks)

Most of customers have by now switched over to a Windows / SQL server environment, but we still have several customers who have stayed on Oracle for their Database needs. This mostly stems from having the Oracle skill set in-house as there is really no other advantage to staying on Oracle once you have moved over to Windows.

Often when there are troubles with connecting to the application, it is relevant to test the connection the database from the server itself. Of course there are several ways to do this, but test fastest way is to do so directly from the command prompt in LID as it doesn’t require any additional setup or software. But it is easy to forget how this is done so we decided to write this quick article to document this very simple syntax.
The utility we’re going to use is called sqlplus and it should already installed on your LSF application server. Simply login to the server using LID and on the command prompt type in the following command:
sqlplus <username>/<password>@dbserverName
If you have the correct username and password, and the server is responding, you will get a SQL> prompt on which you can run any query you want. Here’s an example:
However if you type in the incorrect username:
And finally, if you have the incorrect server name or the server is not responding, the prompt will be suspended for several seconds and you will see the following message:
A few small notes about using sqlplus:
  • Be sure to use a semicolon to end your statements. Otherwise the application doesn’t know when to run your query.
  • Make sure the environment variable %ORACLE_HOME% is set correctly. ($ORACLE_HOME on Unix):
  • To exit sqlplus user the “quit” command
  • The SQL buffer contains the last statement you ran, and you can run the previous query again by simply typing “RUN”  and hitting enter.
  • User the LIST command to see a list of your most recently executed SQL commands.
  • “HELP INDEX” shows a list of possible commands
  • To launch a sql script simply put the “@” symbol in front of the file name and execute it. like: @script.sql or even @/path/to/script.sql
  • You can have a multi-line sql statement.
  • The “SHOW USER” command prints the name of the Oracle user you’re logged in as
  • The “SHOW ALL” command prints all the current settings to the screen.

MSCM Data Migration

If you are upgrading MSCM and need to test against production data, you may want to have multiple testing passes.  This article will help you to refresh your MSCM database, even if the versions differ.  (The MSCM install procedure updates the database for you when an older version is found).

Uninstall MSCM

  1. Log into the server as Lawson (or as the install user)
  2. Open a command prompt as administrator
  3. Navigate to <installdir>/config
  4. Run the following commands
    1. uninstallmscm
    2. undeploymscm
    3. Verify services as prompted
  5. Verify that the MSCM application has been removed from WebSphere

Restore Database

  • Overwrite the destination database with the desired data set

Re-install MSCM

  1. Log into the server as Lawson (or as the install user)
  2. Open a command prompt as administrator
  3. Navigate to <installdir>/config
  4. Run the following commands
    1. webspheregraft
    2. installschedulertableprefix
    3. installmscm
    4. deploy
    5. Verify services as prompted
  5. Start the mscm application in WebSphere

IP Designer Series – SQL Query Node

The SQL Query Node can be used to query any SQL Server database.

Connection information

  • Either select the configuration name that contains your JDBC connection information
  • Or select Override Connection and provide the override information

The SQL Query Node can run a SQL Query, Run a stored procedure, or perform a create/update command. If you are running a SQL Query, you can click the “Build” button to build the query in a GUI wizard.

3 Steps To Embedding Artificial Intelligence In Enterprise Applications

In today’s modern tech world, all contemporary applications that exist use some form of a database, whether it be flat files, in-memory or NoSQL, small or large databases. In the next few months, Artificial Intelligence (A.I.) will be necessary for almost all modern apps, becoming the new database for the next generation of applications.

In order to get ready for this new A.I. era of applications, here are 3 steps to begin A.I. – enabling enterprise applications.

Step 1: Start Consuming Artificial Intelligence API’s (Application Program Interface)

Step 2: Build and Deploy Custom A.I. Models in the Cloud

Step 3: Run Open Source A.I. Platforms On-Premises

With A.I. rapidly evolving to become a core component to modern applications, be smart and get started today on exploring APIs.

For Full Article Click Here

Infor BI–Office Plus: Create a Database Alias

This is a simple way to create a database alias.

 

Create your Alias:

  1. Log on with Options
    infor-bi-office-plus-create-a-database-alias-1
  2. Select the Repository
    infor-bi-office-plus-create-a-database-alias-2
  3. On the Database Structure Pane – Click New Database Alias button
    infor-bi-office-plus-create-a-database-alias-3
  4. Fill in information:
    infor-bi-office-plus-create-a-database-alias-4

Your Alias is now created:

infor-bi-office-plus-create-a-database-alias-5

Pandora’s grand plan: A CRM system for recording artists

“No one knows customer relationship management better than a musician,” says Fortune magazine’s Erin Griffith. When it comes to singles, record releases, tours and national events, band managers hope for an essential platform to track their fanbase’s complex analytics.

Pandora’s artist management platform, AMP, hopes to be that service to artists. This platform launched in October 2014, allowing musical acts to see where their listeners are located, how they responded to certain songs (thumbs up/down feature), and what other stations they subscribe. This information could help with song lists for performances.

With this new platform, co-founder Tim Wetergren hints that this is the start for a whole customer relationship management (CRM) platform for artists. Perhaps the ideal CRM platform they’ve been looking for.

For Full Article, Click Here

 

Healthcare.gov has many bumps that need to paved over

 

There are several bumps that healthcare.gov needs to pave over to work more efficiently. One of those bumps is the fact that those filing taxes on their own are finding it incredibly difficult to get affordable healthcare plans. An example of a person in this category would be someone who is currently separated but not divorced from their husband/wife. Another bump are immigrants and those with twins, who also have a tough time enrolling in the website. Immigrants would have trouble when typing in their immigration number and would be meant with an error screen. Those with twins would confuse the website that wouldn’t allow family members with the same birthday to apply.

Federal officials have said that these problems have been fixed. However, proponents of the healthcare legislation have stated that the problems have only been diminished and are still there.

To read the full article, click here