Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

External Connection (DRM)

You can connect to an Oracle database from DRM.

The external connection is for you to register the connection information typically entered in the tnsname file.

  • Server Name
  • Port #
  • Service Name
  • User ID (Oracle DB User)
  • Password
  • Schema
  • and grant a list of tables that become accessible to a given connection

DRM is written in .NET architecture

The connection string is the ODP.NET connection string

 

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s