BookmarkSubscribeRSS Feed
sset
Calcite | Level 5

Hello,

We  a requirement to migrate timeseries database from FAME to timeseries database of Sybase RAP.  Sybase RAP may require SAS analytics on top. We have below queries.

(a) Each vendor store timeseries data in its own optimized way. No open standards exists. What is the best way, practices for timeseries data migration?

(b) Can timeseries migration performed  by ETL?

(c) Kindly send any documentation, links for reference in the areas of timeseries data migration?

(d) What are the best ways of optimizations, performance for timeseries data?

(e) How do we  migrate from sqlserver timeseries data to Sybase RAP?

Thanks

2 REPLIES 2
LinusH
Tourmaline | Level 20

It's hard to give advice on such a complex task as a system migration, especially when SAS is not directly involved, as I understand, in the current solution.

b) As long as they are represented as relational data, ETL can be used to create/maintain time series data.

e) This is not really a SAS question. Once you sort out how to migrate, then you can decide whether you can/will use SAS for the migration.

Data never sleeps
udo_sas
SAS Employee

Hello -

I agree with @LinusH that it is hard to give advice - however I thought it would be useful to share that SAS provides ACCESS engines to both Sybase and FAME.

For access Sybase check out: http://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a002299547.htm

For access to FAME data check out: http://support.sas.com/documentation/cdl/en/etsug/63939/HTML/default/viewer.htm#etsug_sasefame_sect0...

Thanks,

Udo

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1157 views
  • 0 likes
  • 3 in conversation