Home > Data Services > Defining Aliases Within Your Datastore in Data Services

Defining Aliases Within Your Datastore in Data Services


When developing code within SAP’s Data Services enterprise information management tool, generally requirements dictate having to extract and load data across multiple environments.  Data services utilizes datastores to allow you to connect to a variety of different data sources such as a web service, an adapter, or more commonly a database.  Those database data sources can include everything from SQL Server, Oracle, DB2, even Netezza.  This blog will describe setting up datastores against a Netezza database to utilize the alias functionality to simplify the process of migrating code from development to production.

What is Netezza and how does Data Services connect to it?

Netezza is a powerful Data Warehousing appliance that integrates the database, server, and the storage components into a single system. Netezza is purpose-built for data warehousing and is specifically  designed for running complex data warehousing workloads. As a result of using proprietary architecture to deliver fast query performance, minimal tuning and administration, and high scalability; Netezza is an ideal database system to use for your data warehousing needs.  As with any relational database system, Data Services can easily connect to Netezza using a datastore connection. Data Services can then import the metadata that describes the data through that connection. If the metadata is identical across multiple environments you can have multiple data configurations within one datastore.

shaunblogpic1

Having multiple configurations within one datastore eliminates the need to create a datastore for every single database you need to connect to; which can speed up development time and prevents unnecessary clutter in your local object library.

 

To download full PDF and Continue Reading…

shaun2About Shaun Scott

Shaun Scott is a Business Intelligence consultant specializing in data warehousing and ETL development. Shaun delivers customized SAP BusinessObjects solutions for customers across all industries. With Decision First Technologies, Shaun utilizes SAP Data Services, Universe Design, Web Intelligence, and a variety of database technologies, including SQL server, DB2, and Netezza.

 

Categories: Data Services
  1. August 9, 2014 at 1:30 am

    I constantly spent my half an hour to read this
    weblog’s content all the time along with a cup
    of coffee.

  2. July 29, 2015 at 3:27 pm

    wonderful points altogether, you simply won a new reader.
    What might you recommend in regards to your post that you made a few
    days in the past? Any positive?

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

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

%d bloggers like this: