BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: Upcoming Events: SAP TechEd: Sep 28.

Adding prefix to table name BODS


 
Search this topic... | Search Data Integrator... | Search Box
Register or Login to Post    Forum Index -> Data Integrator  Previous TopicPrint TopicNext Topic
Author Message
sumnesh.nepalia
Forum Member
Forum Member



Joined: 16 Jun 2011

Posts: 9



PostPosted: Mon Jul 03, 2017 2:54 am 
Post subject: Adding prefix to table name BODS

Hi Experts,

We have following requirement:

1. Replicate the database with all table and columns.

2. Add prefix to all the table names say Fusion.

3. Schedule this daily.

I researched and found Data services workbench can do it quickly and created a replication.

But I want to know how can I do:

1. Add prefix to table names.
Back to top
eganjp
Forum Addict
Forum Addict



Joined: 12 Sep 2007
ASUG Icon
Posts: 4231
Location: Denver Area


flag
PostPosted: Sun Jul 16, 2017 9:23 pm 
Post subject: Re: Adding prefix to table name BODS

Why not just replicate the table names as-is into a different schema/database? Then just use a new Datastore Configuration to connect to the new schema/database.
_________________
Jim Egan
ProKarma-an SAP Consulting Partner
Speaker at RMOUG Training Days 2013
Speaker at Sapphire Now 2013
Speaker at Business Objects User Conference 2013
-My ETL is faster than your database! - Advanced ETL performance tuning for Data Services
-Kill ETL bugs before they kill you!
My ETL blog

Latest Blog Posts
• 2014-04-17 Can Your ETL Make Your Reporting Faster?
• 2014-04-04 ProKarma Acquires Mantis Technology Group
• 2014-04-02 How to Create Charts in Webi (Part 2 of 2)
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0118 seconds using 18 queries. (SQL 0.0021 Parse 0.0002 Other 0.0094)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo