SQL query Output to XML schema and output to FRL..

[NewbieM]

Hello All,

I have a proprietary layout of x12 data. What I am trying to do is
query a sql database table via ODBC and output the file to an xml
schema file and to an fixed record layout. Is there any easy way of
doing this. Can someone please assist me in the steps necessary to
accomplish this?

Thank you,
NewbieM

[Ted Peck]

That sounds fairly detailed. I can't promise an easy way, but here are
components that could help:

- SQL Inbound Adapter / Cache SQL Gateway

- Data Transformation Language (DTL)

- Record Mapper (input and output from flat file formats)

- XML Schema Wizard / XML Virtual Documents

Also: X12 Virtual Documents, although it sounds like your X12 data is
already in a database so you might not have a use for this.

Ted

[NewbieM]

Thank you Ted.

I was able to create the SQL gateway connection and execute the query in Ensemble.  I also created the business service with SQL Inbound Adapter, Router and an operation type outbound file Record Map (all I am doing at this point is querying from a table and sending the output to a fixed record layout). However, I am getting this error and the service stays RED.  Not sure what is going on, please advise. 

According to the error, it is a gateway connection error and table cannot be found.  The table does exist and I can run a query against this in Ensemble.

ERROR #6022: Gateway failed: Execute. + ERROR <Ens>ErrGeneral: SQLState: (42S02) NativeError: [942] Message: [Oracle][ODBC][Ora]ORA-00942: table or view does not exist