Hello Chris and Yaron,
I was able to create a new Datasource type which can connect Postgre SQL Database and acquire the Data in WFA successfully.
( Don't bother about the code http://stackoverflow.com/questions/9217650/connect-to-remote-postgresql-database-using-powershell here, it doesn't work. )
1. For the POC and demo, I'm using a sample database dvdrental which I found here : http://www.postgresqltutorial.com/postgresql-sample-database/
2. Unzip it and import the dvdrental.tar
C:\>cd C:\Program Files\PostgreSQL\9.3\bin
C:\>pg_restore -U postgres -d dvdrental C:\temp\dvdrental.tar
3. Install PostGre SQL ODBC Driver. https://code.google.com/p/visionmap/downloads/list on your WFA server. Download and install the setup_psqlODBC_x64_8.3.4.0.exe.
4. Configure you Postgre SQL server for receiving connection from any outsider host. (By default it only takes requests from localhost) . Modify the pg_hba.conf file in data folder and make the following entries.
| host all | postgres | 0.0.0.0/0 | trust | ||||
| host all | postgres | 0.0.0.0/0 | md5 |
Restart the Postgresql service ( using PGAdmin or CLI or Windows services)
5. On WFA server, Go to "Control Panel" => 'Administrative Tools' and find 'Data sources (ODBC) . Double click to open the ODBC Datasource Administrator.
4. Tab 'User DSN' => Add. Select the PostGreSQL 64-Bit ODBC Drivers.
5. Provide the details and Test. Connection should succeed and then only can it work.
6. Open the WFA server in a browser and Import the attached Data source Type file (.dar ).
7. Go to Designer -> Data source Types - Open PostGRE SQL Database for editing. Modify the script with you Server_ip, your Uid and Pwd at the below line:
$connStr = "Driver={PostgreSQL 64-Bit ODBC Drivers};Server=10.226.179.161;Port=5432;Database=dvdrental;Uid=postgres;Pwd=netapp;"
Save it.
If you Postgre SQL server uses SSL etc, Read the following and modify the Driver accordingly : http://www.connectionstrings.com/postgresql/
8. Execution -> Data sources -> Add a new Datasource of PostGRE SQL Database 9.3 (POWER_SHELL) . Fill in the Server etc. ( They are just space-fillers for now, the Acquisition script has everything hard-coded. Its POC after all )
9. Save. Your Datasource acquisition will succeed and you can see a table 'customer' in scheme dvd with first_name, last_name , email column acquired from the Postgre SQL DB.
Now its all yours, Add your filters/finders/commands/workflows as you wish.
Message was edited by: Abhishek Sinha
Message was edited by: Abhishek Sinha Replaced the DataSource type for WFA2.1 RC1.
