How to import data using mid server

archanajoshi · ‎04-11-2016

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.

Mihir Mohanta · ‎04-11-2016

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

Manoj Kumar16 · ‎04-11-2016

Please follow the links given above.

Mihir Mohanta · ‎04-11-2016

Hi Archana,

Is your Data source type is JDBC ?

For JDBC type of Data source you need to import through mid server otherwise mid server is not needed.

Please mark it as Helpful/Correct according to its impact.

Thanks,

Mihir

archanajoshi · ‎04-11-2016

Hi Mihir,

Yes Data source type is JDBC.

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

Thanks,

Archana Joshi.

Mihir Mohanta · ‎04-11-2016

Hi Archana,

What is the format of Data source ? Is it Oracle or SQL or something else?

Please mark it as Helpful/Correct according to its impact.

Thanks,

Mihir