Featured post
How can I extract data from OData API to SQL -
i'm wondering community suggests extracting data odata api sql 2008 r2. need create nightly job imports data sql. should create simple console app iterates through odata api , imports sql? or can create type of sql server bi app? or there better way this?
this going sooo slow. odata not api bulk operations. designed clients access individual entities , navigate relations between them, @ paginate across filtered lists.
extracting entire dump via odata not going make happy. odata api owner have investigate doing these nightly crawls on api , discover , cut off. on other hand discover odata not efficient bulk transport format , marshaling http encoded entities , forth not best way spend bandwidth. , crawling entire database every time, opposed discovering deltagrams last crawl, going work until database reaches critical size s @ update takes longer frequency you're pooling!
besides, if not data, extremely use terms odata api explicitly prevent such bulk crawls.
get dump of data, archive it, , copy using ftp.
- Get link
- X
- Other Apps
Comments
Post a Comment