AJ,
Acquiring a Datasource in WFA needs some good amount of planning to be done as what all do you want to acquire from the external DB ( MS sql in your case ). This decision will be based on what all data you want to use for resource selection for your workflow executions. So as you can see this needs some planning to get it to full strength.
So setps to start with:
1. Create your dictionary on a new scheme. This will create a New Database. Dictionary are like DB tables, rows in dictionaries will be the columns in that table. So decide what all columns you need to acquire from MS sql.
2. Create a Datasource Type, Method SQL, Driver: MS SQL Jdbc driver 3.0. You might also have to mention your SID/Database name as present in MS SQl server.
3. Create Cache queries on your Data Source Type. They are SQL queries with select methods which will be executed against the MS SQL server and the result data will be obtained and filled in WFA DB into the dictionary your created. You need to create Cache queries for all your dictionay items which you want to acquire. by default all will be enables to be acquired.
4. Create a New Data Source with the given DataSource Type as in step 2. Provide connection details like Host IP, port, credentials of your MS SQL. Run acquistion.
5. You are done.
See some certified Datasource like OCUM6.0 ( Mysql server) etc. to see how it works.
@i tried to create a dictionary entry but i cannot see whether its filled up or not - so how i can proceed??
-------
WFA DB is mysql server. So you can connect to it using any mysql client like SQLYog, DB vizualizer, SQL workbench etc using credentials wfa/Wfa123. See WFA developer's guide/Instllation Guide for information on this. You can see the Data acquired in your DB by the acquistion.
sinhaa
If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.