{"id":1564,"date":"2012-11-27T20:50:15","date_gmt":"2012-11-28T02:50:15","guid":{"rendered":"http:\/\/allidm.com\/blog\/?p=1564"},"modified":"2012-11-27T20:59:54","modified_gmt":"2012-11-28T02:59:54","slug":"etl-process-in-the-identity-space","status":"publish","type":"post","link":"https:\/\/allidm.com\/blog\/etl-process-in-the-identity-space\/","title":{"rendered":"ETL Process in the Identity Space"},"content":{"rendered":"<p>ETL means extract transform load. During your identity and access management implementation the information for the users might come from different sources and to consolidate into a common place you can use any ETL tool.<\/p>\n<p>Usually is required on you identity system to prepare your users for initial load into the system. <\/p>\n<p>Some tools you can use for that are:<\/p>\n<p>CloverETL (<a href=\"http:\/\/www.cloveretl.com\" title=\"Identity and Access Management ETL\" target=\"_blank\">http:\/\/www.cloveretl.com\/<\/a>)<br \/>\nCloverETL is open source data integration platform based on Java. It can be used for data migration, data cleansing and other data transformation tasks.<\/p>\n<p>JasperETL (<a href=\"http:\/\/community.jaspersoft.com\/project\/jaspersoft-etl\" title=\"Identity and Access Management ETL\" target=\"_blank\">http:\/\/community.jaspersoft.com\/project\/jaspersoft-etl<\/a>)<br \/>\nJaspersoft ETL is a data integration platform providing high performance data extract-transform-load (ETL) capabilities.Jaspersoft ETL is easy to deploy and out-performs many proprietary and open source ETL systems.<\/p>\n<p>ScriptellaETL (<a href=\"http:\/\/scriptella.javaforge.com\" title=\"Identity and Access Management ETL\" target=\"_blank\">http:\/\/scriptella.javaforge.com<\/a>)<\/p>\n<p>Open source ETL (Extract-Transform-Load) and script execution tool with support for JDBC\/ODBC, CSV, LDAP and XML data sources.<\/p>\n<p>Take a look on the next wiki link to read more about ETL process <a href=\"http:\/\/en.wikipedia.org\/wiki\/Extract,_transform,_load\" title=\"Identity and Access Management ETL\" target=\"_blank\">http:\/\/en.wikipedia.org\/wiki\/Extract,_transform,_load<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>ETL means extract transform load. During your identity and access management implementation the information for the users might come from different sources and to consolidate into a common place you can use any ETL tool. Usually is required on you identity system to prepare your users for initial load into the system. Some tools you [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1005,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[264,278,88,44,6],"tags":[502,501,59,134,437,503,10],"class_list":["post-1564","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-article","category-iam-space","category-identity-space","category-miscellaneous","category-news","tag-data-load","tag-etl-process","tag-identity-access-management","tag-identity-and-access-management","tag-identity-management-data-load","tag-identity-management-tools","tag-identity-manager"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/allidm.com\/blog\/wp-content\/uploads\/2012\/06\/Identity-Access-Manager-Article.jpg?fit=312%2C173&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/p25vfy-pe","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/allidm.com\/blog\/wp-json\/wp\/v2\/posts\/1564","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/allidm.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/allidm.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/allidm.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/allidm.com\/blog\/wp-json\/wp\/v2\/comments?post=1564"}],"version-history":[{"count":2,"href":"https:\/\/allidm.com\/blog\/wp-json\/wp\/v2\/posts\/1564\/revisions"}],"predecessor-version":[{"id":1566,"href":"https:\/\/allidm.com\/blog\/wp-json\/wp\/v2\/posts\/1564\/revisions\/1566"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/allidm.com\/blog\/wp-json\/wp\/v2\/media\/1005"}],"wp:attachment":[{"href":"https:\/\/allidm.com\/blog\/wp-json\/wp\/v2\/media?parent=1564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/allidm.com\/blog\/wp-json\/wp\/v2\/categories?post=1564"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/allidm.com\/blog\/wp-json\/wp\/v2\/tags?post=1564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}