Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84462members
353666posts

ITA export data to other software

EcoStruxure IT forum

A support forum for Data Center Operation, Data Center Expert, and EcoStruxure IT product users to share knowledge on installation, configuration, and general product use.

Solved
Gianluca
Lieutenant Lieutenant
Lieutenant
0 Likes
6
1312

ITA export data to other software

Hi All

 

is it possible to export data from ITA to another software?

 

Customer wants to use some data from ITA to populate info to another software

 

Thanks

Tags (1)

Accepted Solutions
gsterling
Commander Commander
Commander
0 Likes
1
1265

Re: ITA export data to other software

Hello Gianluca

 

This page from the help center describes the steps to create an ETL export database onto a SQL server database https://helpcenter.ecostruxureit.com/hc/en-us/articles/360007453917-ETL-export-to-MS-SQL-Server

 

 

 

ITA has a built-in servicenow connector for the servicenow cmdb. Information can be found here https://helpcenter.ecostruxureit.com/hc/en-us/articles/360037365533-ServiceNow-Asset-Management-Conn...

Information about the ETL export schema can be found here: https://helpcenter.ecostruxureit.com/hc/en-us/articles/360007339797-ETL-export-database

 

The above servicenow connector pulls data from servicenow into ITA. It should work with ITA 9.1.4 and newer releases. Customers wishing to update servicenow based on data in ITA would likely have to create an integration from the servicenow side so that data can be pulled into the service now platform from either ITA REST api's or pulling data from an ETL export database. Most customers wanting this type of integration do so with an engagement with our ACS (advanced customer services) team.

See Answer In Context

Tags (1)
6 Replies 6
gsterling
Commander Commander
Commander
0 Likes
5
1305

Re: ITA export data to other software

Hello Gianluca

 

ITA has REST apis and ETL which can be used to export data from and import data into ITA.

 

If the customer is not comfortable using an ETL export database on the ITA server because they are not comfortable with PostgreSQL, ETL Export databases do not have to reside on the ITA server. The platform has the ability to export data to MS SQL server and Mysql as well as a remote postgres database.

 

Regards

 

Greg Sterling

Tags (1)
Gianluca
Lieutenant Lieutenant
Lieutenant
0 Likes
4
1302

Re: ITA export data to other software

Thanks Greg

 

do you have any examples?

Tags (1)
gsterling
Commander Commander
Commander
0 Likes
3
1297

Re: ITA export data to other software

What type of example are you looking for? 

 

A SQL query from data in an export database?

 

Regards

 

Greg

Tags (1)
Gianluca
Lieutenant Lieutenant
Lieutenant
0 Likes
2
1284

Re: ITA export data to other software

Hi Greg

 

if is it possible an example from ITA to SQL and ITA to Service Now

 

thanks a lot

Tags (1)
gsterling
Commander Commander
Commander
0 Likes
1
1266

Re: ITA export data to other software

Hello Gianluca

 

This page from the help center describes the steps to create an ETL export database onto a SQL server database https://helpcenter.ecostruxureit.com/hc/en-us/articles/360007453917-ETL-export-to-MS-SQL-Server

 

 

 

ITA has a built-in servicenow connector for the servicenow cmdb. Information can be found here https://helpcenter.ecostruxureit.com/hc/en-us/articles/360037365533-ServiceNow-Asset-Management-Conn...

Information about the ETL export schema can be found here: https://helpcenter.ecostruxureit.com/hc/en-us/articles/360007339797-ETL-export-database

 

The above servicenow connector pulls data from servicenow into ITA. It should work with ITA 9.1.4 and newer releases. Customers wishing to update servicenow based on data in ITA would likely have to create an integration from the servicenow side so that data can be pulled into the service now platform from either ITA REST api's or pulling data from an ETL export database. Most customers wanting this type of integration do so with an engagement with our ACS (advanced customer services) team.

Tags (1)
Gianluca
Lieutenant Lieutenant
Lieutenant
0 Likes
0
1262

Re: ITA export data to other software

Hi Greg

 

thanks

Tags (1)