How to import data using mid server

archanajoshi
Kilo Expert

Hi All,

We have a requirement where we need to import data using Mid server.

We have 1) Mid server setup 2) Data sources and transform maps created for this.

Can you guide me after this what steps we need to follow to import data.

Or any wiki link which will explain step wise procedure.

Thanks,

Archana Joshi.

1 ACCEPTED SOLUTION

Fill up these database and server fields properly :




Database name     ---name of the database from where you want to import data


Database port     ---port of the database from where you want to import data


Connection URL   --- Example jdbc:mysql://xxx.xxxx.com:3306/dbname


User name             ---Credential to thatserver


Password               ---Credential to thatserver


Server                   --- name of the server


Query                     ---SQL query or table name






and click on Test Load 20 records Related link






Please mark it as Heplful/Correct according to its impact




Thanks,


Mihir


View solution in original post

8 REPLIES 8

Hi Mihir,



Yes Data source type is SQL.



Now i want to know stepwise how using MID server i will import data.



Thanks,


Archana Joshi.


Fill up these database and server fields properly :




Database name     ---name of the database from where you want to import data


Database port     ---port of the database from where you want to import data


Connection URL   --- Example jdbc:mysql://xxx.xxxx.com:3306/dbname


User name             ---Credential to thatserver


Password               ---Credential to thatserver


Server                   --- name of the server


Query                     ---SQL query or table name






and click on Test Load 20 records Related link






Please mark it as Heplful/Correct according to its impact




Thanks,


Mihir


Hi Mihir,



So after MID server set Import procedure is normal Like load data ---> Transform.



Please correct me.



Thanks,


Archana Joshi.


Yes Archana,



After you are getting   data form the server, the next step is to transform those and set in ServiceNow table using Transform Map.



Thanks,


Mihir