denodo Virtualization – Useful Links

Here are some denodo Virtualization references, which may be useful.

Reference Name Link
denodo Home Page https://www.denodo.com/en/about-us/our-company
denodo Platform 7.0 Documentation https://community.denodo.com/docs/html/browse/7.0/
denodo Knowledge Base and Best Practices https://community.denodo.com/kb/
denodo Tutorials https://community.denodo.com/tutorials/
denodo Express 7.0 Download https://community.denodo.com/express/download
Denodo Virtual Data Port (VDP) https://community.denodo.com/kb/download/pdf/VDP%20Naming%20Conventions?category=Operation
JDBC / ODBC drivers for Denodo https://community.denodo.com/drivers/

Related References

PostgreSQL – Useful Links

PostgreSQLUseful Links

Here are some PostgreSQL references, which may be useful.

Reference Type Link
PostgreSQL Home page & Download https://www.postgresql.org/
PostgreSQL Online Documentation https://www.postgresql.org/docs/manuals/
Citus – Scalability and Parallelism Extension https://github.com/citusdata

Related References

The Business Industries Using PostgreSQL

PostgreSQL is an open-source database, which was released in 1996. So, PostgreSQL has been around a long time.   So, among the many companies and industries which know they are using PostgreSQL, many others are using PostgreSQL and don’t know it because it is embedded as the foundation in some other application’s software architecture.  

I hadn’t paid much attaint to PostgreSQL even though it as been on the list leading databases used by business for years.  Mostly I have been focused on the databases my customer were using (Oracle, DB2, Microsoft SQL Server, and MySQL/MariaDB).  However, during a recent meeting I was surprised to learn that io had been using and administering PostrgresSQL embedded as part of another software vendors application, which made me take the time to pay attention to PostgreSQL. Especially, who is using PostgreSQL and what opportunities that may provide for evolving my career? 

The Industries Using PostgreSQL

According to enlyft, the major using the PostgreSQL are Computer Software and Information Technology And services companies.  

  PostgreSQL Consumers Information

Here is the  link to enlyft page, which provides additional information companies and industries using PostgreSQL:

Related References

The Most Important Databases In Business

If you are looking to learn a Structured Query Language (SQL) skills and have marketable database knowledge, then it is time to talk about which are the most important business databases.

Why Learn The Most Important Databases Used By Business Are?

Well, I assume that you are reading this article with an eye toward improving your employment prospects.   If improving your employment prospects is what you are after, then why waste time learning databases skills, learning advanced SQL language chrematistics of a database, or get after a certification, which will have a small market?  The most important or most used databases, if you like, to business will likely be where the most work opportunities will be no matter whether you plan to be a company employee, independent contractor, consultant or like me have moved through all of these at one time or another.

Focus On Market Opportunity

The top five databases have a solid 85% of the market, so, this allows a person to build their skill is a database which will have employment opportunities.  While there are non-business users of databases of other databases not discussed here, most of us will, thorough out our careers, be working in work for or with business to earn our living.  

The Top Five Database Most Popular In Businesses

Now to the heart of this article, in 2019 the top five databases used in a business are listed in order of most popular to least popular are:

Database Name Percent of market
Oracle 25.31%
MySQL 24.04%
Microsoft SQL Server 20.39%
PostgreSQL 9.06%
MongoDB 7.71%

Related References

A Quick Guide to Creating Competition Battle Cards

Writing and The Written Word

Why Use Competition
Battle Cards?

During the B2B sales and
marketing processes, if there’s one question that the buyer is sure to ask, it
will be some variation of “how does your product stack up against X competition?”
Maybe the prospect is interested in a certain feature, price, or benefit –
regardless of the specifics, your reps need to speak intelligently about how
your product or service compares.

The struggle is that
in any B2B sales role, there’s a lot of information to remember. The ability to
retain every nuance of their product or service is no large feat, let alone the
details of every competition.

That’s where competition
battle cards come in. They’re essentially a cheat sheet for your sales reps.
When a prospect brings up the competition, the rep can open the battle card and
have instant access to that company’s product information…

View original post 734 more words

How to get a list of installed InfoSphere Information (IIS) Server products

Which File contains the list of Installed IIS products?

  • The list of installed products can be obtained from the Version.xml file.

Where is the Version.xml file located?

  • The exact location of the Version.xml document depends on the operating system in use and where IIS was installed to, which is normally the default location of:

For Linux, Unix, or AIX

  • /opt/IBM/InformationServer

For Windows

  • C:\IBM\InformationServer

Related References

How To Get A List Of Oracle Database Schemas?

Well, this is one of those circumstances, where your ability to answer this question will depend upon your user’s assigned security roles and what you actually want. 

To get a complete list, you will need to use the DBA_ administrator tables to which most of us will not have access.  In the very simple examples below, you may want to add a WHERE clause to eliminate the system schemas from the list, like ‘SYS’ and ‘SYSTEM,’ if you have access to them.

Example Administrator (DBA) Schema List

SELECT distinct OWNER as SCHEMA_NAME

FROM  DBA_OBJECTS

ORDER BY OWNER;

Example Administrator (DBA) Schema List Results Screenshot

Fortunately for the rest of us, there are All user tables, from which we can get a listing of the schemas to which we have access.

Example All Users Schema List

SELECT distinct OWNER as SCHEMA_NAME

FROM    ALL_OBJECTS

ORDER BY OWNER;

Example All Users Schema List Results Screenshot

Related References

Oracle help Center > Database> Oracle > Oracle Database > Release 19