Skip to main content

I know the question is a little bit weird, but I'll try to explain it.

 

I have to create a simple workspace to get data from an external database (Informix) and copy to our database. This workspace will be published to FME Server. 

 

As I said, I don't get access to external database, from my PC, but I do from Server. So, if I can publish the workspace to the Server it will run correctly, I sopose.

 

But, how can I create an Informix Reader in FME Desktop if I don't get access to this database? Is it possible to do it?

 

Thanks.

In theory this should work...

If what you want to do is "just" copy the external database and not do anything fancy with it you can set up a dynamic workflow using another Informix database that you do have access to. Use a Single Merged feature type on the input side and a dynamic feature type definition on the output side should do the trick.

If you do need to do something fancy in between it will get a lot harder...


Similar to above, I've been able to do this using a FeatureReader but it's necessary to have access to a local database of the same format, and there's more set up required in terms of exposing attributes as you need to use the generic port


In theory this should work...

If what you want to do is "just" copy the external database and not do anything fancy with it you can set up a dynamic workflow using another Informix database that you do have access to. Use a Single Merged feature type on the input side and a dynamic feature type definition on the output side should do the trick.

If you do need to do something fancy in between it will get a lot harder...

Thank you very much for your quick answer.

The only thing I have to do is to use VertexCreator transformer in order to create points (original data only have coordinates).

 

I do not have any Informix local database to test it, so I'm afraid I can't do it, can I?


Similar to above, I've been able to do this using a FeatureReader but it's necessary to have access to a local database of the same format, and there's more set up required in terms of exposing attributes as you need to use the generic port

Thank you very much for your quick answer.

I'm afraid I do not have any Informix local database to test it.


Thank you very much for your quick answer.

The only thing I have to do is to use VertexCreator transformer in order to create points (original data only have coordinates).

 

I do not have any Informix local database to test it, so I'm afraid I can't do it, can I?

You could try with a generic reader and just use a dummy dataset that has those attributes with coordinate values. The attribute names have to be the same.

 

However, the more generic your approach is the less control you have so I'd be a bit apprehensive about this.


@dxirgu​ You need a dataset that mirrors the data model of you Informix. So if you took the SQL CREATE TABLE statements used to create your Informix and used those to create tables in any other database you have access to (even SQLITE). Then create your workspace reader from those tables. So now you'll have a workspace that has a SQLite reader, say, and the feature types that mirror your Informix. Now... On the navigator, right-click on the SQLite reader and select Update Reader... In the Update Reader dialog switch the format to Informix and in the Update Options select "Update Reader" . This should switch your SQLite reader to an Informix reader that hopefully you can publish to your server, where you'll have to setup the database connection.

dialog


Thank you very much for your quick answer.

The only thing I have to do is to use VertexCreator transformer in order to create points (original data only have coordinates).

 

I do not have any Informix local database to test it, so I'm afraid I can't do it, can I?

Hi, @Hans van der Maarel​ 

 

Thanks for your help. I tried to use a Generic Reader but it didn't work, because when I publish the workspace to the Server, the reader was using the dummy dataset and I couldn't change it. 


Thank you very much for your quick answer.

The only thing I have to do is to use VertexCreator transformer in order to create points (original data only have coordinates).

 

I do not have any Informix local database to test it, so I'm afraid I can't do it, can I?

Did you set the source parameter?


@dxirgu​ You need a dataset that mirrors the data model of you Informix. So if you took the SQL CREATE TABLE statements used to create your Informix and used those to create tables in any other database you have access to (even SQLITE). Then create your workspace reader from those tables. So now you'll have a workspace that has a SQLite reader, say, and the feature types that mirror your Informix. Now... On the navigator, right-click on the SQLite reader and select Update Reader... In the Update Reader dialog switch the format to Informix and in the Update Options select "Update Reader" . This should switch your SQLite reader to an Informix reader that hopefully you can publish to your server, where you'll have to setup the database connection.

dialog

Hi @Mark Stoakes​ ,

Thanks for your answer. I tried what you propose, but it did not work for me. When I have to Update the reader, it ask me about user and password: 

- If I fill in user and password it fails, because I do not get access. 

- If I don't fill in the user and password the reader doesn't update it. 


Hi @Mark Stoakes​ ,

Thanks for your answer. I tried what you propose, but it did not work for me. When I have to Update the reader, it ask me about user and password: 

- If I fill in user and password it fails, because I do not get access. 

- If I don't fill in the user and password the reader doesn't update it. 

Hmm.. You need the database connection. It looks like you do need a connection to the database. No short cut there it seems. (outside of installing workbench on your FME Server machine)


Reply